Summary
Overview
Work History
Education
Skills
Visa Details
Education Certifications Publications
Certification
Timeline
Generic

Pradeep Kumar Poojari

Tampa

Summary

Professional with 18 years of experience in end-to-end implementations, testing, migrations, and enhancements of Oracle ERP, specializing in Finance and Distribution modules. Certified in Oracle Financials Cloud, with expertise in client/server application design and development using REST API and PL/SQL in Unix environments. Proven track record in supporting finance modules integrated with 170 Mark view systems, Sabrix, and KOFAX. Strong analytical skills and a results-driven approach to problem-solving, consistently exceeding performance expectations.

Analytical professional with technical knowledge and critical thinking skills to thrive in data-driven Fusion environments. Tackles challenges with positivity and drive to overcome. Works great alone or with others and consistently exceeds expectations.

Overview

20
20
years of professional experience
1
1
Certification

Work History

Techno Functional Lead

Citi Group
Tampa
03.2013 - Current
  • Project Overview: It is an Oracle ERP Development project in which am involving in Financial Modules. Involved in the implementation of Account Standardization, and other enhancements related to GL feed to Strategic Ledger and S2C.
  • Designed data structures for cloud integrations to ensure seamless connectivity.
  • Designed and Documented data flow for APIs in integration layer between two cloud environments.
  • Conducted research and analysis to support strategic planning and decision-making.
  • Collaborated with cross-functional teams to align project goals and meet deadlines.
  • Developed drill-down reports from assets to SLA accounting for detailed tracking.
  • Created functional and technical design documents for team collaboration on development.
  • Configured SFTP connectivity for external inbound and outbound feeds.
  • Conducted comprehensive research and data analysis to support strategic planning and informed decision-making.
  • Worked with cross-functional teams to achieve goals.
  • Identified needs of customers promptly and efficiently.
  • Collaborated closely with team members to achieve project objectives and meet deadlines.
  • Technical Design and Develop the drill down reports from the Assets to SLA accounting.
  • FRS LVID Changes in GL Feed to Strategic Ledger.
  • Working on Oracle SRs to analyze Oracle patches for standard issues, like generating asset trace errors.
  • Conducting regular Integration calls to discuss new solution design.
  • Preparing Functional and Technical design documents to work with team on development.
  • Technical Design and Developed the Package Serial number Conversion based on Vendor Feed.
  • Technical Design Using XML payload and Jason Payload in webservices for CLOUD.
  • Involved in Webservices Invoking thorough SOAP and REST APIs.
  • Prepared Technical Documentation and Developed Year End Reports in Fixed Assets.
  • Developed Investment in Property Assets Load Template.
  • Developed Fixed Assets Conversion Using Bulk Collect.
  • Involved in sftp connectivity setup for one of external inbound and outbound feed.
  • Customization of reports to accommodate the secondary ledger data to be reported.
  • Working on Archive and Purging data to increase disk space and processing response times.
  • Developed Impairment Interface to load the Impairment by using Templates.
  • Developed Global Impairment and Inv in Property Asset Detail report.
  • Developed many regulatory reports as part of Italy implementation.
  • Developed Retirement Custom API.
  • Convert the Discoverer Reports in PL/SQL Report to overcome the Performance issues.
  • Modified the Record group at PO Distributions level using Form Personalization.

TechnoFunc Consultant

Amazon
Seattle
04.2012 - 02.2013
  • Project Overview: It is an Oracle ERP R12 Implementation project for O2C and P2P. Along with the implementation, to improve the efficiency and control over receivables invoicing Amazon wants to automate entire returns process.
  • Modified SLA related Customizations to AR reports to accommodate for R12 Functionality.
  • Developed XML/Bi publisher reports by using XML data templates, which invokes PL/SQL package.
  • Bursting the XML/Bi Publisher reports to different vendors by using Bursting Functionality.
  • AMZ Load AR Vendor Returns Invoices.
  • Developed many AR Aging reports.
  • Customizing the AR Aging Reports.
  • Customized the Vendor Return custom package as per MOAC functionality.
  • Convert the Reports 6i reports in PL/SQL Report to overcome the Performance issues.
  • Automating the process of AR transaction in to AP invoice and made the AR adjustment by calling Standard APIs.
  • AMZ Customers Interface load from Vendor Returns.
  • Resolved performance issues by tuning the queries and by changing RDFs to PL/SQL pkgs.
  • Working on Aging Reports Performance issues.
  • It is an Oracle ERP R12 Implementation project for O2C and P2P. Along with the implementation, to improve the efficiency and control over receivables invoicing Amazon wants to automate entire returns process.

Techno Functional Onsite Lead

GE Energy
Albany
09.2008 - 01.2012
  • Project Overview: GE EAST Apex is a Maintenance/Support Project and Oracle EBS R12 Implementation. EAST Apex is an Oracle EBS Enhancement and Support Project where in Team is responsible for debugging/resolving all issues related to AP Responsibilities includes debugging PL/SQL code, enhancements, scheduling concurrent programs, working with Oracle SR, coordinating with Third-Parties like DBA Team, Sys Admin Team, 170 Mark view Systems and Sabrix.
  • Having co-ordination with offshore team to make sure the deliverables on time.
  • Defined new Alerts to send e-mail notifications to the business users.
  • Developed UNIX Scripts to Schedule requests/request sets whenever there is any schedule change.
  • Creating new transaction types for AME.
  • Coordinating the Month/Year End closing schedules with Business and processing teams.
  • Customized the 1099 report as per business requirements.
  • Tuning the Oracle reports which really affected the business in monthly closing.
  • Helping out in submitting the 1099 reporting to IRS.
  • Developed Fixed Assets Conversion to get the Assets import into the system.
  • Developed XML/Bi Publisher Reports by using data template instead of RDF.
  • Performed the performance tuning on Daily Invoices and PAID programs.
  • Developed New Cash Requirement Report that in turn sends an email to the business users.
  • Setting Profile values for AME.
  • Creating the Alerts on Business-critical programs.
  • Developed AP Invoice Conversion by calling Open Interface Import.
  • Customized WRICEP components as per business requirements.
  • Having control on Business-Critical Scheduled Concurrent Jobs.
  • Managing the Instance Outage windows with proper sanity checks.
  • Coordinating with Oracle on Standard AP issues.
  • Helping in closing related critical issues.
  • Guiding team time to time whenever it is required and helping them out in case of any issue/bug.
  • Interacting directly to client by conf. call and Web-ex meeting.
  • Taking the ownership of any object where it is required.
  • Taking ownership of team objects during rollout when issue or bug was on higher priority.
  • Providing guidance to the team in components like Extensive usage of XML publisher.
  • Helping to the project team while Data Migration for AP invoices.
  • Worked on Major Enhancements.
  • Created Request Set for AP invoice Interface program as well as adding one custom program.
  • Working on enhancement on some existing objects.
  • GE EAST Apex is a Maintenance/Support Project and Oracle EBS R12 Implementation. EAST Apex is an Oracle EBS Enhancement and Support Project where in Team is responsible for debugging/resolving all issues related to AP Responsibilities includes debugging PL/SQL code, enhancements, scheduling concurrent programs, working with Oracle SR, coordinating with Third-Parties like DBA Team, Sys Admin Team, 170 Mark view Systems and Sabrix.

Techno Functional Consultant

GE Infra
Hyderabad
09.2006 - 09.2008
  • Project Overview: GE Infra is a combination of GE Aviation and GE Power Systems with having around 60 Ous. This Oracle EBS project involves implementation of Distribution, Financials and Customer Services modules and integration among them.
  • Developed conversion script to convert Open Purchase Orders.
  • Developed Vendor conversion script.
  • Developed AR Customer Data Conversion by using HZ APIs to hit the destination TCA tables.
  • Prepared test cases for customized oracle reports or new reports in apps with different scenarios.
  • Prepared technical documents MD70, MD120, and MD200 for custom reports.
  • Customization of Order Holds Report.
  • Modified the Record group at PO Distributions level using Form Personalization.
  • Worked on Major customizations on WRICEP Components in various modules.
  • Developed Sales Person Basis Order Report.
  • New development of WRICEP components in AR and AP modules.
  • Guiding and preparing Shell script, LDT files MD70, MD120, and MD200.
  • Review of programming code, packages, procedures and functions.
  • Involved in testing any particular object through front end with all documentations.
  • Involved in discussion with functional consultants in case to provide feasible solution of any new requirement of client.
  • Involved in helping out my team if they have any issue or stuck up somewhere in development part, understanding of objects or any personal issues.
  • Discussed with business owners on MD50s for various Aging and Sales Order reports.
  • Involved in testing, developing reports and reviewing MD70, MD120 and MD200.
  • GE Infra is a combination of GE Aviation and GE Power Systems with having around 60 Ous. This Oracle EBS project involves implementation of Distribution, Financials and Customer Services modules and integration among them.

Onsite Lead

AlRotsamani, UAE
Dubai
12.2005 - 08.2006
  • Project Overview: AlRotsamani, UAE is an Automobile distribution business for its branded as well as used Vehicles in UAE and other Gulf countries. This project involves implementation of Oracle EBS Distribution, Financials and Retail modules.
  • Responsible for delivery for data conversion, interfaces and other customizations.
  • Using LDT files to move the objects from DEV and TEST instances to PROD by using FND LOAD.
  • Involved in project in offshore leading a team of 11 people who are involved in data conversion, oracle reports, oracle alerts, oracle workflow, oracle discoverer reports, form personalization.
  • Involved Migrating data from legacy system to Apps and resolve setup issues in case of any issue related to data conversion.
  • Involved developing some interfaces for legacy system like loading supplier on regular basis in beginning while legacy system is running parallel.
  • Reviewing data conversion scripts from extract to load.
  • Testing the data through front end after loaded data in apps instance for each conversion.
  • Performed client interaction with offshore team and having the meeting among offshore team.
  • Preparing documentation for technical document MD70 as per MD50 document given by onsite consultants.
  • Helping my team if they have any issue or stuck up somewhere in development part, understanding of objects or any personal issues.
  • Using VSS tool for maintaining version of objects in development/support phase.
  • Developed Outbound and inbound custom interfaces as per client requirement.
  • Developed many discoverer reports at the client side.
  • AlRotsamani, UAE is an Automobile distribution business for its branded as well as used Vehicles in UAE and other Gulf countries. This project involves implementation of Oracle EBS Distribution, Financials and Retail modules.

Technical Developer

GE Supply, Ireland
Hyderabad
07.2005 - 12.2005
  • Project Overview: GE, Ireland is in distribution business for its branded products of games equipment in UK, US and Europe. This project involved implementation of Oracle EBS Distribution, Financials and HRMS modules.
  • Developed Supplier Returns without PO Reference Report.
  • Developed Sales Exception Report.
  • Migrated data from 11.0.3 to 11i(9.5.10).
  • Involved reviewing data conversion scripts from extract to load.
  • Involved testing the data through front end after loaded data in 11i instance for each conversion.
  • Involved in documentation mentioning all steps that were required while loading data from extract to upload in new 11i instance for every conversion.
  • Customized preliminary payment register report.
  • Customized Final payment remittance advice.
  • Scheduling of multiple Data conversion test rounds.
  • Overall Status Reporting, Issue Resolution and handling of escalations and onsite communication.
  • Planning of go live data conversion activities.
  • GE, Ireland is in distribution business for its branded products of games equipment in UK, US and Europe. This project involved implementation of Oracle EBS Distribution, Financials and HRMS modules.

Technical Consultant

Tektronix, USA
Pune
02.2005 - 06.2005
  • Project Overview: A multi-organization implementation of Oracle Applications (EBS). This is a Re - Implementation Project. The Client Tektronix has already in Apps 10.7 but we have Re implemented the new version of 11.5.9 instead of Migrating.
  • Customization of Reports: Customized various reports in GL, AP, and AR modules. Design reports from scratch also.
  • Registration of Program: Registered reports, Procedure and SQL
  • Loader in Oracle Apps. Defined executable, Concurrent Program and attached in Request Group.
  • Customization of reports –. Defining Executable, program and adding it to a standard Request group.
  • Table Registrations: Registered Custom Table in Apps by Using ad_dd packages.
  • Developed some PL/SQL programs (procedures, functions).
  • Developed and customized more than 40 oracle reports including matrix reports in AP, OM, AR, Customer support (CRM), Planning modules.
  • Used User Profile & procedure to set printer setting for different reports.
  • Developed some new Oracle Discoverer reports in OM.
  • Customized and Designed of Reports from Scratch as well as Standard also and Registered Oracle Reports in Apps, Values Sets, Defined Executable, Concurrent Program and Request Group.
  • A multi-organization implementation of Oracle Applications (EBS). This is a Re - Implementation Project. The Client Tektronix has already in Apps 10.7 but we have Re implemented the new version of 11.5.9 instead of Migrating.

Education

M.C.A - Master of Computer Applications

J.N.T.University
01.2004

Skills

  • Oracle ERP/Fusion Modules
  • General Ledger
  • SLA
  • REST API
  • Connectors
  • Account Receivables
  • Account Payables
  • Oracle Assets
  • UNIX
  • SQL
  • PL/SQL
  • SOAP
  • AME
  • Loader
  • Inventory
  • Purchase Order
  • Order Management
  • AOL
  • Oracle Alerts
  • System Administrator
  • Application Developer
  • Developer 6i/10g (Forms & Reports)
  • Discoverer
  • XML/Bi Publisher
  • Informatica
  • Web methods
  • 170 KOFAX Systems
  • Oracle Workflow
  • BPEL
  • Linux

Visa Details

Green Card

Education Certifications Publications

M.C.A (Master of Computer Applications), 77%, 2004, J.N.T.University

Certification

  • Oracle Financials Cloud Certified

Timeline

Techno Functional Lead

Citi Group
03.2013 - Current

TechnoFunc Consultant

Amazon
04.2012 - 02.2013

Techno Functional Onsite Lead

GE Energy
09.2008 - 01.2012

Techno Functional Consultant

GE Infra
09.2006 - 09.2008

Onsite Lead

AlRotsamani, UAE
12.2005 - 08.2006

Technical Developer

GE Supply, Ireland
07.2005 - 12.2005

Technical Consultant

Tektronix, USA
02.2005 - 06.2005

M.C.A - Master of Computer Applications

J.N.T.University

Similar Profiles

CREATE PROFILE
Pradeep Kumar Poojari