Sr. Oracle Pl/sql Developer/ Lead Resume
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
