PROFESSIONAL SUMMARY:

• Having 10 years of experience in SQL, PL/SQL & Oracle Technologies.
• Good experience in tuning techniques to optimize the performance of SQL queries and PL/SQL using optimization tools like TKPROF, Explain Plan, Dbms Profiler, SQL Trace and AWR report
• Extensive experience in Oracle 11g/10g/9i, SQL*Loader, Oracle SQL Developer
• Excellent knowledge in 12c In Memory and new features
• Knowledge and work experience in Virtual Private Database and oracle packages DBMS LOB, DBMS PROFILER, DBMS SCHEDULER, UTL FILE and many more DBMS packages
• Working experience in DBA activities like Backup, tablespace management, export, import, monitoring the database and security related (like grants, etc) and many more.
• Solid knowledge on multiple features like PARTITIONS, CLOBS, Bulk processing, REF cursors
• Excellent experience in Data Modelling. ER Diagrams (Logical/Physical data models) on Erwin, Microsoft Visio.
• Excellent knowledge on Data migration & Data conversion.
• Extensive experience in writing PL/SQL Packages, Functions, Procedures, External tables, Types, Views, Indexes &Triggers to implement business logic.
• Knowledge and exposure to Unix, Shell Scripting and batch scripting
• Extensively used ETL methodology for supporting Data Extraction, transformation and loading processing using Informatica and OWB (Oracle Warehouse Builder)
• Good working knowledge in IBM COGNOS, XML/BI Publisher reporting tools.
• Good working knowledge in data virtualization tool CISCO CIS (Composite Information Server).
• Guided and lead team members in various stages of the project Good team player and ability to work independently.
• Excellent logical and analytical skills, enthusiastic, interpersonal & communication skills.

TECHNICAL SKILLS:

Oracle Tools: Oracle Developer, PL/SQL Developer, TOAD, Export & Import, SQL Loader, Data Pump

Databases: Oracle 9i/10g/11g/12c

Languages: SQL, PL/SQL, Java, HTML, Javascript

Reporting: IBM Cognos, BI/XML Publisher

ETL Tools: Informatica 8.1, OWB

Virtualization Tools: CISCO Composite Information Server

Version Control Tools: TFS, Tortoise SVN, VCS, PVCS

PROFESSIONAL EXPERIENCE:

Sr Oracle Consultant

Confidential, San Jose, CA

Responsibilities:

• Worked on improving the performance of the BORG job from 2.5hrs to 28mins.
• Worked on Journal Import
• Assessed the changes needs to be done in various modules of application like Vendor Validation, Exchange rates API, etc
• Reviewed multiple CL's (Change List) worked by different teams
• Setup the application environment and test all the flows in order to make sure nothing fails
• Created bugs for the cross functional teams in Confidential and worked on some Oracle SR's

Environment: Oracle 11g, PLSQL, Perf Tuning, EBS, Oracle SQL developer, UNIX, Putty

Sr Oracle Consultant

Confidential, Plano, TX

Responsibilities:

• Involved in discussions with LOB users & SA’s to understand the reporting requirement needs
• Design ETL processes to load the data into the reporting data mart from multiple sources
• Worked on designing the END to END solution from source to reporting including the ETL (Oracle) and Reporting(COGNOS) technologies for many Inventory SLA reports
• Standardized the Exception and Audit logging process
• Worked on the Automation of Autosys Batch scripting and also in fixing the issues of the jobs executions due to automation and jobs load
• Worked on developing the data model for the reporting data mart.
• Working on improving the performance of the SQL queries used in the existing ETL & reports
• Created multiple views in CISCO CIS data virtualization if needed to connect diverse datasources
• Created a METADATA report which will give complete information about the SCHEMA, Tables, Columns and all the information which is close to DATA DICTIONARY information in Oracle
• Part of designing the creating PARTITIONS and the FRAMEWORK which is created for STAGING loading. Proposed some key solutions including PARTITION Pruning in Oracle to make the STAGE loading process much smoother, efficient and robust.
• As part of development, Identified many key issues/bugs in the SOR (System of Records)
• Involved in helping and giving KT to the reporting team understand basics of SQL & ETL process
• Worked with the DATA modelers to create the automated scripts for different new objects which in turn helped streamlining the process from requirements gathering, development and deployment.

Environment: Oracle 11g, Oracle SQL developer, TOAD, SQL Loader, Tortoise SVN, TFS, CISCO CIS, Autosys, IBM COGNOS

Project Lead

Confidential, California, San Francisco

Responsibilities:

• Validating and Migrating the data from Metavance Pre - Production to PRODUCTION.
• Developing procedures for the Insert group in the P2E modules.
• Streamlined the process in the org like coding best practices, code reviews and version checkins
• Code reviews and process the documents on the newly proposed changes in development.
• Participating in meetings with the business users to understand the business and requirement
• Validating the different schema objects w.r.t security privileges (grants/revokes)

Environment: Oracle 11g, Oracle SQL developer, TOAD, SQL Loader, PL/SQL, Tortoise SVN

Sr Applications Engineer

Confidential

Responsibilities:

• Handled many performance bugs. Dealt with SQL Trace, TKProf, Hints and Statistics.
• Modified the existing Stored Procedures and packages for various modules in the application.
• Worked on various Interfaces and Conversion programs which involved PLSQL coding.
• Involved in modeling the data model for the whole functionality of the Application Acounting Definition functionality.
• Worked on various data fixes to fix the data corruptions for multiple high end customers like GE,
• Developed batch processes and reports using UNIX shell scripts, SQL, PL/SQL.

Environment: Oracle 11g, Oracle Applications 11i/R12, EBS, Oracle SQL developer, UNIX, Putty, Shell Scripting, Online Patching, Erwin

Confidential

Sr Database Engineer

Responsibilities:

• Involved in Exporting and Importing tables.
• Involved in backing up the database activities and tablespace management activities.
• Involved in data loading across different schemas
• Involved in comparing the schemas to compare both the structural and data differences
• Involved in writing the SQL queries to the application team members
• Involved in tuning the performance of the queries
• Worked on enhancing the logical and physical models for the application for new enhancements
• Written Stored Procedures and cursors for various modules in the application

Environment: Oracle 11g, SQL, PL/SQL, SQL Developer, TOAD, Webworks, UNIX, Shell Scripting

Confidential

Module Lead (Sr. Support Engineer)

Responsibilities:

• Involved in identifying the problems in the issues reported in production
• Involved in making the fixes to the bridge cases (issues raised in production)
• Involved in various calls between different teams with in the UII
• Provided 24x7 batch processing support
• Troubleshoot batch failures to determine cause (review AutoSys logs) and correct/escalate.
• Involved in code reviews for the code written by other team members.

Environment: Oracle 9i, SQL, PL/SQL, SQL Developer, Autosys, Weblogic 8.1, Tortoise SVN

Confidential

Module Lead (Sr. Database Developer)

Responsibilities:

• Conducting interviews to take the new members into the team
• Involved in code reviews for the code written by other team members.
• Involved in writing PL/SQL blocks which implement business logic.
• Involved in maintain the data models for different instances along with taking care of privileges for roles, users and objects
• Involved in Exporting and Importing tables.

Environment: Oracle 10g, PL/SQL, SQL Developer, PL/SQL Developer, WinSCP, OC4J, Tortoise SVN

Module Lead (Database Developer)

Confidential

Responsibilities:

• Working on Performance Tuning in order to increase the performance of the application in exporting report (CLOB Data).
• Working on all the query changes in the entire application which involve in Virtual Private Database (VPD) context.
• Responsible for creating/ monitoring the user scheduled jobs.
• Responsible for creating the installation guide (contains the steps to apply the release/patch on the production/Test environment) to the client.
• Responsible for updating the DSTD document with the ER Diagrams along with physical data model details of the objects used in the module
• Involved in writing PL/SQL blocks which implement business logic.
• Written Stored Procedures and cursors for various modules in the application.

Environment: Oracle 10g, PL/SQL, SQL Developer, PL/SQL Developer, Putty, WinSCP, OC4J, Eclipse, Tortoise SVN, UNIX