SUMMARY

• 10+ years of progressive IT experience working as Oracle Technical Consultant/Analyst and has hands on experience in developing Oracle SQL/ PL SQL routines. Sound knowledge in PL/SQL Stored Procedure, Packages, Functions, Database Triggers and Cursors.
• Hands on Experience in SQL, TOAD, Oracle Utilities (data export/import etc) and PL/SQL Developer
• Worked extensively in leading teams and develop applications using Oracle 12c/11g/10g /9i/8i/7.x SQL, PL/SQL, Unix, Perl Scripting and well versed with concepts related to RDBMS like ORACLE, DB2.
• Worked with Erwin (Model Manager and Model Mart) and have taken reports out of Erwin Data Model.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features. Execute Data Quality Assessment for specific functional areas of business.
• Extensive experience in development of SQL, OLAP, Stored Procedures, Triggers, Functions, Packages, Performance tuning and optimization for business logic implementation.
• Worked on data modelling tools like Oracle data modeler for arriving at the target database tables and designing the database.
• Involved in various areas of SDLC like requirement gathering, requirement analysis, preparation and review of impact analysis, development, testing, implementation, application support and unit & integrated testing.
• Hands on Experience in Data Warehousing/ETL programming using Oracle PL/SQL and Fulfillment of data warehouse project tasks such as data extraction, cleansing, transforming and loading Warehouse using Oracle SQL, SQL *Loader, PL/SQL Procedure/Functions/Packages.
• An enthusiastic and project - oriented team player, with excellent communication and leadership skills to develop quick solutions for challenging clients’ needs.
• Exceptional user facing skills and client relationship skills, ability to perform independently as well as in team player, ability to meet tight deadlines and work under pressure.

TECHNICAL SKILLS

• Oracle
• SQL
• PL/SQL
• Performance Tuning
• Data Modelling
• SQL PLUS
• SQL loader
• UNIX Shell scriptingMS SQL Server
• DB2
• HP Quality Center
• BMC Remedy
• TSG Service Now
• TOAD
• Sql Developer
• ERWin 4.0/7.3
• Peregrine

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Project Lead

Responsibilities:

• Involves day to day interactions with the Client/business leaders and understands the requirements and prepares the technical design document.
• Participate on the meetings with the business leaders and get the proper sign off for proceeding with all the phases of the project.
• Analyze the application dat is running at other work locations and design the project charter for the application which needs to be implemented at the new site.
• Analyze all the components dat are needed and deploy the same in the test environment. Build the test environment (both application and database server)
• Co-ordinate with multiple teams across multiple corporations and geographies in getting the unified objective achieved
• Involved in different server migrations (application / db servers) with testing the application on different platforms
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and SQL Developer.
• Develop adhoc SQL reports in Support central for financial users for weekly/monthly invoicing.
• Send the time labor details to finance through an automated batch process weekly for generating the weekly invoices.
• Data analysis of the existing Legacy System and involved design using DB2.
• Worked on data migration between MS access and oracle databases
• Built physical data structures like tables, views, constraints & Indexes.
• Deploy the application in the test environment and get the UAT going.
• Coordinate with the team to bring all the issues to closure during UAT.
• Co-ordinate with the DBA team for solving the issues related to the DB.
• Preparing Quality Documents conferring toGEstandards and maintain in the libraries.
• Communication with the business on a weekly basis on the status of the testing.
• Prepare the deployment plan when ready for the production deployment and follow the steps for smooth go-live
• Post-Production support

Environment: Oracle 12c SQL/PL SQL, Data modeler, Sql Developer 3.x, Erwin 7.x, Ms Visual Basic 6.0, TSG Service Now, Sybase Open Confidential /Ms-TFS

Confidential

Project Lead

Responsibilities:

• Managing a team of 15 in Industrial RTS and development activities for NA/LA & EMEA of the RTS Industrial team.
• Monitor the daily feeds dat are received from the source team and ensure the data flows into the system using scheduled jobs.
• Monitoring and troubleshooting Hyperion loads
• Administering the essbase cubes in the Hyperion server.
• Modifying the data-load sql’s as per the business requirements to load the essbase cubes.
• Involved in query tuning of the long running programs for improving the performance of instance
• Generate adhoc reports using Essbase excel add-in and Business objects 3.1 as per business requirements
• Assign the issues to the team based on the priority and functional area
• Co-ordinate with the DBA team for solving the issues related to the DB.
• Preparing Quality Documents conferring toGEstandards.
• Created SQL script to create/drop database objects, tables, views, indexes, constraints, triggers, materialized views, sequences and synonyms.
• Involved in providing reports to users in MS ACCESS files.
• Communication with the business on a weekly basis on the status of the issues.
• Responsible for performance tuning and optimization of SQL queries and indexes
• Coordinate with the team to bring all the issues to closure.

Environment: Oracle 11g, DB2, ETL, SQL Plus, SQL Loader, Business Objects, Essbase Excel Addin, Erwin 7.x

Confidential

Offshore Project Lead

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Extensively worked on various new customizations, Reports and Interfaces.
• Analyze and work for the resolution of technical issues related toPayroll, Project Accounting application modules.
• Built physical data structures like tables, views, constraints & Indexes.
• Extensively involved in query tuning of the long running programs for improving the performance of instance
• Monitor the daily AWR reports / long running programs and proactively identify the long running programs and tune them according to the priority.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Co-ordinate with the DBA team for solving the issues related to the DB.
• Preparing Quality Documents conferring toGEstandards.
• Communication with the Customer on a weekly basis on the status of the issues.
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER etc.
• Developed complex triggers in reports before/after for validation of user input
• Communicate to the ORACLE Support team on any issues which requires halp from Oracle.

Environment: Oracle 10g, SQL Plus, Oracle E-business Suite 11i

Confidential, Greenville SC

Offshore Project Lead

Responsibilities:

• Managing a team of seven in Production Support & Enhancements ofGAMS EAST NRPSInstance.
• Extensively worked onXML Reports. Involved in developing and customizing variousXML reports.
• Extensively worked on various new Reports, customization Reports and Interfaces.
• Analyze and work for the resolution of technical issues related toManufacturing, Distributionsapplication modules.
• Assign/ follow up status of cases withthe team members
• Code modifications in the form of enhancement requests from the user and Providing custom queries impacted into the business
• ProvidingData fixes wherever required and issue resolutions related to work products
• Preparing Test cases for testing the code changes in the Development instance
• Integration of NRPS custom objects with Apps and Interaction with Corporate teams
• Thorough knowledge of Data Warehousing concepts like Star Schema and Snowflake Schema, Slowly changing dimensions, foreign key concepts, referential integrity.
• Involved in customizing in various reports and interfaces
• Preparing Quality Documents conferring toGEstandards
• Built physical data structures like tables, views, constraints & Indexes.
• Proficient in Oracle Tools and Utilities such as TOAD, SQL Plus, SQL Developer and SQL Navigator.
• Communication with the Customer on a weekly basis on the status of the issues.
• Preparation of metrics for every month for audits

Environment: Oracle 10g, Oracle E-business Suite 11i

Confidential, SC

Lead PL SQL Developer

Responsibilities:

• Requirement gathering and documenting requirements
• Analyze the data from legacy systems migrate the data from legacy to oracle.
• Data conversion to sync with newly developed interface systems.
• Develop the DB objects to have the data moved from existing system to the new system
• Develop Unit test plan and execute it
• Writing shell scripts to automate the installation and conversion process
• System Testing and implantation.
• Worked on external hints during the SQL optimization to fast up the SQL process.
• Post production support.

Environment: Oracle 9i, PL/SQL, Developer 10g/6i, Toad, UNIX Shell scripts, Erwin 7.x

Confidential

Lead PL SQL Developer

Responsibilities:

• Responsible for designing schema using Erwin data modeler and generate the DB scripts using the tool
• Worked with Sql*Loader to import and export data from the flat files in and out of the legacy database.
• Participated in the development of new PL/SQL procedures, functions, and triggers and also updating the old ones based on the change requests.
• Created various DML and DDL statements using Oracle Pl/SQL and SQL.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Worked with SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.
• Assist Java development team for writing SQL Queries for the application.

Environment: Oracle 8i, PL/SQL, Developer 6i, JSP, Peregrine

Confidential

PL SQL Developer

Responsibilities:

• Responsible for designing schema using Erwin data modeler and generate the DB scripts using the tool
• Assist Java development team for writing SQL Queries for the application.
• Worked with Sql*Loader to import and export data from the flat files in and out of the legacy database.
• Scheduling Job using Oracle DBMS JOB packages
• Participated in the development of new PL/SQL procedures, functions, packages and triggers and also updating the old ones based on the change requests.
• Tuned some existing queries using Hints to improve execution time of the queries.
• Worked on SQL Trace, TKPROF in generating statistics for queries which are performing badly.
• Participated in creation of database objects like tables, views, Materialized views, cursors (Implicit, Explicit, REF), procedures, packages, cursors using Oracle tools like TOAD, PL/SQL, SQL* Plus, SQL*Loader and Handled Exceptions.
• Prepared the test scenarios and performed unit and regression tests on PL/SQL programs.

Environment: Oracle 8i, SQL, PL/SQL, J2EE, TKPROF, HTML, SQL*Loader.