Home

Bipul Kumar Shrivastava - Oracle Fusion Cloud Financials Solution Architect

[email protected]

Location: Plano, Texas, USA

Relocation: REMOTE

Visa: H1B

Bipul Shrivastava Summary: Over 22+ years of experience in Oracle Fusion Cloud Functional/Solution Architect and Oracle EBS Implementation. Having vast ERP Financial end-to-end implementation, upgrade and support experience in GL, AP, AR, FA, CM, EXP, FAH (Fusion Accounting Hub), SLA (Subledger Accounting) and Cloud Tax. Specialized in Record to Report (R2R), Procure to Pay (P2P), Order to Cash (O2C) and Integrated Invoice Imaging and have extensive experience in ERP reporting tools like, OTBI, FRS (Financial Reporting Studio), BI Publisher, SmartView etc. Position as Solution Architect for medium to large size engagements delivering solutions. Strong Oracle Fusion Cloud Financials Functional with about 7 years of extensive experience in Oracle Fusion Cloud Financials Application Implementations & Support. Functional expertise in Traditional Oracle ERP Implementation (11i/ 11.5.9/11.5.10.2/R12) and Oracle Fusion Cloud. Lead various Discovery sessions/Requirements gathering discussions. Performed key business analysis, gap analysis, solution design, configuration, testing & implementation of Oracle Fusion cloud and Oracle EPR Applications. Extensively used True cloud Methodology (TCM) Application Implementation Methodology (AIM) & Oracle Unified Method (OUM) for Fusion cloud and eBusiness Suite (eBs) implementations and Support. Extensively involved in defining requirements for integrations with third party applications, like FIS Get Paid, Ariba & Coupa- PO and Concur-Travel & Expense etc. Implemented Advanced Global Intercompany Solutions along with traditional Intercompany Solutions. Setup of Subledger Accounting Rules (SLA) and Cloud TAX as per various business requirements like configurations of Tax rules. Worked on proof of concept to showcase cloud capabilities of Oracle fusion cloud financial for critical business processes (Record to Report, Procure to Pay). Implemented Fusion Cloud ERP for Equinix Inc, IQVIA, Metro Pacific Tollways Corporation, KPMG Lower Gulf, Deyaar Property, Amway, and R12 Oracle EBS financial system globally for MCKINSEY & COMPANY, GE Lighting & Appliances business, DELL Technology (for USA, EMEA & APJ), ITV- UK, Airtel telecommunication and INDU Construction. Worked with many esteem companies such as KPMG, DELL TECHNOLOGY, IBM, GENERAL ELECTRICAL(GE), PRICEWATERHOUSE COOPERS(PWC), CAPGEMINI CONSULTING. Experienced in Waterfall and Agile Methodology. Experienced in project management activities (Resource planning and Staffing, Project estimation, Schedule tracking, Risk Assessment) Experienced in all phases of software development life cycle (SDLC) Requirement Analysis, GAP Analysis, Solution design, Configuration, Functional & Integration Testing; Go live, Post-Implementation Support, End-User Training and Business Process Re-engineering. Technical Skills: Oracle ERP Finance Cloud: Accounts Payable/Payments (AP), Receivables (AR), General Ledger (GL), SLA, Budgeting, Fixed Assets (FA), Expense (Exp), Cash Management (CM), Subledger Accounting (SLA), Fusion Accounting Hub (FAH), Tax, Global Intercompany, Allocations, Revaluation, Financial Studio /Smart View, Enterprise Structure, AP Invoice Imaging Solution, Oracle Purchasing, iProc and Oracle Security ERP Versions: Oracle eBs 11i, R12 and Oracle Cloud 10, 11 and 12 versions Database: Oracle 12C, 11g, 10g, 9i & 8i Software, Tools, Languages: PL/SQL, SQL*Plus, Toad, SQL Developer, Financial Reporting Tool, Smart View/FRS Studio, OTBI, Data Loader, HP Quality Center, SharePoint, MS-office, Lotus Notes. Visio, MS Project, MS Team Foundation Server (TFS), Flex Deploy. Implementation Methodology: True Cloud Methodology, OUM Methodology, AIM Methodology, Waterfall Methodology and Agile Methodology Engagement Experience: Advisory, Cloud Familiarization, Process Playback, Requirement Gathering, Solutioning and Design, Configuration, Data Conversion, Fit/Gap Analysis, Blue Printing, Integration Testing, Project Management, Facilitating End User Training, Month End Closure, proof of concept and postproduction support. Others: Hyperion (EPBCS, FCCS) Industry Experience: Toll road, Professional services, Property & Maintenance, Retail, Laptop Manufacturing, Management Consulting, Telecom, Media & Entertainment, Construction, Home appliances, Aircraft Manufacturing. Education: Master of Financial Administration (MFA) from Institute of Management Studies ( Devi Ahilya University INDORE -M. P India) Executive Master in Business Administration (EMBA) from Indian School of Business Management & Administration Certifications: Oracle Certified Professional in EBS R12 Oracle General Ledger, Oracle Certified Professional in EBS R12 Oracle Payable, Oracle Certified Professional in EBS R12 Oracle Receivable, Fusion 11g Financial Management Sales Specialist, R12 Oracle Financial New Features Fundamental, OUM (Oracle Unified Management), SeiLevel Certification in Requirement Core Concepts, Visual Models, Elicitation and Facilitation, PMI Certification in Mastering Agile Scrum, Quality Six Sigma Certification from GE, Engagement Manager Level 1 Certification from Capgemini Professional Experience: Client: Block Inc. (Square), Oakland,CA Duration: May 2023 to May-2024 Role: Solution Architect Fusion Cloud / Business System Analyst Project: Block Inc Oracle Transformation & ERP Cloud Implementation Project Description: Block, Inc. is a U.S. public company. Block helps sellers more easily run and grow their businesses with its integrated ecosystem of commerce solutions, business software, and banking services. Part of Transformation program, Block Implementing a new Oracle ERP Cloud solution along-with integrate peripheral operation application (like, Equity Edge, Bitkey, Afterpay, TIDEL etc.) that can bring further value towards automation, scalability, operational efficiency, cost reduction and compliance for the overall organization. This is a big scale transformation project which involves most of the business process will go through major change management process. Responsibilities: As the solution architect worked with client to gather business requirements and map them into cloud standard features. Developed an understanding of a client s current state process and developed future state solution. Integrated upstream system by using Cloud FAH and configured the Journal accounting rule based on accounting requirements. Mapped client requirements against Oracle Fusion Financial Modules like GL/AP/AR and Fusion Accounting Hub. Subject Matter Expert in Data conversion as part of ERP implementation like (Customer, Transaction, Receipt, Adjustment etc.) Assisted to create a data conversion strategy followed by a detailed plan for Master Data and transactional data conversion as well as migration to the new IT ecosystem. Defined functional specifications for customization as per business requirement and use development specifications to create detailed test cases. Created test scripts and training documentation. Worked closely with users during UAT phase. Environment: Oracle Cloud Release 13 Client: Equinix, INC, Redwood City, CA Duration: March 2022 to May 2023 Role: Solution Architect Fusion Cloud / Business System Analysis Project: Equinix Oracle ERP & EPM (FCCS) Cloud Implementation Project Description: Equinix is the world s digital infrastructure company. Digital leaders harness our trusted platform to bring together and interconnect the foundational infrastructure that powers their success. Part of Transformation program, Equinix seeking to replace its existing EBS R12 legacy financial systems with a new Oracle ERP Cloud solution along-with consolidation solution (FCCS) and integrate peripheral operation application (like, Workday, Coupa, Payroll, PBCS, FCCS, Bloomberg etc.) that can bring further value towards automation, scalability, operational efficiency, consolidation, cost reduction and compliance for the overall organization. This is big scale Implementation Project where 75+ Legal Entity will be migrated to Oracle ERP Cloud. The Chart of Account, Enterprise Structure and Subledger accounting rules (SLA) will be redesigned, and majority of business process will go through major change management process. Implementing FCCS for better consolidated view of financial statement for entire company at corporate level. Responsibilities: As a solution architect directly work with Business Users to understand the business requirement Designed new COA and Enterprise structure as per reporting requirements. Configured cloud applications and performed testing to verify all the intended functionalities to meet client requirements and documented into application configuration. Extensively involved in ERP reporting solution by using the various out of box reporting tools like, OTBI, BI Publisher, SmartView, FRS (Financial Reporting Studio) and others external reporting tools like MS Power BI, Hadoop etc. Partner closely with client SMEs to define requirements for integrations with third party application like FIS Get Paid, Ariba and Coupa-Travel & Expense Deeply experienced in Oracle functional P2P process where in liaise with end users for analyzing business requirements and develop detailed functional designs in Oracle Purchasing, iProc and Accounts Payable. Configured and modified SLA Rules based on IFRS & local GAAP accounting requirement. Modified journal entry rule sets, journal line rules, accounting rules, description rules, supporting reference, by using the conditions and mapping set and custom formulas. Adept at mapping industry trends and best practices to the clients unique requirements and processes to determine applicable fit. Interacted with business users to gather the business requirements and perform the Fit-Gap analysis. Mappped business requirement with standard functionality, otherwise suggest the custom solution. Involved in preparing Solution design, Functional Specifications, Setup Documents, Test Scripts, and Training materials. Conduct POC s before concluding and implementing any solution. Worked closely with users during UAT phase Opening, managing, and resolving Oracle SR s with Oracle Support Environment: Oracle Cloud Release 13 & EPM (FCCS) Client: IQVIA, Wayne, PA, Duration: July 2021 to March 2022 Role: Solution Architect Fusion Cloud Project: IQVIA Oracle ERP Cloud Implementation Project Description: IQVIA is the leading global provider of advanced analytics, technology solution and clinical research services to the life sciences industry. As a company s transformation initiative program, IQVIA is seeking integrated its existing SAP, PeopleSoft legacy financial systems with a new Oracle ERP Cloud solution that can bring further value towards scalability, operational efficiency, cost reduction and compliance for the overall organization. Responsibilities: As a solution architect working on Oracle fusion cloud and design the solution as per business requirement. Conduct workshop to design new COA and enterprise structure as per management and statutory reporting requirement. Configured and modified SLA Rules based on IFRS & local GAAP accounting requirement. Involved in reporting requirement gathering and prefer to achieve by using out of box ERP reporting tools like OTBI, BI Publisher, SmartView, FRS (Financial Reporting Studio) and otherwise, external reporting tools like MS Power BI, Hadoop etc. Modified journal entry rule sets, journal line rules, accounting rules, description rules, supporting reference, by using the conditions and mapping set and custom formulas. Conduct GAP analysis between business requirement and Oracle cloud application and provide solution for Identify GAP. Interacted with users and understand the business requirement and convert them into functional specifications. Performed initial round of solution testing and facilitate client workshops. Conducted UAT testing and get the user sign-off. Conducted POC s before concluding and implementing any solution. Supported users on production issues. Environment: Oracle Cloud Release 13. Client: Metro Pacific Tollways Corporation, Philippines Duration: January 2021 to June 2021 Role: Solution Architect Fusion Cloud Project: MPTC ERP Cloud Implementation Transformation Project Description: Metro Pacific Tollways Corporation (MPTC) is the largest toll road developer and operator in the Philippines. As part of the company s Finance Transformation program, MPTC is seeking to replace its existing SAP legacy financial systems with a new Oracle ERP Cloud solution that can bring further value towards scalability, operational efficiency, cost reduction and compliance for the overall organization. This is medium scale Implementation Project where 18 Legal Entity will be migrated to Oracle ERP Cloud. The Chart of Account, Enterprise Structure will be redesigned, and majority of business process will go through major change management process. Responsibilities: Worked as a Solution Architect on the Implementation of Cloud financial. Liaison with Client to conduct discovery sessions for solution design and developed TO-BE business process. Lead Cloud Familiarization sessions to demonstrate cloud standard functionalities to client. Documented AS-IS process and proposed TO-BE business process. Designed new COA and Enterprise structure as per reporting requirements. Trained Super user for new system functionality. Documented all solutions design, configurations, and training documents. Designed Intercompany solutions for different Legal Entity. Designed and Implemented Single Ledgers and 18 Business units in 6 months. Used Rapid Implementation methodology to configure Oracle Cloud Financial. Written and reviewing detailed test scripts for System, Integration, and User Acceptance Test Phases. Environment: Oracle Cloud Release 13. Client: KPMG Lower Gulf, Dubai Duration: January 2019 to December 2020 Role: Solution Architect/ IT Application Manager- ERP Fusion cloud Project: Transformation project- From EBS R12 to Fusion Cloud Implementation for KPMG Lower Gulf (Dubai) Description: KPMG Lower Gulf was on Oracle EBS R12 platform which was implemented around twelve years ago and due to various system limitations, unable to up skill the current EBS R12 system to handle the growing business. It s an IT transformation project where in restructuring the KPMG IT footprint which includes Financial, CRM, Risk system, Resource scheduling and collection system. Oracle fusion cloud is basically a reimplementation project which includes business processes standardization, simplification, enhancing reporting & profitability capability, prebuild integration, improve month end closing and automate the business processes by introducing the RPA technology. Responsibilities: Worked in the capacity of solution Architect and design complete end to end solution footprint. Conducted workshop to understand AS-IS process and Lead Cloud Familiarization, Process Playback sessions to demonstrate cloud standard functionalities to client. Identified business requirements and mapped them to the Oracle Cloud functionality. Also, identified functionality gaps and developed PaaS solutions for them. Designed solution for automating the business process by using the Robotic process automation (RPA) technology. Configured Cloud Applications and Tested all functionalities to meet client requirements and documented application configuration. Documented business requirement for reports, interfaces, data conversions and application extensions Defined testing scenarios developed test scripts and supported clients for execution of test scripts and delivered end-user training. Environment: Oracle Cloud Release 13. Client: Amway, Malaysia Duration: May 2018 to January 2019 Role: Solution Architect/ Senior Manager ERP Project: EBS R12 Implementation and Rollout and POC for Fusion Cloud Implementation for Amway (Malaysia) Description: Amway ATLAS is basically the Oracle R12 EBS Implementation and rollout project. Client Also client seeking conducted POC for moving the EBS R12 solution to fusion cloud for P2P and O2C flow. Responsibilities: Act as a Subject Matter Expert in all technical/Functional aspects of Oracle Cloud Financials including best practices for deployments and data integration techniques (staging area, direct feed, etc.) Assist with transition from Legacy Systems to Cloud based products. Translate requirements from process owners into functional specifications. Worked with business units to develop best practices and optimized processes. Manage all aspects of Oracle Service Requests with Oracle Support Create value added reports specification for; SmartView; FRS (financial reporting studio) and OTBI (Oracle Transactional Business Intelligence) Conducted user training, UAT, and CRP sessions independently. Established strong controls/security around Oracle Cloud applications. Provided support to business users to handle the critical issues in the new environment. Environment: Oracle Cloud Release 13. Client: Deyaar Property PJSC, Dubai Duration: December 2017 to March 2018 Role: Solution Architect- Oracle EBS R12 /Fusion cloud Solution Architect Project: Fusion Cloud Implementation & VAT Enablement for Deyaar Property (Dubai) Description: Deyaar Property is currently on EBS R12 and moving to fusion cloud and enabling the VAT calculation on P2P and O2C flow after introducing the VAT law in UAE counties. Responsibilities: Analysis of current business process flow of EBS R12 and Peripheral systems and mapping the functionality to Oracle fusion cloud; as well as the data mapping to Fusion cloud. SME in Oracle Fusion/Cloud Financials (Accounts Payable, Accounts Receivable, General Ledger, Fixed Assets, Cash Management and Tax Management) Worked with business to modify the business process flow of Peripheral system to migrate to new platform Oracle fusion cloud successfully. Worked with business to categorize process change opportunities between existing process and future processes. Recommend alternative business process solutions to accommodate gaps. Lead the documentation of design specifications as well as review of designs and configuration documents. Conducting Proof of Concept, Conference Room Pilot (CRP) and User Acceptance Testing (UAT) demonstrations Environment: Oracle Cloud Release 13. Client: Dell international Services India Pvt. Ltd., Bangalore, India Duration: May 2016 to October 2017 Role: Senior Manager -IT Business Consulting- Oracle EBS R12 / Fusion Cloud Solution Architect Project: Dell Platform Modernization & Portfolio Rationalization Description: Dell Order Management system (OMEGA) is the core system running on EBS R12 platform caters core business needs of Dell. In addition, Dell has numerous Peripheral systems that are not running on EBS R12 platform as a result they are not fully integrated with Core OMEGA System. This project is part of Dell s platform modernization initiative which includes migration of existing OMEGA system running on Oracle EBS R12 to a new platform Oracle Fusion Cloud as well as migrate functionality of Peripheral applications and their Data to new platform. There are one hundred business critical Peripheral applications in Order to Cash area, those are identified as priority candidates for migration to the new platform Oracle Fusion Cloud. Responsibilities: Worked as SME- Evaluated EBS R12 AS-IS processes and defined, designed roadmap for fusion Cloud application implementations. Worked on proof of concept to migrate the Oracle EBS R12 to Oracle fusion cloud to showcase cloud capabilities for critical business processes (Order to Cash and Record to Report). Analysis of business process flow of Peripheral systems and mapping the functionality into Oracle fusion cloud; as well as data mapping to Fusion cloud. Work with business to modify the business process flow of Peripheral system to migrate into new platform Oracle fusion cloud successfully. Work with business to categorize process change opportunities between existing process and future processes. Recommend alternative business process solutions to accommodate gaps. Environment: Oracle Cloud Release 13. Client: Dell international Services India Pvt. Ltd., Bangalore, India Duration: May 2013 to April 2016 Project: DELL EBS R12 Sustaining & Enhancement project (OMEGA) Role: Oracle EBS R12 Solution Architect Description: Dell Order Management System (OMEGA) is an Oracle EBS R12 global implementation which has around 50+ business units across the world (USA, EMEA, and APJ). Each country has separate Operating Units, Multi-Currency and Multi-Language enabled. Oracle EBS R12 application is tightly integrated with various Up-Stream and Down-Stream applications. Oracle Apps Modules include Order-to-Cash Flow- Order Management (OM), Accounts Receivables (AR), General Ledger (GL), Inventory (INV), Cash Apps, and Collections. Dell Oracle EBS sustaining & enhancement project (OMEGA) involves process improvement, enhancement, and defect resolutions. Responsibilities: Performed GAP Analysis, identify business improvement opportunities and encourage business to raise CR s for any improvement and enhancement. Ensuring timely and successful execution of each release deployment within approved down time. Determining the scope for each quarterly release and triaging the CR s & production defects to meet the business needs. Performed Cost benefit analysis (development effort Vs business benefits) to determine the CR s priority. Responsible for update the business process flow documents, diagram, and user guide appropriately after implementing the CR s. Provide coaching and training to end users after each deployment for CR s and production defects. Conduct End to end integration testing, user acceptance testing, training, and documentation. Working with multiple stakeholders like compliance team, business users, Risk, Infrastructure, DBA and firewall team for successful release execution. Environment: Release 12, Oracle Applications. Client: McKinsey & Company, New York City Duration: February 2011 to May 2013 Project: EBS R12 Implementation for McKinsey & Company Role: EBS Finance Functional Solution Architect Description: Oracle EBS R12 implementation for McKinsey & Company was one of the largest Implementation projects for Management consulting organization. Client: Dell international Services India Pvt. Ltd., Bangalore, India Project: Oracle 11i Implementation and Oracle EBS R12 Upgrade for DELL Computer Inc. Duration: May 2008 to January 2011 Role: EBS Finance Functional Solution Architect Description: Dell Oracle 11i implementation project was deployed for EMEA & APJ regional business which has 45 countries in scope and each one has separate business unit. Afterwards the same project got converted into Oracle EBS R12 upgrade. Client: ITV, United Kingdom Project: Implementation Oracle Application for ITV- UK Duration: November 2007 to April 2008 Role: Oracle EBS Finance Functional Consultant Description: ITV- UK is the biggest commercial television network in the UK. They had multiple in-house applications catering to their business needs. ITV management decided to consolidate their home-grown applications (Business process flow and Data) into Oracle ERP system to meet their key challenges. It includes various modules like Oracle General Ledger (GL), Account Receivable (AR), Order Payable (AP), Purchasing (PO) Fixed Assets (FA), HR Self Service, I-Expense, I-Procurement and Cash Management (CM). Client: INDU Project Ltd, Hyderabad, India Duration: May 2007 to November 2007 Role: Oracle EBS Finance Functional Lead Consultant Project: Implementation EBS R12 INDU Project Ltd. (Construction Company) Description: Oracle 11i implementation for INDU Construction Company. Client: GE Appliances, Puerto Rico Duration: August 2006 to April 2007 Role: Business Analyst Oracle App Finance Functional Consultant Project: Implementation Oracle App GE Appliances - Puerto Rico Description: Implementation of Oracle Applications for GE Appliances business is the rollout project for other counties which includes Oracle General Ledger (GL), Account Receivable (AR), Order Payable (AP), Purchasing (PO) Order Management (OM) and Inventory (INV). Client: GE Mexico Lighting, Monterrey Duration: September 2005 to August 2006 Role: Business Analyst Oracle App Finance Functional Consultant Project: Implementation Oracle app GE Mexico Lighting Monterrey Description: Oracle application Implementation for GE Mexico lighting business is one of the biggest implementation projects which included Oracle General Ledger (GL), Account Receivable (AR), Payable (AP), Purchasing (PO) Order Management (OM) and Inventory (INV). Client: Bharti Airtel Limited, Bangalore Duration: March 2004 to September 2005 Role: Customer Support Associate - Oracle EBS Finance Functional Consultant Project: Implementation of Bharti Airtel Limited, a part of Bharti Enterprises, Description: Implementation of Oracle AP, AR, and GL module for Airtel Telecommunication Company for all 23 telecom circles. Client: GE- Aircraft Engines, Hyderabad Duration: April 2002 to March 2004 Role: Techno Functional Consultant Project: Implementation Oracle App for GE- Aircraft Engines Description: This project was implementation Oracle 11i for GE- Aircraft engines. Client: COHERENT NETWORK MATRIX (P) LTD, Hyderabad Duration: September 2000 to March 2002 Role: Techno Functional Consultant Project: Development of forms and various accounting reports Keywords: business intelligence information technology golang hewlett packard purchase order microsoft procedural language Arkansas California Pennsylvania