SREEHARI

POLAPALLE

ad17mq@r.postjobfree.com

669-***-****

Louisville, KY

https://www.linkedin.com/in/s

reehari-polapalle-a6138517/

EDUCATION

Master of Computer Applications

(MCA) from Jawaharlal Nehru

Technological University

SKILLS

• Oracle Applications R12 and 11i

• Oracle Cloud Order Management and

Financials

• OIC (Oracle Integration Cloud)

• Oracle Financials (AP, FA, CM, GL,

AR, TM etc..) and Supply Chain OM,

Shipping and PO

• Oracle Workflow Builder, Reports6i

• Discoverer, XML Publisher

• SQL Loader, Toad, Sql Developer and

SSH

• SQL/PLSQL

• Dollar Universe

• JIRA, Github, Win CVS, PVCS,

Artifactory, Kintana

• HP Quality Center

CERTIFICATIONS

PROFESSIONAL SUMMARY

• Having 17+ years of good experience in Oracle Applications and have been extensively involved in Development, Customization, implementation, and Support projects.

• Having 2 years of hands-on experience in projects using Oracle Integration Cloud

• Expertise in designing and building integrations with cloud/ on premise applications using Oracle Integration Cloud (OIC)

• Good experience in Oracle Application Finance and SCM Modules, which includes AP, GL, CM, PO, PA, FA, iExpenses, SLA, AME, 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 Personalization's.

• 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 in JIRA/Github/PVCS and Kintana Infosys Ltd - Technology Architect

Louisville, KY : 01/2020 - Current

Accenture LLP - Oracle Financial

Techno Functional Lead

San Jose, CA : 03/2016 - 12/2019

WORK HISTORY

• Implements improved process flows, newly create, or restructures pre-existing reports, educate users to streamline process

• Advanced skills on OIC in-build cloud adapters (REST, SOAP)

• Ensured that all orders have a positive lead-time and appropriate order processing procedures are followed for rush orders

• Managed service side of customer relationships including escalation, implementation, and execution of carrier EDI on boarding

• Conducted regularly scheduled status calls with 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 production tracking processes; build strong relationships with business users

• Developed BI report to identify duplicate orders and send a mail to specific DL

• Customization on applying new "incorrect ship method" hold for dotcom orders

• Developed form personalization to restrict user to do not enter any special characters when entering an tracking number

• Developed program to identity Accounting Issues and send an mail to Biz users

• Modified GL Daily Rates program to improve 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 Sub-ledger 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 ME/QE/YE

• Handling CCB Meeting to evaluate all fixes going into Production to make sure existing functionality will not be broke Accenture Services Pvt Ltd - Oracle

Financial Techno Functional Lead

Hyderabad : 03/2013 - 03/2016

Accenture Services Pvt Ltd - Developer

And Offshore Lead

Hyderabad : 09/2011 - 07/2013

• 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-ordinate with Oracle and working on getting the bug fixes on the seeded application issues

• Developed GL Journal AME approval Process as per business needed.

• Developed AP Invoice AME approval Process as per business needed.

• Publishing the weekly status report (WSR) and Quarterly Base Review (QBR) to the clients

• Developed 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 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 need basis

• Working on incidents related to all financial modules

• Working on Enhancement requests

• Monitoring schedule jobs through Dollar Universe tool and taking appropriate action on same.

• Developed 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 CSV file name as parameter

• Program takes data from those CSV Files from server and creates the setups in 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 financial calendar

• Customization on AP and GL Intercompany program as per 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 data)

• Created new Separate Remittance Advice Templates, modified Payment Format RTF Templates as per country requirements. Genpact India Pvt Ltd - Team Member

Hyderabad : 08/2010 - 09/2011

Trianz Consulting Pvt Ltd - Team

Member

Hyderabad : 04/2010 - 08/2010

Trianz Consulting Pvt Ltd - Team

Member

Hyderabad : 09/2009 - 04/2010

Trianz Consulting Pvt Ltd, Team

Member Hyderabad : 11/2008 - 08/2009

SATYAMComputer Services Pvt Ltd -

Team Member

Hyderabad : 01/2008 - 07/2008

HCL Technologies - Team Member

Chennai : 08/2006 - 08/2007

• Development of Packages

• Customization of Resale Batch Processing Workflow

• Developed custom program to load PO data (PO Conversion) from data file to Oracle

• Developed Credit Card Payment Report

• Worked on AR Customer Statement Report

• Worked on UPS Routing Codes Conversion through Shell Script

• Prepared Technical Document, Unit test scripts and review code

• Download and Upload objects from one instance to another instance through ldt's

• Worked on TM Conversions through WEBADI.

• Development and customization of Reports and Packages

• Defined Concurrent Programs, Executables, Value Sets

• Developed Oracle triggers based on business need

• Download and Upload objects from one instance to another instance through ldt's

• Worked on Enhancement Requests.

• Developed Discoverer Plus Reports and Packages

• Defined Concurrent Programs, Executables

• Created Database triggers

• Prepared Technical Documents and setup document

• Created custom tables and custom views

• Download and Upload objects from one instance to another instance through ldt's

• Import and Export .eex files from one instance to another instance

• Developed Commission Extract Package.

• 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 XML Reports as per requirement

• Registered Oracle reports in Oracle 11i applications.

• 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 data from flat file to staging table

• LOADER program and written PL/SQL package for validations

• Import data from flat file to Oracle Base tables.

• Customized AR Invoice and Pick Slip report

• Developed wrapper program to pick correct country template based on transaction type

• Created 12 XML Templates to print AR Invoice

• Developed Oracle Reports and Packages

• Developed package for dynamically selecting template

• Download and Upload objects from one instance to another instance through ldt's

• Involved in preparing all Technical and Installation documents as per Standards

• Registered 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.

.

Contact this candidate