SUMMARY:

• 12 + years of strong IT experience (with multiple cloud projects) in the functional domain, analyzing, designing and developing solutions for clients as well as implementing and testing solutions and providing post - production support for various types of businesses.
• Extensive functional knowledge on Oracle Financials including Oracle Fusion, Oracle Cloud Financials and R12, General Ledger, Account Payables, Account Receivables, Advanced Collections, Fixed Assets, Cash Management, Fusion/E-Business Tax, Purchasing, Advanced Pricing, System Administration (Sys Admin) and i-Expenses.
• Experience with both on-premise and cloud financials and managing business process change requirements across both versions.
• Experience in execution of multiple project life cycles from Initiation through to Go-Live, including Business Analysis, Requirements Gathering, Implementation as well as Support and Monitoring including working on multiple projects in parallel in the cloud environment.
• Conducted multiple Workshops and performed Scope Verification & Validation, Alternatives Identification, Analysis, Functional Design Development, Integration & User Acceptance Testing, Training, Cut off, Go-live, and post-implementation support.
• Experience in working with global implementations and experience with AGIS (Advance Global Intercompany System), Involved in Multi-Org & Multi-Currency configuration, ledger setup and org design in a global operating environment
• Extensive knowledge in understanding multiple business process flows including Procure to Pay (P2P), Order to Cash (O2C), Acquired to Retire (A2R), Record to Report (R2R), and Detailed functional flow of Event models in Sub ledger Accountings (SLA).
• Designed base enterprise structure for multi-business unit implementations including consolidations and statutory reporting
• Involved in D Conversions and Data Migration, including data mapping for Customers, Assets, Suppliers, GL Balances, Open AP and AR with Revenue Recognition and unapplied receipts from Legacy System to Oracle.
• Experience in using and maintaining documentation of Application Implementations Methodology includes BR 100, BR 150, BP 80, RD20, BR30, MD 50, TE 40, CV 40 and Change Management Process documentation with in depth functional impact analysis.
• Conducted multiple CRP’s and provided wide range of functional training to multiple business user groups and Co-ordinated UAT sessions.
• Work with 3rd Party Vendors and assist with integrating 3rd Party systems like Kofax Markview and the Vertex Tax Solution
• Conduct multiple meetings with business; coordinate with offshore team for timely deliverables in order to meet the aggressive time lines.
• Conduct meetings with business to understand the functional change proposals and create documentation with detailed functional Impact Analysis with the change proposal as part of Change Management Process
• Excellent communication skills and leadership qualities with analytical problem solving abilities
• Work with SOX and Audit Groups to resolve SOD and User Access Monitoring issues.
• Coordinate and follow-up with offshore technical team to meet the aggressive timelines with respect of Development and conversion activities.

TECHNICAL SKILLS:

Oracle ERP: Oracle Fusion11g and Financials R12&11i - GL including AGIS, AP, AR, CE, FA, E-B.Tax, PO, OM, QP, iExpense, Sys Admin, SLA, cycles including P2P, O2C and A2R.

PROFESSIONAL EXPERIENCE:

Confidential

Finance Architect

Responsibilities:

• Worked as the Finance solution architect and lead which included interfacing with business users in the US, Latin America and Europe to standardize business processes and transition to Cloud Financials
• Led requirements gathering and business process mapping workshops with users to understand current process requirements and map it to standard Oracle functionality
• Conducted initial CRP reviews with users to demonstrate system functionality and collected feedback to assist with developing a solution
• Worked with key stakeholders at the controller and senior director level to transform their chart of accounts to make the best use of Oracle Cloud Financials functionality and recommended best practices to simplify and speed period close using a single global chart of accounts and calendar
• Developed a reporting consolidation solution and implemented reporting currencies and statutory reporting ledgers to provide a real-time US-GAAP view of global operations as well as simplify IFRS and local reporting.
• Implemented a tax solution for the US, EU (NL, FR, DE) and Central America (MX, CL)
• Developed reporting and workflow solutions to assist with tax reporting and automate the tax hold process to allow tax department input was incorporated during transaction entry instead of during month-end adjustments
• Implemented I-Expenses for global employee base including mobile integration to transition away from the current manual expense audit process. Implementing best practices in expense policy implementation and audit automation helped reduce the reimbursement time by 2 weeks, simplified the approval process and reduced the number of period end accruals needed
• Integrated all US banks and implemented the bank statement reconciliation process to allow the clients to reconcile their AP and AR on a near-daily basis instead of waiting until month-end. This helped speed up the close process and automated a lot of entries that were previously made manually
• Made recommendations to help the client implement a thin-ledger by developing SLA configurations and reporting solutions to ensure clear drill-down from GL to source sub-ledger transactions
• Configured the intercompany functionality to stream-line month-end settlements and cost-plus transactions and developed a custom solution to automate month-end intercompany billing using available web-services
• Used web-services to automate AP integration from legacy systems related to direct procurement functionality that was not migrated and developed a pre-processor to generate accounting in the AP interface before files were imported
• Automated the creation of elimination entries using the allocation manager and introduced the clients to the concept of elimination companies to help speed-up month-end processing. Improvements including journal entry automation and process streamlining helped reduce the close cycle from 3 weeks to 1 week.
• Developed conversion and cutover strategy including conversion templates to streamline the conversion and data-reconciliation process
• Designed OTBI, Smartview and BIP reporting solutions to match existing reporting requirements and helped identify legacy reporting requirements that were redundant due to process change improvements
• Worked with end users to support change management efforts and conduct user testing as well as train-the-trainer sessions and writing training guides to assist with the updating of update desk-documents

Confidential, Dallas, TX

Responsibilities:

• Ran the requirements gathering and initial CRP workshops to help the business understand the changes and different in functionality between the on-premise 11i solution and the public-cloud 11g Financials solution.
• Helped rationalize business processes that were reliant on heavy customization to support automation and developed new process flows to support similar processes in 11g
• Developed the Fusion Enterprise Structure and Security Structure to support their North American and Europeans business entities
• Setup and defined the Global Ledger, Legal Entity and Business Unit structure for multiple divisions to align business divisions with their functional currencies and allow for easy consolidation
• Defined secondary ledgers, reporting currencies and tax books to support statutory reporting requirements
• Defined ledger sets around primary USD and reporting currency USD ledgers to provide a global real-time view of subsidiary performance in the primary reporting currency
• Perform Rapid Implementation for Financials GL, FA, AR and configured the fusion tax engine for US and VAT requirements
• Configured allocation sets to streamline and simplify intercompany eliminations
• Configured Accounts Receivables and worked on design specifications for Invoice Templates
• Configured and developed design specifications for lockbox integration to automate receipt application
• Developed automated web-service feed using standard file templates to interface invoices created in the existing 1i environment
• Defined tax regime to rate flow for the United States and EU countries where the client was registered
• Developed master-data requirements to ensure tax outcomes would be driven consistently using centrally defined item category codes
• Defined and setup first and third party registrations and developed solutions to eliminate customizations in the existing 11i environment to distinguish between intra-community and domestic supplies and improve cash-flow through more accurate VAT treatment
• Setup and designed intrastat reporting as well as ESL reporting in addition to OTBI reporting requirements to support current reconciliation processes
• Led CRP sessions for product demos through end-user testing and training
• Analyzed and created requirements to develop reports in OTBI for day-to-day business reporting needs.
• Worked with the business to plan and run the UAT sessions
• Triaged and prioritized defects and worked with the implementation team to re-test issues to make the best use of business users time
• Created training material for the business based on their requirements and ran training sessions for end users
• Provided post go-live support for the business and worked with user groups to resolve issues and provide user workarounds for process issues that arose in production

Confidential, Baltimore, MD

Responsibilities:

• Developed a custom revenue recognition solution in 11i to allow the business to recognize revenue independent of invoicing to support diverse contractually driven contingencies. Solution included operationalizing contractual terms and designing a custom application to automate revenue recognition decisions that helped reduce the period close cycle by 3 days.
• Developed new business and technical processes to allow for operationalized contract terms that are crucial to determining revenue contingencies to be stored and used to drive automated revenue recognition decisions
• Developed solutions to allow for systematic revenue unbundling and re-classification based on contractual obligations and automated simple revenue decisions based on integrated carrier signals
• Developed OBIEE reporting specifications to support the custom revenue recognition solution developed.
• Performed requirements gathering and fit-gap analysis for upgrade to 11g and business process transformation of financial modules including GL, AR,AP, CE, Advanced Collections and Tax
• Conducted requirements gathering from local accounting providers in 24 countries to support a localization assessment and the roll-out of a statutory accounting solution within Oracle.
• Re-design of the OU and Ledger structure to be more aligned with changes in business requirements which involved the closing of certain operating units and the creation of corresponding new OUs in new ledgers.
• Designed and configured local chart-of-accounts for statutory books and secondary ledgers within GL to systematically provide statutory reporting in real-time instead of the current excel-based processes
• Record to Report (GL, IC, FA, TAX) team-lead to support the accounting and tax requirements for global supply-chain re-design that involved a drop-ship model being implemented to process intercompany sales.
• Setup and configured tax regime to rate setup for US, Canada and certain EU countries(France, Germany, UK) and Switzerland and configured intrastat reporting requirements
• Designed a solution for and implemented Advanced Collections and Credit Management - developed strategies to automate task creation and customer email communication
• Developed risk-based collections business processes and corresponding system design to transition the business away from the current excel based processing
• Identified areas of improvement within the current collections processes and developed a custom solution to automate the generation of customer statements for 1200 customers on a bi-weekly basis for activity that was previously done manually.
• Configured solutions using SLA to help reduce the number of re-class entries being performed in GL by setting up SLA rules in AP, AR and Cost Management
• Developed custom invoice formats to meet local requirements in Europe and support summary billing requirements.
• Conducted requirements gathering and impact analysis to determine the impact of process and system changes on BI reporting solution
• Worked with business users to streamline business process requirements to map them to Revenue and COGS process changes in Fusion
• Prepared data transition strategy to support data requirements related to new process changes and changes in the Oracle Org-Structure post-upgrade.
• Co-ordinated between the off-shore teams, multiple vendors and key-stakeholders involved to solution, configure and test business processes which had cross-functional impact

Confidential, Houston,TX /Tulsa, OK

Responsibilities:

• Presented an overview of R12 to the business users during kick-off meetings and gathered business requirements and an overview of system functionality from end-users during the kick-off phase
• Analyzed business processes and identified gaps, custom changes and areas where there was scope for business process improvement
• Developed business process improvement solutions and system changes to
• Performed gap-analysis, and developed documentation for the proposed changes including BR100 configuration, CV40 conversion, MD50 Custom Development Specification and BR110 responsibility configuration documentation.
• Developed CRP plan and test scripts during testing sessions along with a defect monitoring process and defect taxonomy that was relevant to the project in order to enable quick prioritization of defects.
• Worked with cross-functional and project management teams to communicate progress and clarify issues related to the project.
• Developed a solution for a Regulated Operating Unit company that included the development of a Reporting Ledger that allowed users to make adjustments and run reports using a modified Chart of Accounts Structure.
• Developed solutions to reduce the number of Operating Units for the companies’ US Operations from 3 to 1 which resulted in a significant process improvement for the users, the vast majority of who provided shared services across the organization and over 7000 IExpenses Users
• Analyzed and developed solutions for the business to replace customizations in the IExpenses module with standard functionality that simplified the expense entry process for employees, reduced the time taken to enter expense reports and replaced an external receipt management solution with seeded receipt management.
• Changes in IExpenses workflow and configuration resulted in a simpler expense entry process that improved the expense accounting, a simplified workflow that included automation of issue resolution for frequent help-desk issues and greater use of standard functionality that resulted in a large reduction of support effort and support tickets along with greater employee satisfaction.
• Developed changes to the Payments module in AP to modify the current payment process given the organizational changes taking place along with a new custom solution to reduce the number of check templates used and required in the future.
• Worked on master data conversions to support the organization changes taking place as well as to move vendor and customer data from a hub-system that supported 10 different interfacing applications into the Oracle TCA structure and assist the technical team with making related changes to the affected interfaces.
• Served as the functional point of contact for issues related to the integration and upgrade of integrated Tax (Vertex) and Invoice Imaging (Markview) solutions. This involved extensive testing within Oracle, configuring EBTax and Vertex as well as developing custom solutions to overcome gaps in functionality between the 3 products resulting from changes in R12 that their design hadn’t fully taken into account.
• Held regular meetings with vendors to streamline development and provided dashboards on the progress of the entire Finance Project Track to Project Management and Steering Committees.
• Assisted with preparing an initial cutover plan for the final upgrade to take into account all the functional and technical activities and worked with individuals to streamline tasks and reduce the critical path of the upgrade
• Worked with the technical, cross-functional, change management and system audit teams to develop a new set of access guidelines while consolidating and reducing the number of user responsibilities to meet the organizations new requirements

Confidential, Moberly, MO

Responsibilities:

• Reviewed Business Requirement Documents and developed the implementation strategy.
• Identified standard & required functionality, developed gaps document and design solution for GL, CE, AP(with PO)
• Prepared the CRP plan, conducted kick off meetings, created testing trackers and metadata for reference
• Coordinated with Project Manager, Steering Committee and Business teams for system updates and implementation deadlines.
• Worked as the primary interface with the team in India to implement the GL, CE & AP modules.
• Created a base template to gather country specific localization requirements.
• Responsible for gathering and implementing EU localization requirements
• Designed custom reports to support local reporting requirements
• Designed COA Structure for Ledgers with Multi Org and Multi Reporting Currency setup.
• Defined system controls, intercompany accounts, summary accounts, journal sources and categories.
• Defined currencies for multi currency operations and currency translation and conversion.
• Set up cross validation rules and configured Sub-ledger accounting process to GL.
• Defined Security rules at segment level.
• Reviewed current business processes and documented them for Procure to Pay (P2P) and Project Invoicing to Cash Receipts (P2C).
• Designed Payables process and configured and setup system financial options, Payable system options & Payables options for P2P.
• Configured and setup Ledger, Legal Entity, Operating Unit and Locations for new countries
• Developed batch invoices, batch payments, employee expense report process, withholding tax, 1099 reporting, cross currency invoices and payments.
• Configure approval hierarchy, approval groups and approver assignment.
• Prepared the custom PO Print Program MD050 and worked on custom PO Detail Report.
• Reviewed the current reconciliation process in Cash Management and designed business process and system has been configured and tested to meet the Business requirements.
• Integrated Cash Management with Payables, Receivable modules for reconciliation. Auto import and reconciliation of bank statement Bank file integration/mapping.
• Worked to integrate International Bank accounts and enable payments from OFA to Deutsche Bank (DBI) Online system.
• Conducted meetings with AP and Treasury to decide the payment methods and further, prepared MD050 and payment generation files for Domestic and International Wire payment methods.
• Completed Mexico bank integration with HSBC for ACH and WIRE payment methods.
• Prepared BR100, MD050, TE40, TE050 and conducted regression testing and OATS testing
• Conducted CRP's and Business Super User Training using Oracle tutor and WebEx virtual training

Confidential, Atlanta, GA

Responsibilities:

• Responsibilities included requirement gathering, analyzing current business processes, re-engineering and re-designing business processes, system configuration and system testing
• Reviewed the current reconciliation process in Cash Management and re- designed business process
• Integrated Cash Management with Payables, Receivable modules for reconciliation.
• Designed Auto import and reconciliation of bank statement Bank file integration/mapping.
• Prepare custom financial reports for month end MU process using FSG
• Create custom report and separate view reports from the back-end with assistance from technical team
• Responsible for the implementation and conversion of the Oracle Consolidation Process
• Configured (AGIS) System Options, Security and Transaction Setups
• Setup Intercompany Accounting, Period, Organizations and Invoice Options (AGIS)
• Setup Default Account Rules in Sub-Ledger Accounting for Intercompany (AGIS)
• Configured Account Derivation Rules, Journal Line definitions and Application Accounting Definitions under SLA to implement client requirements
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Actively Participated in collecting current business process E-B.Tax (12.1.2) and collected the E-B.Tax Business Requirements for 10 States in US
• Worked on configuring TCA Geography Hierarchy and prepared E-B.Tax (BR 100) configuration
• Setting Party Tax profile options and defining Inventory category sets and categories
• Setting up Tax Jurisdictions and Tax Rates integrated with third part tax engine.
• Rates Integrated with Vertex and defined Determine Factor Sets and Condition Sets to work specific tax calculations
• Created Expert rule entity and Guided Rule entity for specific tax calculations and configured Regime to Rate flow for Sales Tax UAT instance
• Worked on setting up the new tax rates including withholding taxes as localization requirements
• Prepared Cut- over Plan, Listing all Pre & Post Go- live tasks. Involved in Post-Production support.
• Created/Maintained Business process Documents BP80,RD-20,BR-30,BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.

Confidential, Palo Alto, CA

Responsibilities:

• 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 EB-Tax, AR, and FA depending on Business requirement
• Provided support and oversaw trouble-shooting for all O2C and R2R modules
• Coordinated with project Manager, Business team for system updates and deadlines for the implementation.
• Developed the conversion strategy to move asset data from legacy system (Access Database) in to Oracle Fixed Assets by using Web ADI.
• Setup AR System option, payment term and Auto accounting.
• Create and setup customers and its profile class.
• Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting
• Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
• Setup Sub ledger Accounting for Receivables third party merge activity
• Retire an Asset, Run mass Changes, Run mass Reclassification Mass Transfer, Asset Insurance Policy details.
• Enter an Expense Requisition, Asset Requisition, and Enter Blanket PO, Enter Releases for blanket PO, Review Buyer Workload, Create Approved Supplier List, Define Sourcing Rules, Assign Sourcing Rules, Enter RFQ s, Enter a Quotation. Purchasing Reports
• Configured Regime to Rate flow for UK Tax for AR
• Collected the E-B.Tax Business Requirements for US Sales Tax and Use Tax
• Understanding Business requirements and preparing BR 030 document
• Understanding the nexus in the state and locality and identified gap
• Defined Determine Factor Sets and Condition Sets to work specific tax calculations
• Created Expert rule entity and Guided Rule entity for specific tax calculations
• Configured Regime to Rate flow for Sales Tax UAT instance
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration.
• Prepared Cut- over Plan, Listing down all Pre & Post Go- live tasks.
• Created/Maintained Business process documents BR-100,MD-50,TE-40,CV-40 for requirement gathering, process design, system configurations, custom reports, discoverer reports and conversions (RICE) and test scripts in AIM methodology as part of project implementation task.

Confidential, Burlington, NJ

Responsibilities:

• Captured new requirements from the business team in GL and AR modules
• Preparing meeting minutes and documentation for Business requirements
• Conducted mapping of business process flows and produced -up as-is and to-be documentation
• Set-up of system setup options in AR
• Configured the Sub ledger Accounting(SLA) setups
• Developed Workflows to customize the approval Process for Journals
• Preparing Visio Process diagrams for AS IS/ To Be Scenarios
• Capture and upgrade all the Custom Processes and Reports
• Created customer profile classes, attached payment terms, collectors, matching receipts, statement cycle to profile classes
• Setting up Consolidation Ledgers, AGIS for intercompany Transactions
• Interface PeopleSoft student Financials to Oracle GL/AR for creating transactions
• Import data to GL using Open interfaces table
• Upgrade and modify the current Revenue Recognition schedule in AR to reflect R12 changes and Future Business needs
• Setup AR System option, payment term and Auto accounting.
• Create and setup customers and its profile class.
• Setting-up of AR for invoice transactions including auto invoicing from OM and Service Contracts, auto application of receipt application to invoices using auto lockbox functionality, sub ledger accounting
• Set-up receipt class, receipt methods, receivable activities and setting up accounting information for revenue recognition
• Worked with technical team for clarifying and coordinate the data conversion and validate converted data
• Prepared and executed test scripts (TE 40)
• Involved with migration of historical data for Accounts Payables and Accounts Receivables
• Set-up of invoices, debit and credit memos, guarantees, transaction types
• Eliminated duplicate customer problem using merging functionality
• Providing solution for Revenue Recognition for different types of Blue coat orders in AR
• Helping technical team develop a customized Revenue Recognition program in AR
• Participated in CRP and UAT
• Created user-manuals and trained the end users
• Extensive unit and integrated testing done before CRP & UAT
• Set-up receipt class, receipt methods, receivable activities
• Created the supplier, supplier sites, banks and bank account
• Prepared the MD 50 and worked with technical team regarding RICE components

Confidential, North Brook, IL

Responsibilities:

• Review the R12.0.3 setups with the CFO, Manager and users of respective modules/systems and updated the setup as per Business requirements.
• New functionalities like Sub Ledger Accounting (SLA) and functionality changes in various modules as gathered from the CFO, Super users and Users of various Business areas.
• Responsible for preparing upgrade and re-implementation plan for GL, AP & FA
• Prepared impact analysis document for the upgrade of financials module
• Responsible for setting up Data Access sets, Report Manager, Payment Process
• Responsible for complete functional testing and resolving issues
• Configured CRP’s, Prepared Test Scripts, Test plan, Test Scenarios, User Manuals, plan for UAT, user feedback integration. Coordinated with Oracle support and raised SR for critical issues
• Resolved process issues, period end closing and interface issues in GL, AP, AR, FA, iExpenses and E-Business Tax modules.
• Issue resolution, update functional impact analysis with proposed changes, if any in to Bugzilla issue tracker
• Create and followed up SR’s with Oracle Technical Support, coordinate and follow on multiple issues based on priority including indentifying bugs and follow-up with Oracle Development
• Periodical status updates to PMO and follow up with pending business input or issue resolutions as part of status meeting.