PROFESSIONAL SUMMARY:

• 11+ 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.
• 8+ years of experience working with different databases and SQL, including Oracle, MSSQL, PostgreSQL and MySQL
• Hands on Experience in SQL, TOAD, Oracle Utilities (data export/import etc) and PL/SQL Developer, experience in exporting data from Oracle to Excel.
• 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, MySQL, MSSQL Server and DB2.
• 5+ years in MySQL database management and design in an enterprise environment.
• 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.
• Worked as DBA to perform database re - organizations as required to assist performance and ensure maximum uptime of the database.
• Experience in complex BI Reports, Dashboards and generated SQL reports using Tableau.
• 3 yrs. Experience in Tableau and Qlikview Dashboards in latest Design and Presentation.
• Hands on experience with Data Extraction, Transformation and Data Loading in Data Warehouse environment.
• Creating variables, sequences, user functions, scenarios, procedures, interfaces and packages in ODI.
• 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)
• MySQLMSSQL Server
• Performance Tuning
• Data Modelling
• SQL PLUS
• SQL loader
• UNIX Shell scriptingOracle Data Integrator
• Java, J2EE
• HP Quality Center
• BMC Remedy
• TSG Service Now
• TOAD, Sql Developer
• ERWin 4.0/7.3
• QlikView Analytical Tool

PROFESSIONAL EXPERIENCE:

Confidential, Los Angeles CA

Senior Oracle Developer

Responsibilities:

• Involved in the Analysis, Design, Coding and Testing of the application.
• Served as DBA/Project lead and managing projects from business requirements analysis to solutions delivery and support
• Extensively worked on various new customizations, Reports and Interfaces.
• Analyze and work for the resolution of technical issues related to Patient, Clinical 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.
• Responsible for SQL, PL/SQL performance tuning, performance monitoring and involved in procedure, functions and packages optimization.
• Extensively used Oracle Analytical functions.
• Developed EDW that replaced multiple legacy data warehouses and data marts for CSMC and MDN to deliver a single source of truth for analytical reports, dashboards, and queries on clinical and financial data across the continuum of care.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• Extract Clinical Data from MySQL Enterprise Schema and migrate into Oracle
• Involved in SQL tuning, PL/SQL tuning and Application tuning using various tools like TKPROF, EXPLAIN PLAN, DBMS PROFILER etc.
• Collaborate with developers to design complex features, data structures and database code.
• Communicate to the ORACLE Support team on any issues which requires help from Oracle.
• Efficiently designs, debugs and manages stored MySQL procedures and functions

Environment: Oracle 12c SQL/PL SQL, Data modeler, MySQL 5.7, Sql Developer 3.x, Informatica 9.1, MySQL, Tableau

Confidential, Atlanta GA

Senior Oracle DBA/ Developer

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.
• Developed and tested storage strategies and disaster-recovery plan for large manufacturing company's operational database, delivering solution that guaranteed recovery performance and high availability.
• Design, define, optimize and develop databases as required, Report on MySQL server performance and operations, Troubleshoot and repair problems
• Efficiently designs, debugs and manages stored MySQL procedures and functions.
• Debugs nested procedures and functions as well as anonymous code, perform release related DBA Task to all environments. Write and maintain ETL (extract-transform-load) scripts.
• Performance tuning proficiency, experience analyzing query planner output to inform indexing strategy
• Data analysis of the existing Legacy System and involved design using MySQL.
• Created database objects like tables, views, procedures, packages using Oracle tools like SQL* Plus, PL/SQL and SQL Developer.
• Built physical data structures like tables, views, constraints & Indexes.
• Responsible for SQL, PL/SQL performance tuning, performance monitoring and involved in procedure, functions and packages optimization.
• Analyze all the components that 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.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• Extensively worked as DBA for solving the issues related to the DB.
• Preparing Quality Documents conferring to GE standards 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, MySQL, Data modeler, Sql Developer 3.x, Oracle Data Integrator 10.1.3.5, Ms Visual Basic 6.0, TSG Service Now, Tableau, tableau server

Confidential

Senior Oracle DBA/ Developer

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.
• Familiarity with replication modes, threads and constraints placed on development and released under various replication schemes.
• Responsible for Efficient DB design, debug and managed stored MySQL procedures and functions, debugs nested procedures and functions as well as anonymous code.
• Built physical data structures like tables, views, constraints & Indexes.
• Responsible for SQL, PL/SQL performance tuning, performance monitoring and involved in procedure, functions and packages optimization.
• Analyze all the components that are needed and deploy the same in the test environment. Build the test environment (both application and database server)
• Extensively worked as DBA for solving the issues related to the DB.
• Preparing Quality Documents conferring to GE standards.
• Created SQL script to create/drop database objects, tables, views, indexes, constraints, triggers, materialized views, sequences and synonyms.
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data using Tableau.
• 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.

Environment: Oracle 11g, MySQL, ETL, SQL Plus, SQL Loader, Business Objects, Tableau, tableau server, Erwin 7.x

Confidential

Senior Oracle Developer

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 to Payroll, 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.
• Responsible for SQL, PL/SQL performance tuning, performance monitoring and involved in procedure, functions and packages optimization.
• Developed / modified scripts to create tables, views and executed them using SQL Plus.
• 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 help from Oracle.

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

Confidential, Greenville, SC

Senior Oracle Developer

Responsibilities:

• Managing a team of seven in Production Support & Enhancements of GAMS EAST NRPS Instance.
• Extensively worked on XML Reports. Involved in developing and customizing various XML reports.
• Extensively worked on various new Reports, customization Reports and Interfaces.
• Analyze and work for the resolution of technical issues related to Manufacturing, Distributions application modules.
• Assign/ follow up status of cases with the team members
• Code modifications in the form of enhancement requests from the user and Providing custom queries impacted into the business
• Providing Data 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.
• 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, SCTDY, NY

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.