SUMMARY

• Over 10 + Years of IT experience in enterprise - wide Oracle Applications design, development, systems analysis, defining system standards and database administration and 11i / R12 implementations, Upgrade from 11i to R12.
• Experience in major R12 Implementations, R12 Upgrade and 11i / R12 Production Support.
• Solid expertise in Technical as well as Functional aspects of ERP solutions implementation using Oracle HRMS and Financials (V R12 & V 11i).
• Have 2 Full cycle end-to-end R12 Re-Implementation and 4 R12 Upgrade and 4 11i/R12 Production Support Projects experience.
• Experience with Order to Cash (O2C) and Procure to Pay (P2P) Cycles.
• Proficient in the concepts of Multi Org, Global Intercompany Accounting System, Global Consolidation System, Multiple Reporting Currencies and Flex field setups.
• Expertise in Client Interaction, Requirement Gathering, Process walkthrough, Functional Mapping, GAP Analysis and Functional and Technical Design documentation and Full lifecycle implementations, Upgrades, Production Support.
• Proficient in System Administration, Application Object Library, TCA, Web ADI, OA Framework, BI Publisher and Workflow
• Good understanding of the Project Scoping and the Implementation methodology
• Strong knowledge in design and development of interfaces (inbound and outbound using API'S and open interfaces for integrating other applications with Oracle Applications.
• Extensive experience in building Decision Support Systems and writing PL/SQL Stored Procedures, Functions, Packages, Triggers * Loader /UTL and FNDLOAD scripts.
• Experience in preparing functional and technical documents like BR.030, BR080, BR.100, BR.110, CV.010, CV.040, MD.020, MD.050, MD.070, TE.020, TE.040
• Experience in writing UNIX /Linux shell scripts.
• Significant Performance Tuning capabilities and Problem solving abilities related to Oracle EB Suite.
• Excellent command over XML/BI Publisher in Creating Custom Reports.
• Extensive experience in developing and customizing Reports and Forms using Oracle Forms 9i/6i/4.5 and Reports 9i/6i/4.5/2.5
• Extensive experience on working with Discoverer 4i/9i/10g tool in creating and maintaining of Discoverer Workbooks.
• Support of Production and Test instances for upgrade/regression/integration/User acceptance testing. Test Plan Preparation, Technical design and Coding, UAT, Production Migration and documentation in Oracle Applications.
• Support and Involvement in risks identifications and risk mitigations.
• Managed all implementations with a high degree of client satisfaction. Projects were completed on schedule and met all utilization and profitability targets

TECHNICAL SKILLS

Technology: Oracle EBS (11i & R12), Unix Shell Scripting

Oracle Modules: GL, AP, AR, OM, PO, FA, PA, CE, IB, SC, WSH, INV, BOM, QP, ebiz-Tax, Trade Management, i Expense, i Suppliers, i Procurement, Oracle Sourcing, Procurement Contracts, i Receivables, i Recruitment, Advanced collections, HR, OTL, Payroll, Advanced Benefits (OAB), SSHR, AME, TCA, Sysadmin.

Languages: Oracle PL/SQL, Java, XML and J Developer

Oracle GUI/Tools: Oracle Database 11g, 10g,9i, 8i, 8, J Developer Suite 11g /12c ADF, SOA, BPEL, OAF, OBIEE, TOAD, Discoverer, PL/SQL, SQL*Loader, SQL, SQL*Plus, API’s, Oracle Reports/Forms 6i /10g, Microsoft Visual Studio 6.0, Citrix, Juniper Networks, Load Runner, Win Runner

Systems Management Tools: Windows, Linux, Unix and Main Frame, Subversion, PVCS, MS-Project, Visio, MS-Office, Mind Manager, Rational Suit, HP Quality canter, Lotus Notes

Methodologies: Rational Unified Process, iterative, waterfall, Agile

Web Technologies: HTML, Java, JSP, JavaScript

Monitoring Tool: Service Now. Mercury, Manage Now, Control M, HP Quality Canter, Tivoli and Confio.

PROFESSIONAL EXPERIENCE

Confidential

Techno - Functional Consultant

Responsibilities:

• Elicit study, document & understand requirements from client.
• Develop / Review Functional & Technical specifications
• Responsible for managing the RICE development
• Preparing BR100, MD50 and MD70 Documents for Financial and SCM and HR Modules.
• Develop / Review Functional & Technical specifications.
• Worked on the Order Import interface in Oracle OM
• Worked on customizing the Order Line workflow in Oracle Order Management
• Worked on the Quoting Interface with Oracle OM
• Worked on setting up custom quote statuses in Oracle Quoting.
• Design and Develop Intercompany AR and AP Invoices Interface for OM and SC orders.
• Extensively worked on AU Buy & Sell Project for O2C changes.
• Design and develop BI Publisher AP Check Printing Process for Veritas.
• Design and develop the AR Open Transactions Interfaces using PL/SQL for Importing 11i Open Transactions into R12
• Design and develop the Supplier Interface and custom validations using Oracle APIs.
• Design and develop the AP Invoice Import program and PO Import Program for R12.
• Re design the Veritas Order Import interface using PL/SQL Packages and Re design the order fulfilment BI publisher report.
• OAF form personalization’s for customer form in AR and supplier form in AP.
• Extensively worked on fixing the Invoice, Payments, Receipts, Purchase Orders, Sales Orders, Supplier and Customer data validations issues.
• Defined issue reporting, tracking and monitoring, resolution and escalation processes.
• Planned detailed work break down structure to cover the delivery in time as required by management.
• Resolved reconciliation issues between the Receivable module and the General Ledger and AP Reconciliation Issues.
• Working extensively with Oracle for Service Requests.TAR resolution on demand & priority basis
• Process analysis and design. Maintaining the versions of code and documents using Perforce.
• Provided Post Production support after go-live for the Veritas Financials and HR applications.

Environment: Oracle Applications R12, Workflow, Oracle 11g, J Developer 11g, Linux, Windows 7

Confidential

Techno - Functional Consultant

Responsibilities:

• Develop / Review Functional & Technical specifications
• Framing the strategy for migrating data from the legacy system (SAP) to Oracle.
• Extensively worked on fixing the HR, Payroll Integrations issues and eTime Integration issues with ADP.
• Design AR Lock Box Interfaces for Importing SAP LaCie USA and LaCie Canada.
• Design and develop BI Publisher AP Check Printing Process for LaCie.
• Worked extensively with Reports, Interfaces, Conversions, Extensions for Seagate Applications (HR, AP, PO, INV, AR, OM, GL, CM, FA, PA).
• Automation of Invoice processing for Cyber Source Integration to create AR Credit Card Receipt method and LaCie AR Customer Banks using Oracle API’s.
• Design the Data Loader Scripts for Importing LaCie Europe Unapplied Receipts.
• Developed custom WEBADI process for loading / BI Publisher reports for Digital River Integration into R12.
• Design and Build Oracle Advanced Collections Dunning Templates Using BI Publisher.
• Followed SOX rules in designing the responsibilities and restricting access accordingly to various functions as per the business requirement
• Design the Custom reconciliation process for LaCie SAP to LaCie Oracle.
• Participated in the Capacity Test for Seagate and LaCie Financial Modules.
• Process analysis and design. Maintaining the versions of code and documents using Subversion.
• Responsible for preparing required reports and Test Cases for getting QC Business Sign-off for T0, T1, and T2 and Go Live LaCie Conversions
• Provided Post Production support after go-live for the Seagate Financials

Environment: Oracle Applications R12, Workflow, Oracle 11g, J Developer 11g, Linux, Windows 7

Confidential, Los Angeles, CA

Techno - Functional Consultant

Responsibilities:

• Retrofit 11.5.10 HR Self Service web pages to R12 environment and Form Personalization’s.
• Redesign the employee update Process for Populating HR DFF fields for first period of service the
• Accrual and seniority/service award dates and 401(K) Co Match Start Date and Vesting Date.
• Developed and supported various HRMS reports in Discoverer.
• Configured and tested Web Page Layouts for Oracle Learning Management and Self-Service
• Configured Oracle Approval Options Management within SSHR to be turned on/off.
• Reviewed and validated the documents (MD050, MD070, BP080, CV.40,CV.70 and BR100)
• Redesign the Consignment Billing Interface for Order Import, Process Order, Return Import
• Redesign the AR Invoice Printing Reports for INBC, CTS, Central Cost, BCP, MAK, LAB, BSI
• Bio care, CTS Life Track, BSI Purchase Order Status Report and BSI OM Packing Slip Report.
• Design and develop BI Publisher AP Check Printing Reports with Secured Signatures
• Bug fixing, working extensively with Oracle for Service Requests.TAR resolution on demand
• Set-up, facilitate and assist client in carrying out User Acceptance Testing (UAT), including
• Prepare cutover plan, Object packaging & Upgrade plan.
• Defined issue reporting, tracking and monitoring, resolution and escalation processes.
• Resolved reconciliation issues between the Receivable module and the General Ledger and AP

Environment: Oracle Applications R12, Workflow, Oracle 11g, J Developer 11g, Linux, Windows 7

Confidential

Techno - Functional Consultant

Responsibilities:

• Setup and System Configuration of Oracle Supply Chain and Financials.
• Design the BI Publisher reports for OM, Quoting, Advance Pricing, Shipping, AR, AP and GL.
• Framing the strategy for migrating data from the legacy system (Insevo) to Oracle.
• Financials/Procurement Systems.
• Design and develop BI Publisher AP check formats for various countries.
• Prepared controlled documentation throughout all the phases of the Upgrade project
• Process analysis and design. Maintaining the versions of code and documents using PVCS.
• Prepared Unit Test Plan and involved in user acceptance testing.
• Support for all production related issues related to financials and Procurement systems.
• Defined issue reporting, tracking and monitoring, resolution and escalation processes.
• Responsible for conducting the complete cycle of testing in Financials and Procurement modules before go live.

Environment: Oracle Applications R12, Workflow, Oracle 11g, J Developer 11g, Linux, Windows 7

Confidential

Techno - Functional Consultant

Responsibilities:

• Develop / Review Functional & Technical specifications.
• Setup and System Configuration of Oracle Financials and Procurement(GL, AR, AP, PO, OM)
• Design and develop the Customer Interface using Oracle API’s for importing the Canada, Europe and Asia Customers.
• Design the Interface for E commerce gateway EDI transmission codes for the eligible Customers.
• Design and develop the Customer Items and Customer Item Cross References Interface for Inventory
• Design the BI Publisher reports for AR, INV,AP, OM, WSH
• Develop the Sql loader programs for importing the Legacy data in to Oracle Applications.
• Responsible for conducting the complete cycle of testing in Financials and HR modules before go live.

Environment: Oracle Applications R12, Workflow, Oracle 11g, J Developer 11g, Linux, Windows xp

Confidential

Techno - Functional Consultant

Responsibilities:

• Design and Testing the Confidential Expense Inquiry Form, Confidential Disbursement Request Form Manage Transportation Invoices Solution.
• Design and build Customer interface for loading Legacy Customer Data
• Developed PO-Custom PO Print and Delivery report
• Design and Build HR interface enhancements for Confidential using Oracle Public API’s
• Design and Build OIE-Expense Report Approval Workflow, AP-BOT-Requisition Account Generator.
• AP-BOT-Invoice Approval, AP-BOT-Invoice Imaging Transcepta OSN Interface- AP Invoice Fields Derivation.
• Analysis of the technical objects whether it needs to be retrofitted to R12
• Preparing functional/Technical specifications for the existing custom objects in 11i, based on the R12 changes.
• Preparing Test Cases for testing the custom objects and for normal transaction flows in R12

Environment: Oracle Applications R12, Workflow, Oracle 11g, JDeveloper 11g, Linux, Windows xp

Confidential

Techno - Functional Consultant

Responsibilities:

• Presentation on validated documents was given to the client project team.
• Develop / Review Functional and Technical specifications.
• Setup and System Configuration of Oracle Financials, Procurement and HR modules.
• Design and develop the Amex BIP Interface.
• Developed HR Contact employees interface to extend termination date using Oracle HR API
• Designed and Developed OTL Interface and ADP Payroll Interface for Confidential .
• Designed and mapped the Chart of Accounts as per Management’s requirement
• Developed and supported various reports in Discoverer
• Resolved reconciliation issues between the Receivable module and the General Ledger
• Defined issue reporting, tracking and monitoring, resolution and escalation processes

Environment: Oracle Application Suite 11.5.10, BI Publisher, Workflow, Oracle 10g, Developer 6.x Linux, Windows xp.

Confidential

Techno - Functional Consultant

Responsibilities:

• Re Implementation of the Oracle ERP Suite of application Release 12
• Perform an Impact analysis of all oracle financial applications custom objects and changes Associated with the existing Oracle Applications (11.5.8).
• Develop deployment plan with a minimum downtime strategy
• Prepared BR 100 capturing the functional configuration for Financial and HR modules
• Setup and System Configuration of Oracle Financials and HR modules.
• Create workflow to send email notifications for remittance advice.
• Developed Interface and Conversion programs to interface external systems (EDI) /applications
• Data files to Oracle Application modules using UTL FILE, PL/SQL and UNIX shell scripts.
• Designed and develop the FA Mass additions interface for loading the legacy data in to FA base Tables.
• Setting up Inventory module like Item flex fields, category flex fields, sub inventory.
• Worked on various inbound & outbound interfaces for Financials and HR modules.
• Defined numerous signing limits for different managers of various cost centres in AP
• Developing PL/SQL procedures and Alerts and Concurrent Programs and configuring the printers.
• Develop vendors, Sites, Contacts, GL code combinations, Locations Cross walk feed for the variousExternal systems.
• Data Loading for Conversion using FNDLOAD, Developed queries and views for reporting.
• Responsible for work allocation to team, defect tracking and ensuring timely deliverables.
• Prepare cutover plan, Object packaging & migration plan.
• Provided Post Production support after go-live for the Financial and HR modules

Environment: Oracle Applications Suite R12, BI Publisher, Workflow, Oracle 10g,Oracle J Developer, Linux, Windows xp.

Confidential

Techno - Functional Consultant

Responsibilities:

• Bug fixing working extensively with Oracle for Service Requests.TAR resolution on demand & Priority basis.
• Providing 24/7 Application Support for the Production System,
• Bug fixing, Invoice, Payments, Receipts, Purchase Orders, Sales Orders, Supplier Data Customer Data validation.
• Developing Data Conversion Strategy for Data Conversion from legacy systems.
• Interfacing with HR systems to upload Customer data into Production base tables.
• Analysis and Design the SSN Interface Project for HR modules.
• Developed various Unix Shell Scripts for Application Enhancement Projects.
• Maintaining the versions of code and documents using PVCS.
• Performance tuning done for various custom reports for Purge Process.
• Responsible to ensure closing of the books (AP, AR and GL) during month/quarter/year end.

Environment: Oracle Application Suite 11.5.8, BI Publisher, Workflow, Oracle 8i, Unix, Windows xp, Developer 6.x.