Experience Summary:

• Over 8 years of hands-on experience in Software Development including Design, Development, Testing, Deployment and Maintenance.
• Expert in Oracle 10g/11g, PL/SQL and SQL
• Knowledge in Oracle Applications ERP E-Business Suite 11i/R12 with RICE components, Order Management OM , Accounts Payables AP and General Ledger GL modules
• Architected simple and complex SQL queries, Stored Procedures, Triggers, Functions, Packages and Indexes
• Engineered design and creation of PL/SQL code, Oracle Forms and Oracle Reports.
• Proficient in Oracle Tools such as TOAD, SQL Developer, UTL FILE SQL Loader
• Experience in Data Migration across different Relational Database Management System RDBMS .
• Involved in Extraction, Transformation and Loading ETL of large volume of data into Data Warehouse
• Knowledge on tools like XML Publisher, ADF, Application Express Framework APEX OAF
• Performed tuning of PL/SQL code by using Explain Plan and DBMS PROFILER
• Well-versed with Database design, Entity Relationship Diagrams ERD , Schema building, Data Modeling and Dimensional Modeling
• Strong experience in building Materialized Views for complex queries
• Strong skills in Business Analysis, Applications Programming and trouble shooting
• Designed Online Transaction Processing OLTP for various client modules
• Contributed in writing strong back-end scripts using Unix shell scripting
• Domain knowledge in Banking, Transport Distribution, Insurance and Telecommunication
• Analyzed and involved in solving Post Production Issues and Tickets
• Involved is writing Functional MD50 Technical Design Document MD70 .
• Good team player with excellent work ethics, self-motivated and quick leaner.

Technical Skills:

• ERP : Oracle Applications 11i/ R12 E-Business Suite
• OPERATING SYSTEMS : Windows 98/2003/2000/XP, UNIX
• DATABASES : Oracle 10g/11g
• LANGUAGES : SQL, PL/SQL, UNIX Shell Scripting, HTML, XML
• DESIGN TOOLS : Oracle Forms Reports 6i/10g/11g, XML BI Publisher
• TOOLS : TOAD, SQL Plus, SQL Loader, SQL Developer, UTL

Projects Summary:

Confidential

Responsibilities:

• Interaction with the client to understand the business requirement
• Preparation of Document of Understanding and MOM
• Involved in Migration from Sybase to Oracle schema using SQL Developer
• Customization of PL/SQL procedures and Functions
• Performed System Integrated Testing to sync up the code and managed the defects
• Performed Data Seeding and Validation process for the requested CR/BRF
• Involved in Monitoring of the data seeded to General Ledger GL tables
• Involved in Deployment of the Application and production support

Environment: Oracle 11.4, PL/SQL, TOAD, Sybase, SQL, SQL Server, Oracle Applications R12.1.3

Confidential

Sr Oracle Developer

Responsibilities:

• Interaction with the client to understand the business requirement
• Development of PL/SQL Functions, Procedures and Packages
• Performed Bug-Isolation and Data-Conditioning for all cycles of BAT110 Wave-3
• Developed and customized Oracle reports from scratch for wave-2 and wave-3 releases
• Involved in Extraction, Transformation Loading ETL of data into Oracle Tables
• Performed Tuning of the PL/SQL code
• Designed ERD and Multi-Dimensional modeling using SQL Developer
• Processed Anti-Money Laundering AML Entities to regulate the Financial System for Wave-3
• Performed Manual Automation Regression Testing for Release 1A, R2a R2b
• Designed and customized Oracle Forms for various entities/attributes
• Involved in Deployment and Provided resolution to the post-production issues/Defects

Environment: Oracle 11g, PL/SQL, HP QC, SOAtest, Oracle Warehouse Builder 11.2, Oracle Forms Reports 11g, SQL Server

Confidential

Sr Oracle Developer

Responsibilities:

• Understanding seeded functionality of ERP P2P cycle.
• Interacted with the client to understand the requirement.
• Customized Conversions for Account Payables
• Customized and deployed PL/SQL Procedures and Packages
• Customization of Oracle Reports for AP.
• Resolved Technical Issues.
• Developed Oracle Forms from scratch
• Customized Oracle Forms Personalization
• Preparation of Technical Design Document.
• Support for the Issues/Enhancement of Tickets and provided Resolution.

Environment: Oracle 11g, Oracle Forms Reports 11g, Oracle Applications R12, PL/SQL, TOAD

Confidential

Oracle Developer

Responsibilities:

• Implemented eTerraSettlements application.
• Coordinated with the customers for requirement gathering and analysis.
• Development of Packages, Procedures, Functions and Triggers
• Proposed Change in Business Logic
• Constant monitoring and performance tuning of the code
• Involved in production support of the application
• Demonstration of the module to the client
• Prepared Technical Design Document

Environment: Oracle 10g, PL/SQL, TOAD, SQL Server and UNIX Shell Scripting,

Confidential

Programmer/Analyst

Responsibilities:

• Implementation of Ebilling Application.
• Involved in client meetings to understand the requirement and Issues.
• Developed and Customized Oracle Forms
• Involved in Conversions to seed data into Account Payables tables
• Development of back-end process code in Unix Shell Scripting
• Analyzed the Issues and Resolution.
• Developed and Customized Oracle Reports
• Unit tested and Performance Tuning of the PL/SQL code
• Prepared Technical Design Document for the application.

Environment: Oracle 10g, Oracle Forms 6i Reports 6i, PL/SQL and UNIX Shell Scripting, Oracle Applications 11i, TOAD