SUMMARY

• Experienced IT professional with extensive experience in Oracle Applications Assignments (Implementations, Upgrades, Production Support, Enhancements, Development and Customizations).
• Over 18 years of experience in IT industry that includes Functional Analyst experience in Oracle ERP for around 12 years. Worked in various roles such as Business Analyst, Project Manager, Project Lead, Release Manager, Configuration Manager and as a Hands on Analyst.
• Extensive experience in P2P and Financials Modules mainly focusing on GL, FA, CM, AP, PO, AR, iSupplier, iProcurement, iExpenses, EBTAX and SLA modules.
• Extensive knowledge in both R12&11i versions of Oracle E - Business Suite.
• Involved in 4 full life cycle implementations and multiple technical and complete upgrades from Oracle EBS version 11i to R12.
• Extensive experience in gathering, managing and documenting business and functional requirement and communicating effectively with stakeholders, developers, QA testers and also playing vital role in coordinating multiple business meetings.
• Efficient in providing solutions, designing, customization, implementation, configuration, thorough testing and documentation of Oracle Financials.
• Working knowledge of Agile and Waterfall methodologies.
• Experience in implementing AGIS (Advance Global Intercompany System), involved in Multi-Org & Multi-Currency, re-valuation, translation and GCS (Global Consolidation System), designed and developed Financial Statements (FSG’s) as per Business Requirement.
• Expertise with business process flows in the areas of Procure to Pay (P2P), Order to Cash (O2C), Sub-Ledger Accounting (SLA) and Acquire to Retire (A2R).
• Experience in designing functional specification document for Suppliers, Customers, Assets, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle and also involved in Data Conversions/Migration.
• Expertise in Gap analysis and providing solution design and building RICE components as a part of fit gap analysis.
• Experience in configuration and testing system (BP 80,RD20, BR30, BR 100, BR 150, MD 50, CV 40 &TE 40) and also maintaining documentation and using the Application Implementations Methodology (AIM), which includes Business Functional Requirement analysis, Understanding AS-IS & TO-BE process.
• Expert in conducting Oracle Web Conference(OWC) with Oracle Support Team, creating SR’s with Oracle Technical Support as well as efficient at coordinating and following multiple issues based on priority including identifying bugs and follow-up with Oracle Development.
• Well experienced in providing wide range of functional training to multiple business user group and co-ordinate UAT sessions and also conduct CRP’s.
• Expertise in planning, estimation, presentation and developing design documentation using the AIM Methodology, MS Visio, MS Project, etc
• Expert level knowledge on User Management, AOL objects, Approval Management (AME).
• Performed numerous designs of Conversions and interfaces from legacy systems/third party systems into Oracle Applications.
• Provided support during go live critical times and post-production maintenance phase to different clients.
• Strong Analytical, Diagnostic and Troubleshooting skills and ability to work in a fast-paced and team-oriented environment.
• Experience in System Administration activities like creation and maintenance of users, creating & assigning responsibilities, changing profile options, Setting up vacation rules, Alerts etc.,
• Expert in coordinating with various teams that includes legacy systems, users, DBA team, clients and app-leads enabling competent production support
• Ensured all Project deliverables are of high quality before implementing them to the production environment. Adhering to SLAs. FTR(First Time Right) and OND(On Time Delivery)
• Very good exposure in working at various geographical locations via USA, Europe and India
• Ability to perform as an individual and in team environments with proven communication and interpersonal skills.

TECHNICAL SKILLS

• Financials: AP
• AR
• GL
• CM
• OM
• AR
• FA
• SLA/FAH
• AGIS iExpenses iProcurement
• EB-Tax
• Oracle iSetup
• R12/11i Implementations
• Upgrades and Support
• Business Process Design / Re-design
• Architectures and Business Processes: Multi Org. MRC
• TCA
• P2P
• A2R
• OTC
• R2R
• Project Budgeting and Planning
• Oracle EBS Testing on Regression
• Integration
• System and UAT Testing
• Multi-National Implementaitons
• AIM Methodology and Documentation
• End User Training

PROFESSIONAL EXPERIENCE

Confidential, Rochester, NY

Oracle EBS Finance Specialist

Environment: Oracle Applications (GL, AP, AR, PO, FA, CM, iExpenses, iSupplier, SLA, EB-Tax), Windows7, SQL*Developer, SQL

Responsibilities:

• Primary responsibilities include requirement gathering, current business process analysis, re-engineering and designing of business process, system configuration and system testing.
• Conduct multiple meetings with Business and Technical team at different intervals for various purposes.
• Defined various currencies for multi-currency operations and currency translation, conversion, revaluation has been done to meet the requirement. Cross validation rules have been setup for various GL codes. Configured Sub-ledger accounting process to GL.
• Setup AP payable system option, financial options, and payable options.
• Extensively worked on Configuration of Approvals Management Engine (AME) for standard Invoice Approval Workflow HR information to support Purchasing Documents Approval to define Employee, Jobs & Positions, and define & assign Approval Groups to support Job Position Hierarchies & also supported Employee/Supervisor Hierarchy for PO Approvals.
• Involved in the data migration of the master data and transaction data of all the Purchasing and Order Management modules.
• Converted Fixed Asset data into Oracle through web ADI.
• Analyze Fixed asset system to find cost differences between GL and fixed asset system.
• Correct cost differences to get GL in-line with fixed asset system.
• Creating cross validation and security rules.
• Presentation of Financial Consolidation system to the Management.
• User Support Analysis: Research solutions to problems, answer client questions and provide consulting and training as required. Track software and documentation issues.
• Involved in Month-end support for close and reconciliation for AP and AR modules.
• Based on the existing functionality provided functional review & impact analysis on proposed changes.
• Designed and executed several Customizations and Setups in ERP as a part of Revenue Recognitionsand provided solution for Revenue Recognition requirements by developing extensions.
• Worked on E Business tax to calculate tax on Receivable transactions automatically which includes creating tax regimes, taxes, jurisdictions, tax recovery rates, tax rates and tax rules.
• Customized SLA (Sub ledger Accounting) requirements for Fixed Asset Account and Revenue Recognition.
• Resolved the issues related to automatic refund of credit card charges stuck in the receivable workbench
• Resolved the issues related to automatic clearance of receipts, aging bucket report, credit snapshot report, customer statement report
• Maintained and updated the development issue log tracker, enhancement tracker and the defects tracker.
• Prepared Cut- over Plan, listing down all Pre & Post Go- live tasks. Involved in Post-Production support.

Environment: Oracle Applications R12.2.4/R12.0.6 (GL, AP, PO, iProcurement, AR, iExpense, e - payments, SLA, CM, FA, INV, OM, QP) SQL, TOAD, Windows 7, Confidential Service Center, Confidential Quality Center.

Confidential, South San Francisco, CA

Sr. Oracle Functional Analyst

Environment: Oracle Applications R12.1.3 (GL, AP, AR, PO, FA, CM, iExpenses, iSupplier, SLA, EB-Tax), Windows7, SQL*Developer, SQL

Responsibilities:

• Implementation of Oracle Payables including setup of payment options, payment terms, distribution set, payment format, banks, expense report templates, matching options, tax codes, etc.,
• Worked as part of R12 implementation team, gathering requirements and authoring business requirement documents and functional specifications.
• Implementation of Oracle Fixed Assets module using AIM methodology, which included Asset categories, asset locations, book controls, depriciation methods, security profile, asset calender, fiscal year, quick codes and system controls.
• Worked on setting up of accounting method builder (AMB) for Financial accounting hub for various pass through Journal applications.
• Designed and developed multiple FSG reports on Budget and Actual balances, crossing over fiscal periods as per Business requirement.
• Extensively registered various AOL objects such as Value Sets, Value Set values, Custom Responsibilities, Lookup Values, Request Sets, and Request Set Links.
• Designed and Developed customized solution for Oracle Fixed Assets to resolve depreciation issues.
• Supported Procure to pay and FA issues during month end performing additional configurations.
• Provided support on purchasing issues like PO’s stuck in workflows & maintenance of purchasing hierarchies.
• Involved in the analysis and design phases of various iProcurement initiatives. Configured external punch outs and OSN.
• Configured iSupplier for supplier centralization and online invoice processing.
• Liasoned between the technical staff and the users (staff and management). Was also responsible for interdepartmental coordination between the various teams involved.
• During the Support phase, Applied various Recommended patch Collections (RPCs), for AP, Suppliers, Workflows and Cash management. Analyzed and applied various GDFs in payables and applied RCA patches to fix the issues permanently.
• Designed, tested and delivered various custom reports as per the Client specific requirement, including Invoice Register, Payment register Summary and Detail reports, Allocation of labor, Timeliness of Payments, Rejected Invoices register, etc.,
• Participated in user testing and helped in migration to production for BAU activities.
• Provided exptensive production support of Oracle financials, including following up SR’s with Oracle Meta link.
• Taken care of admin activities like setting up the users, assigning responsibilities and profiles.
• Extensively involved in creating setting up employee and end dating them when they were terminated.

Confidential, Horsham, PA

Sr. Oracle Financial SME/Analyst

Environment: Oracle Applications 11i/R12.1.3 (GL, AP, AR, PO, FA, CM, iExpenses, iSupplier, SLA, EB-Tax), Windows7, SQL*Developer, SQL

Responsibilities:

• Involved in the re-implementation of the Applications for all financial modules like GL, AP, AR, FA, CM, Purchasing and the Self-Service Modules Like iExpenses, iSupplier.
• Prepared and updated CV40, BR100 documents and created MD 50 Functional Design documents according to AIM.
• Designed and created new CHART OF ACCOUNTS and configured Ledgers for the North American Region.
• Configured, Accounting setup manager, COA Structure, Segments, Values Sets, Flex fields, Account qualifiers and Segment Qualifiers, Cross Validation Rules, Security Rules, Calendar and Currencies.
• Expertly defined, configured and implemented Rollup Groups, Aliases, Dynamic Insertion, Accounting Calendar, Summary Accounts, Intercompany accounts, and consolidation ledgers.
• Implemented EB-tax integration for Procure to Pay and Order to Cash cycles with One-Source Indirect Tax product line.
• Extensively worked on Oracle Sub Ledger accounting to analyze and gather information from Payables into GL and reverting back from GL Journal Entries to grab Payables Invoice and Payment Details through XLA.
• Designed various Quarter and Year end reports for Higher Management review in like Top Ten vendor payments, Overall Payments history, Employee and Tax Payments etc.,
• Setting up Standard, Statistical & Recurring Journals, Suspense Account and Mass Allocation formulas.
• Created users and modified the privileges for users, rollup group and summary accounts.
• Created suspense accounts for automatic balancing journal entries from particular sources and categories.
• Oracle Solution Design for Ledgers and Multi-Org structure and have given a POC for Multi-LE to OU structure.
• Worked on the setups of AP Module - setting up financial options, payable Options, system options, pay groups, discount terms, AME rules, etc.,
• Configured payments module including Payment formats, custom payment methods, payment documents, Payment Instruction Formats, Payment Process Profiles, PPR Templates, etc.,
• Conducted Conference Room Pilots (CRP) sessions showcasing the proposed solutions and validating the business requirements.
• Created test scripts for UAT (User Acceptance Testing) in TE040 documentation with detailed testing of all the above modules. Extensively worked on Confidential Quality Center for creating test scripts and tracking test results.
• Set-up supplier and supplier sites for suppliers in payables.
• Set up banks, receipts, transactions, plus training for invoicing, receipts, adjustments, and period close.
• Involved in setting up Project resources and roles to the project, Jobs and organizations for project Organizations, creating and maintaining Project budgets and worked on PA costing Import Process as part of project costing and billing.
• Conducted orientation training, CRP, UAT and Rollouts strategies for System up gradation.
• Provided production support for day to day business issues and worked on SRs with Oracle.

Confidential

Oracle Functional Analyst/ Coordinator

Environment: Oracle Applications 11i (GL, AP, AR, PO, FA, CM, iExpenses, iSupplier, SLA, EB-Tax), TOAD, SQL

Responsibilities:

• Involved in various design and decision making meetings with Global Process Owners, Financial System Optimization, Data Governance, Controllership and Transformation teams.
• Involved in business process study and creating business process maps using Visio for Oracle E-Business Suite GL, AP, PO and AR modules during implementation.
• Was part of team involved in the cut over planning and execution including finalizing the processes, scenarios and ways to handle exceptions while executing and monitoring of cut over activities.
• Reviewed Oracle General Ledger business requirements and mapped them to standard Oracle functionality. Identified Gaps, documented and provided workarounds by defining custom Business Processes.
• Configured various setups of General Ledger, including but not limited to Accounting Flex Field definition, Chart of Accounts, Calendars, primary and secondary ledgers, cross validation rules, security rules, consolidation, translation, revaluation, etc.
• Created intercompany Transaction, Consolidation, Elimination entries setups and configurations.
• Created Master/Detail Budgets, Mass Allocations and Summary Templates. Designed FSG Report for Budget Balance, Actual Balance and Funds Available.
• Worked on AR setups - defining the Auto Invoice options, accounting and invoicing rules, revenue recognition, auto lock box process, receipt classes, receipt sources, bank setups, transaction types, etc.
• Extensively worked on design and coordinating with technical team on developing the third party billing system to bring invoices into oracle receivables.
• Developed several BR100s on required reports to fulfill the business need.
• Defined the Accounting Rules and Invoicing Rules in oracle AR module to drive deferred revenue as well as upfront revenue.
• Customized the Invoice Aging and Customer Balance Report in AR
• Worked on the setups of e-Business Tax module - including the setups of Tax Rates, Tax Codes, Tax Regimes, Regime to Rate flow - for EMEA and US.
• Fixing small code changes as of when raised during UAT and during post production support.
• Performed effort estimation for design and development for data fixes, code fixes and change requests.
• Support Production issues on a day to day basis including month end closure priority issues.
• Performed both validation and technical IT General controls testing for SOX & GAP to make the test documentation meet Client’s compliance regulatory norms.
• Successfully provided Technical and Functional support to the users, testers and Business System Analysts.
• Provided with useful training to the users in AP, GL, PO, iExpense, SLA, e-BTAX, AR Modules.
• Actively worked in collaboration with oracle support team for resolving various bugs, opening Service Requests, working 24/7 on production critical issues, participating in OWC sessions and analyzing patches.

Environment: Oracle Applications R12.1.3 (AP, PO, AR, GL, iProcurement, iExpense, FAH, CE), IBM AIX, Start Team, AIM Documentation, Oracle Database 10g, OBIEE, SQL/PLSQL, Confidential Quality Center

Confidential, Denver, CO

Oracle Functional Analyst/ Coordinator

Environment: Oracle Applications 11i (GL, AP, AR, PO, FA, CM, iExpenses, iSupplier, SLA, EB-Tax), TOAD, SQL

Responsibilities:

• Interacting with Client IT and Functional teams to finalize schedules plans, solution and requirements.
• Involved in Requirements Gathering, Functional Design, Gap Analysis, Data Mapping, Design &Modeling, business process re-engineering using AIM methodology.
• Attended OA Framework (OAF) training for designing new pages and customizing existing pages.
• Involved in pre-implementation and support activities related to financial modules (AP, AR, i-supplier, GL, and CE).
• Mentoring the Onsite and offshore team for completing the tasks assigned to them.
• Providing solutions for the GAPS identified in the post Go live system.
• Worked on post implementation interfaces such as Scrambling (Banks, Customers, Suppliers).
• Supported VIGO AP, AR, GL and PO modules as part of take over integration with WU instances.
• Interacting with the On-Site coordinator for finalization the change requests, fixing bugs/issue resolutions.
• Working on support for Incident management using Digital Workflow/ Ticket Tracker.
• Worked extensively for the enhancements for new developments for inbound outbound and reports.
• Involved in release activities like collecting objects, code configuring, smoke testing and releasing to DBA’s.
• Coordinating with the DBA for migrating the fixes/ new objects.
• Supporting for defect/bug fixes in the current system.
• Giving Knowledge Transfer to Peers.

Confidential

Oracle Functional Consultant

Environment: Oracle Applications 11.5.9 (AP, PO, AR, GL, FA, FSG, CE), AIM Documentation, Oracle Database, 9i, SQL/PLSQL

Responsibilities:

• Extensively involved in all phases implementation of oracle applications 11i in SCM & P2P modules.
• Prepared requirement documents and assisted the build team in working with technical documents and build of conversions, Interfaces and Reports.
• Involved in Setups of multiple environments (DEV, PUAT, BUAT, PRE-PROD, PROD, MASTER )
• Supported Data migration team for completing the process tasks related to technical & functional areas.
• Provided solutions for the GAPS identified in the post Go Live system.
• Assist with design of solutions for change requests and the development there after.
• Provided functional support for O2 Testing Team & Users after Go Live.
• Analyzed scope and available features and Business requirements.
• Translated business user requirements into functional and technical design documents/specifications.
• Worked on the functional design for customizations, in Processes, Programs, and Reports.
• Worked on customizing as well as developing new Workflow processes.
• Designed and Developed customized solution for Oracle Fixed Assets to resolve depreciation issues
• Implemented iExpense in the client TEST environment for user training and testing purposes.
• Resolved issues after implementing iExpense by customizing the process flow of Expense report generation, and rule tracking.
• Integrated iExpense with AP for automatic invoice generation and processing.
• Performed all necessary setups for Corporate Credit Card transactions download and generating Expense reports on timely basis, for fully automating the employee expense through credit cards.
• Involved in the iExpense implementation, designing and performing a major modification to the AMEX daily inbound interface to handle multiple files on the same day.
• Designed and configured custom Daily Sales Application, interacting with other process team. The project involves creation of custom tables, developing custom forms to load data into the custom tables and creation of various custom reports to compare sales values against the data in oracle. The custom tables are populated from a third party data ware house on a regular basis.
• Provided functional & technical support to Ascension Supply chain (Oracle SCM) Solution O2 Users.