SUMMARY

• Over 8 years of professional experience in ERP Consulting, Implementation, customization and Production Support of Oracle E - business Suite (11i and R12) Financial Modules in different industries of various sizes and intricacy.
• 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 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, project costing, 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.1.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)

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, West Des Moines, IA

Oracle/ERP Functional consultant

Environment: Oracle E-Business Suite R12.1.3

Responsibilities:

• 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, Purchasing, Accounts Payable, Accounts Receivable, Financial Accounting Hub, Sub ledger Accounting Hub and General Ledger Modules as a team.
• Coordinated with different stakeholders for collecting requirements and resolving issues.
• Implemented Event Based and Journal Pass-through interfaces using Financial Accounting Hub.
• Banks integration
• 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.
• Updated Purchasing (PO), Receiving (AR), and Payables (P2P) options
• Configure Stores for catalog items in iProcurement to meet the business needs in P2P process
• Participated in Project steering committee meetings
• Participated in UAT testing by guiding business users and bug fixing
• Participating in daily meetings and prepared project status reports.
• Discussed with client regarding Quality Assurance Process and offshore-onsite coordination
• Business User to Athene Users.
• Project Estimations and resource planning
• Worked on Business Change management and Access controls.
• On time Project Delivery.

Confidential, Oakland, CA

Oracle Apps Functional Consultant

Environment: Oracle e-Business Suite Upgrade to Release 12.1.3

Responsibilities:

• Part of the new R12 implementation team as a senior oracle apps consultant.
• Assessed the current use of Oracle applications and the mapping of new features and functionality of R12.1.3 to the functionality required in the present company environment.
• Prepared BR.100, MD.050 and Unit Test case document for custom enhancements.
• Created design document for conversion activity for Customer, AR Invoice, AR Receipts process
• Configured Journal Line Type, Journal Line Definition and creation of custom ADR for defining Journal Line type.
• Set up Web ADI for Journal Upload process, mass allocation rule, Cross validation rule and Security rule.
• Prepared the data collection sheets for inventory, purchasing and Order Management modules
• Involved in Period Closing process for sub ledger module like PO, AP and AR & Reconciliation with GL.
• Designed and configured setups in Inventory, Purchase and Account Payables modules to meet the Purchase Requisition created in asset process.
• Configured FSG Reports for customized Financial Statements - Division wise and Department wise Breakup of Expenses and Revenue and allocation of corporate and Branch expense to their divisions, products and departments
• Coordinating and lead the entire testing phase of the project for Oracle Payable and Oracle Purchasing which included initial of analysis, provide resolution of issues during the CRP and supporting reconciliation activity between sub ledger and GL.

Confidential, PA

Oracle Apps Functional Consultant

Environment: Oracle e-Business Suite 12.1.3

Responsibilities:

• Analyse the Reimplementation Requirements and strategize the migration of customizations to Release 12 instance.
• Identification of GAPs & proposal of Solution.
• Preparing 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 the end users on the new processes and facilitated on-the-job .
• Worked on the setups and configurations for GL, AP, CM, Project Accounting, i-Expense, Payment Manager, Procurement Contracts, AR, Sub Ledger Accounting, 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, etc.
• 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.
• 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.
• Provide inputs and part of the team for new solution.
• Test various business scenarios in the new system.
• Interact directly with end users, infrastructure teams, and project teams.
• Functional design of the Conversion / Integration programs.
• Progress the track thro CRP1, CRP2, UAT & Go live
• Provide user & documentation

Confidential, Roseland, NJ

Oracle Apps Functional Consultant

Environment: Oracle e-Business Suite R12

Responsibilities:

• 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
• Worked on Requirements Gathering, Analysis, Design, Solution Design and prepared Test Cases and Deliverables
• 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)
• Configured multi org legal entities, operating units inventory orgs in setups
• Involved in setups of AP and FA, multi reporting currency
• Setting 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
• Involved in maintaining of cash and bank records such as bank deposits and reconciliation
• Define fiscal years, calendar, flex fields, registering the locations of assets, defining asset books in FA module
• Configured mass additions and mass transactions in Assets Module
• Performed depreciation for the assets
• Performed system option settings for receivables

Confidential, San Diego, CA

Oracle Functional and Support Analyst

Environment: Oracle E-Business Suite R12.1.1

Responsibilities:

• Prepared business configuration documents (BR100) for GL, AR and AP modules using the business mapping document (BR30).
• Responsible for requirement gathering, requirement analysis, gap analysis, setups, functional and technical extensions and modifications, unit testing, stress testing, integration testing, and CRP's for Accounts Payable.
• Set up Order Types, Invoice types, credit memo types, connecting invoice types to order types, order numbering, carriers, tax codes, set up items.
• Set up Revenue Recognition Invoices to recognize the revenue over period of time.
• Integrate Oracle Payables with iExpense and Oracle Project Billing.
• Used Accounting Rules to determine the number of periods and percentage of total revenue to be recognized (Revenue Recognition) in each accounting period.
• Involved in the setup of intercompany balancing and global intercompany system.
• Reviewing setups of Oracle Cash Management to use with Oracle Payables or Oracle Receivables.
• Perform the related setup tasks in the applications that work together with Internet Expenses to create an integrated environment for expenses reporting.
• Prepared the setup documents and configured system according to business requirements.
• Defined the chart of accounts, currency and accounting calendar. Created summary accounts and rollup groups.
• Created cross validation rules and security rules.
• Setup receivables to integrate with order management.
• Involved in developing test scripts (TE40) and user manuals for the entire Order to Cash cycle.
• Worked on inbound interfaces in PO and AP module to import the data from legacy system to Oracle Application.
• 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
• Assisted in Conference Room Pilots (CRP) testing and created users manuals.
• Performed knowledge transfer/ for the users.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of GL and AR modules.
• Documented and presented procedures and material to users in GL, AP, and AR.
• Trained users with closing the month in AR, AP & GL Modules and reconciling with GL.
• Worked with technical consultant for data conversion.
• Reviewed and confirmed location based tax setups to meet business requirements.
• Directed and involved in process mapping of significant transactions and risk and control identification
• Conducted extensive tests as per test plans to evaluate the design and operating effectiveness of controls and mitigation of identified weaknesses.
• Organized of four team members on business processes and Oracle Financials.

Confidential, Oakland, CA

Oracle Financials Functional Consultant

Environment: Oracle E-Business Suite R12

Responsibilities:

• Conducted preliminary study on current asset creation process and system (Access Database)
• Organized shop floor meetings with Users, Accounting and Audit groups. Established one-on-one interaction with user in requirement gathering, current system analysis and solution designing
• Current business process in assets creation, assets accounting and asset inventory control was reviewed and provided as-is and to-be process document on Assets creation and effective Asset Management process
• Reviewed the Business Requirements Documents with the Business and Development teams and analyzed the functionality of the Oracle applications so as to finalize the solution
• Identifying standard functionality, analyze gaps document and design solution for GL, AP & AR depending on business requirement
• Coordinated with Project Manager, business team for system updates and deadlines for the implementation
• System integration and regression testing was done for Service Contract, Order Entry, AR Payables and iExpense systems and resolved the issues
• Data conversion and migration strategy was designed for conversion Customer Master, Open Invoice.
• Created and maintained AIM documents BR100, MD50, CV40, & TE40
• Developed business processes, solution designing to meet the business requirement
• Designed and configured setups in Inventory, Purchase and Account Payables modules to meet the Purchase Requisition created in asset process
• Conversion strategy was developed to migrate the asset data from current system (Access Database) in to Oracle Fixed Assets. ADI was used to migrate the data

Confidential, Redwood City, CA

Oracle Financials Functional Analyst

Environment: Oracle E-Business Suite R12

Responsibilities:

• Supporting day to day production issues, gathering requirements, configuring and testing system to meet the requirements. It includes documentation and user 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