Technical Expert Resume
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 teh SQL queries which takes long time to process teh request using Explain Plan, hints to reduce teh 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, Golden Benthic
PROFESSIONAL EXPERIENCE
Confidential
Technical Expert
Responsibilities:
- Debugging teh complex issues and halping teh team to investigate teh complex issues.
- Responsible for analysis of support issues
- Investigating data discrepancy issues, performance issues, data issues etc.
- Preventive and corrective action for teh 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 teh staging tables.
- Creating indexes on tables to improve teh performance by eliminating teh full table scans and views for hiding teh actual tables and to eliminate teh complexity of teh large queries.
- Handled automations of various day to day tasks.
- Debugging teh PL/SQL code, proposing teh solution to R&D for teh 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 teh business logic.
- Ensure OM and teh 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 teh team in automating teh operations tasks and preparing teh automated reports.
- Responsible for analysis of support issues and getting teh work done from teh team members as per teh task plan.
- Debugging teh PL/SQL code, proposing teh solution to R&D for teh code change if necessary.
- Daily/weekly status call with ESO manager. Various report preparation & Follow-ups.
- Escalating teh issues found while supporting teh product and proposing teh solution to R&D for teh fix if required.
- Follow-ups with teh team members to make sure dat teh technical manuals, Knowledge base documents are updated regularly.
- Monitoring teh team member's performance, tracking their performance and halping them to grow further.
- Making sure dat teh noledge doesn’t stay with one individual but at teh team/organization level.
- Debugging teh complex issues and halping teh team to investigate teh complex issues.
Environment: PL/SQL, Oracle 9i, SQL, TOAD, SQL Developer
Confidential
Technical Expert
Responsibilities:
- Involved in teh data audit projects for various clients by Identifying various issues at teh data import & export interfaces and fixed them to correct teh root cause of teh issues to improve teh quality of teh data.
- Understanding teh 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 teh staging tables.
- Prepared test cases and SQL scripts for testing
- Performed unit testing on teh newly coded procedures and documenting teh same.
Environment: PL/SQL, Oracle 9i, SQL, TOAD, SQL Developer
Confidential
Sr. Developer
Responsibilities:
- Understanding teh 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 teh System Requirements & teh 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 teh Test Scenarios.
- Designing and Executing teh Test cases.
- Reporting and Updating teh 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 teh data from Flat files into tables.
- Prepared installation Document and Operations Document before handing them to teh 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 teh operations team
Environment: Oracle 8i, SQL, PL/SQL Developer
