PROFESSIONAL SUMMARY

• 8+ Years of Technical and Functional experience in Implementation, Rollouts, Migration, Customizations, Production Support, and upgrading various business applications utilizing Oracle Applications E-Business suite.
• In-depth Technical and Functional knowledge of Oracle Applications Release 12/11i
• Excellent working knowledge of Procure to Pay (P2P) and Order to Cash (O2C) and Supply chain Management (SCM) life cycles.
• Excellent knowledge of Oracle Application Forms, Reports, PL/SQL and BI/XML Publisher, XML, BPEL and SQL* Loader utilities
• Experience in developing OA pages using Oracle Application Framework (OAF) according to the Business requirements.
• Worked extensively in R12 Oracle Applications Financial Modules like AP, AR, FA, Cash Management & GL Modules and Manufacturing modules like PO, INV, TCA and OM in recent projects.
• Worked on all the aspects of technical design & development of various critical business processes Oracle Applications.
• Experience in Full Life-cycle implementations of Oracle E-Business Suite
• Knowledge in preparation of test cases for End-to-End Testing.
• Strong knowledge in Application Object Library (AOL) and System Administrator Responsibilities.
• Create and Manage SR and research on Oracle Metalink to solve Oracle related Issues.
• Expertise in all aspects of SDLC - analysis, design, coding, testing, performance tuning, documenting, and user training
• Solving business problems with application (Oracle 11i/12i) functionality
• Extensively worked on Performance Tuning and Optimization of SQL Queries and also performed tuning at database level.
• Good at Team Management and capable of handling multiple projects at a time.
• Ability to work effectively while working as a team leader as well as individually.

KEY SKILLS

• Sound Technical and Functional knowledge of Oracle Applications – Financials (AR, AP, GL, Cash Management) and manufacturing modules (PO, INV, OM)
• Proficient with Oracle Application Object Library (AOL) Coding Standards for developing new forms, report and concurrent programs.
• Experience in Design & Development of Oracle Financials modules using PL/SQL, Forms and Reports.
• Familiar with Project and Product Development Lifecycles.
• Extensive experience in Customer Interactions.

SKILL SET

Language : SQL, PL/SQL, C, C++, Java
Tools : Forms 6i/10g, Reports 6i, BI/XML Publisher, OA Framework, Discoverer
Reports, BPEL, SAX, DOM, XSL, HTML and JavaScript.
Databases : Oracle 8i/9i/10g
Development Tools :
Products : Oracle Applications 11i.5.9, 11i.5.10, E-Biz Suite
Environments: Windows 98/NT/2000/XP, UNIX, LINUX

EDUCATION

Master of Computer Applications

PROJECT PROFILE

Role: Technical Lead
Client: Confidential,MI
Duration: July 2008 -Till Date
Project: Oracle Apps Migration and upgrade project from 11.5.10 to R12

Confidential,has its applications running on 11.5.9 and now an upgrade project has been done to R12. Customized many reports in Financials, developed few forms which are used to attach a document for each and every transaction done in Inventory. All the transactions done are categorized and maintained in a tree structure and that tree (hieratical) structure has been shown using the forms developed. User can select a particular document and that document can be printed using another form where it attaches the digital signature from a third party utility. A custom report for tracking all the details of the documents printed, cancelled or deleted has been developed so that the higher management can view the documents of all the transactions happened in Inventory.

Responsibilities:

• Sr. Member of the Product Development Team (Sr. Applications Engineer).
• To work a Techical lead and moniter the progress of the RICE components developed.
• Involved in the full migration cycle from 11i (11.5.10) to Release 12.
• To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
• Setup financial options, purchasing options, receiving options, payables options.
• Defining different Key and Descriptive flex fields as per requirement.
• Modifying/Creating Reports, Forms and Conversions in Accounts payables, Fixed Assets, Purchasing, Order Management and Inventory.
• Transitions of the reports from Report 6i in 11i to XML Reports in R12.
• Developed many custom forms of which one is a setup forms which setups the types of transactions and also setup the sequence to use for a particular transaction. A print form which shows all the trasactions in inventory form in tree structure and a cancellation form which enables users to cancel a particular document giving a reason for cancellation.
• Developed many custom reports which shows all the transactions done in inventory modules using the custom forms.
• Developed Interface program to transfer the data from the cusrtom tables to the standard module.
• Creating FA Deductible Maintenance Cost Report which is used to calculate the deductible maintenance plafond, every year for fiscal purpose.
• Personalization of Inventory transactions form for opening a XX`X`X Inventory document processing form which attaches the decument details to the inventory transaction.
• Developing Inventory Count List report to displays detailed description of Inventory Items.
• Designing a form to setupa a profile option for the user on the usage of custom forms for the security purpose.
• Defining Data Groups, Menu and Report Security Groups.
• Monitor execution activities of unit testing, link testing, integration testing and user acceptance testing.
• Documentation for end user post-training references

Project Name: Projects Oracle Apps Implementation
Client: Confidential,Redwood City (CA)
Duration: Oct 07 – Jun 08
Technical Consulant

This is an implementation project which has implemented all the financial modules. Data loading has been done using the SLQ*Loader. Custom reports have been developed. Custom forms and OA pages using OAF has been done. Modified many standard reports to fit in the requirements. Few forms in Assets modules has been done to capture the details of the assets which are under repair, asstes which has precious materials, and a mass tranfer form which enables users to tranfer a set of assets from one location to another location. An OA page has been developed using OAF to capture the details of the employee and the department mapping.

Responsibilities:

• Creating custom database objects like Tables, Indexes, Views, Synonyms, Triggers, Stored Procedures and Packages
• Developed many forms which captures the data and reports which shows different transactions.
• To develop SQL scripts to create staging tables and developing SQL*Loader control files to load the legacy data into the staging tables. Perform data validations and mappings at staging table level. Developed PL/SQL validation packages.
• Open Purchase Order conversion from the legacy system to standard application.
• Forms to capture data in the asset module
• Done forms personalization on Assets work bench form to open the custom forms developed.
• Custom program to purge all the error AP Transactions in GL_INTERFACE.
• PO Revision Report to shows, for a PO or release, the revision amount ,incremental amount, and total amount of each revision.
• Developed oracle alerts which gives a message on every transaction done in assets module.
• Journal Details Report to print all the journal lines for a range of posting dates and displays the transactions in chronological order.
• To write Form Level trigger to implement specific business rules and policies.
• To do Unit and Integration Testing along the End Users
• To develope Functional Design Documents(MD50) ,Technical Design Documents(MD70) for Order Management, Shipping, Invenoruy, Accouts Payables and Receivables Modules.

Project Name: R12 Russian Locz
Client: Confidential,Russia
Duration: Dec06--Sep07
FA Module Lead

Confidential,requires a Patch to be developed that caters to Russia country specific Localizations. The application modules involved in development of this patch were AP, AR, FA. The localization has been developed on Oracle Financials Release 12. As a module lead, am responsible for developing Financial & FA objects and involved in object development, bug fixing, patches creation and preparing technical design documents. Few custom forms which stores additional data for each asset and validates few fields. Many reports are developed, which display all the details about the assets, created and the additional data, which is stored using the custom, forms. Russian also requires additional global data on standard forms. This has been achieved by enabling the Global Descriptive Flex Fields on different standard forms. For the standard forms, where there is no chance of enabling the global flex fields Localization descriptive Flex fields (LDFF) has been enabled by using a LDFF table and LDFF form.

Responsibilities:

• Technical Analysis of the solution
• Preparing technical design of the solution
• Development of OA pages using Oracle Applications Framework
• Development of custom forms using forms 10g and custom reports
• Development of XML/BI publisher reports.
• Involved in the attending the client meeting for updating the status.
• Creating and updating patches.
• Reviewing and Consolidated Documentation for all the reports and forms.
• Scheduling reports.
• Reviewing the work done by the team for all the FA objects.
• Fixing the UAT bugs and the support bugs.
• Involved in translating the reports, forms and the programs into Russian Language.
• Involved in preparing the plan for the delivery of Fixed Assets objects.
• Create and Manage SRs and research on Oracle Metalink to solve Oracle related Issues.
• Involved in handling the enhancements for the FA objects after releasing them to the Metalink.
• Educating users on the R12 architecture and the Russian Localizations
• Managing SRs on Oracle Metalink to solve Oracle related Issues raised by the customers

Role: Technical Developer
Client: Confidential,Phoenix (AZ)

Duration: Jan-06-Nov-06

Project: Oracle Apps Migration and upgrade project from 11.5.10 to R12

Confidential, is a service group which builds the utility storage products using different technologies. We have upgraded the existing solution from 11.5.9 to 11.5.10. Customised few reports in financials and developed few forms where user can enter the data and the form validates the data and tranfers the data to the interface tables. From the interface tables using PL/SQL packages, functions and standard APIs that data is mapped to the standard tables where in the record appears in the invoice screen.

Responsibilities:

• To work a Techical developer to monitor the progress of the RICE components developed.
• Involved in the full migration cycle from 11i (11.5.10) to Release 12.
• To gather Business requirements, analysing the gaps and design and built to ensure the system meets the required specifications.
• Developed several forms which is used to capture the data entered.
• Developed many reports to cater the transactions done.
• Setup financial options, purchasing options, receiving options, payables options.
• Setup Suppliers, Matching and tolerances, Pay on receipts, Budgetary control, Receipt accrual, Bank reconciliation for Procure to pay cycle
• Defining different Key and Descriptive flex fields as per requision.
• Modifying/Creating Reports, Forms and Conversions in Accounts payables, Receivables, General Ledger, Fixed Assets, Purchasing, Order Management and Inventory.
• Transitions of the reports from Report 6i in 11i to XML Reports in R12.
• Designed and developed Detailed GL Account Analysis Report using XML Publisher. The report displays the GL transactions based on GL dates, supplier, customer, source, category, amount etc. The report includes extracting the transaction details of the Payables and Receivables through sub ledger Module.
• Interface program to create Journal or Invoice in Accounts Payables and Receivables to accomodate the taxation of the Exchange Rate gains and losses between invoice date and payment date. The program includes the creation of Form and a report to display the new transactions created.
• Creating FA Deductible Maintenance Cost Report which is used to calculate the deductible maintenance plafond, every year for fiscal purpose.
• Personalization of Invoice Form for Unique Invoice Number by Supplier and year.
• Developing Inventory Count List report to displays detailed description of Inventory Items.
• Defining Data Groups, Menu and Report Security Groups.
• Documentation for end user posttraining references.

Project Name: Balfour Beatty 11i Support & Enhancements
Client: Confidential,UK
Duration: Feb05-Dec05
Technical Consultant

Confidential,is leading international engineering, construction and services group. The Balfour Beatty Group serves the international markets for rail, road and power systems, buildings and complex structures and is active in four main business sectors.

In Balfour Beatty Support and Enhancements project full fledge support is provided to the 4 Operating Units for which Oracle ERP 11.5.9 was implemented and enhancement and new development are carried out to improve GUI.

A Java program to validate and transfer the records those are loaded through XML. If it has any errors that are transferred to the Error workbench and once again if those records are corrected, those records go out from the error workbench.

Control files have been developed to load data in to Oracle database from flat files using SQL Loader

Responsibilities:

• Development of Custom Journal Entry form to facilitate easy entry of journals and copy existing journals and to reverse journals in period of their wish.
• Development of new custom forms in BBIG and enhancement of the existing BBIG forms.
• Development of new reports in standard Oracle Purchasing, Oracle payables, BBIG and also Customization of reports in Oracle Projects, Oracle payables.
• Development of java code for extracting data from XML files, validate that data and correct the invalid data.
• Development of control files to load data using SQL Loader.
• Interface to insert the extracted data from XML files to the database
• Unit testing of all the developments in custom module.
• Solving the production issues.

Project Name: Balfour Beatty 11i implementation
Client: Confidential,UK
Duration: Dec03–Jan05
Technical Consultant

Confidential,is leading international engineering, construction and services group. The Balfour Beatty Group serves the international markets for rail, road and power systems, buildings and complex structures and is active in four main business sectors.

In Balfour Beatty Support and Enhancements project full fledge support is provided to the 4 Operating Units for which Oracle ERP 11.5.9 was implemented and enhancement and new development are carried out to improve GUI.

A Java program to validate and transfer the records those are loaded through XML. If it has any errors that transferred to the Error workbench and once again if those records are corrected, those records go out from the error workbench.

Control files have been developed to load data in to Oracle database from flat files using SQL Loader

Responsibilities:

• Forms Development:
• Development of Custom Standard PO form to facilitate ease in date entry.
• Development of forms for Custom Module ‘BB Invoice Gateway’.
• Customization of Standard Purchase Order workflow to follow different approval hierarchy for project orders.
• Development of Custom Packages for BBIG invoices Screen.
• Development of Custom D2k reports in Oracle Payables, Purchasing, Inventory, Projects, Assets and receivables, and Custom modules
• Development of control files to load data from flat files using SQL Loader.
• Development of Discoverer reports in Oracle Purchasing and Custom modules.
• Unit testing of above developments.

Project Name: Confidential,
Client: Confidential,Switzerland
Duration: Dec 02–Nov 03
Technical Consultant

Confidential,is the UN specialized agency which seeks the promotion of social justice and internationally recognized human and labor rights. It was founded in 1919 and is the only surviving major creation of the Treaty of Versailles, which brought the League of Nations into being, and it became the first specialized agency of the UN in 1946.

We have built custom module for ILO in existing Oracle application 11i module. The custom module, which is called as Project Budget Proposal system, is collection of few forms and reports and adds as a bolt on to the Projects and HRMS module.

Responsibilities:

• Development of Budget Proposal information form.
• Development of Custom Reports in projects.
• Project Interface development.
• Preparing Technical design documents
• Unit testing of the above developments.

Project Name: Oracle 11i P2P Everest
Client: Confidential,
Duration: Jul 01–Nov 02
Technical Consultant

Confidential,is the worldwide Leader in Networking for the Internet. Cisco’s IP networking solutions are the foundation of the Internet and most corporate, education and governments around the world. Cisco provides the broadest line of solutions for transporting data, voice and video within buildings, across campuses or around the world. Cisco has its applications running on Oracle Applications Release 10.7/11.5.8
The Procure-to-Pay (P2P) for Cisco represents the core finance processes. This track covers all expense processing and financial accounting. The Oracle modules covered under this track are Purchasing, Accounts Payables, Fixed Assets and General Ledger. While the core processes are addressed by the standard functionality within the Oracle Modules, a number of bolt on applications and customizations have been developed to address certain Cisco specific requirements. The current 11i upgrade initiative focuses on upgrade of the core Oracle Applications modules

Responsibilities:

• Involved in up gradation, test cycles support and support.
• Analysis of gap documents and preparation of \'Technical Design Documents\'
• Development / upgradation of customizations
• Preparation of Test case documents and Unit Testing