SUMMARY:

• 7+ years of experience in Implementation of Oracle EBS projects and its Initiatives, Customizations, End user training, UAT and production support which includes General Ledger (GL), Accounts Payable (AP), Payments, Accounts Receivable (AR), Cash Management (CE), Fixed Assets (FA), Purchasing Cycle, I - Procurement(I-Proc), I-Expense, Inventory, Project Billing, Project Cost.
• Implemented full life cycles of Oracle E Business Suite Applications in Financial area having globally operated Multi Organization, Intercompany, Multiple Legal Entities, Multi interfaces with multi-currency business environment.
• Proven Experience in Oracle E business suite R12.1 and 12.2 & 11i - handled end to end full life cycle implementations and multiple support projects.
• Functional work experience on Oracle SCM Modules (OM, PO, Inventory, procurement, iSupplier, Discrete Manufacturing (BOM, WIP), MRP, AP).
• Proficient with Order to Cash (O2C) and Procure to Pay (P2P) cycles, covering modules Inventory Order Management (OM), Payables (AP), Purchasing (PO), Receivables (AR) Cash Mgt. and GL.
• Experienced in Project Management, Business Analyst, Risk and Change Management skills in support to SDLC implementation, resources and project releases within time and budget.
• Strong work experience in support to various stages to supply chain processes: such as P2P, OTC, WMS, IM, MRP, Engineering, Manufacturing, JDM's Contracts, Logistics, Transportation, Costing, LSS and 3PL's.
• Extensive experience in Implementation, Migration, Customization, Production and Support of Oracle (R12 & 11i) with major focus on Financial modules (GL, AP, AR, FA, CM), SCM Modules (PO, OM, Advanced Pricing, INV, Shipping, WIP, BOM), HRMS, Oracle CRM (Service Contracts and Install Base), P2P, O2C life cycles
• Extensively experienced in Oracle PL/SQL Development, stored Procedures, Packages, Functions & Triggers. Experience in P2P (procure to pay) as well as O2C (order to cash) cycles.
• Strong understanding of different methodologies (Agile, Waterfall and Iterative), finance and risk modules, operation (six sigma’s supply chain services), marketing and engineering.
• Extensive knowledge and experience and understanding of Oracle SCM R12 General Ledger (GL), Accounts Payables/Receivables (AP/AR), Purchasing, Order Management, iProcurement, iRecruitment, iSuppliers and Oracle Reporting Tools which includes Report Builder 10G and good working knowledge of SQL.
• Extensive experience in eProcurement eBTax, EAM, FA, iProcurement, iExpense, iSuppliers, iAssets, iReceivable, ePerformance 9.x.
• Proficient in all phases of requirement gathering that includes BRD, FRD, WBS, System Requirement Specification (SRS) and sound knowledge on SDLC models: Waterfall, Agile (SCRUM), and iterative models.
• Highly proficient in working with users and stakeholders to elicit, analyze, communicate and validate requirements using Joint Application Development (JAD).
• Extensive database experience using Relational Database Management Systems (RDBMS) Oracle, SQL Server, MS Access and SQL with solid understanding of primary, foreign key constraints, strong and weak entities & attributes.

PROFESSIONAL EXPERIENCE:

Oracle EBS Consultant- Accounting and Billing

Confidential, Denver, CO

• Involved in Oracle EBS Implementations and its Initiatives and customizations for General Ledger, Payables, I-Procurement, Accounts Payable, Receivables, Fixed Assets, PTP, Inventory, IExpense, Project Costing and Billing, Cash Management.
• Assisted in implementation and deployment of the best SCM processes with seamless integration among various phases of Software Development Life Cycle (SDLC) such as Change Request and Product Life Cycle Management utilizing UCM component of Rational Suite.
• Worked with application design and development from business requirements analysis through implementation in Oracle Cloud Financials including GL Daily Rates, Invoices, Payments.
• Performed Oracle E-Business Suite (EBS or Apps) integration with Oracle Identity Manager (OIM) for User Provisioning and Reconciliation.
• Set up the complete Procure to Pay business flow starting from requisitions creation in iProcurement.
• Performed ad-hoc analysis and reporting using Hyperion SmartView for Essbase and planning and created the existing Budget Book reports using Financial Reporting Studio and Web Analysis.
• Worked on the configuration of Oracle Inventory, Bills of Material, Work in Process, Engineering and Cost Management.
• Created, submitted and Tested Different Purchase Requisitions, Catalogue/Non-Catalogue, Inventory, Expense, Capital, Professional Services and approved it using iProcurement and its Notifications.
• Managed Oracle upgrade from R12 (12.1 to 12.2) with available in-house resources and Worked closely with Finance team on isupplier related payments and supplier setup.
• Performed data validation using SQL queries and run ad-hoc queries to show data to the business users.
• Elicited requirements from the business line through JAD sessions, Workshops & Prototyping.
• Involved in complete Procure to Pay (P2P, AP/PO) and Order to Cash (O2C, OM/AR) life cycle.
• Coordinated the project team for JAD and BRD Sessions, and documentation for different projects including SOA model projects.
• Customized the Oracle Reports and Forms. Modified PL/SQL packages to support the application (ver 11i & R12) e.g. Stock Label Print.
• Worked on Oracle Applications modules are implemented like Procurement Contracts, iSupplier, Sourcing & SLM.
• Performed the whole Order Cycle in Order Management (OM), which includes Booking, Pick Release, Ship Confirming, and Interfacing to Receivables, Complete Line and Complete Order.
• Worked on Business Systems Support - SCM - Purchasing, Release Strategies, Shipping, SRM.
• Responsible for writing or approving User Guides, creating process maps, training applicable personnel on SCM processes.
• Implementation of Supply Chain Management (SCM) from scratch ('Initial findings to system design' then 'UAT to user training' then 'final deployment, implementation & support') apply full SDLC (Software Development Life Cycle).
• Preparing of all the Functional Requirement Documents (FRD), Business Requirement Documents (BRD) and Functional Testing Documents.
• Involved in Oracle Applications Primary Modules R12 GL, AP, PO, AR, Order Management / SCM/ iProcurement, iRecruitment.
• Used Oracle E-Business Suite applications for accounts payable/accounts receivable (AP/AR), general ledger, fixed assets, and order to cash management.
• Auto creating Purchase Orders once the Requisitions are approved set ups were done using PO Create Workflow document type.
• Performed Gap analysis by identifying existing technologies, documenting the enhancements to meet the end state requirements and hands on experience in Supply Chain Management (SCM).
• Created the necessary design specifications of the product regarding Accounts Payable (AP) Automation with Oracle ERP E-Business Suite 11i and R12.
• Facilitated the integration of the business requirements into the Oracle system through application development including design, configuration, testing and implementation.
• Conducting Trainings related to SCM (Supply chain Management) for end-users & super users and Managed Oracle Inventory, Oracle Purchasing & Oracle Order Management as a FFP (Functional Focal Point).

Oracle EBS Analyst

Confidential, Beloit, WI

• Implementation of Oracle Project Accounting (Costing & Billing). Usage of Agile / Scrum SDLC methodologies; JAD/RAD methodology under development.
• Involved in configuration, data conversion and Implementation of Oracle EBS R12 Procure-to-Pay, Inventory, warehouse management, and Order-to-Cash modules.
• Implemented Oracle R12 FAH and GL module to act as a consolidated hub for client's all accounting data and regulatory reporting requirements.
• Making upgrade changes to objects in AR, OM, AP, FA and GL and Customizing OM, AR, AP, GL, PO and Fixed assets reports.
• Worked as a functional consultant for the implementation of Oracle Project Accounting (Costing & Billing).
• Supported mission critical systems including standard and custom Oracle applications for inventory management, order processing, and financials.
• Involved in Full-Cycle Implementation of Oracle Modules: Order to cash cycle Order Management, Inventory and P2P, AP/AR, PO, eProcurement.
• Worked as a part of SCM Make Process based on Oracle Item master, Inventory, Purchasing, Sourcing and OM and Pricing Tables.
• Worked on Order to Cash Cycle, from entering orders to move order stage followed by the ship confirm and updating the GL.
• Developed approval rules based on invoice amount for the following transaction type Payables Invoice Approval using Oracle Approval Management (AME) and configured action types and actions and set up the profile option to work for Payables only and the required setup through Payables Options form.
• Responsible for Modules Involved were Fixed Assets, GL, Project Accounting, Inventory & PL/SQL.
• Implemented customizations and data conversions from Oracle 11.5.9 instance to Oracle 11.5.10 instances of two different Oracle instances / implementations.
• Involved in Implementation and enhancement of HRMS, Procure to Pay, Order Management, iProcurement & iSupplier modules.
• Leading a team of Supply Chain consultants and helping execute an end to end Supply Chain solution in Oracle Applications in above areas.
• Provide solutions and map the business requirements with using Oracle Applications ERP Supply chain, eProcurement, Order Management, Flow Manufacturing modules, account payable (AP), account receivable (AR), P2P, General Ledger.
• Provided secondary support to ORACLE Asset Management, General Ledger, SCM, Accounts payable/receivable (AP/AR), P2P.
• Participated in database design and worked with SQL / Oracle queries for change control and compliance audit reports/applications.
• Added functionality and enhanced reporting features by writing, modifying and testing SQL/Oracle queries.
• Conducting sessions on Receivables, Advanced Collections, iReceivables modules with business users.
• Analyzed and resolved problems related to Oracle applications with respect to business processes.

Oracle Financial Analyst

Confidential, Eighty-Four, PA

• Involved in Full-Cycle Implementation of Oracle Modules: Inventory, Order Management, Purchasing, BOM and WIP.
• Involved in the Development of the functional plan for the R12 EBS implementation. Provided weekly status reports to the Project Manager and managed the functional team.
• Responsible for Full Life Cycle implementation of Purchasing and iProcurement.
• Configured the system with Oracle Applications and provided a customized solution to use I Procurement as an order entry tool.
• Conducted comprehensive user training with super users and users on Oracle Order Management, Shipping Execution, inventory, AP, AR, PO, GL.
• Developed Purchase order interface, Receipt interface in P2P flow cycle.
• Setups/configurations in Oracle to contact Agile to import Items, Revisions, BOM's and Item life cycle management.
• Requirement gathering for the setup of Order Management and Oracle Receivable Modules AND GAP analysis and business process mapping for OM, AR, PO, AP, GL.
• Scheduled status showing the Oracle Work in Process (WIP) to recognize the demand for an item or configuration and opened a work order to supply the demand.
• Supporting & Enhancing AR, AP, GL, Projects, & Payments modules and related Integrations.
• Helping business with AR to GL and AP to GL reconciliations and analyzing reporting requirements and working with EiS teams to customize Reports on AR and CE modules.
• Developing custom components and testing as per AGILE methodology using SDLC AND JAD sessions.
• Implemented EB-tax integration for Procure to Pay and Order to Cash cycles with One-Source Indirect Tax product line.
• Designing & Implementing automated use tax calculation EBTAX solution for iSupplier / B2B invoices.
• Implemented feature-based Order Configurator process that enables order processing of CTO (Configure to Order) and ATO (Assemble to Order) type of products including the manufacturing of the configured products.
• Comparing RCDs of 11i and R12, and documenting gaps in R12 functionality compared to 11i for the modules of AR, Advanced Collections, Loans, iReceivables and Treasury.
• Reviewed and processed existing implementation and outlined current business challenges and worked on the cross platforms implementing ERP and analyzed the customer's database using oracle.
• Conducted JRP sessions with clients and technical units and (JAD) sessions with IT Group.
• Create purchase order or Sourcing Event, visibility of PO in iSupplier portal, ASN creation in iSupplier portal.

Business Analyst

Confidential, Minneapolis, MN

• Streamlined Change management & Business process mapping for HRMS administration activities between Legacy system and Oracle HRMS modules.
• Defined and managed compensation and benefits packages in Oracle HCM.
• Worked on XML / BI publisher reports like Overtime, Higher skills in HR/Payroll.
• Worked with Oracle Support by raising SR to resolve Oracle EBS issues with Oracle seeded functionality.

Involved in sorting out and fixing the Payroll related issues related to Time and labour (OTL) and iRecruitment.

• Involved in HCM-Payroll QA and integration testing after splitting into two instances.
• Attended business unit project meetings to identify and capture the support needs of the business unit from the dedicated OTS DBA team.
• Conducted Unit testing, Integration/ Regression testing and UAT.
• Worked with the complete SDLC, elicit, analyze and define requirements. Executed Agile SDLC project using offshore and onshore managed service model.
• Configured Self Service HR Personalized Employee and Manager web pages, Setup additional flex fields to capture client specific information using self-service web pages.
• Captured functional and technical requirements. Mapped requirements to the standard Oracle R12 functionality and identified the gaps. Provided solutions to the identified gaps.
• Involved in data conversion from Legacy to Oracle HRMS.
• Created Business Requirement Document (BRD), Functional Requirement Specification (FRS) document, User Requirement Specification (URS) and Change Request (CR) document for system application development.

TECHNICAL SKILLS:

Applications: Oracle (SCM) E-Business Suite Ver. 11i & R12

Oracle Modules: GL, AP, AR, INV, BOM, FLM, WIP, OM, Shipping, Advance, Supply Chain and Planning, MRP, Oracle Projects, Oracle, Resource Management, PO, P2P, iProcurement, iExpenses, iAssets, iSuppliers, order to cash management.

BI & ETL Tools: Oracle Discoverer Admin, Oracle Discoverer, Desktop/Plasmodia, Oracle App Server

Operating System: UNIX, MS Windows, MS- DOS, RDBMS Oracle 10g/9i / 8i, Microsoft SQL 2000, MS Access

Programming/Case Tools: Oracle SCM

Methodologies: SDLC, agile, scrum, waterfall, JAD, BRD, FRD, gap analysis