SUMMARY

• 10+ years of progressive IT experience working as Oracle Technical Consultant/Analyst and TEMPhas 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 has 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 teh target database tables and designing teh 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

Project Lead

Responsibilities:

• Involves day to day interactions with teh Client/business leaders and understands teh requirements and prepares teh technical design document.
• Participate on teh meetings with teh business leaders and get teh proper sign off for proceeding with all teh phases of teh project.
• Analyze teh application that is running at other work locations and design teh project charter for teh application which needs to be implemented at teh new site.
• Analyze all teh components that are needed and deploy teh same in teh test environment. Build teh test environment (both application and database server)
• Co-ordinate with multiple teams across multiple corporations and geographies in getting teh unified objective achieved
• Involved in different server migrations (application / db servers) with testing teh 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 teh time labor details to finance through an automated batch process weekly for generating teh weekly invoices.
• Data analysis of teh 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 teh application in teh test environment and get teh UAT going.
• Coordinate with teh team to bring all teh issues to closure during UAT.
• Co-ordinate with teh DBA team for solving teh issues related to teh DB.
• Preparing Quality Documents conferring toGEstandards and maintain in teh libraries.
• Communication with teh business on a weekly basis on teh status of teh testing.
• Prepare teh deployment plan when ready for teh production deployment and follow teh 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 teh RTS Industrial team.
• Monitor teh daily feeds that are received from teh source team and ensure teh data flows into teh system using scheduled jobs.
• Monitoring and troubleshooting Hyperion loads
• Administering teh essbase cubes in teh Hyperion server.
• Modifying teh data-load sql’s as per teh business requirements to load teh essbase cubes.
• Involved in query tuning of teh long running programs for improving teh performance of instance
• Generate adhoc reports using Essbase excel add-in and Business objects 3.1 as per business requirements
• Assign teh issues to teh team based on teh priority and functional area
• Co-ordinate with teh DBA team for solving teh issues related to teh 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 teh business on a weekly basis on teh status of teh issues.
• Responsible for performance tuning and optimization of SQL queries and indexes
• Coordinate with teh team to bring all teh 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 teh Analysis, Design, Coding and Testing of teh application.
• Extensively worked on various new customizations, Reports and Interfaces.
• Analyze and work for teh 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 teh long running programs for improving teh performance of instance
• Monitor teh daily AWR reports / long running programs and proactively identify teh long running programs and tune them according to teh priority.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Co-ordinate with teh DBA team for solving teh issues related to teh DB.
• Preparing Quality Documents conferring toGEstandards.
• Communication with teh Customer on a weekly basis on teh status of teh 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 teh 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 teh resolution of technical issues related toManufacturing, Distributionsapplication modules.
• Assign/ follow up status of cases withthe team members
• Code modifications in teh form of enhancement requests from teh user and Providing custom queries impacted into teh business
• ProvidingData fixes wherever required and issue resolutions related to work products
• Preparing Test cases for testing teh code changes in teh 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 teh Customer on a weekly basis on teh status of teh 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 teh data from legacy systems migrate teh data from legacy to oracle.
• Data conversion to sync with newly developed interface systems.
• Develop teh DB objects to has teh data moved from existing system to teh new system
• Develop Unit test plan and execute it
• Writing shell scripts to automate teh installation and conversion process
• System Testing and implantation.
• Worked on external hints during teh SQL optimization to fast up teh 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 teh DB scripts using teh tool
• Worked with Sql*Loader to import and export data from teh flat files in and out of teh legacy database.
• Participated in teh development of new PL/SQL procedures, functions, and triggers and also updating teh old ones based on teh 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 teh 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 teh test scenarios and performed unit and regression tests on PL/SQL programs.
• Assist Java development team for writing SQL Queries for teh 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 teh DB scripts using teh tool
• Assist Java development team for writing SQL Queries for teh application.
• Worked with Sql*Loader to import and export data from teh flat files in and out of teh legacy database.
• Scheduling Job using Oracle DBMS JOB packages
• Participated in teh development of new PL/SQL procedures, functions, packages and triggers and also updating teh old ones based on teh change requests.
• Tuned some existing queries using Hints to improve execution time of teh 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 teh test scenarios and performed unit and regression tests on PL/SQL programs.

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