Praveen Zakkam

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 6

PRAVEEN ZAKKAM

Objective:

To be a part of an organization that uses my skills and expertise in its process of growth and change, while
giving me ample opportunity to learn and enrich my competencies in my chosen line and to contribute

Professional Summary:

 Having 5 +years of experience with analysis, design, development and implementation of business
requirements through direct interaction with the customers in Oracle Applications.
 Technically involved in modules (OM, AR, INV, PO and AP).
 Possess strong SQL, PL/SQL, Reports, and interfaces.
 Expert in extracting data from Legacy Systems to Oracle Applications modules.
 Having good Exposure to O2C Process, P2P and RICE Components.
 Good Exposure on label reports (Codesoft / Sentinel).
 Good Exposure on Data Loader Classic and Professional.
 Expertise on development of Interfaces, Conversions, Reports.
 Having good exposure on development of XML Publisher Reports include Sub Templates and
Bursting.
 Expertise in development of PL/SQL Stored Procedures, SQL*Loader.
 Expertise in Creation of Value Sets and Concurrent Programs.
 Expertise on usage of oracle tools and other Utilities like TOAD, SQL*Plus, WinScp, UTL_Files and
SQL * Loader.
 Good Knowledge on PANAYA tool.

Professional Experience:

 Worked as Technical Analyst at Eaton Technologies from Sep ‘08 to March ‘14.

Education:

 Master of Computer Applications from Osmania University 2006.

Technical Portfolio:

 ERP : Oracle Applications 11i.


 Data Base : Oracle 8i/9i.
 Languages : SQL, PLSQL.
 Tools/Utilities : FTP, SQL*Plus, Putty, TOAD, Clearcase.
 GUI Tools : Developer 2000 (Reports 9i).
 Deployment Tool : Kintana (PPM).
 Operating Systems : Windows 2000/XP.

Project# 1:

Project ES Oracle Managed Services Production Request Backlog Reduction


Client Eaton
Role Technical Lead
Duration October ‘13 – March ‘14.
Environment ERP : Oracle Applications11i.
Technologies : Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 4

Description:
This project is to be used to track the work and outline the estimation process for Remedy
tickets being transferred from the Oracle Managed Services team to the global Oracle Apps Dev Teams in
the Electrical Sector. Only Requests are being transferred (not incidents). Each transferred Request should
be reviewed and estimated by the assigned developer. There will be a project manager coordinating all
requests with the Oracle Managed Services team who will approve the transfer of all tickets and also
maintain this Project using standard PROLaunch Methodology.

Responsibilities:

 Handled various tickets on Report Customizations.


 Involved for Business Requirement to the customers.
 Assigned tickets to Development team.
 Helping to team on estimation hours for various tickets.
 Involved in peer review of the development.
 Involved in the development of Functional and Technical documentations.

Project# 2:

Project Australia Manufacturing Footprint Consolidation


Client Eaton
Role Technical Lead
Duration April ‘13 – October ‘13.
Environment ERP : Oracle Applications11i.
Technologies : Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 7
Description:
Consolidate the Manufacturing operation into Mascot from Scoresby.

Responsibilities:

 Involved for Business Requirement to the customer.


 Extract the data for BOM, Routing, Approved Supplier List.
 Extract the data for Default Receiving Sub Inventory.
 Loaded New Sourcing Rule for Mascot Inventory Org.
 Loaded Completion Sub Inventory and Locator for Routing through Data Loader Classic.
 Deleted the data for Sourcing Rule for Scoresby Inventory Organization.
 Data Loaded for BOM, Routing and ASL into Production through Data Conversions programs.
 Data Loaded for Sourcing Rule through Classic Data Loader .
 Worked on XML Publisher Reports.

Project# 3:

Project Penang GV migration to Oracle ECP (OM & AR)


Client Eaton
Role Technical Lead
Duration Nov ‘12 – April ‘ 13.
Environment ERP : Oracle Applications11i.
Technologies : Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 10

Description:
Currently Penang site is using a combination of Global Vista & Oracle ECP as their ERP. The
goal of the project is to do away with Global Vista and use Oracle ECP for their Order Management
module. This will eliminate problems due to interfacing errors between GV & Oracle, as well as
maintenance of two systems.

Responsibilities:

 Involved for Business Requirement to the Customer.


 Preparation Functional Design Document (FDD) and Technical Design Document (TDD).
 Involved in development of customer facing reports using reports 6i and XML publisher based on
business requirements and registered them in Oracle applications.
 Involved financial integration to send data from EBS (Eaton Business System) to ISSC (Shared
Service Center).
 Working with testing team and conducting complete testing of the Issue and developing according
to the standards.
 Responsible for internal review of code and Unit test.
 Using Codesoft and Sentinel to create the Label report as per requirement.
 Resolving various issues which got raised in different steps of the development.

Project# 4:

Project Oracle Enhancements for Australia - Release 1


Client Eaton
Role Team Member
Duration Sep ‘11 – Nov ‘12.
Environment ERP : Oracle Applications11i.
Technologies : Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 3

Description:
This project is to implement Oracle Enhancements for ES Australia. This project comprises
changes for Finance, Purchasing related and Order Management related:

Responsibilities:

 Involving for business requirement to the customers.


 Preparation Functional Design Document (FDD).
 Involved in development of reports using reports 6i and XML publisher based on business
requirements and registered them in Oracle applications.
 Worked on EU9B reconciliation report email.
 Net Price Upload Solution for Sales Team
 Automatic email of Sales Order Acknowledgement to customers
 Involved in development for Label Report using Codesoft /Sentinel.

Project# 5:

Project ECP Oracle New Zealand


Client Eaton
Role Team Member
Duration Jan ‘11 – Sep’11.
Environment ERP : Oracle Applications11i.
Technologies : Forms 6i and Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 12

Description:
Implementation ECP New Zealand business, the growth of this project is increase in
Revenue. The functional and process area of the projects Sales/ Order management, Oracle Application
database instances involving PO, AP, INV, OM, AR, WIP and BOM modules.

Responsibilities:

 Involving for business requirement to the customers.


 Involved in development of reports using reports 6i and XML publisher based on business
requirements and registered them in Oracle applications.
 Defined value sets, concurrent programs, request sets, registering reports and PL/SQL Procedures,
and Packages.
 Working with testing team and conducting complete testing of the Issue and developing according
to the standards.
 Performed the unit testing for the code and migrated the files through kintana tool.

Project# 6:

Project ECP Horseheads


Client Eaton
Role Team Member
Duration Jan ’10 – Feb ’11.
Environment ERP : Oracle Applications11i.
Technologies : Forms 6i and Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 15

Description

Implementation ECP (Enterprise common Platform) Oracle for the Electrical Horsehead business,
Implement Oracle Order Management, Manufacturing, and Financials and replace ForthShift, US Vista and
customized databases. The benefits of this project IT Hard Dollars Savings and functional and process area
of manufacturing.

Responsibilities

 Involved in design and development of Reports using Reports6i and Xml publisher in PO, INV, and
OM Modules and finally registered in to Oracle Apps.
 Developed various Extract programs (Outbound), which extracts data to the server from PO, AP
tables as per the business needs.
 Involved in Registering Concurrent Programs, Creating Value Sets, Request group, Data group.
 Apart from these some activities I used to do frequently are defining concurrent program, defining
DFF, value-set, request-set etc.
 Preparation Technical Documentation(MD070)
Project# 7:

Project ECP ANZ Transformer Reporting.


Client Eaton
Role Team Member
Duration Sep ‘08 – July ’10
Environment ERP : Oracle Applications11i.
Technologies : Reports 6i
Database : Oracle 9i
O/S : Windows NT/2000
Team Size 10

Description:

Implementation ECP (Enterprise common Platform) Oracle for the Electrical Australia project by
identifying, designing and developing the required reporting solution for Electrical Australia to run and
manage the business. The benefits of the project to run the compliance and functional/ process area for
electrical.

Responsibilities:

 Migrated existing object from seeded application to custom application.


 Involved in peer review of the development.
 Involved in the development of technical documentations, Release notes of reports.
 Development and customization of reports based on Customer requirements.
 Involved in sysadmin activities related to all Concurrent Processing and Programming, Custom
Application Development, System Administration, Value sets etc.

You might also like