PROFESSIONAL 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. .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

Technologies: Oracle Applications R12 (12.1.1) GL & HRMS, Oracle BI Publisher, Oracle Application Express, SQL and PLSQL.

Technical Consultant

Responsibilities:

• 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.
• Involved in managing the custom application deployments and upgrades.

Confidential, St. Louis, MO

Technologies: Oracle Applications R12 (12.1.3) AP, PO & OM, JDeveloper, SQL and PLSQL.

Technical Lead

Responsibilities:

• 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 .
• Involved in extending the supplier page using JDeveloper .
• 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) AR, AP, PO &GL, JDeveloper, SQL, PLSQL and BI Publisher.

Technical Lead

Responsibilities:

• 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 ( GL, AP & AR ).
• 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.
• Did page extenstions and personalizations.

Confidential, San Francisco, CA

Technologies: Oracle Applications R12 (12.1.3) AP, AR, GL & PO, SQL, PLSQL and BI Publisher.

Senior Developer

Responsibilities:

• 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) JDeveloper .
• Developed conversion programs to migrate the master data (AR Customers) from legacy system, GL rates and balances.
• 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) GL, AP, AR, INV, & PO, SQL, PLSQL and XML Publisher.

Senior Developer

Responsibilities:

• 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.
• Closed GL periods during the month end process.
• 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 GL, AP & AR, SQL, PLSQL.

Developer

Responsibilities:

• 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

Responsibilities:

• 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

Responsibilities:

• 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.