We provide IT Staff Augmentation Services!

Sr. Oracle Pl/sql Developer/ Lead Resume

3.00/5 (Submit Your Rating)

Pittsburgh, PA

SUMMARY

  • Having 11+ Yrs of Experience in Oracle PL/SQL as Oracle Developer.
  • Strong knowledge in Data warehouse.
  • Expertise in Linux and shell scripting.
  • Having knowledge in Oracle 12c features.
  • Good experience in Agile Methodology. Worked as key player in a team.
  • Strong skills in Oracle server side programming which includes SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialize Views, Temporary tables and a very good knowledge in Oracle 10g Developer Suite modules.
  • Effectively Implemented Business Validations using Data Base Triggers.
  • Strong expertise in writing complex SQL Queries.
  • Having experience on performance tuning.
  • Expert in using SQL Loader utilities.
  • Excellent trouble shooting, debugging and error trapping skills.
  • Extensive experience in data migration techniques using SQL* Loader, Import/Export.
  • Worked on UTL packages.
  • Good knowledge in Health Care, Energy, Telcom domains.

TECHNICAL SKILLS

Operating Systems: Red Hat Linux and Windows 2003/XP/7

Databases and Tools: Oracle 9i/10g/11g/12c, SQL Server 2005, TOAD, PLSQL Developer, SQL Navigator

Languages: SQL, PL/SQL, T - SQL, UNIX Shell Scripting

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM

PROFESSIONAL EXPERIENCE

Confidential, Pittsburgh, PA

Sr. Oracle PL/SQL Developer/ Lead

Responsibilities:

  • Project requirement analysis and technical design document preparation
  • Prepared data model for the new projects.
  • Created many batch processes to perform load and run the PL/SQL procedures.
  • Requirements gathering from Clients and implement the back end changes in existing product and in designing the database
  • Involved in SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
  • Responsible for developing code in Oracle PL/SQL to implement application logic as present in DataStage.
  • Developed complex SQL statements using joins, sub queries, analytical functions like Rank(), row number(), over().
  • Used partition exchange concept to load history data into fact tables
  • Involved in different stages of data conversion projects (Database modeling, Data mapping, Coding, Data reconciliation, Testing).
  • Writing SQL scripts and Unix shell scripts to outbound data to downstream partners.
  • Make sure that the ETL procedure runs efficiently for large data sets by improving performance on aspects like Oracle hints, indexes and partitioning.
  • Load data from an external source through various methods like External Tables, DB link and Materialized views.
  • Involved in writing test plans and test cases, business rules, functional and technical designs.

Environment: Oracle 11G/12C, Unix, Workbench, Toad, OEM and Putty.

Confidential

Sr. Database Developer

Responsibilities:

  • Understanding business requirement through series of interaction with client (business analyst).
  • Involved in Oracle DBA activities.
  • Developed scripts to run batch jobs by using shell scripting.
  • Monitoring the Scheduler Jobs on daily basis.
  • Prepare a Solution Approach Document listing the solution, effort required, tools required etc. and propose the same to the client
  • Implementation of the proposed solution within the stipulated time.
  • Unit and functional testing of the implementation.
  • Worked as an offshore team lead.
  • Taken the ownership of reviewed the code done by other team members before sending it to client.
  • Involved in 24*7 Production Support and fixing bugs on a day to day basis.
  • Involved in writing test plans and test cases for the requirement being catered to.
  • Documented business rules, functional and technical designs and application logic.
  • Developed complex SQL statements using joins, sub queries and correlated sub queries and tuning them for optimal performance.
  • Interface liaising with external system teams, deployment teams and Customer co-ordination.

Environment: Oracle 10g, Unix, CVS, Toad and Putty.

Confidential

IT Analyst

Responsibilities:

  • Understanding business requirement through series of interaction with client (business analyst).
  • Understanding business requirement through series of interaction with client (business analyst).
  • Prepare a Solution Approach Document listing the solution, effort required, tools required etc. and propose the same to the client
  • Implementation of the proposed solution within the stipulated time.
  • Prepare test cases and test scenarios.
  • Unit and functional testing of the implementation.
  • Provided Zero-Defect code to the client in continuous 2 releases and got the appreciation for the same.
  • Checking-in files into CVS and requesting for deployment.

Environment: Oracle 10g/11g, Unix, CVS, Toad and Putty.

Confidential

Senior Oracle Developer

Responsibilities:

  • Developed Procedure for automate generation of reconciliation reports.
  • Developed Procedures for automate generation of Daily, Weekly and Monthly reports required by client by using UTL FILE.
  • Developed Procedures for a ‘web portal’ that enables recharge through web.
  • Developed procedures for ‘FIRST TIME (FRC)’ recharge offers for new subscribers.
  • Worked closely with Business Development team for streamlining Reconciliation process for Dealers’ commissions.
  • Prepare a Solution Approach Document listing the solution, effort required etc. and propose the same to the client
  • Developed Procedures for retrieving payment data from Billing Info Tables and inserting it into Confidential Billing Servers by using DB Link
  • Prepare test cases and test scenarios.
  • Unit and functional testing of the implementation.

Environment: Oracle 10g / SQL Server, Unix, Toad and Putty.

Confidential

Oracle Developer

Responsibilities:

  • Developed Procedures to handle Inter-Zone, Zone-Branch reconciliation.
  • Developed Procedures to generate various accounting entries for various components of Installments (Regular Installment, ODC) for Loan-agreements.
  • Being an In-house Development scenario also generated various periodical reports to assist financial reconciliation which is core activity of a multi-location NBFC.

Environment: Oracle 9i / Foxpro

We'd love your feedback!