SUMMARY

• Over 14 years of experience wif 11 years of extensive experience in Oracle Applications implemented, upgraded, supported, integrated and involved in full end - to end cycles including planning and analysis, configuration, design, build, conversions, integrations, testing, training, go-live and post production support of several releases 11i/R12.
• Modules implemented - General Ledger (GL), Account Payables (AP), Account Receivables (AR), Purchasing (PO), Order Management (OM), Inventory, Grants, Advanced Product Catalog (APC/PIM), Cash Management (CE), Fixed Assets (FA) and gained hands-on expertise in teh above modules.
• Gained hands-on experience in Procure to Pay and Order to Cash cycles through teh entire life cycle from strategic scope definition to requirements gathering, design and analysis, testing phase to user training and status reporting.
• Implement Oracle Procurement Command Center (PCC)
• Subject Matter Expert in financials and procurement modules in 11i, R12.1.3, R12.2.4 and R12.2.5
• Gained comprehensive knowledge of business processes and customizations of Healthcare Integrated General Ledger Accounting System (HIGLAS), Federal Financials.
• Oracle EBS integration wif Oracle Cloud Configure Procure Quote (CPQ) and Sales Force (SFDC).
• Gained hands-on experience on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting treatments for a business transaction.
• Illustrated experience in Trading Community Architecture (TCA) and setups.
• Deep understanding of Oracle AIM methodology and documentation.
• Configured Approvals Management Engine (AME) for multiple Oracle integrating applications.
• Garnered extensive experience working wif OBIEE teams handling report requirement gathering, analysis, development of mapping and functional specification documents covering both custom and standard tables spanning various functional areas like Receivables, Payables, Purchasing, General Ledger and trained diverse business groups in OBIEE reports.
• Participated in Federal year-end closing process including pre year-end activities like CAN Roll Forward process, Year-end closing account setups, and Final closing process including final closing entries, proprietary account closing.
• Financial Reconciliation: Aided in redesigning complex federal reconciliation process by harnessing new R12 functionality and remediating existing custom 11i functionality to meet teh business process requirements.
• Created test scripts, business process flows, and involved in multiple Alpha, Beta and User Acceptance testing cycles.
• Functional Testing: Involved in QA Testing process; functional, System Integration, Regression, smoke testing and coordinated wif end users for Acceptance Testing.
• Functional responsibilities: Interfaced wif users, gatheird requirements, performed functional gap analysis, application design, configuration, module setup, test script generation, wrote training guides, training end users, and production support.
• Technical activities: Identified functional and technical gaps, estimated work, architected system interactions, designed custom solutions, performed scheduling, produced documentation, user manual to users and providing production support.
• Experienced working wif OBIEE teams in configuring OBIEE Reports & Dashboards, OBIEE Delivers, Narrativeviews and Advance Reports.
• Business analysis responsibilities: Coordinated business, functional and technical teams in business requirement gathering efforts (BRD) from writing use cases to test cases to UAT testing and training super users along wif development of training manuals.
• Worked on Documentation, BRD, as-is BP-040, To-Be BP080, Setups BR-100, Functional Specification MD050, TE020, TE 030 and TE 040.
• Illustrated development of MD050s for critical components in both P2P and O2C cycles.
• Gained meticulous documentation skills, strong analysis, requirement skills and good interpersonal and communication skills to work wif clients and team members.
• Involved in customization of Aging 7-Buckets by Account (MFAR) Report mapping for client requirements.
• Possessed implementation knowledge of iExpense and iProcurement.
• Gained knowledge in Oracle tax engine eBTax setups and global eBTax integration wif Vertex and Sabrix.

PROFESSIONAL EXPERIENCE

Senior Oracle EBS Functional SME

Confidential, Waukegan, IL

Responsibilities:

• Streamline county-wide procurement business processes.
• Implement Oracle Procurement Command Center (PCC) providing dashboards, application pages dat enable procurement managers and buyers to plan, coordinate execution of procurement processes using relevant charts, graphs, and metrics.
• Document and user training in period end closing procedures of Receivables, Payables, Purchasing, Inventory, Fixed Assets and General Ledger applications.
• Production support of P2P cycle.
• Performed customizations in iProcurement.
• Worked on critical Encumbrance Accounting related issues.

Environment: Oracle E-Business Suite R12.2.5, Toad, OBIEE, DataLoad, Jira, MS Visio

Senior Oracle Business Systems Analyst

Confidential, Hoffman Estates, IL

Responsibilities:

• Acted as Senior Business Systems Analyst in Oracle EBS integration wif Oracle Cloud Configure Procure Quote (CPQ) officially called Smart Quote.
• Simplification of Quote-to-Cash cycle: Oracle Cloud Configure-Price-Quote system implemented replacing various legacy systems - SQT, DocuSign, Flash ACU etc.
• Responsible for MD050 document including data table needs and mapping details for default bill-to deriving capabilities on a CPQ quote.
• Led product catalog conversion and integration wif Sales Force for CPQ data needs.
• Involved in development of conversion from catalogs rules, data table needs and conversion of item attributes to CPQ environment.
• Advanced Product Catalog (APC): Configurations to house numerous item attributes dat are converted from legacy systems.
• Price Lists conversion - Responsible for price list conversion to CPQ, documenting and testing.
• Customer data conversion - Responsible for CMF data conversion to CPQ, documenting and testing.
• Involved in functional testing of integration between Sales Force and CPQ, system integration testing between Oracle EBS and CPQ via Sales Force.
• Worked on critical TFS bugs covering various modules in Oracle EBS.
• Led Item master cleanup effort involving various legacy item attributes for seamless functioning of CPQ.
• Involved in highly visible SKU Rationalization project, deactivated over 120K items from teh catalog.
• Service Contracts integration wif Sales Force (SFDC) and CPQ
• Installed Base integration wif Sales Force (SFDC) and CPQ
• Bill to Override designations are applied per client’s billing needs. Configurations for application of bill to overrides at customer site level and item level in Oracle EBS.
• Worked on linking Order Release package wif Purchasing package in Cognos.
• Led teh enhancement project to cater to teh requirement of rollup of annual allotment of free toners for teh customers classified under Purchase2 program.
• Participated in OneSCM project dat provide end-to-end supply chain visibility for order fulfillment and procurement processes. Involved in task to strip off leading ‘S’ in teh serial numbers of certain vendors dat mismatches teh serial number of teh actual item.

Environment: Oracle E-Business Suite 11i, Toad, DataLoad, MS Visio, Oracle CPQ Cloud, Sales Force, IBM Cognos

Senior Oracle Financials Functional SME

Confidential, Waukegan, IL

Responsibilities:

• Acted as functional subject market expert for financials and procurement modules for R12 upgrade from R12.1.3 to R12.2.5.
• Elicited functional and operational enhancements in R12.2.5.
• Demonstrated enhanced modern user experience and mobility functionality. Icon-based page navigation, tablet optimized HTML user interfaces.
• Configured journal approval process integration wif Approvals Management Engine (AME).
• Enterprise Asset Management (EAM). Configure mapping display.
• Configured Procurement Command Center (PCC) dat allows improved visibility and access purchase activities for more value creation.
• Implemented Procurement Operations Dashboard dat pulls in data from across teh Procure-to-Pay cycle to enable teh buyer to make timely decisions on requisitions, negotiations, contracts, purchase orders, change requests, deliverables, invoices, catalogs, suppliers etc.
• Demonstrated teh Item Analysis and Supplier Analysis portals to bring together traditionally segregated data from both structured and unstructured sources dat empower buyers wif teh insight to ensure dat teh items and suppliers selected are teh best choices to meet teh procurement needs of teh business

Environment: Oracle E-Business Suite R12.1.3, R12.2.5, Toad, OBIEE, DataLoad, Jira, MS Visio

Senior Oracle Financials Functional Consultant

Confidential, Keene, NH

Responsibilities:

• Involved in integration of financial systems of subsidiaries acquired into client’s current R12 EBS environment.
• Performed Fit and gap analysis.
• Led Customer and bank conversions efforts for seamless integration into client R12 EBS environment.
• Developed MD050s for critical components in both P2P and O2C cycles.
• Hands-on experience in P2P business processes covering requisitions, purchase orders, receipts, payables invoices, payments and accounting for goods and services. Well-versed in primary modules -PurchasingandPayableswif an integration of other modules likeiProcurement, iSupplier,iExpenses, Services Procurement, Sourcing, Procurement Contracts, Approval Management, EBTax, and Payments.
• Led development of LIFO and FIFO Inventory valuation reports critical to unique wholesale grocery business model.
• Gained working knowledge of unique wholesale business processes.
• Worked in Production support team of AR, AP, Projects and Fixed Asset modules.
• Acted as in-charge of ticket management system by monitoring teh assignment of tickets, RQM’s and coordination of different teams; functional, technical, OBIEE and DBA teams involved in teh developmental efforts of critical components, reports, interfaces, customizations and extensions for smooth running of business.
• Assigned and monitored of daily EOD (End of teh Day) jobs critical for development of highly customized as well as COTS reports daily dat continuously aide upper management in critical decision-making dat impacts teh bottom line of teh business.
• Involved in automation efforts to streamline teh EOD jobs schedule to cut down daily man hours for teh routine tasks.
• Created Value Sets aiding Value maps dat are critical in mapping teh GL Accounts of teh new companies acquired and sync them wif client books.
• Created Value Maps crucial for highly customized interfaces and reporting solutions.
• Possessed expertise in mapping requirements aiding development and OBIEE teams in development of critical reports and interfaces.
• Developed snapshot logic dat helps provide precise cut off of transactions used in multiple customized reporting solutions.
• Worked in Vertex integration wif R12.2 EBS environment to meet Confidential &S’ complex tax requirement.
• Worked on OAF Form Personalization to meet client requirements.
• Gained extensive testing of customized Deals Account Analysis reports dat provide business wif regular status of various deals accounting requirements.

Environment: Oracle E-Business Suite R12.1.3, Sql Developer, Oracle Business Intelligence, DataLoad, AutoTask, Jazz Team Server, CA Service Management, MS Visio

Senior Oracle Fed Financials Functional Consultant

Confidential, Baltimore, MD

Responsibilities:

• Worked on upgrade efforts of Confidential ’ Healthcare Integrated General Ledger Accounting System (HIGLAS) from Oracle EBS 11. .2.2
• Participated in full upgrade life cycle from work group sessions to develop white papers for AR, AP, GL, SLA modules to remediate/redesign development phase to Alpha, Beta and User Acceptance testing.
• Led working group sessions for presenting and recommending redesign and remediation processes dat help streamline agency’s systems for accounting, financial management, and internal controls
• Supported design, development and Alpha, Beta test phases of various critical RICEL (Reports, Interfaces, Conversions, Extensions and Letters) components of three different LOBs, Benefits, APA and CCIIO spanning AR, AP, PO, GL and Grants modules.
• Developed R12 BR100’s, master BR100 for various modules, and lines of businesses.
• Participated in extensive functional testing of critical business processes involving highly visible interfaces, reports and extensions for APA and Benefits LOB’s in both Alpha and Beta testing cycles.
• Played crucial role in teh task of updating Functional Specification Documents (FSD) and Combined Design Documents (CSD) reflecting R12 changes.
• Developed functional specifications document (FSD) related to teh design of teh Sub Ledger Accounting (SLA) introduced in Oracle EBS R12 dat defines teh business rules, assumptions, and key scenarios dat outline teh accounting capability provided by teh Sub Ledger Accounting.
• Aided in designing teh replacement system after phasing out 11i Public Sector Accounting (PSA) system leveraging Subledger Accounting (SLA) features
• Participated development of white paper on R12 reconciliation features useful for reconciliations processes of different lines of businesses
• Financial Reconciliation: Aided in redesign efforts of complex federal reconciliation process by harnessing new R12 functionality, remediating existing custom 11i functionality to meet teh business process requirements.
• Leveraged R12 Journal Line Reconciliation feature to reconcile certain control, same GL account as well as across multiple accounts
• Updated R12 Financial Reconciliation business process documents dat provide guidance on reconciliation workflows, balance comparisons and checklist verifications for Accounts Payable (AP), Accounts Receivable (AR) General Ledger (GL) and teh Treasury Report on Receivables (TROR).
• Revised Period Close processes incorporating R12 changes facilitating HIGLAS business operations during Month End, Quarter End and Year End
• Participated in Federal year-end closing process including pre year-end activities like CAN Roll Forward process, Year-end closing account setups, and Final closing process including final closing entries, proprietary account closing.
• Participated in redesign financial reconciliation processes for Confidential ’ Benefits, Administrative Program Accounting (APA) and Center for Consumer Information and Insurance Oversight (CCIIO) lines of businesses
• Involved in extensive testing of Financial Reconciliation processes of core modules from executing critical request sets, reports to generation of automated spreadsheets (macros) to aide in streamlined financial reconciliation
• Participated in configuration of R12 reconciliation features - enabling reconciliation flag for natural account segment values or for complete accounting code combinations, reconciliation references assisting in manual and automatic reconciliation processes
• Produced Process flow document assisting in redesigning subledgers to General Ledger reconciliations for various lines of businesses (LOBs)
• Accounts Payable - Redesigned AP-SLA-GL reconciliation process by simplifying teh customization and harnessing COTS functionality and R12 reports
• Accounts Receivable - Remediated teh AR-SLA-GL reconciliation process by streamlining teh business process wif minimal customization of COTS functionality and R12 reports
• Redesigned highly customized daily, weekly and monthly reconciliation processes for Administrative Program Accounting (APA) or headquarters accounting system and various activities performed as a part of period closing procedures by APA users on daily, at month end, at quarter, and at year end closing of sub ledgers (PO, AP, AR, FV) and general ledgers (GL).
• Developed test cases and executing test scripts of various COTS as well as custom functionality, extensions and interfaces. Coordinating wif DBA team, technical and functional SME’s in providing comprehensive solutions.
• Customized GL Trial Balance report, GL Period to Date Balances reports in General Ledger using FSG's and OBIEE reporting tools.
• Remediated existing APA Custom.PLL dat allows extension of Oracle Applications forms wifout modification to teh Oracle Applications code. This Custom.PLL is used to enforce business rules for specific requirements which cannot be met by teh standard Oracle Applications.
• Developed Business Scenarios, Rules and Requirements and Assumptions required for teh Reporting SOB to Standard SOB Reconciliation procedures.

Environment: Oracle E-Business Suite R12.2.2, 11. me), Rational ClearCase, ClearQuest MS Visio, SharePoint, TOAD, VMWare, WebCenter, Remedy

Senior Functional Analyst - Oracle EBS

Confidential, Santa Monica, CA

Responsibilities:

• Oracle EBS R12.2.3 Upgrade: Completed Full upgrade cycle. From requirements gathering to testing teh core finance modules GL, AP, AR, FA and CE both standard and customized functionality. Demo in CRP1 and CRP2
• Acted as Subject Matter Expert (SME) in teh upgrade project from Oracle 11i to R12.
• Credit Card Tokenization: Integrated Princeton Payment Services (PPS), credit card tokenization service provider software wif Oracle EBS R 12.2
• Canada Intercompany: Performed setups of GL, AP, AR, Purchasing, Order Entry, Inventory and Pricing for Canada Intercompany procedures.
• Sabrix Tax integration wif Oracle EBS R12.2 modules. Documented teh setup procedures.
• Configured Tax Regimes to Tax Rules in EBS Tax.
• Implementation of iSupplier, iExpense and iProcurement.
• Configured Approvals Management Engine (AME) for multiple Oracle integrating applications; PO, AP iExpenses and Transaction types. Customized and tested AME workflows for PO Requisition, Purchase Orders, Invoices and various expense reports.
• Provided functional inputs and involved in upgrading effort of OBIEE from 10g to 11g.
• Developed test scenarios and test scripts of GL, AP, AR, FA and iExpenses for CRP1 and CRP2
• Developed R12 BR100’s for AR, AP and GL modules.
• Demonstrated extensive experience in understanding and providing Gap and Fit analysis for smooth upgrade project.
• Developed test cases and executing test scripts of various extensions and interfaces.
• Coordinated wif DBA team, off-shore and on-shore technical and functional SME’s in providing comprehensive solutions.
• Designed & developed training material and undertook training for all levels of users on new functionalities configured.

Environment: Oracle E-Business Suite 11.5.10.2 (11i), R12.2.3, Rational Clear Case, Oracle BI Discoverer MS Visio, Jira, SQL, PL/SQL.,Sabrix, TOAD

Oracle Financials Functional Business Analyst

Confidential, Englewood, CO

Responsibilities:

• Coordinated development of highly customized solution in teh form of Ship & Claim Workbench dat interfaces wif AP module critical for drop ship model business.
• Led mission critical quarter-end sales revenue cutoff automation process dat helped properly state financial statements.
• Handled OBIEE report requirements gathering, analysis and developing functional requirements documents; managed overall application data mapping. Provided teh mapping documents covering teh custom and standard tables and teh columns to display on teh OBIEE reports.
• Assisted in development of comprehensive solution harnessing teh WebADI capabilities for automation of AP invoice and AR invoice imports.
• Developed Project Charters, IT Project Requests and coordinated wif SPMO at various stages of teh SDLC
• Automated month-end SNI (Shipped Not Invoiced) analysis dat aides in accurate revenue recognition to properly state teh financial statements.
• Customized supporting reports for AP in Oracle BI Discoverer for month-end and quarter-end analyses.
• Managed automation of monthly allocation of Purchase Discounts in US and Canadian SOB which not only facilitated quicker visibility of purchase discounts and be complaint wif SOX but also eliminated substantial non-value added effort.
• Implemented changes to EDI invoicing system to take advantage of teh periodical promotions offered by teh Flooring companies providing lucrative financing of certain products.
• Configured changes to order booking system Renew IQ and EDI orders from certain customers to avail teh capability of booking orders of certain products covered under Factoring agreement to certain account numbers to meet teh treasury’s requirement.
• Involved in automation of cash application process after calculating teh Flooring fee charged by teh Flooring companies which significantly reduced revenue loss and increased teh percentage of auto applied floored invoices.
• Assisted in creating functionality to be able to scan exemption certificates to determine sales tax chargeability of customers and install teh Vertex ECM application to be used across divisions.
• Led teh automation of allocation of sales discounts to appropriate accounts and selling company locations. This resulted in significant reductions in resources used at critical times and properly stated profit margins at selling company or Value Added Resources (VARS) level.
• Engaged in development of solution to prevent Oracle EBS from purging purchase orders (PO) in teh Open Packing Slip (OPS) dat has aged 365+ days as a part of purge program ran periodically as some of teh PO’s are not to be purged coz teh business receives invoices in teh future. This effort not only avoided tedious procedures but also helped better representation of teh financials.
• Supported integration of Excel4 App’s GL Wand Tool into Oracle EBS. This tool TEMPhas superior drill down capabilities critical from GL perspective.
• Led automation of freight revenue reclassification preventing freight following teh selling company dat is tied to teh representative dat entered teh sales order. Teh automation corrected it by making teh freight follow teh supplier listed on teh sales order.
• Involved in automation of month-end close process in Oracle EBS. Teh sub ledgers automated include Payables, Receivables, Inventory and Purchasing. Some of teh critical concurrent programs developed during teh course are Payables Invoice Validation, Payables Accounting Process, Payables Transfer to General Ledger Program, Unaccounted Transactions Report, Payables Accounting Process, Unaccounted Transactions Sweep Program etc.

Environment: Oracle E-Business Suite 11.5.10.2 (11i), Rational Clear Case, Oracle BI Discoverer, Requisite Pro MS Visio, Clarity, SQL, PL/SQL., GL Wand, Vertex

Senior Oracle Applications Functional Analyst

Confidential, Van Buren Township, MI

Responsibilities:

• Coordinated and documented detailed gap analysis between client requirements and Oracle R12 functionality.
• Performed End-to-end upgrade of R12.1.3 GL, AP, CM, FA and payments from Blue Print to production as a Financial Functional Lead/Subject Matter Expert
• Developed training material explaining teh changes in teh functionality from older version of Oracle Applications to teh latest version.
• Performed Impact analysis in current business process due to upgrade changes/enhancements.
• Performed Approvals Management Engine (AME) configurations - attributes, conditions, actions, approver groups and rules. Responsible for design, workflow configurations/ setups and testing Approvals management in Payables and Purchasing.
• Analyzed various exiting approvals management workflows and customized approvals management workflows harnessing R12 features in Purchasing, Payables and iExpenses.
• Incorporated all teh business scenarios in CRP demonstration documents for R12. Demonstrated teh CRP to teh client for R12 Upgrade project.
• Created Business Process Test Scripts from end to end event of Business Operations for all possible Business Scenarios for teh Conference Room Pilot (CRP).
• Worked as a functional team member for Oracle Receivables, Payables, & General Ledger module. Developed implementation plan, testing scenarios and contributed to production cutover plan.
• Involved in Post Production Support for Oracle Financials Modules

Environment: Oracle E-Business Suite R12.1.3, 11.5.10.2 (11i), Rational Clear Case, Rational Clear Quest TOAD 9.0, SQL, PL/SQL, Windows NT, Oracle Forms, Oracle Reports, AIX UNIX.