Home

Sailavanya Somesula - Oracle EBS Financial Functional

[email protected]

Location: Plano, Texas, USA

Relocation:

Visa: H1B

Sailavnaya Somesula Summary: Over 14+ Years of experience as a Functional Consultant in Oracle Fusion Cloud, Oracle Financials (EBS) R12, 11i Implementation, Upgrade, Production Support, and Application Maintenance covering various Oracle modules (General Ledger, Accounts Payable, Cash Management, Account Receivables, SLA, iProcurement, PO, Fixed Assets and I Expenses) including Procure-to-Pay (P2P) and Order-to-Cash (O2C) processes. Conducted end-user training, and counseled clients on Oracle features and functionalities so their core business processes can be streamlined, strengthened and productivity improved while reducing costs and increasing revenue. Implemented/upgraded and trained in various Oracle versions of Applications from Oracle Financial Fusion (Cloud Financials R13) and Oracle EBS (R12.2.4). Experience in complete Project Life Cycle implementation involving Analysis & Planning, Business requirements gathering, Solution design, Systems configuration, Production systems roll-out, User Training programs, Conference Room Pilots (CRP), Post- implementation support, and Documentation using AIM Methodology. Coordinate with On-site and Offshore team - provide the transition of requirements, design and share project plans, and deliverables, and track the issues relating to implementation projects. Experience in Global Consolidation Process, Ledger Setup, Revaluation, and Translation. Well versed with the integration and architecture of Multi-Org (MOAC), Financial Statement Generator (FSG), Sub-ledger accounting (SLA), and usage of FBDI and ADFDI templates. Extensively involved in defining requirements for integrations with third-party applications, like Next Process, More4apps, Concur-Travel & Expense, etc. Proficient in data retrieval using SQL queries and supporting the necessary service requested and logged with Oracle. Extensive project management and delivery experience. Managed small to medium size project during tenure in Tata Consultancy Services Ltd and Wells Fargo India Solutions Private Limited. Ability to assist and guide technical team in Technical Design and Development of business requirements. Assisting Finance controllers (India, US, Germany, and China) for month end processes and translating their requirements into viable solutions. Experience in integrating acquisition company finance systems to Oracle. Technical Skills: ERP: General Ledger, Accounts Payable, Accounts Receivables, PA, iProcurement, I Expenses, Cash Management, Fixed Assets, Tax and Oracle Purchasing. ERP Versions: Oracle eBs 11i, R12 and Oracle Cloud Software and Tools: PL/SQL, SQL, HP Quality Center, Tosca and Panaya Education & Certifications: Master of Business Administration, DR C.V RAMAN University, Bilaspur, Chhattisgarh, 2015 Master of Computer Applications, Sri Venkateswara University, Tirupati, Andhra Pradesh 2006 Oracle Financials General Ledger Certified Implementation Professional Experience: Client: Brake parts Inc, Chicago, IL Duration: April 2023 Till date Role: Oracle Cloud Financial Functional Analyst Project: Oracle Fusion Implementation Description: Brake parts Inc is a premier manufacturer and supplier of brake system components Responsibilities: Conducted Project Kick-off meeting, requirements gathering sessions for General Ledger, Accounts Payable, Fixed Assets, Expenses, Tax, and Accounts Receivables Design and integration of More4apps for Receipts in Accounts Receivables. Preparation of Test scripts, Test Scenarios, and User Manuals. Integration of Financials with systems PRMS, Legend, and Concur, via OIC. Analyzed the customizations that needed to be done. Involved in designing AR Customer Invoice Reports integrated with EDI. Implemented the payment templates with external banks like Positive Pay, Check printing, CCD, PPD with Control total files Involved in the design and Integration with Next Process for Suppliers and Invoices Check Printing. Worked on OTBI Reports to create ad-hoc reports for validating the Conversion Data loaded. Reports included Supplier Extracts, Open AP invoices, GL Balances, etc. Involved in the designing of Custom Stock Returns in Order Management. Assisted and worked technical team for the mass cancellation of Invoices in Payables. Involved in designing the Core Charge Process which involves modules of OM and AR. Designing Functional Design Documents as per the business requirement. Involved in the integration design to load exchange rates from the Xignite application. Business process mapping with all standard modules. The configuration of CRP and UAT the GL, AP, AR, and FA modules. Documented business process in terms of change, prepared training manual with training team. Preparing test cases, executing them, and validating their acceptance criteria. Design and development of Reports using Smart View, OTBI Involved in Period close and Month End Process. Environment: Oracle Cloud Financials 13 Fixed Assets, General Ledger, Expenses, Accounts Payable and Accounts Receivable. Client: Brake Parts Inc, Chicago, IL Duration: March 2022 March 2023 Role: Oracle Financials Functional Consultant Project: Postproduction Support, Migration, Implementation and Enhancements Description: Brake Parts Inc is a premier manufacturer and supplier of brake system components Responsibilities: Resolved Month End issues related to Create Accounting. Configured new ledgers in GL as part of the Merging Process. Resolved issues related to AR Invoice Process and Month end issues. Supported Month End Process related to AP Period Closing and AR Period Closing Working with business users to extract the required data needed for open balance conversions like trial balance, open payables, open receivables, and asset master data. Conducting the CRP and System integration test, User acceptance test, and Production migration from Legacy to R12 Resolved issues related to Excel4apps and Helped the GL Controller to extract the data using Excel4apps. Onboarded and integrated three (5) newly acquired companies onto the global Oracle platform for Procure to Pay, Acquire to Retire, Record to Report, Planning, HR and Expenses; projects involved analysis of acquired organizations' financial systems, vendor consolidation, user training, GL structure changes, new currencies or ledgers, where needed. Involved in developing the reports using Apex and Blitz reports in GL, AP, PO, AR, and FA. Handled enhancement of Purchasing Retroactive Pricing. Created business requirements documents, detailed functional design documents, test plans, and test cases, user training documents, and implementation documentation, as necessary. Configured and Implemented GST for the Localization of India Project. Resolved Issues related to AP Payment issues Reconciled GL balance issues affecting downstream applications like Essbase and OBIEE. Resolved issues related to HFM and Oracle ERP. Configured Payment Setup (Allow Predate), Auto post Criteria (GL) Involved in testing various setups and resolving product specific bugs. Reconciliation of Data between Oracle and Vizion Financial Reports Experience with low-level ad-hoc query tools (Toad, SQL Developer) Supported Production Support and resolved critical issues. Participated in the migration of assets from diverse entities using different ERP systems (AS 400, SAP) to a unified Oracle ERP platform. Environment: Oracle Applications 12.2.3(General Ledger, Accounts Payables, Cash Management, Purchasing, Fixed Assets and OM) Client: VSG Oracle Cloud, Downers Grove, IL Duration: March 2021 to March 2022 Role: Oracle Financials Cloud Functional Consultant Project: Implementation of Oracle Fusion Description: Vehicle Service Group (VSG) is a strong, diverse, and dynamic global leader in the vehicle service industry. VSG comprises 13 major vehicles lifting, wheel service, diagnostic, and collision repair brands: Rotary Lift , Chief , Forward , Direct-Lift , Ravaglioli, Warn Automotive , Hanmecson , Revolution , Elektron, Blitz, Nogra, Butler, Space and sirio. Responsibilities: Defined the system configurations setups for all financials modules (GL, AP, AR, FA, CM) Defined the process setups for Revaluation, Translation, CVR rules, Security rules, Reporting and Accounting Sequences Defined the Intercompany setups for different legal entities Defined the Internal Banks, Branch, Payment Methods, and validations. Configured the Transmission Configuration setups, and generation of PGP Keys, and enabled the setups for Bank Integration. Configured the Auto Accounting Rules, Transaction Source, Transaction Type, Receipt Source, and Receipt Methods. Defined the Parsing Ruleset and bank Statement creation ruleset required for Bank Account Reconciliation. Deliver enhancement projects including implementing Automated Invoice Processing (AIP) and Intelligent Document Recognition (IDR) solutions and Tax. Worked extensively on the solution for Master Data Migration (Suppliers, Customers) from legacy applications into Oracle Fusion Cloud. Involved in the integration design to load revenue data from the legacy system. Conducted CRP and SIT Sessions for business users SOX control ownership for automated system controls; analysis of SOC1 reports; implementation of CUECs; ITGC audit support Environment: Oracle Fusion Cloud 13 GL, AP, AR, CM, Tax, Expenses, Fixed Assets Payments, Tax &Intercompany Wells Fargo, India/US Duration: November 2017 January 2021 Role: Oracle Financials Functional Consultant Project: Postproduction Support and Enhancements Description: Wells Fargo is a multinational financial services company. Responsibilities: Proposed solutions to project on enhancing/automating current business process in GL. Configured GL as per the business requirement. Interact with business customers to understand and document their business processes and requirements related to GL module. Mapping the Client requirements with Oracle standard functionality and finding the gaps and delivering the solutions in terms of Customizations, workarounds, reengineering and form personalization. Developed custom Revaluation process as per the business needs. Created business requirements documents, detailed functional design documents, test plans and test cases, user training documents and implementation documentation, as necessary. Handled retrofit enhancements and interfaces effectively. Familiar with change management process and responsible for planning, development, execution, and monitoring change management plans Proactively setting action plans for me and his team, able to complete deadlines without supervision. Experience with low-level ad-hoc query tools (Toad, SQL Developer) Prepared Functional Design Specifications for Outbound Integrations related to General Ledger. Performed CCID Refresh and execution of Test cycles. Performed Balance Out Zero Process in Test Environment for zero outing Balances. Logging defects in HPQC ALM Configured Merger company chart of accounts. Performed setup for Consolidation Process, Ledger Setup, Revaluation and Translation. Configured new ledgers in GL. Interact with business customers to understand and document their business processes and requirements and document application setup related to iProcurement, Purchasing, Cash Management and I Expenses. Environment: Oracle Applications 12.1.3 General Ledger, iProcurement, Purchasing, Cash Management, AR and I Expenses. Client: Dover, IL Duration: June 2017 November 2017 Role: Oracle Finance Functional Analyst Project: R12 Implementation and Postproduction Support Description: Dover is a diversified global manufacturer with annual revenues exceeding $7 billion. Dover delivers innovative equipment and components, specialty systems and support services through four major operating segments: Energy, Engineered Systems, Fluids, and Refrigeration & Food Equipment Responsibilities: Involved in testing various setups and resolving product specific bugs. Interact with business customers to understand and document their business processes and requirements and document application setup. Configuration of Revaluation, Translation, and basic setups for General Ledger Resolved issues related to Month End and Involved in Support Activities Prepared Functional Design specifications, Configuration change Defined cross validation rules & security rules for General Ledger, Assisted mapping Primary to Secondary ledger Configured Accounts Payable, I Supplier and Purchasing. Set up AP bank accounts, bank documents, bank codes and expense report templates. Configured Sub-Ledger Accounting to meet custom accounting needs and provide additional information on reports. Coordinates and conducts user support and training. Prepared SQL queries for data extraction required by the Users. Environment: Oracle Applications 12.1.3(General Ledger, Accounts Payables, Payments, I Supplier, I Expenses, Cash Management, Purchasing, Projects and iProcurement) Client: Vantiv, Cincinnati, OH Duration: December 2016 June 2017 Role: Oracle Financials Functional Analyst Project: Automation of Test Scripts Description: Vantiv is an American Payment Processing company. Responsibilities: Developed and executed test scripts for unit-testing, business-testing (during CRPs/UATs) and integration-testing (during SIT) using TOSCA tool for GL, AP, PO and iProcurement modules. Interact with business customers to understand and document their business processes and requirements. Prepared Test Cases for Automation Project Proactively setting action plans for me and his team, able to complete deadlines without supervision. Experience with low-level ad-hoc query tools (Toad, SQL Developer) Held the position of Release Manager from offshore for deployment of enhancements in Production. SDLC, SOX Compliance, Standards Audits, Tool Audits and AIM Methodology. Environment: Oracle Applications 12.1.3(General Ledger, Accounts Payables, Payments, I Expenses, Cash Management, Purchasing and iProcurement) Client: GE GRC (Global Research Center), India Duration: June 2015 November 2016 Role: Oracle Financials Functional Analyst Project: Automation of Test Scripts, ESCOA (Enterprise Standard of Chart of Accounts) and Postproduction Support Description: GE GRC is the research and development division of General Electric. Responsibilities: Interact with business customers to understand and document their business processes and requirements. Prepared Test Cases for Automation Project for GL, AP, PO, AR, I Expenses, iProcurement, PA and FA modules. Provided Functional Support to Automated Testing team as on when required. Created business requirements documents, detailed functional design documents, test plans and test cases, user training documents and implementation documentation, as necessary. Experience in engaging Oracle Support to research and resolve issues. Mentored the Junior and Documented 1100 test cases in a short duration of time. Resolving the issue related to Production support and analyzing the root cause. Experience with low-level ad-hoc query tools (Toad, SQL Developer) Leading the offshore team and working in multiple time zones for implementing the Functional and technical solutions. Defining and structuring of chart of accounts (COA) by mapping with the old account codes for Enterprise Standard of Chart of Accounts (ESCOA) Planned for Proof of concept and executed with support system. Interact with business customers to understand and document their business processes and requirements. Set up AP bank accounts, bank documents, bank codes and expense report templates. Configured Sub-Ledger Accounting to meet custom accounting needs and provide additional information on reports. Provided Functional Support to Automated Testing team as on when required. Created business requirements documents, detailed functional design documents, test plans and test cases, user training documents and implementation documentation, as necessary. Prepared BR100 Documents for business users and addressing training (KT) sessions to users. Experience in engaging Oracle Support to research and resolve issues. Identifies innovative solutions to business issues in technical development. Coordinates and conducts user support and training. Provided custom solution for FOC, Custom Web ADI Integrator and PCG for FSG in GL and FA module Environment: Oracle Applications 12.1.3(GL, AP, AR, PA, PO, iProcurement and FA) Client: GE Treasury, Boston MA Duration: August 2014 May 2015 Role: Oracle Financials Functional Consultant Project: Postproduction Support and Enhancements Description: GE Treasury is global funding and liquidity, capital structure, cash management and treasury services for all of GE's worldwide operations. Responsibilities: Prepared Functional Design Specifications for Outbound Integrations related to General Ledger. Conducted business meetings whenever required based on enhancement requests / Issues. Resolved Journal Import & Posting Errors for GL Handled Month end closure activities related to GL period close and resolved reconciliation issues with Sub ledgers to GL. Proposed and implemented process improvement ideas related to application. Mentored the Junior team members and handled the project. Configured Journal Approval & new Web-Adi templates. Environment: Oracle Applications 12.1.3 GL Client: Electronic Arts, Redwood City, CA Duration: January 2011 July 2014 Role: Oracle Functional - Module Leader Project: ICLICK R12 Implementation and Postproduction Support Description: Electronic Arts, the gaming company, has configured all its business across the globe in R12 instances. Responsibilities: Handled issues related to Create Accounting and troubleshooting of issues related to SLA setups. Prepared Functional Design Specifications for Integrations related to Payables. Configure setups for Oracle applications as per BR100. Analyzed and tested the patches before being implemented. Assisted Technical Consultant in the preparation of MD70. Provided postproduction support in I Expenses, iProcurement, AP, GL, Inventory and PO modules. Provided functional and technical support for the timely resolution of production issues within the defined SLA. Liaison with Oracle for support on various critical issues. Review flex field security rules and cross-validation rules. Define setups for revaluation & Translation. Defined the financial and payable options specific to the business requirement. Configured the Supplier & Supplier Sites Performed functional & system integration testing. Analyze and Test Integration with Third Party and Legacy Systems. Implemented I Expenses. Defined profile options to specify certain implementation parameters. Configured employee and expense report templates and travel policy. Prepared SQL queries for data extraction required by the Users. Followed a strict change management process involving end users followed by problem analysis, development or bug fixes, unit testing, and user acceptance testing with thorough documentation maintained at all stages. Resolved the issues related to the AP Trial Balance Report & Period end Accruals in the AP module Provided a solution for stopping remittance advice alerts for Check Payments in AP. Configured Expense Account Rules and implemented change request functionality in iProcurement. Monitoring, Guiding, and resolving the day-to-day and month-end closing issues. Conduct CRP to the end users / Onshore Team. Environment: Oracle Applications 12.1.3(General Ledger, Accounts Payables, Payments, I Supplier, I Expenses, Cash Management, Purchasing, Projects and iProcurement) Client: British Telecom, UK Duration: June 2010 November 2010 Role: Oracle Financials Functional Consulting Analyst Project: Extended Patching (OIE.K patch) for BT Responsibilities: Responsible for GAP analysis of Application Upgrade from 11.5.10.2 to R12 for I Expenses Validated the AS-IS Business process. Prepared Test Scripts to validate the Seeded Functionality and Custom Integrations in the financial space. Responsible for Manual, Functional and Regression testing of the Application related to iProcurement and Expenses. Prepare test strategy document to ensure that all testing requirements have been captured. Publishing status reports to senior management Participate in review meetings to ensure high quality of the deliverable. Test management tool Quality center is used for writing test cases, requirement mapping, defect management, test run analysis report throughout the testing cycle. Identify and create test scenarios from requirement documents (MD50) Cut over and Go live as per the schedule and provided post-production support. Environment: Oracle Apps 11.5.10.2 - AP, I Expenses, PO and iProcurement Client: British Telecom, UK Duration: November 2007 June 2010 Role: Oracle Financials Functional Consulting Analyst Project: F&A IT (Ops) Postproduction Support, Implementation and Enhancements Description: BT is British multinational telecommunications holding company headquartered in London, United Kingdom. It has operations in around 180 countries and is the largest provider of fixed-line, broadband and mobile services in the UK, and also provides subscription television and IT services. Responsibilities: Feasibility Study and gathering End User Requirements for new Functionality /Enhancements. Preparation of standard documents like MD050 and BR100 etc. Issue tracking and solution-maintained documentation for the same. Assisting in the preparation of Technical document MD70 Prepared/running of test scripts to validate the instance. Supported in post-production support for modules I Expenses, iProcurement, AP and PO. Provided functional and technical support for the timely resolution of production issues within the defined SLA. Implemented Credit Card functionality in I Expenses, Setups in Purchasing I.e., Approval groups approval limits and Approval assignments. Defined the banks and bank accounts in Account Payables. Interacting with the clients for requirement gathering and providing solutions to the user. Liaison with Oracle for support on various critical issues. Prepared SQL queries from toad for data required by the Users. Creation of Policy Schedules, Rules and updating existing Mileage Rates Enabling Expense Fields for Expense Category and defining notification rule set in I Expenses. Configured I Expenses and iProcurement Module. Environment: Oracle Apps 11.5.10.2 - AP, I Expenses, PO and iProcurement Client: O2, UK Duration: October 2006 October 2007 Role: Oracle Technical Consultant Keywords: active directory information technology golang hewlett packard purchase order procedural language Arkansas California Illinois Massachusetts Ohio Pennsylvania