SUMMARY:

• 11+ years of experience in Oracle EBS Implementations and custom deployment projects as Lead Techno Functional Consultant.
• Excellent skills in understanding and analyzing the business requirements, GAP’s and provide a feasible technical solutions for various RICEFW components.
• Experience in implementing Oracle EBS - Finance Suite (GL, AP, AR and FA), SCM Suite (OM, INV and PO) with HRMS and Projects (PA) .
• Successfully completed three full life cycle implementations using Oracle applications R12 and 11i
• Successfully completed one full upgrade cycle of 11.5.10 to R12.2.3 and data migration from 11i to R12.
• Experience in working in Production Support, attending production calls, troubleshooting the application and resolving bugs.
• Extensively worked on technical design, development, and testing of RICEFW objects - BI Publisher Reports, Interfaces, Conversions, Extensions and Workflows.
• Experience in developing custom applications using Oracle APEX.
• Experience in extending standard Oracle pages using OAF (Oracle Application Framework) and ADF (Application Development Framework).
• Experience in developing both Inbound and Outbound interfaces.
• Have understanding on OIM (Oracle Identity Manager) and OAM (Oracle Access Manager) .
• Extensive experience in converting data ( Master and Transactional ) to Oracle EBS from multiple legacy systems.
• Predominantly involved in preparing Technical Specification and Unit Test Scripts .
• Experience in leading the complex projects and managing cross functional resources.
• Primary accountability point for the client for all planning, execution, validation and risk/issue management associated with the data conversion work stream and cut-over conversion deliverable.
• Experience in configuring GL, AP, AR and PO modules in Different instances.
• Experience in creating and creating executing functional test scripts and setups.
• Strong familiarity with AIM methodology in creating MD-70, MD-120 and also testing documents throughout multiple Projects.
• Have exposure to Performance Tuning using Explain plan and SQL Trace to optimize the cost and for higher efficiency.
• Very strong expertise in design and development of Data Mapping, Upgrade/Migration and Customization programs to import data from legacy systems and Oracle Apps 11i and integrate it into Oracle Applications using API’s and UTL FILE Packages.
• Consistently achieved above 99% success rate for data conversion/migration for 2 Oracle Apps R12 re-implementations. Modules included GL, AR, AP, PO and OM.

TECHNICAL SKILLS:

Oracle Applications: Application Object Library (AOL), General Ledger (GL), Accounts Receivables (AR),Accounts Payabls (AP), Cash Mangement (CE), Order Management (OM),Inventory (INV), Purchasing (PO), iProcurement (iProc), Human Resources (HRMS)and Projects (PA)

Databases: Oracle 9i, 10g and 11g

Languages: SQL, PL/SQL, Shell Scripting,HTML, JQuery, JavaScript, CSS and XML .

Oracle Tools: Developer 2K/6i, SQL*Loader, Toad, BI Publisher, JDeveloper, Workflow, APEX and Discoverer

Operating Systems: Windows NT/2000, UNIX+

PROFESSIONAL EXPERIENCE:

Confidential,Los Angeles, CA

Technical Consultant

• Involved in getting user requirements for the employee transfer match custom application.
• Developed an custom application to accept employees transfer request using Oracle APEX and integrating it with Oracle EBS system.
• Developed BI Publisher reports and integrated them with Oracle APEX .
• Developed code migration scripts to move the application into mutiple instances.
• Prepared detailed technical documentation of the application.

Confidential,St. Louis, MO

Technologies: Oracle Applications R12 (12.1.3), SQL and PLSQL.

Technical Lead

• Managed a team of 15 developers for two rollouts which included work allocation, status reporting, coordinating with functional consultants.
• Developed complex extensions related to high volume PO release and Approved Supplier List creations (P2P cycle) and high volume Order Import .
• Designed and developed Reports related to AP,PO and OM modules using BI Publisher .
• Provided estimates for the new RICEFW components and Change Requests.
• Defined process for issue resolution and bug fixes, deployment for the same.
• Involved in preparing the code migration plan for the cutover period.
• Worked closely with DBA’s to resolve performance issues in major impacted areas during upgrade cycles
• Single point of contact for code migration, instance plan, daily status on delivery and and critical issues.
• Peer Reviewed Technical designs and code.
• Played key role in reducing the downtime for the cut over with the help of DBA’s and self-technical expertise.
• Production support for some critical issues releated to AP and OM modules post GO LIVE.

Confidential,Mountain View,CA

Technologies: Oracle Applications R12 (12.1.3), SQL, PLSQL and BI Publisher.

Technical Lead

• Lead the conversion track.
• Managed a team of 10 people who had to be mentored on the conversion strategy and with the business requirements.
• Build the extraction queries to pull the data from the legacy system (Oracle 11.5.9) based on the criteria given by business.
• Involved in designing the conversion strategy. Providing estimates to RICEW objects.
• Involved in reconciling the converted data realted to Accounts Payables (AP) and Account Receivables (AR) with Business.
• Involved in developing/reviewing Data Conversions, Data Mapping, Data Extraction and Open Interfaces realted to Finance modules.
• Created generic stored procedure to create XML output for various outbound interfaces using XML gen and dynamic SQL.
• Created detailed technical design, giving high level and detail level walkthrough of technical design to the client and developed the same.
• Single point of contact for all the issues related to conversion during the cutover period.
• Involved in peer review of objects and documents within as well as across streams.
• Fixed critical issues related to BI Publisher reports during UAT.
• Support and issue fixing post conversion and GO LIVE.

Confidential,San Francisco,CA

Technologies: Oracle Applications R12 (12.1.3), SQL, PLSQL and BI Publisher.

Senior Developer

• Involved in analyzing functional designs and providing technical solutions accordingly.
• Created detailed technical design, giving high level and detail level walkthrough of technical design to the client, developing the objects related to Accounts Receivables (AR).
• Scheduling and participating in design transition calls with client for all deliverables of the whole team and keeps track of the same till complete development.
• Tweaked the standard AP Invoice Approval Workflow (IAW) to cater the custom requirement. This also involved defining new AME (Approval Management Engine) rules to derive the approver.
• Extended the standard payments page to trigger a custom workflow for payments approval using OAF (Oracle Applications Framework) .
• Developed conversion program to migrate the master data (AR Customers) from legacy system.
• Preparation issue logs, collection of functional/technical requirements, GAP Analysis, technical data mapping analysis and design/review of technical/functional data process flows.
• Created and executed unit test scripts and creating run lists for deployment.
• Involved in peer review of objects and documents within as well as across streams.
• Co-ordinated with the client team for the defects triaging during UAT and post go-live.

Confidential

Technologies: Oracle Applications 11i (11.5.10.2), SQL, PLSQL and XML Publisher.

Senior Developer

• Involved in migrating Accounts Receivables data from legacy system to Oracle Applications (Customers, Customer Relationships, Customer Account Update, Transactions, Receipts and Adjustments).
• Used Advance Lock Box feature for migrating Receipts in Accounts Receivables.
• Involved in high level reconciliation of transactional data.
• Developed AR Invoice Print reports (Pre-Printed stationary) using XML Publisher
• Developed code to alter the standard requisition process when they are raised from Inventory, MRP and Order Management.
• Created new AME (Approval Management Engine) rules in Requisition Approval Process.
• Worked on Alerts in Inventory module.
• Developed reports using Discoverer tool.
• Handled the offshore team during UAT process.

Confidential

Technologies: Oracle Applications R12, SQL, PLSQL.

Developer

• Developed Interfaces on Receivables (creating and updating customer information) and Purchasing (creating requisitions for temporary employees) modules.
• Involved in reviewing other Interfaces and Conversions.
• Developed shell scripts for loading data into custom tables using SQL Loader.
• Involved in preparing technical design documents and unit test plans for the Interfaces.
• Involved in fixing defects during Assembly Testing.

Confidential,Lake Forest, IL

Technologies: Oracle Applications 11i (11.5.10.2), SQL, PLSQL, Reports6i and XML Publisher.

Associate Developer

• Development of new reports using Report 6i and XML Publisher.
• Customizing Descriptive Flex fields, Creating Value sets and creating Request Sets.
• Development of custom Concurrent Programs and registering in Oracle Apps.
• Involved in the development of new interfaces and enhancements of existing interfaces.
• Involved in preparing the Technical documents for the development.

Confidential,Long Island City

Technologies: Oracle Applications 11i (11.5.10.2), SQL, PLSQL and Reports6i

Associate Developer

• Worked on various reports to develop and customize them
• Responsible for creating the scripts for concurrent executables and concurrent programs for interfaces and custom reports .
• Involved in redesigning the EDI validation process for Order Import.
• Support for entire Order Management and Shipping processes.
• Involved in preparing Technical Design Document.