Summary:

• Oracle PL SQL programmer with over 7 years of extensive experience in Application Development, Oracle SQL, PL/SQL Development (Oracle 10g/9i), Implementation of ERP (Oracle Apps) Application, Performance Analysis, Production Support, SQL*PLUS.
• Hands on experience in implementing Software development life cycle, leading and executing deliveries and supporting global clients & customers
• Extensive experience working with Oracle 8i/9i/10g including PL/SQL programming.
  Proficient in writing complex SQL Queries, Stored Procedures, Normalization, Database Design, creating Indexes, Functions, Triggers, Sub Queries, Autonomous transactions and Packages on TOAD to analyze very large data sets
• Extensive knowledge of Dynamic SQL and queries
• Strong working knowledge on Oracle Database concepts
• Extensive experience in Performance Tuning (Using TKPROF, SQL TRACE & Explain Plan, Analyzing Indexes) etc
• Hands on experience in Implementation, Development, Enhancement and support of Oracle Apps Modules (Account Payables/ Order Management/ General Ledger/ Purchasing/ Cash Management/ Inventory/ Manufacturing)
• Hands on experience in creating and migrating AOL objects such as Concurrent programs, Value sets, Menus, functions
• Expertise with ERP implementation and Data Conversions
• Experience in designing Oracle Interfaces
• Experience in Oracle E-Business Suite 11i and R12 and Oracle Developer Suite
• Excellent Analytical skills to understand the business process and functionality, requirements and to translate them to system requirement specifications
• Experience in various phases of SDLC like Gathering Requirements, Analysis/Design, Development, Testing and deployment, Go-live and Post GO-live support
• Experience in preparing Test plans, Test Data and execution of Test cases to ensure application functionality meet the user requirements
• Experience in working on SQL Loader, UTL FILE operations
• Well versed with UNIX Scripts and UNIX Shell Scripting
• Experience in handling Production cases and escalations
• Expertise in system integration testing, preparing design documents
• Ensured Project compliance to Quality and Standard implementation methodology – Drive QA processes for the project in the program, Participate in CMMI Level 5, Identify, communicate and implement opportunities for process/solution improvement; Establish CMMI process to control defects and improve customer satisfaction
• Have good experience in Onsite-offshore model execution of projects
• Excellent documentation and presentation skills, great verbal and written communication skills
• Analytical thinker, quick learner and proficient problem solver who envisions business and technical perspectives to develop workable solutions

Educational Qualifications:

• Master of Business Administration ( Operations Management), Confidential University
• Bachelor of Science (Computer Applications), Confidential University

Technical skills:

Oracle Development Tools : Oracle Developer Suite

Tools: SQL, PLSQL, SQL Developer Oracle Apps

Modules: Oracle Payables, Oracle Receivables, Oracle General Ledger, Oracle Inventory, Oracle Order Management, Oracle Purchasing, AOL, Sys Admin, SABRIX

ERP Tools: Oracle R12, Oracle Reports 6i/9i/10g, Oracle Forms 6i

Database Environments: Oracle 10g, 9i

Script Languages: UNIX Shell scripting

Programming Languages: C, C++, HTML

Database Tools: TOAD 8.0/9.0, SQL*PLUS, SQL Developer, Data Loader, Putty, Workflow Builder

Operating systems: Windows 9x/2000/XP/NT/Vista, UNIX

Version Control tools & other tools: PVCS Tracker, VSS, Share Point, Remedy Tool, MS Office, Citrix

Web Development Tools: Macromedia Dreamweaver, Adobe Photoshop, Macromedia Flash, CSS

Professional Experience:

Client : Confidential Project Duration : Jun’10 to Mar’12 Location : Edison, NJ Technology & Modules : PL SQL, SQL, Oracle Payables, Oracle Receivables, SABRIX, Oracle 10g, Oracle Reports, UNIX Shell Scripting Type : Implementation

Role : Sr. PL/SQL Developer

This project deals with handling customizations around Tax calculations and integrating SABRIX with Oracle for a worldwide leader in networking.

Responsible for:

• Preparation of Technical Specifications
• Design, Development and testing of new RICE Objects
• Code review, Preparation of Unit Test plans and involved in User acceptance testing
• Responsible for migrations of AOL and other database objects to production instances

Contribution:

• Worked on PLSQL packages and various customizations involving UNIX shell scripting
• Designed various custom tables in Oracle 10g on the existing application
• Designed and Developed Oracle Reports (RDF) for customizing AP module
• Extensively involved in testing the customizations in Oracle account payables module
• Actively involved in testing the custom components
• Prepared the Technical design documents for the modules involved
• Build, test and deliver customizations
• Prepared the design document for customizations made in Account Payables module as part of knowledge transition

Client : ConfidentialProject Duration : Apr’09 to Dec’09 Technology & Modules : PL SQL, Oracle Payables, SABRIX, Oracle Reports, UNIX Shell scripting, Oracle 10g Type : Implementation

Role : Technical Lead / PLSQL Developer

This project deals with handling customizations around Tax Calculation and integration of SABRIX with Oracle for Confidential.

Responsibility as Technical lead:

• Responsible for work allocation to the team (team size 5)
• Preparing and presenting weekly status report to the client
• Reviewing the technical specifications and the code changes
• Conducting Unit testing, reviewing test cases and test plans
• Guiding the junior resources on technical issues
• Responsible for day to day deliverables

Responsibility as Developer:

• Preparation of Technical Specifications
• Design, Development and testing of new RICE Objects
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Requirement Analysis, Collection of information from the client and co-ordinate with offshore team to accomplish the tasks

Contribution:

• Worked extensively on PLSQL cursors, Stored Procedures
• Worked on PLSQL packages and various customizations
• Designed global temp tables for developing custom components in Oracle 10g
• Designed various custom tables in Oracle 10g on the existing application
• Worked on UNIX Shell scripting to customize and support the implementation
• Designed and Developed Oracle Reports (RDF) for customizing AP module
• Solely involved in testing the customizations in Oracle account payables module
• Interacted with Client IT Team and business users for post Go-Live support activities
• Actively involved in testing the custom components
• Prepared the Technical design documents for the modules involved
• Build, test and deliver customizations
• Maintaining and publishing the status report for deliverables on daily basis

Role : Technical consultant / Module Lead

This project deals with implementing an end-to-end ERP solution, the Arrow ERP system is required to be integrated with several others standalone systems for data exchange. These interactions include data exchange between Arrow and its trading partners (both vendor and customer) as well as data exchange between Arrows Internal Systems.

Responsible for:

• Preparation of Technical Specifications
• Coordinating with the onsite counterpart; understanding the requirements and customizing the components and to coordinate with the team in getting the deliverables on time
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects that are customized

Contribution:

• Designed and created staging tables for the inbound and outbound interfaces
• Worked extensively on PL SQL packages
• Worked extensively on stored procedures, functions, cursors
• Worked on SQL Loader for loading data into staging tables
• Worked extensively on performance tuning activities like analyzing the TKPROF, SQL TRACE
• Worked on data mapping for creating the inbound, outbound programs
• Developed inbound and outbound interfaces in Oracle modules – Order Management, Purchasing
• Creating AOL concurrent programs and migrating the same to other environments
• Understand Client Business process and preparing the technical design documents for the inbound and outbound interfaces
• Co-ordination with Onsite Interface Track lead
• Provide feasible solutions for the customization
• Co-ordinate between Onsite and Offshore Interface Teams
• Maintaining & publishing the status report of deliverables on weekly basis
• Design Technical design document in project

Client : Confidential Project Duration : Jul’06 to Jul’08 Technology & Modules : PL/SQL, SQL, Oracle 10g database, TOAD, Oracle R12, Oracle Extensions, Oracle Reports, Oracle Forms Type : Implementation

Role : Oracle PL SQL Developer / Technical Consultant

Responsible for:

• Preparation of Technical Specifications based on Functional Specification
• Coordinating with onsite counterpart, understand the requirement and deliver the code
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects

Contribution:

• Worked on PL SQL code to submit the concurrent programs programmatically and test the process
• Worked extensively on PL SQL packages, stored procedures, functions, cursors and arrays
• Have extensive knowledge in creating global temp tables
• Worked on UNIX shell scripting which sends email to users with text output as an attachment
• Involved in end to end testing of the custom components
• Co-ordination with Onsite team for the deliverables
• Understand Client Business process and prepare the design documents and test plans
• Involved in integration testing

Client : Confidential Project Duration : Apr’06 to May’06 Technology & Modules : PL/SQL, SQL, TOAD, Oracle 9i, Oracle Payables, Oracle Receivables, Oracle 11i, Oracle Reports, Oracle forms, Oracle Interfaces Type : Support

Role : PL/SQL Developer

Responsible for:

• Requirements Gathering, Requirement Analysis and preparation of issues logs
• Fixing issues during User acceptance testing, Change requests
• Development of the objects on PLSQL
• Preparation of Technical Specifications based on Functional Specifications
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects

Contribution:

• Working on Oracle Custom Reports (RDF), PL SQL custom packages, stored procedures, cursors
• Understand the change requests and alter the SQL queries and tuning the same
• Testing the changes made in the existing custom components

Client : Confidential Project Duration : June’05 to Mar’06Technology & Modules : PL/SQL, SQL, Oracle 11i, Oracle Reports, Oracle Interfaces, Oracle Payables, Oracle Order Management, Oracle Inventory, Oracle General Ledger, Oracle Purchasing, UTL_FILE, TOAD, UNIX Shell Scripting 
Type : Implementation

Role : Technical Consultant

This Project deals with end-to-end ERP implementation for Emerson Climate technologies – Reynosa for Oracle Financial modules – Oracle Payables, Oracle General Ledger and Manufacturing modules like Work in progress, Bills of Material, Purchasing, Order Management.

Responsible for:

• Requirements Gathering, Requirement Analysis and Design & Development
• Preparations of Technical Specifications and Development of the objects
• Code review, Preparation of Unit Test plans and Participating in User acceptance testing
• Performance improvement process for the objects
• As a configuration controller, I was primarily responsible for version management of the functional specifications, technical specifications, test documents, code and other documents in the project

Contribution:

• Worked extensively on PL SQL packages, stored procedures and cursors
• Migrating the custom tables, PL SQL packages to other environments and testing the custom code
• Worked extensively on UTL_FILE functions, UNIX shell scripting
• Developing the Custom Oracle Reports (RDF) on Oracle Accounts Payables, Oracle General Ledger, Oracle Order Management modules and testing the custom reports
• Designed and developed custom tables using Oracle 10g based on existing application for the Inbound and Outbound Oracle Interfaces
• Worked extensively on Registering Oracle Reports (RDF) and creating and migrating Concurrent Programs to other environments
• Co-ordination with the onsite team
• User requirement gathering, design & development of Inbound and Outbound interfaces in Oracle Financial and Manufacturing modules
• Developing Unit test plan
• Performing Unit testing, Integration testing
• Coordinating with functional team leads for functional testing
• Updating the Test documents
• Providing support for the post go-live activities

Client : Confidential Project Duration : Apr’04 to May’05 Technology & Modules : PL/SQL, SQL, Oracle 9i database, Oracle 11i, Oracle Reports, Oracle Interfaces, Oracle Payables, Oracle Order Management, Oracle General Ledger, UTL_FILE, TOAD Type : Implementation

Role : Oracle Technical Developer, Configuration Controller

This Project deals with end-to-end ERP implementation for Emerson Process Management – Poland Implementation for Oracle financial modules – Oracle Payables, Oracle General Ledger and Manufacturing modules like Purchasing, Order Management and Oracle Projects.

Responsible for:

• Requirements Gathering, Requirement Analysis and preparation of issues logs
• Preparations of Technical Specifications from Functional Specifications
• Development of the objects
• Code review, Preparation of Unit Test plans and Participating in User testing
• Performance improvement process for the objects
• Responsible for the objects Signoff to production system and On-Time Delivery
• As a configuration controller, I was primarily responsible for version management of the functional specifications, technical specifications, test documents, code and other documents in the project

Contribution:

• Have hands on experience in designing PL SQL packages, Stored Procedures and functions
• Worked extensively on Oracle Reports (RDF) for the customizations in Oracle Accounts Payables, Oracle Order Management modules
• Performing extensive testing of the custom components developed in Oracle Accounts Payables module
• Have extensive knowledge in SQL query tuning and generating the TKPROF and SQL TRACE
• User Requirement gathering, design & development of new Oracle Reports, Inbound and Outbound interfaces in Oracle Financial and Manufacturing modules
• Customizing the existing Oracle reports in Account Payables, Order Management as per the new requirements
• Working on AOL, Concurrent programs, migrating the Oracle Apps AOL components like Value sets, Menus
• Involved in patching, registering the Oracle reports developed in various instances as a part of the customization process
• Co-ordination with the onsite team
• Developing Unit test plan
• Performing Unit testing
• Coordinating with functional team leads for functional testing
• Updating the test documents
• Providing support for the post go-live activities