SUMMARY

• Around 7+ years of experience in IT industry mainly in design, development, implementation, testing and documentation of business applications using Oracle/UNIX technologies.
• Proven experience in SQL and PL/SQL that includes Cursors, Ref - cursors, Bulking techniques, Procedures, Functions, Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, Exceptional Handling etc.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Good understanding of RDBMS, Oracle Database architecture, design and performed some DBA duties, such as Table partitioning, import/export and data pump.
• Solid experience in performance tuning and Query Tuning (Using Explain Plan, Optimizer with Hints, Analyze, Indexing strategy, SQL Trace, TKPROF etc.).
• Experience in using SQL tools like Oracle SQL Developer, TOAD and PL/SQL Developer and SQL*Plus.
• Excellent Knowledge of Extraction, Transformation and Loading process (ETL).
• Expertise in Production Support activities and documenting the Abend resolutions for root cause analysis.
• Ability to work on complex technical assignments and ensuring the timely deliveries.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
• A Team evolved person with excellent organizational, verbal, written communication, presentation and understanding skills.

TECHNICAL SKILLS

Languages: SQL, PL/SQL.

Database: Oracle 11g/10g/9i/8.x.

Operating Systems: Windows 98/2000/XP/NT, MS DOS, UNIX (HP and Sun Solaris).

Web Technologies: XML, HTML, Java Scripting.

Scripting: Unix Shell Scripting.

Tools: SQL*LOADER, SQL Navigator, Oracle SQL Developer, PL/SQL Developer, SQL*Plus, TOAD, SVN, Text pad, MS-Office Suite, Tivoli, ClearCase and ClearQuest etc.

PROFESSIONAL EXPERIENCE

Confidential, OH

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Mapping, Coding, Data conversion, Development and Implementation.
• Performance tuning of PL/SQL procedures and SQL queries.
• Defining checklists for coding, testing & deliverables.
• Developing the High Level Design for the enhancements.
• Coding in PL/SQL and Shell Scripting.
• Coordinating with SP/DBA for environment related issues.
• Review of Test Cases and System Testing.
• User Acceptance Testing support at the Client Site.
• Handling Problem reports while migrating the application to production.
• Defining best practices for project support and documentation.
• Job Scheduling using CRONTAB.

Environment: Windows 7 Pro, Oracle 11g/10g, Pl/SQL, Oracle Apex 4.1, SQL*Loader, UNIX shell scripting, Oracle SQL Developer, PL/SQL Developer, AccuRev, CRON Scheduler.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Responsible for Study, Analysis, Design, Development/Customization and Testing/Debugging of the application.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Written Procedures to Load Data into data warehouse system from Staging Tables.
• Written Shell Scripts, control files to load data into staging tables and DW tables.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Experience in E-R data modeling using Toad data modeling tool.
• Prepared final design documents and general instruction to follow during development.
• Loading data from flat files into database tables using SQL* Loader.
• Expertise in UNIX environment and shell scripting. Excellent knowledge in Batch Jobs using UNIX CRON, AWK UNIX Shell Script (csh, bash, ksh) and APIs Using PERL Scripts.
• Fine tuned the SQL queries using Explain Plan and applying appropriate hints and indexes.
• Did thorough analysis of the requirements and prepared the detailed analysis reports and estimations for work requests.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Did the database export/import activities for core data.
• Did the Check-out/Check-in process (version control), Baseline creation using IBM Clear Case and used IBM Clear Quest for Defect tracking.

Environment: Windows XP Pro, Oracle 10g/9i, Pl/SQL, SQL*Loader, UNIX shell scripting, Explain Plan, TKProf, Toad, Tidal, Clear Case, Clear Quest, Ultra edit.

Confidential, CA

Oracle PL/SQL Developer

Responsibilities:

• Involved in System Analysis, Design, Coding, Data conversion, Development and Implementation.
• Translating business rules into procedures, packages, database triggers and functions using PL/SQL.
• Involved in writing Procedures, Functions, Triggers, Packages, Cursors, Dynamic SQLs, Views and data loading using SQL Loader utility for new/enhance requirements.
• Tuned SQL queries using Explain Plan and TKProf utilities to improve performance.
• Prepared status reports and attended status meetings on a daily basis to understand the resource utilization and assignments progress.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.
• Involved in writing data Migration scripts/create table scripts to load data successfully from old schema to new structured schema.
• Data from Flat Files been uploaded into Staging Tables using SQL* Loader.
• Written Shell Scripts for automation of some daily tasks which were scheduled in Autosys.
• Did the Check-out/Check-in process (version control) using IBM Clear Case and used Clear Quest for Bug tracking.

Environment: Windows XP Pro, Oracle 10g/9i, SQL, Pl/SQL, Pro*C/C++, SQL*Loader, UNIX, Explain Plan, TKProf, Toad, Tidal, Clear Case, Clear Quest, Edit plus.

Confidential 

Oracle Pro*C/PL-SQL Developer

Responsibilities:

• Used the Dynamic SQL to create the text file for reading and writing purpose in PL/SQL.
• Created temporary table for report writing using Dynamic SQL.
• Designed the report layout and design documents.
• Experienced on fundamentals of the investment management, such as Securities, Financial Instruments (Stocks, Bonds, Mutual funds and Derivatives).
• Analyzed business requirements and created Technical specifications.
• Coding of Application Program from the Specifications using Oracle Pro* C and PL/SQL.
• Involved in EOD (End of the Day) support issues.
• Wrote Procedures, functions, triggers and packages for new requirements.
• Wrote SQL Queries for data validation, extraction and loading.
• Developed Test Plans and participate in unit testing, system testing, thru production implementation.

Environment: Oracle 10g/9i, SQL, PL/SQL, Pro*C, SQL*Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX (Sun Solaris) Shell Scripting, SQL Navigator, CRON, VSS.

Confidential 

Oracle Pro*C/PL-SQL Developer

Responsibilities:

• Coded stored procedure to implement a variety of data manipulation and query routines using SQL, PL/SQL and Pro*C.
• For insertion, deletion and updating at form level the stored procedure and function are grouped in form of package from better performance.
• Coded database triggers for data manipulation as well as to maintain the security and referential integrity.
• Involved in loading the data into staging tables using SQL* Loader.
• Created Views to fulfill the requirement of Reports and Forms.
• Creating and Dropping Table through Dynamic SQL.
• Responsible for Unit testing.

Environment: Oracle 9i, SQL, PL/SQL, Pro*C, SQL*Loader, Toad, Explain Plan, TKProf, Windows NT/2000, UNIX (Sun Solaris) Shell Scripting, VSS.