We provide IT Staff Augmentation Services!

Team Lead Resume

Herndon, VA

SUMMARY

  • Over 7 years’ experience in Oracle PL/SQL Development, Database Maintenance, Coding, Design, and Production Support using Oracle 9i, 10g & 11g in Production and Staging environments.
  • Experience in SQL, PL/SQL objects like Stored Procedures, Functions, Packages, Triggers, Tables, Table Partitions, Views, Synonyms, Sequences, Cursors and Indexes; utilized advanced features for PL/SQL programming like cursor variables, Ref. cursors, bulk collect, etc.
  • Proficient in creating functional and technical designs based on customer requirements.
  • Hands on experience in data migration activities like Export and Import utilities using SQL *Loader.
  • Exposure and knowledge of Performance tuning, gathering table statistics for Query optimization, troubleshooting and monitoring the daily running scripts to maintain and increase the performance of database.
  • Oracle Certified Associate (OCA 10g) certified as PL/SQL Developer.
  • Onsite visit to Denmark as application developer for one of the complex and crucial functionalities of TIA (The Insurance Application, Denmark): - Tariff calculation.
  • Good written and verbal communication skills; available with little notice to interview via phone/Skype.

TECHNICAL SKILLS

  • ORACLE 9i/10g/11g
  • Oracle Developer suite 9i/10g/11g
  • Toad
  • Oracle PL/SQL Developer
  • SQL*Plus
  • SQL*Loader
  • Oracle Forms 9i
  • UNIX Shell Scripting
  • Rumba
  • HP Quality Center
  • ITSM Remedy
  • Autosys.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Team Lead

Responsibilities:

  • Develop PL/SQL Packages, Procedures and Functions in accordance with Business Requirements for loading data into database tables.
  • Develop database objects including tables, Indexes, views, sequences, packages, triggers and procedures to troubleshoot any database problems.
  • Tune complex Stored Procedures for faster execution and Develop database structures, according to the requirements.
  • Generate Adhoc reports as per the business requirement, which involve complex SQL queries.
  • Work on the Autosys Jobs; run the batch processes and resolve any issues during the batch.
  • Work on and support issues during the Oracle Database upgrade to 11.2.0.4.
  • Provide support during the UAT/BAT/QA phases; work on onsite /offshore model; resolve day-to-day tickets raised by the End users.
  • Work on the Change requests/Work Requests/Problem tickets.

Environment: Oracle 11g/10g, PL/SQL, TOAD, Unix Shell Scripting, Autosys Job scheduler

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • Gathered customer requirements and created functional and technical design documents based on them.
  • Created different schemas and maintained schema objects.
  • Created new packages and modified existing codes to resolve application bugs.
  • Created database objects like packages, procedures, and functions according to the client requirement.
  • Developed SQL scripts to create new tables with partitions to hold millions of records; views, triggers, indexes.
  • Extracted data from data warehouse and loaded into SFR tables using SQL*Loader.
  • Involved in fine-tuning the existing packages for better performance.
  • Provided the guarantee period support to the end users for the code developed and did bug fixes.

Environment: Oracle 11g, SQL*Loader, SQL, PL/SQL, Toad, HP Quality center

Confidential

Senior Oracle PL/SQL Developer

Responsibilities:

  • Worked with Business users to gather requirements for developing Sweden GSR interface module (claim related interface).
  • Wrote Stored Procedures, Functions, Packages using utl file APIs and triggers using PL/SQL to implement business rules and processes.
  • Created GSR claims interface screen using Oracle Forms 9i.
  • Fine-tuned and optimized number of SQL queries and performed code debugging using Oracle PL/SQL developer.
  • Tuned SQL queries, performed refinement of the database using tools like Explain Plan, and TKPROF to significantly improve the system response, time and efficiency.
  • Developed stored procedures, functions and packages for updating, inserting and deleting data from tables.

Environment: Oracle 10g, SQL, PL/SQL, Oracle Forms 9i, Oracle PL/SQL developer, SQL* Plus

Confidential

Oracle PL/SQL Developer

Responsibilities:

  • Created technical design by analyzing and reviewing the functional design provided by the onsite Tryg team.
  • Generated DDL statements for creation of new database objects like tables, views, sequences, functions, synonyms, indexes, and triggers.
  • Created custom functions, stored procedures, packages, database triggers to develop a very complex functionality of TIA - Tariff calculation.
  • Enhanced the existing packages for better performance and provided on­going support to existing applications and troubleshooting serious errors when occurred.
  • Created new batch jobs and fixed existing batches so that they take lesser time to execute.
  • Fixed the re-occurring problems in the batches and provided permanent fixes.
  • Set dependencies and prioritized the batches so that the overall batch execution flow finished on time or as needed by the business.
  • Monitored daily, weekly and monthly batches for both Sweden and Finland using Rumba application.
  • Troubleshot the batch processes in case of any failure and re-ran them.
  • Created and maintained the batch flow diagrams.
  • Documented technical specifications for future reference and technical manuals for users to deploy process on remote databases.
  • Worked on the Change requests/Work Requests/Problem tickets.
  • Looked into Production issues and resolved day-to-day tickets which comprised of doing SQL data fixes and making changes in existing packages, procedures and forms.
  • Solved tickets of E1, E2, E3 and E4 priority without breaching any SLA. Tickets varied from simple data updates/insertions to making extensive code changes to packages and procedures.

Environment: Oracle 11g, SQL, PL/SQL, Oracle Forms 9i, Toad, SQL*Plus, Rumba batch scheduler, ITSM Remedy

Confidential

Associate Oracle PL/SQL Developer

Responsibilities:

  • Converted legacy data from legacy AS400 system to Oracle database. This involved creating new packages with bulk collect, procedures, functions, database triggers, tables to fetch data from legacy system and inserting them into TIA tables based on logic defined in technical and functional designs.
  • Generated DDL/DML statements for creation/updating of new database objects like tables, views, sequences, functions, synonyms, indexes, and triggers.
  • Created Insurance application screens using Oracle Forms 9i.
  • Performed SQL and PL/SQL tuning and Application tuning using various tools like Explain Plan, TKPROF, and Autotrace.
  • Wrote complex SQL statements using joins, sub queries, and correlated sub queries.
  • Utilized ref cursors to load legacy data into Staging tables and relevant Packages to validate and cleanse data, created Cursors, Collections and DB Triggers.
  • Provided the guarantee period support to the end users for the code developed and did bug fixes.

Environment: Oracle 11g/10g/9i, PL/SQL, Oracle PL/SQL developer, Oracle Forms 9i, HP Quality Center

Hire Now