Candidates About

 

Srinivas Vetsa

Profile:

Over 12 years of experience in Oracle E-Business Suite & Fusion Cloud Applications as a Sr Functional Consultant, Involved in Implementations, Upgrading, Migration, Rollout and Post Production Support of Oracle EBS in various industries like IT Service, Banking, Telecom, Insurance, Retail Industry & Government Organizations. Expert in identifying Gaps & translating business requirements into technical solutions

 

Experience Summary:

 

• My core competencies include: Program and project management, solution architecting, business transformation, application setup/configuration, business process re-engineering, business system analysis, custom solution design, business requirements gathering, business requirements mapping, systems testing (CRP’s, SIT’s, UAT’s), end-user education and post implementation support.
• Focus on under budget, on time and successful management of Oracle ERP projects
• Expert architect in Legal Entity, Ledger, BU/OU solution designs along with corresponding Consolidation
• Worked in multiple vendor environments and managed/lead large teams across different geographies ( USA , Europe, Middle East, India) in onsite-offshore model
• Experience in Oracle EBS applications releases 11i, R12 & Oracle Fusion -Cloud Financials
• Experience in Upgradations R11iX to R12 and R12 to R12.X
• Worked extensively on General Ledger (GL) including AGIS and SLA, Accounts Payable (AP) including Payments (IBY), Accounts Receivables (AR), E-BTax, Cash Management (CE), Fixed Assets (FA), Order to Cash (O2C), Procure to Pay (P2P) and Record to Report (R2R)
• Extensive experience with all phases of Software Development Life Cycle(SDLC) including requirements definition, GAP analysis, fit-gap analysis, system configuration, testing, user training, and post-production support.
• Handled Data Migration of Vendor & Customers Masters, Open Payables & Receivables Invoices.
• Good working experience in Post implementation support and converting the new requirements into CR
• Expert in preparing design documents like BR 100, MD 50, BP40, BP 80 & TE 40 as per oracle standards (AIM – Application implementation methodology)
• Lead the large scale oracle conversion/migration projects from SAP, Quick Books, CONCUR, SAGE to Oracle
• Worked on the secondary ledger functionalities in Oracle R12 in order to meet the calendar changes / reporting requirements
• Effective in the identification of problem areas, development of alternatives and implementation of creative business solutions
• Working with Super Users, End Users and Consultants for RICEW development to resolve business needs
• Strong knowledge of Application Implementation Methodology (AIM), Application Object Library (AOL) implementation standards
• Intense experience on Trading Community Architecture (TCA) and Software Development Life Cycle (SDLC).
• Strong finance and accounts background to analyze and reconcile data
• Provided many process improvement solutions which resulted in long term financial & work force savings for the firm
• Sound Knowledge on the AP Payment process and exposure to implement payment process using Payment Process Profiles, Formats, XML Publisher templates to facilitate ACH & WIRE payment formats for US region
• Coordinated with multiple banks and technical teams to automate the payment process
• Leadership Skills – team-management, work allocation, responsibility for team delivery
• Training Skills – end-user training, module demonstration, product overviews
• Managerial Skills – Being responsible for quality delivery of the team; Reporting to senior management with Service Delivery reports; liaising with senior management on Demand and Capacity Management

 

Skills

 

Oracle Fusion Cloud Financials & Oracle E-Business Suite [Oracle 11i and R12]	General Ledger, Payables, Receivables, Fixed Assets, Cash Management, Global Consolidation System, EBusiness Tax, iExpenses, iSupplier, iProcurement, SLA, Supply Chain  Management, Project Accounting, AGCS, AGIS, Global HRMS & HFM
Languages	SQL
Tools & Utilities	Oracle Web ADI, Dataloader, Discoverer & SQL Developer, Smartview, FRS, JIRA & MOATIS ticketing tools

Academic Record

 

• Master of Commerce (M.Com) from Andhra University
• Master of Business and Administration (MBA) from MSB Business School (A Division of ICFAI), Hyderabad

 

Key Assignments

 

Client                                      : Western Digital Corporation – Milpitas CA.

Environment                         : Oracle Fusion Cloud Financials – 12

Duration                                : Jun’17 to till date

Role                                        : Sr Functional Consultant

 

Project Detail: Western Digital Acquired the SanDisk and HGST Companies, presently all three companies are running on three legacy ERP ecosystems. Running operations on multiple ERP's with complex up/downstream applications requires excessive manual workarounds.

 

To enable a single, integrated platform with improved process integration and data integrity WDC decided to implement Oracle Fusion Cloud modules I have been a Lead Consultant and Sr Business Analyst to Implement Fusion Financial Modules it includes GL, AP, FA, CM & Fusion Tax Modules.

 

• Conducted detailed and comprehensive Business Analysis by working with end users and other stake holders to identify the system, operational requirements, and proposed enhancements.
• Preparing Business Requirement Document [BRD], Future State Design [FSD] and Setup Documents [BR100]
• Conducted the Gap Analysis in order to understand the 'as-is' and the 'to-be' scenarios
• Configured setups for General Leger, Payables, Cash Management and Fixed Assets Modules
• Conducted CRP1 sessions to demo the out of box functionality on the service modules
• Conducted User Acceptance Testing (UAT) and collaborated with the QA team to develop the test plans, test cases and test data to be used in testing
• Provided training and conducted practice and Business Requirements definition sessions. Supported the production environments and users on a daily basis by resolving user issues.
• Experienced in preparing Test Plans, Unit Testing, System Integration Testing and Documentation and Providing support for SIT (System Integration Testing) and UAT (User Acceptance Testing).
• Logged, viewed, accessed, monitored, followed up and closed the Service Request (SR) with Oracle Support.
• Supported to Business users to build the smart view reports as per the requirements.

 

Client                                      : Nexant Inc., – San Francisco CA.

Environment                         : Oracle Fusion Cloud Financials – 11g

Duration                                : Nov’16 to May’17

Role                                        : Sr Functional Consultant

 

Project Detail: Nexant is a globally recognized software, consulting and services leader that provides solutions to utilities, energy enterprises, chemical companies and government entities worldwide

 

Nexant Inc., is implementing Oracle Fusion - Cloud Financials to enhance their financials system to support their current and future processes through automation

I have been a Lead Consultant and Sr Business Analyst to Implement Fusion Financial Modules it includes GL, AR, AP, FA, CM, AGIS, Expenses, Tax & Purchasing Modules.

 

·         Identify business requirements and align them to Oracle Cloud Financials functionality.

·         Preparing Business Requirement Document [BRD], Future State Design [FSD] and Setup Documents [BR100]

·         Created System Configuration Setups for GL, AR, AP, FA, CM, AGIS & Expenses based on client requirements.

·         Designed complex Ledger, Legal Entity, Subledger Accounting (SLA) setups to meet multi-currency reporting requirements

·         Analyzed requirements and established designs for new Global Chart of Accounts (COA).

·         Assessed impact on Record-to-Report track and provided input to redesign team

·         Coordinated with and supported IT department in designing data conversions and 3^rd party system integrations

·         Configuring Business Units Reference Data Sets

·         Conducting the CRP and User Acceptance Test

·         Provide functional application leadership and guidance to client regarding “best practices” and the functionality of the software modules through all phases of an implementation.

·         Data Conversion by using FBDI & ADFDI templates

·         Provide thought leadership around industry best practices for improving operation efficiencies and profitability of client business.

·         Participate with the respective client functional lead throughout system testing. Provide guidance to the respective client functional lead in the preparation of training materials

·         Supporting the business users to reconcile and upload the data by using standard Fusion –FBDI and ADFDI templates

·         Configuring the reports using smart view and Financial Report Studio

·         Project Support: Support project team for successful delivery of the client’s business requirements through all phases of the implementation. Lead weekly project status meetings for assigned team and actively participate in project’s weekly status, and/or, issues meetings.

·         User training and working with business users to understand and troubleshooting the issues

 

 

Client                                      : Gymboree Corporation – San Francisco CA.

Environment                         : Oracle Applications R12.1.3

Duration                                : Jul’16 to Oct’16

Role                                        : Sr Functional Consultant

 

Project Detail: Gymboree is moving accounting year from the typical Retail Accounting Calendar (February – January) onto a new Accounting Calendar (August – July) to achieve capital goals. There are two major activities are performed in this project

 

Ø  Conducted the POC [Proof of Concept] to the stake holders

 

Ø  Rationalizing the Oracle Secondary Ledgers features in order to achieve the business requirements

 

• Responsible for Client interaction, gathering requirements and process mapping with oracle features
• Designing as-is and to-be process documents and demonstrate the POC [Proof of Concept] to the Business users.
• Preparing the functional design documents like BRD, MD 050, BR 100, Data conversion/Migration templates and preparing the test scripts.
• Create new fiscal calendar (August- July) for Secondary Ledgers
• Configure  Secondary Ledgers for all Primary Ledgers
• Transfer historical account balances & Translated balances from last one year to till Go-Live into the Secondary Ledger.
• Assisting the technical team to preparing the conversion scripts
• Create new Consolidation module and mapped all the secondary ledgers, to achieve the  consolidated trial balance and other reports
• Analyzed and designed modifications to FSG reports as per the GL Secondary Ledger implementation requirements.
• Designed custom financial reports using FSG, for Corporate/Statutory Reporting requirements.
• Recommended additional COA modifications needed to synchronize FSG's and COA.
• Tested, tracked and implemented FSG modifications into Production environment

• Created multiple FSG and custom design reports relating to Intercompany Eliminations
• Propose process improvements and control mechanism in the business processes through R12 capabilities such as MOAC, Data Access & Definition Access Sets
• Responsible for driving CRP, UAT and Cut-over activities of the implementation

Client                          : Digital Risk LLC – Maitland FLORIDA.

Environment             : Oracle Applications R12.1.3

Duration                    : Jan’14 to Jun’16

Role                            : Project Lead / Sr Functional Consultant

 

Project Detail: This is R12 Implementation project for one of the Mphasis an HP newly acquired company. There are two major activities are performed in this project

 

Ø  Calendar changes as per the legal requirement

 

Ø  Implement all Oracle Financial, Procurement & Projects modules.

 

• Calendar Changes:
  • Implemented the secondary ledger functionality in order to meet the calendar change & reporting requirements for all 40 operating units
  • Developed new FSG reports and Account Analysis reports in Oracle R12 to meet the requirement of TB and other schedules
• Implementation of Financial & Procurement Modules for Digital Risk entities:
  • Study the present business process and implement Oracle R12 for the Digital Risk and their entities.
  • Responsible for Client interaction, gathering requirements transferring into technical solution
  • Creating end to end setups for all the Finance and Procurement modules based on the design documents and business requirements.[General Ledger, Receivables, Payables, Fixed Assets, Cash Management & E Business Tax, Purchasing & Projects modules]

o    Conducting CRP [Conference Room Pilot] and supporting UAT [User Acceptance Test]

o    Worked on SLA (Sub Ledger Accounting) rules to replace traditional transaction codes for generating multiple accounting representations for one business transaction

·         Created End to End Setups for Receivables & Projects

o    Understanding of Revenue Recognition principles [US GAAP]

o    Defined Invoicing and Accounting Rules to meet the revenue recognition schedules

o    Defined Transaction Types, Sources, Receipts Classes & Sources

o    Defined Auto Invoice & Auto Cash Rule Sets

o    Co-ordinated with business users to get the requirements for the custom reports

·         Extensively Worked on AP Payments setup Module it includes:

o    Defining multiple banks and payment formats

o    Setting up ACH setups for bank

o    Design & implement SEPA credit transfer in ACH/WIRE formats in Oracle Payments for JPMC & CITI banks

o    Design & implement NACHA payment format in Oracle payments for JPMC & CITI banks operating in United States

o    Coordinating the team to develop XML templates and logic to process Oracle checks, EFT and automatic wire transfers.

o    Implemented and created process for XML Check Outsourcing payment formats using Oracle [Host to Host Process]

o    Worked with Technical team to develop the check printing process for Fifth Third and Citi Banks

• Worked on reconciliation of AP (Accounts Payable) with General Ledger (GL) by running Accounts Payable Trail Balance report, Posted invoice register report, posted payment register report and Unaccounted Transaction report.
• Integrating between Oracle and third party tool Concur. Worked on Inbound and out bound interfaces between CONCUR and Oracle
• Responsible to gather details from third party tool manage engine
• Design of SOD [Segregation of Duties] including the MOAC [Multi-Org Access Controls] implementation
• Created intercompany Transaction, Consolidation, Elimination entries setups and configurations
• Assess the reporting and interfacing needs and interact with the development team to get the reports/interfaces deployed in Oracle R12 and Discoverer
• Monitoring data reconciliation of legacy data and migrated data project management, team management activities. Project deliverables review and functional testing, client handling and communications
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Conducting end user training sessions and delivering the user manuals
• Participating in Client’s Change Management and Change Requests (CR’s) for any changes in existing processes

 

Production support includes:

·         Responsible to resolve user service tickets with SLAs.

·         Work with technical team in order to resolve production support tickets related to custom functionality

·         Participating in Client’s Change Management and Change Requests (CR’s) for any changes in existing processes and testing the Functionality on the application for all new change requests

• Tracking all development activities and provide updates to the client on daily basis and Lead Regression testing after release upgrade/major patching
• Supporting End users in solving their regular day-to- day problems
• Working with Business Users on a daily basis, providing functional support as well as technical troubleshooting assistance to ensure the successful flow of Business processes.
• Raising SR with Oracle with for getting assistance in resolving the issues

·         Manage the Production support team and responsible for working with business users to understand and troubleshooting the issues

·         Supporting on Month end Quarter end issues and assisting the business users while doing reconciliation subledgers with GL

 

Client                          : Mphasis Corporation, New York

Environment             : Oracle Applications R12.1.3

Duration                    : Apr ’13 to Dec ’13

Role                            : Project Lead / Business Analyst

 

I have been a Project Lead and senior SME was involved in Roll out of R12 Financial and Procurement modules. Some of the activities performed included.

 

• Solution designing for roll out of Oracle Applications at specific market, considering country specific requirements. Process Reengineering Responsible for Client interaction, gathering requirements.
• Gather Business Requirement and working on customization as per business requirements
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Creating end to end setups General Ledger, Payables, Receivables, Fixed Assets, Cash Management, EB Tax  & GCS
• Configuration, Testing and Data Conversion in Financial modules [AP, AR, GL and FA]
• Determining Batch Scheduling Requirements
• Conducting CRP and User Acceptance Testing and Sign off
• Facilitate Change Management Processes, Prepare Process Documents and Diagrams.
• Working with business streams to reconcile the data

·         Conducting Steering Committee with Mphasis Senior Management and client leadership team

• Primary point of contact with client management for Production issues in Oracle Financials and their resolution

 

Client                          : Mphasis Wyde, France

Environment             : Oracle Applications R12.1.3

Duration                    : Oct ’12 to Apr ’13

Role                            : Project Lead / Sr Functional Consultant

 

Project Detail: This is R12 Implementation project for one of the Mphasis an HP newly acquired company to implement the all Oracle financial modules. This implementation project has brought about process changes of Chart of Accounts [COA] as per France legal requirement.

• Responsible for Client interaction, gathering requirements transferring into technical solution.
• Conducting and driving the study of “As-Is” and “To-Be” business process for Oracle especially in General Ledger.
• Gather Business Requirement and working on integration between SAGE and Oracle Application
• Worked on reconciliation of subledger data before moving into Oracle
• Identify scope of integration required and
  • Rationalization of Master data.
  • Mapping between entities in two systems
  • Solution Design and Development
  • Preparation of roll-out plan
  • Production Roll out
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like BR 100, MD 50, BP40, BP 80 & TE 40 documents
• Creating end to end setups for all financial modules – General Ledger, Payables, Receivables, Fixed Assets, Cash Management, EB Tax  & GCS

·         Conducting Conference Room Pilot and supporting User Acceptance Test

·         Conducting Steering Committee with Mphasis Senior Management and client leadership team

• Consolidation mapping and setups for the Wyde and Mphasis. Transfer the GL transaction data from Wyde to Mphasis through consolidation on every month end
• Revaluation & Translation Setups
• Created Auto Bank Reconciliation setups using BAi2 format for CITI Bank accounts
• Closing all issues & providing month / quarter end support it includes running the period closure exceptions reports at subledger level and assisting the team to preparation of schedules and reconciling the data with GL

 

     Client               : Mphasis an HP Company

Environment: Oracle Applications R12.1.2

Duration        : Feb ’10 to Oct’12

Role                : Team Lead / Sr Functional Consultant

 

I have been a Team Lead and senior functional consultant was involved in implementation activities of all the financial applications in Oracle E Business Suite R12. Some of the activities performed included:

 

• Study the business processes and find areas of improvement
• Propose applications that need to be sunset and utilize the Oracle e Business Suite capabilities
• Propose process improvements and control mechanism in the business processes through R12 capabilities such as MOAC, Multiple reporting conventions through the use of Secondary Ledgers, GCS, EB Tax, India Local Taxes and Purchasing modules etc.,
• Collected requirements, led discussions and established design for new Global Chart of Accounts (COA).
• COA design for 8 segments, including new Parent/Child rollups and COA Mapping design for conversion from legacy chart of accounts structure.
• Responsible for driving CRP, UAT and Cut-over activities of the implementation
• Actively involved in Vendor Management and Project Control
• Worked on third party tool ‘Newgen’ to interface invoices to Oracle AP module
• Assess the Application GAPS in comparison with the BPR propositions
• Develop design documents at various stages of the project as per Oracle’s AIM methodology like RD 20, BR 100, MD 50, BP40, BP 80 & TE 40
• Participating in CCB meetings for the new Change Requests.
• <span style="font-size:10pt;font-family:Verdana, 's