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 Data 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

Cloud System Integrator

Confidential

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 forFinancials 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

Cloud System Integrator

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