Having 17+ years of good experience in Oracle Applications and have been extensively involved in Development, Customization, implementation, and Support projects
Good experience in Oracle Application Finance and SCM Modules, which includes AP, GL, CM, PO, PA, FA, iExpenses, SLA, iProcurement, GRC, OFR/OCR, Core HR, OM,AR and TM,TCA.
Creating and Publishing Weekly Status Reports (WSR) and Adhoc reports as per client need basis. • Prepared and Submitted SOW's for new projects .
Excellent development experience in coding Functions, Procedures, Packages and Triggers in SQL/PL SQL • Excellent development/Support experience in P2P (Procure to Pay) and Supply Chain Modules.
Having 5 years of Production System Support experience on Oracle Finance Modules which includes day to day interaction with business users, understanding user problems and identifying gaps in the system, working on support tickets (Remedy Incidents) raised by business, applying Long Term Fixes for the functionality gaps in the system.
Good development Experience in RICEW (Reports, Interfaces, Conversions, Extensions and Workflow) components, Alerts and Forms Personalizations.
Customization on Approval Management Engine (AME) in iExpenses, AP Invoice, GL Journal Approval Workflows.
Knowledge in SQL, PL/SQL Code optimization with Significant Performance Tuning (Trace Files, TKPROF, and Explain Plan) capabilities related to the Oracle E-Business Suite.
Completed Corporate training on Oracle Clouds, OBIEE 11g
Developed Custom BI Publisher Reports as per Business need.
Experience in creating SQL*Loader control programs and PL/SQL validation scripts.
Involved in gathering requirements from the customers and create a user stories for the same. • Created setup documents and defined setups in AP, PO modules
Very proficient in using Oracle Application Implementation Methodology (AIM) for documentation (MD050, MD070, TE020) • Developed and customized of Reports using Discoverer Desktop according to the client's specifications and requirements.
Worked on UNIX & Shell Scripting.
Good working experience with PVCS, Kintana, Dollar Universe and Quality Center.
Download and Upload the objects from one instance to another instance through LDT's.
Overview
17
17
years of professional experience
1
1
Certification
Work History
Technology Architect
Infosys Ltd
01.2020 - Current
Implements improved process flows, newly create, or restructures pre-existing reports, educate users to streamline the process
Ensured that all orders have a positive lead-time and appropriate order processing procedures are followed for rush orders
Managed the service side of customer relationships including escalation, implementation, and execution of carrier EDI on boarding
Conducted regularly scheduled status calls with the customer to discuss significant service topics and to review available service offerings
Efficiently processed orders received via, EDI, customer net and from other integration's in order to ensure on-time delivery to customer locations
Coordinated status of all orders with sales and prepared RFPs, promotional material to secure new business and up-sell existing accounts
Coordinates and enhances the production tracking processes; build strong relationships with business users
Developed the BI report to identify the duplicate orders and send a mail to specific DL
Customization on applying the new "incorrect ship method" hold for dotcom orders
Developed a form personalization to restrict user to do not enter any special characters when entering a tracking number
Oracle Financial Techno Functional Lead
Accenture LLP
03.2016 - 12.2019
Developed a program to identity the Accounting Issues and send a mail to Biz users
Modified the GL Daily Rates program to improve the performance from 15 hrs to 10mins
Created a new report to identify the Revaluation formula
Enabled to fetch the location based on the transaction accounting segments
Developed a program to identify the difference between Sub Ledger and GL
Identify the GAPS between SLA and GL for the impacted transaction and do the required changes in Production to clear all open transactions
Designed and defined the Subledger setups for India entities
Customized the Journal Copy and Supplier Copy programs logic as per the business requirement
Primary task is to work on Production incidents raised by business users (called as Remedy Incidents or Cases or Tickets) and provide resolution as per agreed support timelines
Regular sync up with Business and leads on weekly basis to discuss on on-going priority issues, status and problems/issues business team is facing with application
Pro-actively identifying gaps in the system or business process (if any) and working towards implementing LTF (Long Term Fix)
Pro-active checking for smooth books closure for every Month End or Quarter End or Year End
Handling CCB (Change Control Board) Meeting to evaluate all fixes going into Production to make sure existing functionality will not be broke
Helped user to reconcile the AP and PO recon process Helped user to reconcile the APTB and GLTB issues Working on the Enhancement requests Monitoring the schedule the jobs through Tidal Schedular tool and taking appropriate action on the same
Handling Month End/Quarter End/Year End close activities and issues
Co-ordinating with Oracle and working on getting the bug fixes on the seeded application issues
Publishing the weekly status report (WSR) and Quarterly Base Review (QBR) to the clients
Oracle Financial Techno Functional Lead
Accenture Services Pvt Ltd
03.2013 - 03.2016
Developed a Unix program to compare job statuses before Ramp Down and after Ramp Up
Customization of Supplier Invoice Account Generation Process
Regular sync up with Business and leads on weekly basis to discuss on on-going priority issues, status and problems/issues business team is facing with application
Pro-actively identifying gaps in the system or business process (if any) and working towards implementing LTF (Long Term Fix)
Pro-active checking for smooth books closure for every Month End or Quarter End or Year End
Managing offshore team and helped team based on the need
Working on the incidents related to all financial modules
Working on the Enhancement requests
Monitoring the schedule the jobs through Dollar Universe tool and taking appropriate action on the same.
Developer And Offshore Lead
Accenture Services Pvt Ltd
09.2011 - 07.2013
Developed a custom PL/SQL concurrent programs to load Daily Conversion Rates into GL
EUR to other currencies as per Italy Legal Requirements BRL to other currencies as per Brazil legal requirements
Program is having each setup workflow as parameter and user will give the CSV file name as parameter
Program takes data from those CSV Files from server and creates the setups in the system
Created Oracle Alerts to sends notification/mail reminders to requestors in case of any invoices are on Quantity Ordered Holds
Creating AP invoices through XML file
Developed custom reports in Oracle General Ledger that gives a listing of all accounts balances according to the financial calendar
Customization on AP and GL Intercompany program as per the business requirement
Created Technical Design Documents (MD070) and Testing Documents (TE020) as per AIM
Created Supplier Site Interface load Supplier Sites from One operating unit to another operating unit
Implemented Payments Setup for 40 Operating Units (Unified Payments Process - Cisco custom process to make payments setup easy and common across all countries except the data)
Created new Separate Remittance Advice Templates, modified Payment Format RTF Templates as per country requirements.
Team Member
Genpact India Pvt Ltd
08.2010 - 09.2011
Development of Packages
Customization of Resale Batch Processing Workflow
Developed a custom program to load the PO data (PO Conversion) from data file to Oracle
Developed a Credit Card Payment Report
Worked on AR Customer Statement Report
Worked on UPS Routing Codes Conversion through Shell Script
Prepared a Technical Document and review the code
Prepared Unit test scripts
Download and Upload the objects from one instance to another instance through ldt's
Worked on TM Conversions through WEBADI.
Team Member
Trianz Consulting Pvt Ltd
04.2010 - 08.2010
Development and customization of Reports and Packages
Defined a Concurrent Programs, Executables, Value Sets
Developed a Oracle triggers based on business need
Download and Upload the objects from one instance to another instance through ldt's
Worked on Enhancement Requests.
Team Member
Trianz Consulting Pvt Ltd
09.2009 - 04.2010
Developed Discoverer Plus Reports and Packages
Defined the Concurrent Programs, Executables
Created Database triggers
Prepared Technical Documents and setup document
Created custom tables and custom views
Download and Upload the objects from one instance to another instance through ldt's
Import and Export the .eex files from one instance to another instance
Developed a Commission Extract Package.
Team Member
Trianz Consulting Pvt Ltd
11.2008 - 08.2009
Defined Concurrent Programs, Executables
PL/SQL method of submitting Concurrent programs
Created Database triggers as per requirement
Customized on of Leave of Absence Workflow
Customized the XML Reports as per requirement
Registered Oracle reports in Oracle 11i applications.
Team Member
SATYAMComputer Services Pvt Ltd
01.2008 - 07.2008
Developed of CHECK prints and Payment Batch report
Defined Concurrent Programs, Executables, value sets, DFF, KFF
PL/SQL method of submitting Concurrent programs
Registered Oracle reports in ERP application Prepared documents as per standards
Developed Inbound Invoice Interface on AP, by using SQL
LOADER program transfer the data from flat file to staging table
LOADER program and written PL/SQL package for validations
To import the data from flat file to Oracle Base tables.
Team Member
Trianz Consulting Pvt Ltd, Hyderabad, Telangana
09.2006 - 08.2007
Defined Concurrent Programs, Executables
PL/SQL method of submitting Concurrent programs
Created Database triggers as per requirement
Customized on of Leave of Absence Workflow
Customized the XML Reports as per requirement
Registered Oracle reports in Oracle 11i applications.
Team Member
HCL Technologies
08.2006 - 08.2007
Customized AR Invoice and Pick Slip report
Developed a wrapper program to pick the correct country template based on transaction type
Created 12 XML Templates to print AR Invoice
Developed Oracle Reports and Packages
Developed a package for dynamically selecting the template
Download and Upload the objects from one instance to another instance through ldt's
Involved in preparing all Technical and Installation documents as per Standards
Registered a Custom Applications, Concurrent Programs, Tables
Defined Data Groups, Menu and Request Set
Defined responsibilities and assigning them to users
Defined Concurrent Programs, Value Sets and Executables
Developed Inventory on hand balance conversion program.
Education
Master of Computer Applications - Computer Applications
Jawaharlal Nehru Technological University
Skills
Oracle Applications 11i
R12
Oracle Cloud Financials
OIC (Oracle Integration Cloud)
Oracle Financials (AP, FA, CM, GL, AR, TM etc) and Supply Chain OM, Shipping and PO