We provide IT Staff Augmentation Services!

Technical Expert Resume

5.00/5 (Submit Your Rating)

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

We'd love your feedback!