SUMMARY

• 8+ years of Experience in the field of Software Design, Development and Implementation with Proficiency in Oracle, SQL, PL/SQL.
• Expertise in all the phases of System development life Cycle (SDLC).
• Writing code for enhancing existing programs or developing new programs.
• Experience programming PL/SQL batch environment utilizing large tables and high transaction throughout requirements.
• Experienced in working with many complex SQL queries with joins, date functions, Inline views, cursors, refcursors, collections, partition tables, external tables, materialized views, sub - queries and analyticalqueries to generate reports.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Highly knowledgeable in SDLC methodologies (Waterfall & Agile).
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections and UTL FILE to read and write the files.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Optimized existing queries for better performance and less impact on database.
• Expertise in using tools such as SQL*Plus, TOAD, SQL Developer and SQL*Loader.
• Good knowledge in creating DDL, DML and transaction quires in Oracle SQL and SQL Server Database.
• Proficient in shell scripting, unit testing, code migration/deployment, Pre and post production support, extensions, customizations and Maintenance.
• Excellent team player with good problem-solving and trouble-shooting capabilities.
• Worked on Oracle APEX for development of functional capability.
• Proficient in developing and maintaining of packages, functions, application procedures, storedprocedures, triggers, tables, indexes, views using Oracle PL/SQL database programming language andmaintaining the DDL scripts.
• Developed and maintained system documents, including technical specifications, data mapping, program logicand flowcharts.
• Expert knowledge with Microsoft Excel, Power Point, Word.
• Strong communication, interpersonal, analytical skills with proficiency at grasping new concepts quickly andutilizing the same in a productive manner.

TECHNICAL SKILLS

Database: Oracle 11g,Db2, MS Access.

Operating systems: Windows, Linux, UNIX.

Database Tools: SQL *Plus, Toad, Oracle SQL

Developer, SQL loader.:

Languages: SQL, PL/SQL, C, Java.

Web Technologies: HTML, CSS, Java Script.

Methodology: Agile, Waterfall.

PROFESSIONAL EXPERIENCE

Sr Oracle PL/SQL Developer

Confidential, Philadelphia, PA

Responsibilities:

• Design, build, deliver, and support solutions to critical business requirements utilizing SQL, PLSQL andreporting skills.
• Create database objects such as tables, global temporary tables, views, synonyms, indexes, sequences anddatabase links.
• Involved in developing Data models, Data dictionaries, mapping documents and cross functional documents across systems for all the ETL needs.
• Develop stored procedures, packages, functions, triggers, as per business requirements.
• Good knowledge on Golden gate technique.
• Move large tables and data, utilizing different techniques including bulk collect/forall techniques. Collaborate andcoordinate with different teams and users.
• Knowledge of other Programming languages like Core Java, JDBC.
• Designed XML schemas, packages and GUI development using Oracle Forms and Reports. Tune queries fromperformance at all levels, indexes, joins, nested loops, temp space usage.
• Applies in-depth or broad technical knowledge to maintain ETL Unix Pro*C/C++ system applications and Oracle PL/SQL and SQL querying and Unix job scripting.
• Support data refreshes from production to lower environments using RMAN database restores and export/importdata pump utilities.
• Developed the logical data model and physical data model for the DB2 database Using ERWIN
• Created Mail Scripts in UNIX to send notification on successful completion or failure of variousInterfaces and Jobs, with
• Customized Subject and Text. Streamline the reporting process develop using reusablecode, easing the troubleshooting needs, meeting complex scheduling requirements.

Environment: Oracle 11g/10g, PL/SQL (Triggers, Procedures, Functions), C, SQL *Loader, DB2, TOAD, SQL Developer, MS-Access, Windows XP and Linux, Core Java.

Oracle PL/SQL Developer

Confidential, Philadelphia, PA

Responsibilities:

• Queries in PL/SQL, performance tuning.
• Involved in unit testing and maintenance.
• Migrated data from legacy DB2 to Oracle 11g suing SQL loader and data pump.
• Testing scripts in different environments while server migration phase.
• Coordinating with project stake holders for deliverable &support Setup of various testing environment &conductUAT for sigh off.
• Responsible for offshore team deliverables.
• Trouble shooting production issues, conducting root cause analysis for the issues.
• Experience in creating the tables, constraints, Joins, Sub queries, Sequences, Views, Synonyms, Indexes andsequences in SQL.
• Loaded the data into the tables using TOAD and SQL*Plus.
• Data loaded from legacy systems (ETL Operations) using PL/SQL and SQL*Loader.
• Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Created the integrity constraints and Database Triggers for the datavalidations.
• Tuned several Oracle SQL statements using Explain plan, Auto Traceutilities.
• Database security by authenticating users, using log on triggers. Created materialized view on remote databaseand automated scheduler of refreshing of materialized view.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Experience in working a variety of analytical SQL functions, RANK, DENSE RANK, LAG, LEAD,DB2, andPARTITION OVER.

Environment: Oracle 11g, PL/SQL (Triggers, Packages, Procedures),C, TOAD, Java, SQL Developer.

Oracle PL/SQL Developer

Confidential, Philadelphia, PA

Responsibilities:

• Designed/developed/Modified tables, views, materialized view, stored procedures, packages and functions.
• Coded PL-SQL packages and procedures to perform data loading, error handling and logging.
• Tuned database SQL statements and procedures by monitoring run times and system statistics Inserted hints andrewrote code as required.
• Created new Procedures, Functions, Triggers, Materialized Views, Packages, Simple, Ref & Traditional Cursors, Dynamic SQL, Table functions as part of Project/Application requirements.
• Wrote PL/SQL Database triggers to implement the business rules in the application.
• Created external tables to handle huge volumes of data which is not used frequently.
• Optimized lot of SQL statements and PL/SQL blocks by analyzing the execute plans of SQL statement and createdand modified triggers, SQL queries, stored procedures for performance improvement.
• Support Production issues
• Developed the ETL mappings in PL/SQL via packages, procedures, functions, views and triggers.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Automate the requests which are requested by users and avoid manual process like exporting the data
• Responsible for Analyzing and Implementing the Change Requests.

Environment: Oracle 10g, Oracle FORMS, Java, DB2, PLSQL Developer and Foot Prints.

Pl/SQL Developer

Confidential

Responsibilities:

• Involved in the complete life cycle of the product from requirements gathering to end of system testing.
• Worked on developing a financial application system to handle all the bank transactions using SQL, PL/SQL, Developer 2000(Forms4.5 and Reports2.5) on Windows environment.
• Maintained the system application design using Designer2000 tools.
• Used SQL*Loader to load the database from flat files.
• Created new Tables, Indexes, and Sequences where needed.
• Created database triggers for data security & Consistency.
• Worked on UNIX Shell Scripting for Scheduling Batch Jobs.
• Developed PL/SQL Packages and Database Triggers.
• Involved in Data modelling DB Queries.
• Developed various UNIX Shell Scripts to generate ad hoc reports.
• Performed manual testing on the application and involved in defects fixing team.
• Involved in developing Extraction-Transformation-Loading (ETL) process, using SQL*Loader and PL/SQL package UTL FILE.
• Used ERWIN to develop logical and physical database models.
• QTC/BV instances depending on the order number environment.
• Developed a custom program for sending survey emails to customers after the service request is closed.
• Extensively used the Oracle utilities such as Export/ Import, SQL*Loader, SQL Trace, TKPROF and day-to-dayactivities of different databases.
• Design and Developed Customized Reports.
• Worked on enhancing the existing shell scripts for automating the process of refresh of data periodically.
• Worked on ETL tools like Power Center8.0 which were used for data integration and also mapping the data.
• Developed new functionality in the existing application as part of change requests.
• Developed Revenue reports like Monthly and weekly Revenue, Total Revenue and Monthly transaction and Revenue Comparison Reports.

Environment: Oracle 8i, SQL, SQL*Plus, PL/SQL, SQL*Loader, Microsoft Access, Microsoft Excel, Developer2000