SUMMARY:

• Around 14 years of experience in design, development and production support of Oracle E - business Suit Applications, Database programming and OAF web applications.
• Around 9 years of experience in full life-cycle implementation, upgrade and supporting applications using Oracle Applications R12/11i.
• Oracle Applications development experience with SQL, PL/SQL, SQL Loader, Oracle Reports, Oracle, Workflow2.6, BI (XML) Publisher, Oracle Discoverer, OA Framework and AOL.
• Experience in AP, AR, PO, PON, iSupplier, iExpenses, EAM and OM modules.
• Experience in design, implementation, development, support and migration of interfaces and conversion.
• Experience in upgrade from 11i to R12 of RICEW components.
• Sun certified Java programmer and extensive experience in personalizations, extensions, development, upgrade and migration of OAF applications. Have experience in JAVA, JSP, Servlets, J2EE, Web logic, Jdeveloper.
• Strong analytical and problem solving skills, excellent written, oral and presentation skills and good team player.
• Experience in AIM software development life cycle, CMM level 5 and 6 Sigma quality standards.

TECHNICAL SKILLS:

EBS: Oracle Applications R12/11i/10.7 (GL, AP, AR, PO, PA, OM, INV and HRMS)Oracle Forms 6i/6.0 and Oracle Reports 10g/6i/6.0 SQL, PL/SQL, SQL LoaderBI/XML publisher, Oracle Discoverer

Databases: Oracle 10g, Oracle 9i/8.x/7.x, SQL Server 6.5/7.0/2000

Web technologies: OAF, ADF, Java, J2EE, JSP, HTML, XML, Java script, Jdeveloper

Data warehousing: Informatica5.1/6, BO, Data Stage

Design tools: Erwin

Migration tools: Kintana

PROFESSIONAL EXPERIENCE:

Confidential

Solutions Architect

Technical Environment: Oracle Applications R12.1.2, J Developer 10g, Oracle 11g, OAF

Responsibilities:

• Responsible for designing inbound, outbound interfaces as per the business needs for AP, Inventory, PA, EAM etc.
• Responsible for interacting with client, functional consultants to understand the requirement and design interfaces using Oracle open interfaces.
• Responsible to develop technical design documents, source file to interface table data mapping documents, pseudo code development, technical objects design.
• Responsible for communicate requirements to development team at offshore and overview the development activities.

Confidential

Solutions Architect

Technical Environment: Oracle Applications R12.1.2, J Developer 10g, Oracle 11g, OAF

Responsibilities:

• Responsible for interacting with business, analysis, production support issues, enhancements, bug fixing and development of RICEW and BI reports.
• Responsible for design, development personalizations, extensions to iSupplier, iExpenses and iProcurement modules.
• Responsible to develop technical design documents, migration scripts and migration plan documents.
• Responsible for development of custom modules using OAF.
• Responsible for development of custom workflows and customize workflows.
• Raised SRs for the issues related to Oracle code and worked with Oracle support to fix the issues.

Confidential

Solutions Architect

Technical Environment: Oracle Applications R12.1.2, J Developer 10g, Oracle 11g, OAF

Responsibilities:

• worked on post production tickets, code fixing to resolve many bugs in OAF pages, database procedures, packages, oracle report queries in AR, AP, PO, iSupplier and iExpenses.
• Responsible for on development of enhancements to OAF applications, developed new pages and added new functionality to the existing pages
• Responsible for R12 upgrade of OAF custom modules, modified the Entity objects, View objects according to changes to database and changes to OAF.
• Responsible for EBS upgrade from 11i to R12. Modified the database objects code according to the database changes in R12 in Banks, Customers, Suppliers etc.
• Also modified the Oracle reports queries according to changes in R12.
• Responsible for code migration, development of migration documents and scripts
• Responsible for development of custom modules using OAF.
• Responsible for development of custom workflows and customize workflows.

Confidential

Solutions Architect

Technical Environment: Oracle Applications R12.1.2, J Developer 10g, Oracle 11g, OAF

Responsibilities:

• Responsible for upgrading Oracle reports to R12. Modified the reports query as per the changes in R12 database.

Confidential

Consultant

Technical Environment: Oracle Applications R12.1.2, J Developer 10g, Oracle 11g, OAF

Responsibilities:

• Responsible for design, development and implementation of data conversions, interfaces, report development for Oracle Receivables, Oracle Payables and Oracle General Ledger.
• Responsible for development of PL/SQL packages, scripts to validate and load data for data conversions. And load base tables using Customer Interface and Auto Invoice interfaces.
• Responsible to develop and customize Reports using Oracle Reports and BI publisher.
• Responsible for personalization, extensions and development of new web pages using OAF.
• Responsible for design and maintenance of technical design documents.

Confidential

Consultant

Technical Environment: Oracle EBS 11i, Forms 6i, Reports 6i, Oracle Discoverer, XML Publisher, Work Flow 2.6, TOAD, SQL Plus, PL/SQL, UNIX, WINDOWS 2000

Responsibilities:

• Responsibilities include development, support of Oracle financials, Oracle Reports, Oracle BI, bug fixes and enhancements for BioReliance financials.
• Responsible for development, maintenance, deployment, trouble shooting and problem solving for Oracle Applications.

Confidential

Consultant

Technical Environment: Oracle Applications 11i, Developer 2000(Forms 6i, Reports 6i), Oracle Discoverer, XML Publisher, Work Flow 2.6, TOAD, SQL plus, PL/SQL, UNIX

Responsibilities:

• Responsible for design, development and implementation of AP out bound interfaces to transfer RCI supplier payments to City Bank.
• Developed Electronic File Transfer (EFT) payment system to transmit RCI Latin America supplier payments via a bank interface to Citibank for each RCI country. EFT payments using out bound interface was implemented for RCI Latin America countries Argentina, Brazil, Colombia, Chile, Mexico, Uruguay and Venezuela.
• Developed separate PL/SQL packages for each RCI country to create the EFT Payment file in the given country specific file format from the data extracted from different tables in Oracle Payables.
• Validate the output files generated by out bound interface.
• Create payment batches in Oracle using the custom payment format to create flat file.
• Setup the payment format programs within Oracle Payables.
• Responsible for creation of AOL objects and migration of AOL objects using FND LOAD.
• Design and development of Reports for Accounts Payables and HRM using Oracle Reports and Discoverer.
• Developed reports using XML publisher for Accounts Payables module. Developed RTF templates, converted Oracle reports to XML publisher reports. Also installed and configured XML publisher.
• Designed and developed data models, XML Schemas, DTDs, XML templates for data conversions and migrations. Analyzed and validated XML schemas based on organization information needs.
• Responsible for design, development of Oracle reports for AP Invoice printing, Check printing and reports for HR data.
• Involved in enhancements and bug fixes in Oracle Reports, PL/SQL packages for
• Oracle financials modules.
• Developed new discoverer reports and enhancing existing reports as per the requirements for financial modules.

Confidential

Consultant

Technical Environment: Oracle Applications 11i, Developer 2000(Forms 6i, Reports 6i)Oracle Discoverer, Work Flow 2.6, TOAD, SQL plus, PL/SQL, UNIX, WINDOWS

Responsibilities:

• Responsible to study the existing reports on legacy system and checking on the feasibility to develop the reports using Oracle Reports or Oracle Discoverer.
• Designing the new report layouts based on the client requirements.
• Design and development of Discoverer reports for Work Order, Purchasing, Inventory and General Ledger.
• Developed design documents and training material for users.
• Trained the users on how to develop reports on Discoverer.
• Coordinated team at offshore, explained the design specifications to offshore team and helped the team to develop the reports. worked with functional consultants to test the reports functionality.

Confidential

Oracle Apps Technical Consultant

Responsibilities:

• Responsible for design, development and implementation of data conversions, interfaces, report development for Oracle Receivables, Oracle Payables and Oracle General Ledger.
• Responsible for development of PL/SQL packages, scripts to validate and load data for data conversions. And load base tables using Customer Interface and Auto Invoice interfaces.
• Responsible for development of PL/SQL packages for data conversions of Items, Vendors for PRISM using Compusearch Interface.
• Developed conversion packages using TCA API to create customer contacts, contact Roles and Banks in customer conversion of IHS agency.
• Responsible to develop and customize Reports using Oracle Reports and Oracle Discoverer.
• Developed technical design documents and conducted walkthrough of design document with the clients.
• Responsible for database and AOL objects migration to production using Kintana tool.
• Worked in stabilization team on fixing issues in production, data fixes and code fixes.
• Involved in performance testing and analysis.