SUMMARY

• Oracle E - Business Suite Functional Analyst Professional with 8 Plus of experience
• Industries: Financial Data Services,Retail Banking / Investment Banking / Private Banking
• ERP Functional Consulting, Oracle E-Business Suite Release 11i and R12, Financial Modules - Purchasing, Payables, Receivables, iExpense, Cash Management, AGIS, Fixed Assets, Projects Costing, Projects Billing, Oracle Time and Labor and Oracle Projects Suite
• ManufacturingModules - OM, INV,Shipping, BOM, PO, and WIP. Advanced Pricing and Distribution modules
• Functional experience in setting up, configuring and testing of Advance Pricing, Oracle Order Management, Purchasing & Inventory
• Involved in Implementation, Re-Implementation, Upgrade and Support of Oracle Financials and Oracle Project Modules
• Experienced in conducting Functional Requirement Analysis, Gap Analysis, Production Support, Business Users, Testing, and Project Documentation
• Experienced inOrder to Cash (O2C), Procure to Pay (P2P)business flows
• Good working knowledge in designing technical documents using AIM Methodologies (MD50, MD70, CV40ANDCV70)
• Extensive experience in completing several full cycle implementations of Oracle Financials, which include Accounts Payable, Accounts Receivables, Advanced Collections, Claims Management, Vendor Rebate Management, and Oracle's Channel Revenue Management.
• Strong understanding of ITIL Framework
• Ability to understand and analyze business process related problems and requirements across cross functional business areas
• Team player with an attitude to learn and excel along with strong people management skills
• Experienced in interacting with stakeholders, analyzing the root cause of the problems, gathering requirements, rating and assigning priorities to requirements.
• Skilled at understanding complex business processes and providing input for business solutions
• Good analytical, presentation and Confidential interaction skills
• Track record of delivering high quality output within the given time lines
• Experienced in preparation of financial statements like income statements, cash flow statement and balance sheet

TECHNICAL SKILLS

Programming Languages: C, VB 6.0, PL/SQL, SQL, ERP

Oracle Financials: R12/11i (GL, AR, AP, FA, CM, SLA, Payments, AGIS, ebTax, OM, INV, Projects Foundation, Projects Costing, Projects Billing, Resource Management, Oracle Time and Labor and Project Management )

Database Tools: SQL *Loader, TOAD, Data Load, ADI

Application Software: MS-Word/ Excel/ PowerPoint/ Access/ Visio/ Project

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Oracle Financials Functional Lead

Responsibilities:

• Conducted gap analysis with Confidential to discuss the possibility of R12 Upgrade vs. Re -Implementation
• Conducted fit-gap analysis, identified gaps and worked with business owners/users in the design sessions. Mapped the future state process requirements in Financials and Projects Module
• Involved in CRP sessions and also in preparation of BP040, BP080, BR100 documents
• Prepared Customization Documentation (CV40, MD50, MD70) and Test case Documentation (TE40)
• Configured GL, AP, AR, O2C, P2P, FA, CM, Projects Foundation, Projects Costing, Projects Billing in the gold instance
• Loaded the invoice information from legacy system into OracleARModule
• Worked on Revenue Recognition functionality considering accounting and audit requirements
• Established data conversion routines and executed scripts to convertGL, APandFAdata from legacy systems
• Developed a Program for theAuto Invoice Interfaceto import Customer Invoices, Credit & Debit Memos in ReceivablesAR.
• Established data conversion routines and executed scripts to convertGL, APandFAdata from legacy systems
• Wrote Functional (MD50), Technical (MD70) and Conversion Mapping document (CV40)
• Worked on ebTax to solve issues and implement a new tax rate for special Jobs in projects
• Worked on integration between Oracle Projects and custom project management and monitoring solutions
• Worked with the technical team for developing customer interface and transaction conversion from legacy systems
• Assisted in developing and testing Invoice Import from third party systems
• Led the test sessions for GL, AP, PA and AR modules. Performed unit, End to End tests and assisted in UAT sessions
• Performed role of primary support analyst providing production support for Oracle GL, AP, AR, FA modules covering a huge Confidential base
• Configured setups of Project Accounting modules and trained the users on business flows of project accounting process
• Involved in SIT and UAT testing and prepared test scripts
• Involved in AR and AP Invoice and PO Print Program customizations
• Channeled Rebates and reporting
• Played a vital role in implementation of ITIL process
• Oversaw the and support forOracleGL, AP, FA, CE & AR Modules along with resolution of issues logged in by the end users

Confidential, Omaha, NE

Oracle Apps Lead Business Analyst

Responsibilities:

• Studied the current Chart Of Accounts and proposed a design to enhance the business with a new Chart of Accounts in R12
• Helped analyze issues relating to various Operating Units in financial modules such as GL, AP, AR, FA, AGIS, Cash Management and iExpense
• Involved in CRP implementation phase and also in preparation of BP040, BP080, BR100 and TE040 Documents
• Led the test sessions for GL, AP and AR modules. Performed unit, system integration tests and assisted in UAT sessions with preparation of test scripts
• Established data conversion routines and executed scripts to convertGL, APandFAdata from legacy systems
• Setup FA fully, uploaded & purged the Assets data and prepared the reports
• Worked on the development of Interfaces, Data Conversions,Developing new Forms, Reports, Customizing Oracle Reports in Order to Cash Cycle touching various modules such asGL, AR, INV, OM, BOM & SHIPPING
• Involved in the Functional setup of Order Management (OM), Inventory (INV) modules
• DevelopedInterfacefor theStandard ItemsinINVENTORYgenerating the SQL Loader scripts and PL/SQL procedures for validating and loading data into oracle tables
• Developed interfaces to import payable invoices andiExpensesrelated invoices
• Configured Indirect Sales Management functions for third party sales tracking, charge-backs, rebates, and sales commission
• Configured and setup Tax in ebTax module
• Customized existingOracle Reportsin Inventory Module (INV),PricingusingReports 10g
• Performed, developed and documented systems analysis, validation testing and development of documentation
• Held Workshop sessions to dive into the key requirements, enhancements and Impact Analysis for all Financial Modules (GL, AP, AR, Cash Management, P2P, O2C and Assets, EBTax)
• Provided post production support for financial modules with month end closing related as well as regular issues
• Resolved month end related issues involving data fixes and configuration changes
• Corrected auto invoice errors while importing invoices from various third party systems

Confidential, Manchester, NH

Oracle Financial System Analyst

Responsibilities:

• Conducted gap analysis with Confidential to discuss the possibilities of R12 Upgrade
• Studied current Chart Of Accounts and proposed a future design to enhance the way Emerson does Business with a new Chart of Accounts in R12
• Held workshop sessions to understand the key requirements, enhancements and Impact Analysis for all Financials and Oracle Projects Modules
• Interacted with Business Users to understand their pain points and Key requirements
• Designed and Developed Demo/ CRP sessions for the Modules with the Respective users for R12 Environment
• Demoed various standard functionalities
• Solutioned complex integration between the custom Laboratory New Product Development software - KRONOS and Oracle Projects
• Gathered Business Requirements for reimplementation and documented them
• TestedBoundary systemsSI data collaboration with oracle in various financial business processes(P2P, O2C)
• Trained the super users and explained the business process flows of Financials and Projects Modules
• Involved in Data Migration of the master data and transaction data
• Conducted UAT sessions and obtained user sign offs
• Participated in Cutover meetings and post go-live support

Confidential

Oracle Financial System Analyst

Responsibilities:

• Team lead for maintaining/ implementing Oracle systems involving modules: GL, AP, PO, FA, CM and Project modules for the In-house implementation
• Conducted Fit Gap assessment of Financials (AP, GL, AR) and Impact assessment on current customizations, business processes (which vary across different orgs)
• Gathered requirements for enhancements, Design and configuration. Testing and user communications. Assessment of R12 functionalities for upgrade
• Assisted the team in setting up EBTax partially, setting up of Chart of Account, setting up of Fixed Asset Categories, Intercompany accounts
• Testing ofP2P and O2C processend to end while providing support to users for the same
• Guide and review team on test plan and scripts, material
• Conducted Conference Room Pilots for demonstrating key functionalities
• Monitored functional testing and resolved issues while following up with Oracle support
• Support the team with regards to Project scheduling and resource planning, data conversion,, testing and implementation planning
• Configured Key Flex field and Descriptive Flex field

Confidential

Oracle Business Analyst

Responsibilities:

• Worked as a Business core implementation team member and super-user in the areas of Oracle Financials and Oracle Project Accounting
• Assisted the Oracle Project team in finalizing business processes and evaluated/approved various customizations
• Participated actively in CRP, UAT, Cutover and Go-live activities
• Post implementation facilitated as a Business Champion/ Change management owner for finance and project modules by preparing setup documents and approving UAT s before enhancements/ bug fixes could move to production
• Assisted in structuring the deal and preparing offering memorandum
• Facilitated the due-diligence process for prospective investors and consultants
• Supervised a team responsible for post-transaction monitoring and compliance
• Structured and negotiated terms and conditions, including pre-payment, draw down schedule and security agreement
• Assisted with loan documentation process, including drafting of security agreement.
• Assisted with development of detailed financial model and monitored key variables impacting the model outcome such as project cost, capital structure, interest rates, tax rates, working capital limits, repayments power purchase agreement details and various other key operating expenses
• Presented all project findings to the Board of Directors
• Negotiated terms, security conditions, commission rates & margin requirements for obtaining project related guarantees
• Prepared analysis of various alternatives for financing the import of power plant equipment, including Buyers and Suppliers Credit Agreements