SUMMARY

• Almost 8 Years of experience in analysis, design, development and implementation as SQL/PLSQL Developer working on Oracle 9i/10g/11g platforms.
• Excellent hands - on experience in Software Development Life Cycle (SDLC) that includes requirements gathering, functional and technical specifications, design, development, testing and production deployment.
• Experience in developing PL/SQL Stored Procedures, Functions, Packages, Database Triggers using features like Cursors, Collections, Exception Handling and good in Oracle Forms and Reports.
• Strong experience in developing Oracle PL/SQL packages in application development.
• Experience on working with TOAD, SQL*Plus, SQL developer and PL/SQL Developer tools.
• Hands on experience in supporting ETL tools Data Stage.
• Strong skills in optimization and performance tuning of SQL Queries using different utilities like STATSPACK, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Excellent knowledge in troubleshooting the SQL performance issues by analyzing Automated Workload Repository (AWR) Reports.
• Working experience in using Export, import and data pump utilities to export/import the tables in schema.
• Working experience in developing JIL files to schedule jobs in AUTOSYS.
• Hands on experience working on UNIX platforms in developing shell scripts to schedule the jobs in cron tab.
• Worked on data migration from text, csv files to oracle database tables using sql loader.
• Well experienced in developing the Data mart in Star Schema and Snowflake Schema, Flat files and building the Data warehouse.
• Working experience in developing Data model, ER Diagrams and organizing the data as per the functional requirements.
• Excellent communication skills and ability to work individually and as a member of a team.
• 24X7 on-call support for production environment.

TECHNICAL SKILLS

Databases: Oracle 11g/10g/9i

Operating Systems: Red Hat Linux, Aix, Solaris, Windows 98/2000/2003/2005/ NT/XP

Language: Shell Scripting, C, C++, SQL, PL/SQL

Tools: Import/Export manager, Datapump Utilities, TOAD, SQL*Loader, SQL Developer

Data Modeling: Sybase Power Designer, Erwin

ETL Tools: IBM Information server 8.0/8.1

Job Scheduler: AUTOSYS

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

• Requirements gathering from business users, analysis and system design.
• Data modeling using Sybase power designer to design the data model and creating entities and relationships.
• Created database objects Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages.
• Created the PL/SQL packages, procedures and functions.
• Migrating application code from Development to Testing environments.
• Performance tuning of the PL/SQL code and SQL queries using optimizer hints.
• Created partitioned tables and indexes to resolve performance issues.
• Migrating database objects and data between databases using data pump utilities (expdp/impdp)
• Exporting and importing data from text and CSV files using SQLLOADER.

Environment: Oracle 11g, SQL Developer, TOAD, RTC (Rational Team Concert), Sybase Power Designer, UNIX and Windows NT.

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

• Involved in gathering requirements from business users, analysis and system design
• Created and managed data base objects such as Tables, Views, Indexes, Sequences, and Synonyms, procedures, packages
• Created the PL/SQL packages, procedures, functions applying the business logic to load the data to relevant tables
• Deployment and migration of DB Scripts in Production after testing in SDLC including Development and testing environments
• Prepared the ETL Technical design and mapping documents.
• Developed Datastage parallel jobs, by using database stages, file and processing stages.
• Worked on different stages to develop parallel jobs like Join, Merge, Lookup, Filter, Modify, Pivot Enterprise, Copy, Filter, and Aggregator.
• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables
• Involved in Logical Data Modeling (LDM) and Physical Data Modeling (PDM) in accordance with the business requirements
• Developed the SQL*Loader scripts to load data into the staging tables from the flat files.
• Worked on data migration from text, csv files to oracle database tables using sql loader
• Extensively worked in tuning the queries and applying hints for faster and better performance of the SQL queries
• Worked in preparing functional document, user document, process flow diagram and flow chart
• Developed views to facilitate easy interface implementation and enforce security on critical customer information.
• Created and manipulated stored procedures, functions, packages and triggers using TOAD and SQL Developer.
• Identifying and tuning the long running queries by analyzing the AWR reports.
• Worked on DBMS STATS to gather the table, index and schema level statistics.
• Used TKPROF to get the explain plan for the long running SQL’s.
• Worked on Oracle packages like UTL FILE to open, read and write files to OS directories
• Involved in preparing test plans, unit testing, System integration testing, implementation and maintenance
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for ETL jobs.
• Created UNIX shell scripts to run Data stage batch jobs through Autosys

Environment: Oracle 11g (OLTP, OLAP), Oracle 10g, Data Stage 8.1.2/8.0.1 , XML files, CSV files, flat files, SQL server 2005, SQL Developer, TOAD, UNIX, and Windows NT.

Confidential, Charlotte NC

Oracle SQL/PLSQL Developer

Responsibilities:

• Requirements gathering, analysis and design.
• Involved in creating specification documents, mapping documents, data flow diagrams, ER diagrams, dependency documents.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Worked extensively in PL/SQL and developed complex packages, procedures and functions using SQL Developer as well as SQL PLUS.
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links.
• Closely working with testing teams to resolve the code defects.
• Excellent experience in resolving SQL performance issues by analyzing the EXPLAIN plan.
• Tuning the PL/SQL procedures and packages and modified code accordingly to improve performance
• Created indexes and partitions on various tables in order to enhance performance.
• Involved in Logical and Physical Database design and Star Schema design. Identified Fact tables, Transaction tables.
• Actively involved in Production Support by Performing Tests, Trouble Shooting and Bug Fixing.
• Enhanced database performance and PL/SQL context switching by implementing PL/SQL Bulk Collect features

Environment: Oracle 11g/10g, SQLPLUS, SQL Developer, TOAD, RHEL 5

Confidential

Oracle SQL/PLSQL Developer

Responsibilities:

• Analysis of new business requirements gathering by talking to the business, worked on analysis and design.
• Worked thoroughly on coding, enhancing and debugging of procedures, packages and other Oracle objects.
• Worked on Oracle utilities, which were used for generating/loading flat files and exporting/Importing flat file.
• Supported backend of client order processing application which handles orders placed by client.
• Product’s Backend release management.
• Worked on change request when there was any support issue that involved code changes, data maintenance and bug corrections. Change requests involved enhancement to system components.
• Tuning of SQL statements using EXPLAIN PLAN to improve the performance.
• Worked on Integration Testing, which was used to determine if software modules function together correctly.
• Performed tuning for PL/SQL procedures and packages and modified code accordingly to improve performance
• Created indexes and partitions on various tables in order to enhance performance.
• Provided support and played a major role in debugging production issue.
• Performed code reviews on PL/SQL.
• Created database objects like tables, views, synonyms, indexes, and sequences.

Environment: Oracle 10g, SQLPLUS, SQL server 2005, SQL Developer, TOAD, UNIX.

Confidential

Oracle SQL/PLSQL Developer

Responsibilities:

• Involved in creating specification documents, mapping documents, data flow diagrams, ER diagrams, dependency documents.
• Developed UNIX shell scripts.
• Worked on table partitioning (Range) and deploying various methods of indexing like local indexes on partitioned tables.
• Participated in system analysis, data modeling and database designing which included creating tables, views, indexes, synonyms, triggers, functions, procedures, cursors and packages.
• Created Pl/SQL Tables, Record Types, Indexes on tables to improve performance.
• Extensively worked on Cursors, ref Cursors, Nested Conditional Statements, Co-Related sub-queries, DB Links.
• Worked extensively in PL/SQL and developed complex packages, procedures and functions using SQL Developer as well as SQL PLUS.
• Performed Database Tuning - SQL Tuning using Oracle’s regular performance tuning methods like Explain Plan, SQL*Trace, TKPROF, ADDM and AWR.
• Migrated the data from Excel sheets, text files into the respective Oracle Database tables using SQL *Loader scripts.
• Identified potential inefficient queries using Explain Plan and worked on Performance Tuning using hints.
• Involved in intensive Unit Testing and in writing Test plan document for QA.
• Written DDL scripts to create and update objects like tables, views, indexes, triggers, synonyms and sequences.
• Used SQL*Loader scripts to load legacy data into test environment.
• Written Stored Procedures and Functions
• Written procedures to populate missing interval data for multiple data sets with default data.
• Responsible for the development and maintenance of end-user documentation.

Environment: Oracle 9i, TOAD, UNIX, Erwin, SQL Loader, UNIX scripting.