Skilled Oracle Systems Analyst with a proven track record of leading analysis and requirement-gathering efforts for application development projects. Additional background includes conducting joint and rapid application development sessions, service-oriented architecture and supervisory experience in functionality, usability, reliability, performance and regression testing. Executed critical projects as Senior Business Analyst, Functional Lead, Designer on Functional & Techno-Functional roles. Extensive business area experience & have received great commendations at client site for excellent interpersonal & client interaction skills.
Overview
8
8
years of professional experience
Work History
Oracle Consultant
WalkWater Technologies
02.2016 - 11.2023
CLIENTS:
Senior Oracle Systems Analyst
Aramark Uniform & Career Apparel
06.2018 - 11.2023
Worked extensively on testing various modules for the upgrade of EBS version from 12.1.3 to 12.2.9 during planning till post upgrade support phase.
Worked on the setups of Positional Hierarchy Approval Hierarchy in Oracle Purchasing.
Worked on defining the Purchasing and Receiving Option in Oracle Purchasing.
Setup the Match Options on the Purchasing Documents.
Defined Buyers and setup their roles in Oracle Purchasing.
Defined Price Breaks, Modifiers, Qualifiers, Setup Price lists for different currencies for Advance Pricing.
Engaged actively with Oracle Support for the timely fixing of bugs and issues faced.
Tested the customizations and enhancements in the upgraded version.
Customized Subledger Accounting for Cost Management/Inventory module by defining Custom Sources.
Customized Subledger Accounting for Payables module for various Invoice types and Purchasing Categories.
Lead the efforts for the conversion of AP invoices, Fixed Assets and Projects during the acquisition of Ameripride Services.
Designed new and complex GL Mass Allocation formulae based on user requests.
Managed the monthly activities for Blackline, Vertex Tax Engines.
Developed a new custom business process for completing Wire Payments in the system.
Configured new bank transaction codes and mapping for new bank institutions.
Performed the necessary setups to enable the MOAC functionality.
Worked on creating new layout for various WebADI templates in GL and Fixed Assets modules.
Worked on enhancing the existing approval routing process for Requisitions and POs using AME.
Involved in the setup of iExpense and Procurement Card program for the employees.
Provided hands on techno-functional support during the month end process for AP, GL, PO, Inventory, Cost Management, Fixed Assets and Project modules.
Established compatibility with third party software products like More4Apps and integrating them with EBS modules.
Provided users with information extracts from DB tables by writing complex SQL queries when requested.
Worked closely with the Change Management team to navigate the changes to higher instances.
Coordinated with the offshore technical team working in multiple time zones for implementing the functional and technical solutions.
Provided continued maintenance and development of bug fixes and testing of patch sets.
Oracle Consultant
Salesforce
04.2017 - 05.2018
Involved in the design of custom solution for revaluing the Amortization pattern of Assets and Capital Commissions for regions across the world as per new Revenue standards (ASC 606).
Engaged with users from all across the globe (EMEA, APAC, LATAM & AMER regions) during the design and testing phase of the project.
Worked comprehensively on the technical design and automation of Interface between Hyperion Planning and Oracle GL system.
Worked on project Quokka which involved the implementation of Oracle Receivables, Cash Management and several other Integrations for Australia entity.
Prepared the BR100 for all the configuration changes involved.
Worked on setting up the newly implemented GST tax invoice templates for the Indian entity.
Worked extensively on the automating following third party integrations Org62, RevPro and Blackline applications with Oracle EBS.
Worked on setting up multiple Secondary Ledgers for Primary ledgers.
Oracle Business Systems Analyst
Sherwin-Williams Company
06.2016 - 03.2017
Involved in CARMS Replacement Project: Replacing Mainframe AR and Collections System with Oracle E-Business Suite. GL, AR, Advanced Collections, Credit Management, CRM, Channel Revenue Management & ARDS were implemented.
Prepared technical mapping document for Data conversion of legacy Customer, Invoices and Receipts data.
Worked on creating new responsibilities, menus and exclusions that reflected the functionalities in the mainframe system.
Developed custom reports based on mainframe ones giving stakeholders valuable insights into business operations.
Oracle Systems Analyst
Univision Communications Inc.
02.2016 - 06.2016
Involved in implementing and integrating AME to the i-Procurement module for the newly established Mexican entity.
Created flowcharts of the newly implemented approval process to provide a clearer picture for the stakeholders.
Worked closely with the Audit and Control teams to align the approval process with the company guidelines.
Designed an interface between Oracle and third party system for seamless flow of Payables Invoice data.
Education
Certification in Cybersecurity Management - Cybersecurity For Managers
OTTAWA University
Phoenix, Arizona
05.2022
Executive MBA - Information Technology
OTTAWA University
Phoenix, Arizona
05.2021
Master of Science - Electrical And Computer Engineering
University of Texas At Dallas
Dallas, Texas
05.2015
B.Tech - Electrical, Electronics And Communications Engineering