SUMMARY:

• 5 years of programming experience as an Oracle PL/SQL Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery.
• Experience with Oracle SQL and PL/SQL programming and used Database utility programs like TOAD and SQL Navigator.
• Experience in Oracle SQL and PL/SQL including all database objects Stored procedures, Stored functions, Packages, TYPE Objects, Triggers, cursors, REF cursors, Parameterized cursors, Views, Materialized Views, PL/SQL collections.
• Extensive Knowledge and Experience in ETL tools like SQL Loader, Informatica and DTS packages to transfer the data between different databases.
• Used Erwin tool for data modeling and MS Visio to create the flow chart and to show the process flow.
• Effectively made use of Table Functions, Indexes, Table Partitioning, Collections, and Analytical functions, Materialized Views, Query Re - Write and Transportable table spaces.
• Experience in Logical Data Modeling, Physical Data Modeling and creating ER Diagrams.
• Good understanding of Oracle data dictionary and normalization techniques. Experienced in Oracle 11g/10g/9i/8i systems.
• Experience in the preparation of Technical Design documents and involved in unit testing, systems integration testing and documented the same.
• Knowledge in Core Java, HTML, XML.
• Excellent communication skills, technically competent with strong problem-solving skills enabling effective interaction with project sponsors, testers and business users.

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, Java, C++, UNIX Shell Scripting.

ETL Tools: Informatica (PoweCenter 5.1/6.2/7.1/8.6.1/9.1.0, PowerMart5.1, Power Connect/Power Exchange for SAP R/3, Mainframe and Oracle Change Data Capture (CDC), AB Initio 1.8 and SQL*Loader.

Database: Oracle 9i/10g/11g (SQL, PL/SQL, Stored Procedures, Triggers), MS SQL SERVER 2000/2005/2008.

Data Modeling: Erwin 3.5.2, 4.0

ERP: Oracle Applications 11i/R12.

Oracle Tools: Reports 6i/9i, Forms 6i/9i, XML Publisher.

DB Utilities: SQL plus, SQL Loader, Toad.

Operating Systems: UNIX, Windows 98/NT/2000/XP

PROFESSIONAL EXPERIENCE:

Confidential, Malvern, PA.

Oracle PL/SQL Developer

Responsibilities:

• Design competent data models, PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Design and implement various structures for all physical objects and recommend changes on applications through efficient statistical structures.
• Develop and provide support to all system interfaces and coordinate with all project managers to provide specifications for all core modules.
• Coordinate with various developers, project managers and analyst to prepare designs for new applications and documents all processes to ensure effective evaluation of all applications.
• Develop user defined functions based on requirements. Develop back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Create PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Create the integrity constraints and Database Triggers for the data validations.
• Using PL JSON tool to implement JSON in oracle PL/SQL environment.
• Use PL/SQL Tables and Records in payment generation process. Write Test Plans and Involve in unit testing.
• Create scripts, reports by using SQL and PL/ SQL for the bug fixes and pre and post verification script for the data verification.
• Involve in the continuous enhancements and fixing of production problems. Design, implement and tune interfaces and batch jobs using PL/SQL.
• Development of Oracle Forms 11G, Apex Reports and performing enhancements on existing Forms and Apex Reports.
• Working in data replication and high availability design scenarios with Oracle Streams.
• Work under Agile Team.
• Working on HUBSPOT integration with the database to replace the current email system using HubSpot API’s and implement using PLJSON Tools.
• Designed workflows and strategies to support transactional emails, opt-in and opt-out's.
• Involved in integration testing. Debugging and Fixing Production Data.

Environment: Oracle 11g, SQL Navigator 6, Oracle Forms and Reports 11g, XML publisher, PL/SQL, SQL Loader, Toad.

Confidential, NJ.

Oracle PL/SQL Developer

Responsibilities:

• Created stored procedures, functions, packages, collections, triggers, object types to implement complex business functionality.
• Designed the Oracle Partition strategies, Exchange Partitions, Performance tuning and data analysis, Data optimization, scrubbing and manipulation of staged data using PL/SQL packages.
• Used PL/SQL bulk collection and DML (insert/update/delete) methods.
• Expertise in writing Complex SQL queries, structure hierarchy by using analytical functions, data validation using Regular Expressions
• Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL Navigator.
• Created scripts, reports by using SQL and PL/ SQL for the bug fixes and pre-and post-verification script for the data verification.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed the shell scripts to automate the jobs by using UNIX.
• Experience in Database Application Development, Query Optimization, Performance Tuning and DBA solutions and implementation experience in complete System Development Life Cycle.
• Used standard packages like UTL FILE, DMBS SQL, and PL/SQL Collections and used BULK Binding involved in writing database procedures, functions and packages for Front End Module.
• Involved in the continuous enhancements and fixing of production problems. Designed, implemented and tuned interfaces and batch jobs using PL/SQL. Involved in data replication and high availability design scenarios with Oracle Streams.
• Assisted with testing existing code and making necessary enhancements for Oracle 11G upgrade. Created database objects such as tables, indexes, views, materialized views, triggers, sequences, synonyms.
• Implemented the test Plans for the integration testing.
• Worked with multiple vendors to facilitate integration of systems during merger. Effectively documented and archived historical data for future auditing purposes. Responsible for production support and troubleshooting production issues. Experience working with huge database size of 5 TB.

Environment: Oracle 10g/11g, UNIX, PL/SQL, SQL Plus, SQL Loader, SQL developer, Toad, Erwin.

Confidential,Dallas, TX

Oracle PL/SQL Developer

Responsibilities:

• Developed user defined functions based on requirements. Developed back end interfaces using PL/SQL Stored Packages, Procedures, Functions, Collections and Triggers. Created PL/SQL procedures and packages.
• Extensive query optimization and performance tuning. Created the integrity constraints and Database Triggers for the data validations. Used PL/SQL Tables and Records in payment generation process. Written Test Plans and Involved in unit testing.
• Created relevant staging tables to load the CSV files, identified the business validation rules. Created SQL Loader script generator application using UNIX shell scripting and PL/SQL.
• Experience in creating the tables and sequences for the experimental data load capture. Loaded the data into the tables using TOAD and SQL*Plus. Created metadata validation lookup tables and pre populated them using SQL Loader generator application.
• Designed competent PL/SQL programs using PL/SQL collections, Records types, and Object types.
• Developed and automated the interfaces by using the PL/SQL. Developed user defined stages and common templates.
• Tuned several Oracle SQL statements using Explain plan, Auto Trace utilities.
• Involved in implementing table partitions using Range, Hash, Composite techniques.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Experience in working a variety of analytical functions, RANK, DENSE RANK, LAG, LEAD, and PARTITION OVER.
• Automated Quality Check tasks by creating PL/SQL procedures, cursors, functions and dynamic SQL. Enhanced it with creating exceptions for error handling. Created triggers for auditing purpose and created group, tabular and form reports.
• Database security by authenticating users, using logon triggers. Created materialized view on remote database and automated scheduler of refreshing of materialized view.

Environment: Oracle 10g/11g, PL/SQL, SQL Plus, Informatica ETL, SQL Loader, SQL developer, Toad.