SUMMARY

• Over 8 years of experience as consultant in Oracle ERP implementations, Upgrades and support mainly in General Ledger, Payables, Receivables, Purchasing, Inventory, Cash Management, Costing, Projects and Fixed Assets modules. Well experienced in implementation processes esp. Gap Analysis & developing Custom components as per business requirements.
• Worked as a Functional Analyst in Implementations, Upgrade and Post Production Support of Oracle EBS in various industries like Banking, Pharmaceutical and Manufacturing.
• Designed process flows for each functional area during the implementation, Carrying out requirement gathering, requirement analysis, gap analysis, setups, functional modifications, unit testing, and CRP’s.
• Full life cycle Implementations and upgrades in 11, 11i and R12 with GL, AP, PO, AR, CM, FA, Inventory, iExpenses, EB - Tax, SLA, Costing.
• Designed solutions to enhance standard oracle processes - Order to Cash, Procure to Pay Inventory, TCA, Credit Card Transactions, GL Accounting processes.
• Implemented Oracle Warehouse Management as various warehouse solutions.
• Proficiency in AIM Methodology to enrich project management and documentation processes.
• Expertise in preparing BP040, RD020, BR30, BR100, MD050, TE020 and TE040 documents.
• Proficient in analyzing the ‘As-Is’ Business Processes, Redesigning and Developing Business Process Flows.
• Wide experiences in requirement analysis, GAP analysis, design of the ‘To-Be’ process, Process Mapping, Data Conversion Management, Testing (unit/integration/system).
• Collaboration with the Business users during the various stages of project lifecycle.
• Designed the Functional solutions to the Key Gaps through Interface, Extension Customization, and Reports.
• Good understanding in designing and requirements analysis for RICE (Reports, Interfaces, Configuration, Enhancements) Implementation, Conversion, Data Migration.
• Highly experienced in post implementation, support and training the end users.
• Good experience with Application Tools TOAD, Data loader, ADI & WebADI.
• Proficient Database Management understanding AR, AP, GL, CM tables predominantly.
• Interpersonal skills, self-motivation, communication and quick adaptation to new applications and technologies.
• Firm understanding of integration of Oracle Applications modules, Flexfields, MRC Setups, Multi Org, Revenue Recognition and AGIS.
• Deployed strategy for Supplier Management solution.
• Expertise in Reconciliation of Sub-Ledger modules with GL, R12 SLA, R12 Accounting Setup Manager, Inter Company Accounting and MOAC.
• Good experience with Oracle Business Intelligence.
• Excellent communication skills.

TECHNICAL SKILLS

ERP: Oracle EBS R12, Oracle EBS 11i

Modules: General Ledger (GL), Account payable (AP), Purchasing (PO), Account Receivable (AR), Cash Management (CM), Fixed Assets (FA), Oracle Cost Management (CST), Projects (PA) and Inventory (INV).

Operating Systems: Windows 7, Vista, XP

Office Applications: MS Outlook, MS Visio, MS Project

Database Tools: TOAD, SQL Loader, Data Loader, SQL Developer

Tools: Discoverer

Processes: Order to Cash, Procure to Pay

PROFESSIONAL EXPERIENCE

Confidential, Denver, Colorado

Functional Consultant

Responsibilities:

• Acted as key member in R12 upgrade and thus played a significant role in stabilization of the application.
• Performed analysis on the impact from current version of 11.5.10.2 to R12 upgrade for General Ledger, Payables, Receivables and Collections, Inventory, Assets, Costing, Projects and Cash Management.
• Created Logistics Cockpit, which includes custom screen layout, this transaction allows the user to run Inventory movements, Physical inventory, MRP & Forecasting and Inventory reports.
• Configured AutoAccounting setups to ensure error free interface process.
• Resolved issues in AR Interface during AutoInvoice process and Tested the functionality.
• Implemented effective inventory control operations.
• Delivered documentation to gather the user requirements for new features. And developed detailed test scenarios and test scripts.
• Implemented new features in R12 Cash Management Module to use multiple sources for reconciliation of same BAI codes.
• Customized Sub-Ledger Accounting’ accounting rules to meet the business requirements for Revenue Recognition.
• Provided online details for each customer group through advanced collections customizations and statements to customers.
• Implemented Procure to Pay process, Order to Cash process.
• Coordinated with users in multiple locations for requirement gathering and user training.
• Implemented AME workflow for AP invoices in R12.
• Configured E-Business Tax in R12.
• Enabled activity based and project based management capabilities to improve cost performance.
• Configured inventory structure and cost controls that were important for business.
• Resolved issues raised while defining costing methods.
• Managed and Updated item unit costs.
• Created FSG reports for consolidation of multiple legal entities.
• Maintenance of Issue Logs for reporting the status of the issues and conducting issue status meetings on weekly basis.
• Configured AGIS for intercompany billing.
• Defined various Intercompany transaction security rules.
• Consolidated with Intercompany transactions, accounts datails.
• Follow up of team members for the completion of tasks.
• Prepared documentation for the custom reports.
• Define accounting rules for Oracle Projects using a centralized accounting setup consistent with other subledgers.
• Captured project information during P2P.
• Customized expense reports inorder to make payments for project-related expenses.
• Implemented iProc and iExpenses as part of R12 upgrade to use new features. iExpenses setup with multi level approval and paperless streamlines process. iExpenses travel policy definition and audit procedures.

Confidential, Boston, MA

Functional Consultant

Responsibilities:

• I have been associated with the project from the inception, Preparation of client presentation, and Interacting with the client for various information requirements.
• Prepared AS-IS document and provided initial demo to the client/super users to gather system requirements for General Ledger, iExpenses, Purchasing and Inventory, Payables and Receivables modules.
• Setting up the CRP instance for training/ demo as per the requirements gathered during the business process study. Demo to the customers on the flow of business process based on the TO BE scenarios presented.
• Analysis of the current system by interacting with business and cross-functional team.
• Mapped the Client requirements with Oracle standard functionality, found gaps, prepared setup Documents (BR 100) and delivered the solutions in terms of Customizations, workarounds, re-engineering and form personalization.
• Writing/executing scripts using SQL Navigator, SQL Developer to perform various extracts from database.
• Data conversions for AR Customers (Customer Interface), AR Invoices and Receipts (Auto Invoice and Lockbox), Suppliers Master conversion and Vendor Invoices. Both open and closed invoices converted.
• Participated in the financial accounting Month-end close process to ensure financial sub-ledgers, Accounts Payable (AP) and Accounts Receivable (AR) close successfully covering the Procure to Pay and Order to Cash cycles.
• Resolved problems relating to the process of reconciliation of GL with AP and AR.
• Designed interfaces between external system and Receivables using AutoInvoice.
• Worked closely with Business Users to identify right data for conversion. Helped the users in cleaning up the data and created policy documents for future maintenance of master data.
• Worked with extracts of data from legacy system and molded them according to the Oracle Apps requirements verifying the integrity prior to the load into Oracle.
• Created the conversion document (CV10) and assisted the technical team in developing the conversion and Interface program for GL and AR.
• Experience with MOAC Multi-Organization Access Control.
• Advanced Experience with Deferred Revenue process.
• Worked with auto application of receipts.
• Reconciliation between Oracle financials and External systems.
• Resolved issues raised during AP and AR interfaces.
• Monitored inventory, item costs, work-in-process values, and accounting entries.
• Analyzed, simulated and forecasted product costs.
• Setup of Policy schedules such as Accommodations, Meals and Entertainment, Rental Car, Airfare, Mileage, Relocation, other travel expenses as part of iExpenses roll out.
• Implemented revenue recognition to recognize the revenue into various periods.
• Defined Accounting Rules in AR for quarterly, half yearly and yearly schedules, so that invoice amount was split into the various periods defined in the revenue recognition schedules.
• Configured AGIS for Intercompany billing.
• Resolved issues rose during AR/AP invoices while AGIS.
• Developed/Updated Discoverer Reports for Month End Reports.
• Testing the functionality of new enhancements for new entitles in 11i.
• Full CRP1, CRP2, UAT1 and UAT2 testing cycles, with issue trackers and SME’s sign of provided.
• Trained, Conducted Practice & Additional Business Requirements sessions.
• Analyzed and tested Integration with 3rd Parties and legacy systems.
• Used SQL*Loader for import into Interface tables, and PL/SQL block for complete validation of data and inserting into base tables.
• Supported production environments and users on a daily basis by responding to emergency requests.
• Developed PL/SQL program to validate and insert data into AP invoice import interface tables.

Confidential, Pittsburgh, PA

Functional Consultant

Responsibilities:

• Worked on R12 upgrade from 11.5.8 along with daily production support.
• Prepared financials module test scripts and tested the R12 upgraded system for setup and functionality. Tested custom programs, which are converted from 11.5.8 to R12.
• Implemented iExpenses to US operating unit.
• Configured AGIS as per business needs.
• Generated various reports and handled reconciliation in AGIS
• Designed and implemented the changes to the existing customizations ( GL daily rates load, GL data extract to ODS, GL data extract from Order to cash databases)
• Prepared test cases for R12 upgrade testing and coordinated with QA team for test case execution
• Coordination with DBA team, offshore developers, cross-functional teams, release management team, performance tuning team, SOX compliance team, Org adoption team.
• Coordination with Oracle support for resolution of R12 bugs.
• Trained users on the new R12 new features especially new R12 modules.
• Suggested new period closing procedures because of R12 changes.
• Weekly status meetings to communicate progress on system support issues to management and user groups.

Confidential, Evansville, Indiana

Lead Consultant

Responsibilities:

• Functional Consultant for Purchasing (PO), Payables (AP), Receivables (AR) and Responsible for Supplier master modules.
• Gap Analysis and gap resolution for PO / AP / AR / INV.
• Involved in setting up meetings with Business users to gather requirements information.
• Followed AIM Implementation methodology.
• Gap and Fit analysis done based on the business requirements.
• Involved with Purchasing setups: Payment Terms, PO Lookups, Purchasing Options, Buyers, Financial Options, Transaction Reasons, Receiving Options, Suppliers, Sourcing Rule, Position Hierarchies and Employees.
• Implemented Back-to-Back orders in Configured scenario where purchasing activity is involved.
• Implemented the pick sources using the global sourcing rules.
• Implemented the transit time calculation using internal locations, regions and zones.
• Working on issues related to Freight Charges from suppliers.
• Involved in setting up Cost types, Future, Engineering and additional Cost types, Defined material sub-elements, Defined Overheads, Material overhead defaults, Defined Category accounts, Associate WIP account class with Category accounts.
• Involved in the Creation of test script documents for CRP and UAT.
• Providing functional inputs to coordinate between client and Technical consultants related to application issues.
• Involved in setting up Out-Side processing flow.
• Captured the business processes in form of scenario matrix for testing various process alternatives followed as part of Bill of Material/Work in Progress/Costing/Quality and Planning.
• Designed and implemented a third party tool for handing massive intercompany transactions across multiple companies to handle ‘Transfer pricing’ and ‘Cost plus’ business functions.

Confidential, Minneapolis, MN

Production Support Analyst

Responsibilities:

• Handled support for all financial modules as the first point of contact for P1 issues.
• Designed, implemented and supported integration of Oracle AR and AP with third party tax system - Sabrix for US and EMEA entities.
• Responsible for Upgrade of Sabrix AR and AP connector for Version 5.3
• Coordination with Sabrix vendor for engagement in solution design.
• Worked with company architects to align Sabrix Architecture the company’s Architecture strategy.
• Advisory role in gathering business requirements and in preparation of Functional Specifications.
• Ambiguity management and conflict resolution across cross-functional teams.
• Performed release management.
• Documentation of Setup Changes, Migration and bug Resolutions.
• Period closing support.
• User training and testing.
• Implemented Auto lock box in Oracle AR.
• Communicate progress on system support issues to management and user groups.