SUMMARY

• Oracle certified with over 10+ 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).
• Expertise in development of business applications using Oracle 11g/10g/9i/8i, SQL, PL/SQL, Toad, SQL*Loader.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Strong knowledge on various database concepts like Normalization and ER Diagrams.
• Extensively used PL/SQL to build Oracle Packages, stored procedures, functions, triggers, cursors, ref cursors, views for processing data, enforcing referential integrity and business rules.
• Experienced in Tuning SQL and PL/SQL code for better performance with large volume of data.
• Strong knowledge of Extraction Transformation and Loading (ETL) processes using UNIX shell scripting, SQL, PL/SQL and SQL Loader.
• Implemented PL/SQL advanced topics like System variables, Ref Cursors, Dynamic SQL, Collections, UTL FILE to read and write the files.
• Implemented Slowly changing Dimensions for Historical Data attribute level changes.
• Have created Joiner, Router, Lookup, Filter, Sequence Generator, Normalizer, Expression transformations as per the defined objectives.
• Having good knowledge in Data Transformation and Loading using SQL Loader utility and External Tables.
• Have extensive experience in PL/SQL exclusively on stored procedures, packages, triggers, functions, Cursors and bulk loads as per the requirements.
• Worked on Materialized views, Collections like Nested Tables, Objects, Autonomous Transactions, Dynamic SQL.
• Expertise in Database Performance Tuning, Performance Monitoring and Optimization using Oracle Hints, SQL Trace, Explain plan.

TECHNICAL SKILLS

Programming: Oracle PL/SQL

Operating Systems: Windows2000/XP/NT/7, UNIX

Databases: Oracle 9i/10g/11g

Reporting Tool: Tableau 9.2

IDE Tools: SQL Developer, Toad for Oracle 12.1

ETL Tools: Informatica

PROFESSIONAL EXPERIENCE

Confidential, Warren, NJ

PL/SQL Developer

Responsibilities:

• Improved and maintained the current data warehouse and OLAP platform for the Counterparty credit risk group.
• Developed Stored Procedures, packages, Functions and Triggers using PL/SQL to implement day to day modified business rules into the current system.
• Dealt with huge data and resolved issues of slowness and tackled performance issues while loading as well as retrieving.
• Resolved issues with existing PL/SQL Procedures by implementing best practices.
• Implemented Error Handler functionality for tracking errors.
• Worked on Workflows for implementing Account Hierarchy creation process and created Transformations, Sessions, Workflows, Procedures.
• Worked with Tableau for OLAP Reporting.
• Analyzed Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems.
• Tuning SQLs to enhance the performance of the data to be retrieved.
• Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.
• Converted and loaded data from flat files, CSV & Pipe delimited files to temporary tables in Oracle database using SQL*Loader.
• Tuned long running queries explain Plan, TKPROF, ANALYZE, HINTS etc.
• Automating the flow using batch scripting like extraction, running the jobs to delete and reporting as required.
• Developed Mapplets, Workflows & Sessions in Informatica with various transformations and executed the as part of the batch scripts.
• Monitoring the runs and verifying logs as part of the executions during various phases like development, testing and deployment.
• Involved in resolving complex scenarios using Informatica transformations.
• Involved in Administration activities migrating the repository from development to testing environment, and assisting the production support team during deployment activities.
• Involved in resolving the issues found during Unit Testing & User acceptance Testing.
• Responsible for collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans.

Confidential, NJ

PL/SQL Developer

Responsibilities:

• Understanding the requirements from the Business Team and the Sales Reps.
• Loading Territory Alignments to the Representatives and Customers.
• Loading weekly data loads to keep the database up to date with the Addresses, the User and Customer details.
• Tracking User issues and provides swift resolutions to them as well as provides information to clear out the issues.
• Creating and managing views for various objects, new profiles, Roles and Territory Hierarchies, Products, Key Messages.
• Creating reports for User tracking, expenditures, Educational material distribution, etc
• Provide weekly reports to the Business team to analyze the activities or the outcome of the Sales Rep activities.
• Understand the Lifesciences program and suggest the new technological enhancements that the Organization needs to implement.
• Schedule the weekly loads related to Accounts, Users, Territories and Addresses.
• Handle the upstream and downstream teams who rely on the Application database.
• Analyzed Upstream and downstream systems architecture, Business Requirements, and Document Business Rules for the associated systems.
• Developed Stored Procedures, packages, Functions, Triggers, staging tables and views using PL/SQL to implement day to day modified business rules into the current system.
• Deal with data inflows on a daily basis and data changes and resolved performance issues that hamper the retrieval ability.
• Resolved issues with existing PL/SQL Procedures by implementing best practices.
• Implemented Error Handler functionality for tracking errors.
• Provided the documentations for Business and Technical processes in the system and provided periodic review of the same.
• Lead a large team with offshore and onsite model and had went live with multiple projects.

Confidential, NJ

Oracle PL/SQL Developer

Responsibilities:

• Enhancing and executing the campaigns as per the Client requirements.
• Involved in all cycles of the development like gathering requirements, design, development, testing, deployment and support.
• Involved in Logical and Physical modeling of the new data marts created for reporting purposes.
• Created ER Diagrams for business requirements and transformed them on to the database.
• Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables.
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Tuning SQLs to enhance the performance of the campaigns, simultaneously to achieve better results.
• Tuned performance risque queries using explain Plan, TKPROF, SQL TRACE, ANALYZE, HINTS etc.
• Create partitioned tables & moving data from non - partitioned tables to partitioned tables.
• Created views and materialized views to resolve complex queries.
• Added/Changed Tables, columns and triggers.
• Created Dimensions and Facts and have implemented Slowly Changing Dimensions for Historical Data captures
• Developing triggers for the common usage across the campaigns.
• Ensuring error free and timely delivery of business objectives performed.
• Profiling customers with respect to various business categories and segmenting based on business rules.
• Providing vital insights to the merchandizing and marketing team.
• Capturing the changes on the flowcharts and creating the code review documents and this will be shared with the team as part of knowledge transfer initiative.
• Testing the developed flowcharts using the temporary tables created and generating the QCs which once approved by client can be moved into production.
• Assisting the Admin team in the smooth deployment of the developed code into the Production environment. Providing a run book which provides the necessary knowledge to the associated admin team about the steps to be followed, the objects to be moved and the objectives to be met.
• Working on RFP requirements and presenting before the business leads.

Confidential, Irvine, CA

Oracle PL/SQL Developer

Responsibilities:

• Involved in end to end development cycles of the including gathering requirements, design, development, testing, deployment and support.
• Created ER Diagrams for business requirements and transformed them on to the database.
• Created views and materialized views to resolve complex queries.
• Coded and debugged the Stored Procedures, Packages, and Views in Oracle Databases using SQL and PL/SQL, which were called by user-oriented application modules.
• Extensive querying using SQL * plus / TOAD to monitor quality and integrity of data.
• Design and prepared Data Flow Diagrams and mapping documents for existing PL/SQL code.
• Involved in coding of data extraction scripts as per technical specifications.
• Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.
• Optimized SQL statements and PL/SQL blocks by analyzing the execute plans and statistics of SQL statements and created and modified some Oracle Database objects to make sure all SQL statements could be executed in the most efficient ways.
• Responsible for writing the night batch process using Shell scripts.
• Developed automating reports by validating converted data.
• Involved in production support and resolved many critical issues by providing emergency cleanup scripts.

Confidential

Oracle Developer

Responsibilities:

• Creation of Technical Design Documents based on the High Level Design Documents provided by the Business analyst.
• Communicating the issues to the Client and clarifying them for better understanding as well as the quality development.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.
• Developed SQL Loader scripts for loading data from varying resources and inserting the master data into tables.
• Implemented triggers to enhance functionality, supplement validation, and default transaction Processing.
• Tuned the queries to improve the performance using Explain Plan, TK Prof, Auto Trace utilities, assessed the efficiency of the code modules.
• Daily Backups of transaction logs and Scheduling Jobs to perform this task.
• Loading and updating the Key Entities in base tables using PL/SQL Procedures.
• Extensively involved in preparing Mapping sheets for Interface and Base table.
• Preparing CTL files for loading data into the staging Database.
• Involved in developing detail technical design documents for project implementation.
• Guided and worked with the team in configuring the application.
• Reporting on a regular basis with the Development authorities, ensuring timely deadlines are met.
• Resolving the issues raised by the testing team and generating the reports for the same.