SUMMARY:

• Expert working experience on Full Life Cycle Global Implementations of Order to Cash Cycle (O2C) covering Account Receivables, Cash Management, Advanced Collections and General Ledger.
• Extensive work experience in Procure to pay cycle (P2P) covering procurement, Purchasing, Account Payables and General Ledger.
• Expert working experience on Sub Ledger Accounting, Financial Accounting Hub and Fixed Assets.
• Expert working knowledge on Project Accounting, Oracle e - Business Tax, AME and Workflow Builder.
• Working Experience on Oracle R12 and 11i Implementations, Re-Implementations and Up-gradation projects.
• Experience in successfully delivering large scale business transformation programs and Global Roll-outs.
• Experience in Application evaluation, Requirement gathering, Business Analysis, Gap Analysis, Mapping Requirements to E-Business Suite, AS-IS process, TO-BE Process, Gap fitment documents, conducting workshops, Process flow reviews, Scope Verification & Validation, Alternatives Identification and Analysis, Go-live and Post-Implementation Support.
• Expert working experience in preparing user stories and use cases.
• Experience in Preparing Business Process (BP), Business requirements and mapping (RD & BR), Configuration (BR100), Solution and Functional design (MD.050) Test Plan (TE.020) and Conversion Documents.
• Data migration strategy, approach, conversion and reconciliation activities.
• Good understanding of E-Business Suite Technical Architecture.
• Experience in all types of extensions and customizations (CEMLI components) of E-Business Suite.
• Production Support experience.
• Techno- Functional knowledge of Oracle e-Business suite release 11i / R12 in a multi-organization and multi-set of books/ledger books environment.
• Experience in Country Specific Localizations (Europe).
• Experience in using Oracle AIM implementation methodology.
• Conducting CRP sessions with Business users.
• Functional training to Business users, Preparing end business user manuals and Business Process documents.
• Liaising with Client and Business users.
• Leading and guiding the project team towards deliverables.
• Interaction with different stake holders of the projects.
• Quality Assurance Process and offshore-onsite collaboration.
• Risk Management (Risk factors and mitigation plan), Change Management.
• Participation in Project steering Committee meetings.
• Experience in delivering projects using Agile Methodology.
• Project planning, management and delivery.
• Excellent interpersonal, communication, documentation and leadership skills.
• Strong presentation skills and the ability to communicate at different levels within the organization with exceptional problem solving, analytical skills at both application & system level and excellent attention to detail.
• Create SR’s with Oracle Technical Support, coordinated and followed on multiple issues based on priority including identifying bugs and follow-up with Oracle Development as well as conducting Oracle Web Conference (OWC) with Oracle Support Team.
• Experience in complete software product development life cycle (SDLC): System Analysis, Design, Development, Testing and Deployment.
• Led the teams on small to medium scale engagements.
• Configure Business access as per SOX compliances and setting up responsibilities accordingly to maintain the proper internal control mechanism.

TECHNICAL SKILLS:

ERP Software: Oracle Applications 11.5.9, 11.5.10.2, R12.0.6 and R12.2.3

Business Areas: Finance (General Ledger, Payables, Receivables, Fixed Assets, Cash Management, Advanced Collections, iExpenses, Sub Ledger Accounting and Financial Accounting Hub), Projects (Project Costing, Project Management and Project Bulling ), Procurement ( Purchasing, iProcurement and iSupplier), Concur, Hyperion

Hardware: UNIX and Windows based systems

Tools: MS Office, MS Project, MS Visio, PL/SQL Developer, Data Loader, TOAD, Workflow Builder 2.6 and Quality Center

Database: Oracle (9i, 10g,11g)

Programming Language: SQL,PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential,NE

Oracle Financials Lead

Environment: Oracle E-Business Suite R12.2.3 (upgrade and support)

• Led the R12 (AP&AR) implementation encompassing the client’s main inventory facility and over 10 field sales offices.
• Managed team and assisted on techno-functional analysis, requirement gathering. Involved in architecture design process.
• Facilitated the design of client facing documentation and operational reporting across all Quote to Cash modules.
• Performed configurations across all Order to Cash modules (O2C).
• RevRec (Revenue Recognition) setup.
• Revenue Management.
• Worked on adding and re-configuring AME rules to add more approver based on certain dollar amount.
• Facilitated CRP and UAT testing efforts for all Procure to Pay (P2P) module.
• Practiced AIM methodology in all aspects of process analysis, requirements gathering, design and configuration.
• Worked with Concur, a Travel & Expense management company, to integrate their services with the R12 Payables under aggressive time constraints.
• Reviewed the client’s existing iPayment integration, conducted requirements gathering sessions and established the design approach from a functional and technical standpoint.
• Resolving day-to-day Prod Support tickets for both Oracle Apps 11i/R12 releases.
• Managed Tax Exemption and Product specific taxation for both USA and Canadian customers.
• Weekly status reports identifying progress, status and issues.
• Supporting solving Day-to-Day End - User problems.
• Direct interactions with users and seeking information as required for resolving issues
• Raised SR to Oracle for Critical Issue Solution.
• Developed and implemented cross validation rules and provided Production support.
• Supported in configuring Multi-Org environment for Business Group, Legal Entities, Operating Units and Ledgers.
• Upgraded from 11i to r12.2.3.

Confidential,Detroit, MI

EBS Support Analyst/ Consultant

Environment: Oracle E-Business Suite R12.1.3

• Supported day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user training on new processes
• Provided period end closing process for Payables and General Ledger. Resolved period end closing issues. Coordinated with Business users.
• Gathered requirements on budgets and configured the GL system to meet the requirements. Functional process was developed to upload budget journals and configured setups for Web ADI for batch journals upload process.
• Analysed the requirements/process issues and designed a business process to meet the functional requirements for enhancements, Period End closing and production issues
• Issue resolution, update functional impact analysis with proposed changes, if any in to Bugzilla issue tracker.
• Provided production support on GL, AP, AR, FA, PO, and modules and resolved period end closing and interface issues in production. Trained users on process design and enhancements.
• Coordinated and raising SR’s for issues related to standard functionalities with Oracle Support. Bug fixes, Data fixes for Purchasing and Sourcing related issues.
• Implemented iProcurement, iExpense, Purchasing, Accounts Payable (P2P), Accounts Receivable (O2C), Financial Accounting Hub, Sub ledger Accounting Hub and General after validating and system testing for E-Business applications.
• Configured E-Business Tax for USA, Mexico, Brazil, India, France and China.
• Business flow set up of Order to Cash and Procure to Pay (P2P), Analyzed system requirements developed through test plans and test scripts. Configuring multi-org structure in R12.
• Configured AME rules.
• AR setups, receivables transactions processing, Invoicing, lockbox, cash applications and revenue recognition. FA setups, conversion, loading historic data.
• Prepared test scripts and testing of oracle applications. Developing of scripts which enabled loading of accounts in General Ledger.
• Revenue Management
• Supported Project Accounting and Billing.
• Provided support to the development of a cutover plan for the EBS finance system as well as cross Project Cut-over activities and dependencies.
• Lead a variety of tasks focused on stabilizing the system prior to final testing and preparing for final cutover to production. This includes work to troubleshoot and resolve open issues, testing, providing functional expertise needed by the team to complete the system readiness tasks.
• Supported the project team efforts to provide post production support to the county during the month after Go Live by providing functional Oracle EBS expertise and troubleshooting and resolving issues escalated from the help desk.
• Weekly status reports identifying progress, status and issues.
• Troubleshot various data, functional, technical issues during development and production support phase related to Accounts payables, Purchasing, and other financial modules within Oracle EBS.
• Worked with various phases of implementation like gathering requirements, functional design, user acceptance testing, resolving functional issues.
• Involved in customizing custom SLA rules for AP, AR, FA and PA.
• Patch Analysis, working with DBA’s on installing patches, testing the patches.
• Created Training Manual and Provided Training to the User.
• Upgraded from 11i to 12.1.3.

Confidential, West Des Moines, IA

Oracle / ERP Functional consultant

Environment: Oracle E-Business Suite R12.1.3

• Lead consultant for GL, AP, FAH, SLA and FA modules for this Business Transformation Program.
• Participated and led the workshops for collecting Business Requirements.
• Prepared user stories and use cases.
• Guiding the Team on the solution and Functional Architecture.
• Analysed the gaps and proposed alternative solutions.
• Implemented the project using AIM methodology.
• Prepared BR.100, MD.050 and Unit Test case documents.
• Implemented iProcurement, iExpense, Purchasing, Accounts Payable (P2P), Accounts Receivable (O2C) (Revenue Recognition), Financial Accounting Hub, Sub ledger Accounting Hub and General Ledger Modules as a team.
• Revenue Management
• Supported Project Accounting and Billing.
• Coordinated with different stakeholders for collecting requirements and resolving issues.
• Implemented Event Based and Journal Pass-through interfaces using Financial Accounting Hub.
• Banks integration.
• Configured E-Business Tax for USA and Mexico.
• Led and participated in client discussions.
• Implemented GAAP and IFRS accounting.
• AS IS and TO BE business process documentation.
• Prepared and reviewed Configuration Documents and Functional Design Documents.
• Data Migration Strategy Document.
• Conducted CRP sessions.
• Participated in Project steering committee meetings.
• Participated in UAT testing by guiding business users and bug fixing.
• Participated in daily meetings and prepared project status reports.
• Discussed with client regarding Quality Assurance Process and offshore-onsite coordination.
• Business User training to Athene Users.
• Project Estimations and resource planning.
• Worked on Business Change management and Access controls.
• On time Project Delivery.

Confidential, Louisville, KY

Oracle Financials Functional Consultant

Environment: Oracle Applications R12 - 12.1.2

• Worked with R12 Implementation team to study the existing client’s systems, preparing the functional design documents to extract the data from legacy system (Passport) into Oracle Applications open interface tables.
• Involved in gathering business requirements, analysis and design the future business process for AP and iExpenses applications.
• Involved in setups financials and payables options, payment system, payment profiles, payments templates options including all key configurations in AP.
• Involved in P2P and O2C process.
• Supported Project Accounting and Billing
• Receivables Lockbox setup, Revenue Recognition, and Receipt Rules setup
• Involved in setups expense report templates, expense report options, policies allocations, receipt notifications rule set, mileage expense type definitions in AP,
• Assigned responsibilities to internal users, enabling function security, enabling profile options and other key configurations in iExpenses and iSupplier applications.
• Designed and setup inbound process to import invoices from external sources.
• Designed the functional specification documents for customized interfaces (EDI), reports and extensions.
• Prepared documents for setup configuration (BR 100), training manuals in AP and iExpenses applications.
• Responsible for end-end internal testing, CRP/UAT and regression testing, including obtaining the sign off from the business stake holders & sponsors at various stages of project.
• Performed unit testing and helped the user with the testing, identified and fix the bugs before the go-live.
• Resolved period close issues in AP.
• Performed functional testing, worked with off-shore teams and Oracle support team to resolve the issues.
• Worked extensively on production support role, supporting end users and provided solutions to the bugs/enhancements.

Confidential, PA

Oracle Apps Functional Consultant

Environment: Oracle e-Business Suite 12.1.3

• Analysed the Reimplementation Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Prepared of all of the Functional Specification Documents (FSD), Business Requirement Documents (BRD), Data Mapping Documents (DMD) and Functional Testing Documents.
• Carry out Data Mapping for data conversions.
• Understand Division-specific business processes from the end users and implement the same.
• Responsible for training the end users on the new processes and facilitated on-the-job training.
• Worked on the setups and configurations for GL, AP, CM, Project Accounting, I-Expense, Payment Manager, Procurement Contracts, AR, Sub Ledger Accounting, and e-Business Tax modules.
• Worked on the setups of the Payment Manager - defining payment formats, setting up EFT. Transmission formats, payment process profiles, payment process templates.
• Worked on the Revenue Recognition Process in Oracle AR Module.
• Setup Accounting and Invoicing rules in Oracle AR.
• Setup Auto Invoice in Oracle AR module.
• Setup Invoice Sources in Oracle AR Module.
• Worked with business users on planning and executing data conversion activities like Item, PO, On-hand, Cost and Categories.
• Worked in P2P and O2C process.
• Designed the Return process, which starts from customer return, rectifying/repair/disposition and then ship the good back to customer.
• Resolved the Conference Room Pilot (CRP), System Integration Testing (SIT) and User Acceptance Testing (UAT) issues in distribution track.
• Business Process analysis includes understanding the existing business process (AS-IS) and designing the future process (TO-BE) with the standard Oracle functionality for manufacturing track.
• Documented and analysed businesses processes and develop detailed user requirements and functional specification documents.
• Provided inputs and part of the team for new solution.
• Tested various business scenarios in the new system.
• Interacted directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progressed the track through CRP1, CRP2, UAT & Go live.
• Provided user training & documentation.

Confidential,Washington, DC

Oracle EBS Financial Functional Analyst

• Involved in Super User meetings to gather specific business requirements for setting up the modules.
• Monitored and documented team members’ activities and provided updates to the management on project progress.
• Designed financial documentation based on AIM Methodology (BR100, MD 50).
• Configured and implemented diverse Oracle financial modules (GL, AP, PO, AR, FA, CM).
• Worked with the diverse business groups and technical team in the communicating business requirements within the business organization.
• Identified gaps between business requirements and current application within the environment.
• Identified the requirements from User & developed functional specs for the General ledger, Account payables, Account Receivables.
• Involved in developing specs for Fixed Assets and Cash Management.
• Assisted in the setup of ledgers, segment value, MOAC, Multi-Org, and Sub-ledger accounting engine within the R12 Environment of the financial application.
• Designed diverse security rules and cross validation rules for diverse accounts within the GL application.
• Assisted in the setup of diverse profile options for General ledger, Account Payable, Account Receivable, Revenue Recognition process, Fixed Assets and I-Expenses.
• Assisted in designing training documentation for the application users and diverse business groups.
• Assisted in the design of functional specifications documents for diverse business groups.
• Participated in meetings in the design of new chart of accounts and analysis of diverse financial accounts.
• Assisted in resolving business users’ issues pertaining to the financial application.
• Participated in the analysis of diverse financial accounts (Expenses and Assets Accounts).
• Worked on inbound interfaces in PO and AP module to import the data from legacy system to Oracle Application.
• Participated in P2P and O2C process.
• Defined system options, payment terms, banks, customers, transaction types and source, auto accounting.
• Setup customer profile class and customer relationships, dunning letters, aging buckets, defined collectors, receipt classes, source and program.
• Created test documents, conducted Unit Integration and conducted UAT sessions.

Confidential,Roseland, NJ

Oracle Financial Functional Consultant (11.0.3 to R12.1.3)

• Updated Organization Parameters, Receiving Accounts, Expense AP Accrual Accounts, P&L Accounts, Clearing Accounts, Cost Group Valuation Account.
• Updated Purchasing (PO), Receiving (AR), and Payables (P2P) options.
• Changed Auto Accounting rules to accommodate the new organizational structure.
• Developed Year End process using Mass Allocation Formulas, configured Mass Allocation Year End formulas.
• Configuration of ledger sets and new secondary ledgers.
• Configured new cross validation Rules and Security Rules.
• Configured and tested various FSG Reports (Income summary reports etc.) that were designed to meet the requirements of CORP in ES.
• Used ADI and tested various GL Journal import process through ADI. Also performed standard and statistical Journal entries in GL.
• Participated in test reviews and defect report meetings periodically.
• Developed GL Consolidation Process, Configured Consolidation Rules and Implemented GL Consolidation.
• Train users in fundamental and functional changes from 11.0.3 to R12
• Worked with Business to design and implement new business process.
• Involved in support for Procure-to-Pay life cycle (P2P).
• Involved in setups of AP and FA, multi reporting currency.
• Set up of financial options, payable options, invoice, supplier, supplier sites, distribution sets and tolerances.
• Defined currency conversion, revaluation and set the profile options for GL.

Confidential,Boca Raton, FL

Junior Oracle Financial Functional Consultant (11i)

• Setup Key Flex Fields.
• Imported invoice information into Oracle application tables using auto invoice.
• Set of books (Chart of Accounts, Calendar & Currency).
• Assisted in P2P process.
• Created security rules and assigning to application users in OE module.
• Generated reports using Financial Statement Generator (FSG) for Order Entry.
• Setup Descriptive Flex Fields