SUMMARY

• Over 9 years of programming experience as an Oracle PL/SQL Developer in development, testing and operations/support in Pharmaceutical/Health Care domain.
• Supported Cegedim's One - Key and Dendrite's Confidential Databases.
• Expertise in Client-Server application development using Oracle 11g/10g/9i, PL/SQL, SQL *PLUS, SQL Developer, PL\SQL Developer, TOAD and SQL*LOADER.
• Created Tables, Views, Constraints, Indexes.
• Developed Complex database objects like Stored Procedures, Functions, Packages, cursors and Triggers using SQL and PL/SQL.
• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Loaded Data into Oracle Tables using SQL Loader.
• Expertise in Dynamic SQL, Collections and Exception handling, Analytical functions, Materialized Views, Records and PL/SQL Tables.
• Experience in SQL performance tuning.
• Tuning of the SQL queries which takes long time to process the request using Explain Plan, hints to reduce the response time.
• Strong noledge in ETL.
• Good noledge in Creating shell scripts for invoking SQL scripts.
• Knowledge in python programming.
• Experience in test plan design, writing test cases, triage meetings, test completion reports.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11g, SQL Server, DB2

Oracle Tools: SQL*Loader, TOAD, PL/SQL Developer, SQL Developer, SQL*Plus, UTL FILE utility

Data Warehousing: Data stage, Informatica

OS: Windows, Unix

Languages: SQL, PL/SQL, Java, XML, C, Python, Unix

GUI Tools: Oracle Forms/ Reports, TOAD, PL/SQL Developer, Gloden Benthic

PROFESSIONAL EXPERIENCE

Confidential

Technical Expert

Responsibilities:

• Debugging the complex issues and halping the team to investigate the complex issues.
• Responsible for analysis of support issues
• Investigating data discrepancy issues, performance issues, data issues etc.
• Preventive and corrective action for the support issues

Confidential

Technical Leader

Responsibilities:

• Wrote packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Creating indexes on tables to improve the performance by eliminating the full table scans and views for hiding the actual tables and to eliminate the complexity of the large queries.
• Handled automations of various day to day tasks.
• Debugging the PL/SQL code, proposing the solution to R&D for the code change if necessary.
• Daily/weekly status call with ESO manager. Various report preparation & Follow-ups.
• Wrote complex PL/SQL subprograms, packages, procedures, functions and DB triggers using Toad to implement the business logic.
• Ensure OM and the client system is in sync.
• Script to perform generic sync refresh is developed, which can be used where OM and AIS queues are used.
• Daily sync report preparation & Follow-ups.
• Reviewing sync refresh queries, root cause analysis of any potential issue.
• Preparing adhoc Reports and Scripts on Request.
• Unit Test Scripts preparation and Unit testing.
• Product support and maintenance activities.
• Participate in Process Improvement efforts.

Environment: SQL, PL/SQL, Oracle 10g, TOAD, SQL Developer

Confidential

Technical Leader

Responsibilities:

• Leading and mentoring a Production Control support and operations team
• Encouraging the team in automating the operations tasks and preparing the automated reports.
• Responsible for analysis of support issues and getting the work done from the team members as per the task plan.
• Debugging the PL/SQL code, proposing the solution to R&D for the code change if necessary.
• Daily/weekly status call with ESO manager. Various report preparation & Follow-ups.
• Escalating the issues found while supporting the product and proposing the solution to R&D for the fix if required.
• Follow-ups with the team members to make sure that the technical manuals, Knowledge base documents are updated regularly.
• Monitoring the team member's performance, tracking their performance and halping them to grow further.
• Making sure that the noledge doesn’t stay with one individual but at the team/organization level.
• Debugging the complex issues and halping the team to investigate the complex issues.

Environment: PL/SQL, Oracle 9i, SQL, TOAD, SQL Developer

Confidential

Technical Expert

Responsibilities:

• Involved in the data audit projects for various clients by Identifying various issues at the data import & export interfaces and fixed them to correct the root cause of the issues to improve the quality of the data.
• Understanding the interface used
• Developed SQL, PL/SQL Procedures/ functions/Packages
• Wrote SQL, PL/SQL Procedures/ functions/Packages to fetch complex data from different tables in remote databases using joins, sub queries and database links.
• Used SQL*Loader as an ETL tool to load data into the staging tables.
• Prepared test cases and SQL scripts for testing
• Performed unit testing on the newly coded procedures and documenting the same.

Environment: PL/SQL, Oracle 9i, SQL, TOAD, SQL Developer

Confidential

Sr. Developer

Responsibilities:

• Understanding the System Requirements.
• Preparing Design Document
• Code Review
• Developing backend SQL, PL/SQL Procedures/ functions/Packages/ Triggers
• Prepared test cases and SQL scripts for testing

Environment: PL/SQL, Oracle 8i, SQL, TOAD, SQL Developer

Confidential

Sr. Developer

Responsibilities:

• Understanding the System Requirements & the pre-requisites.
• Preparing Design Document
• DB Refresh, Data Loading, Developing backend SQL, PL/SQL Procedures/ functions/Packages/ Triggers
• Preparing SQL scripts for testing
• Developed and maintained automation scripts
• Performed Unit Testing, Integration Testing and Performance Testing.
• Test plan design, writing test cases, triage meetings, test completion reports.

Environment: PL/SQL, Oracle 8i, SQL, TOAD, SQL Developer

Confidential

Sr. Developer

Responsibilities:

• Developing the Test Scenarios.
• Designing and Executing the Test cases.
• Reporting and Updating the Issue list
• Performed Unit Testing, Integration Testing and Performance Testing.
• Test plan design, writing test cases, triage meetings, test completion reports.

Environment: Web Based Application (Front end Testing)

Confidential

Sr. Developer

Responsibilities:

• Performed Data Analysis (root cause analysis to prevent erroneous delivery of data)
• Prepared Design document.
• DB Refresh, Data Loading, Developing backend SQL, PL/SQL Procedures/ functions/Packages/ Triggers
• Preparing SQL scripts for testing
• Prepared SQL Loader Scripts to load the data from Flat files into tables.
• Prepared installation Document and Operations Document before handing them to the Operations team.

Environment: PL/SQL, Oracle 8i, SQL, PL/SQL Developer

Confidential

Developer

Responsibilities:

• DB Refresh, Data Loading, Developing backend SQL, PL/SQL procedures/functions/packages/triggers
• Preparing SQL scripts for testing
• Performed Sanity check
• Prepared installation document and operations document before handing them to the operations team

Environment: Oracle 8i, SQL, PL/SQL Developer