Thirupathi Reddy
Oracle apps Technical Consultant Mobile :91-9963421616
Email:thirupathireddy.apps@gmail.com
Experience Summary Total 3.7 Years of IT experience in and Having 3.3 Years of Experience
on OracleApps 11i, Knowledge on R12. As an Oracle apps Technical
Consultant(SCM & Finance & HRMS), I was involved in the implementation
Projects , Development and Customization of forms and reports. Worked with
concurrent programs, PL/SQL, API’s Interfaces and conversions.
In addition, my go-getting and can-do attitude has made me a key resource
at my orgnizations.
Educational Profile
B.Sc (computers) Osmania University
Professional Summary Company
Designation Duration
Delloitte Consulting, Hyderabad Technical Consultant Dec 2009
To Till date.
Tecnics Integration Hyderabad Software Engineer July 2007
To Nov 2009.
Technical Skills Platforms Windows NT , Windows 98/95/2000
Languages PL/SQL, SQL,C,C++,.Net
Tools SQL *PLUS, Forms6i, Reports6i.
Discover Reports, XML Publishers,
Toad, SQ*LOADER
RDBMS Oracle 9i/10g
GUI Tools D2K (Reports 6i,Forms 6i)
ERP Oracle Applications11i &R12 Modules: PO, OM INV
& AP, AR, GL & HRMS-Core, Payroll
Having 3.7years of IT experience in Oracle Technologies
Having 3.3 years experience in the Oracle Applications 11i
Implementation & Knowledge on R12.
Worked on XML Publishers, Discoverer.
Involved in all phases of Development, Support and Maintenance of
Oracle Apps 11i & R12 Reports 6i, Forms 6i, Conversions, Interfaces,
UTL_FILE, Extensions Conversant with Modules like
Account Payables (AP) Account Receivables (AR) General Ledger (GL)
Purchasing (PO) Inventory (INV) Order management(OM)
HRMS-Core
Good Functional Knowledge in Procure to pay & Order to cash Cycle
Possess very good communication and interpersonal skills.
Page 1 of 4
Apps Tech Experience
Project #1
Duriation : Dec-2009 to Till date
Client : ADCO,
Role : Oracle Apps Technical Consultant.
Modules Majored : PO, AP and GL,INV,OM
Environment : Oracle Applications11.5.10.2, Sql loader,
D2K and PL/SQL
Description:
ADCO acts on behalf of its shareholders to explore, develop and produce
hydrocarbons within Its area of operations. In meeting our shareholder’s
aspirations, we will operate at maximum efficiency and optimum cost with
minimum impact on the environment and we will avoid harm to people. we will
promote an environment of continuous important while maintaining the
Highest standards of honesty and integrity in all aspects of our business.
Responsibilities
Development and Enhancement of Forms and Reports.
Developed In bound Interface to transfer the data from legacy
system.
Prepared and reviewed MD070 documents based on MD050
document.
Developed and Involved in Inbound Interfaces and Conversions.
Analysis and Development of Outbound Interface programs in
Oracle SQL,PL/SQL
Defining Concurrent Programs and Executables
Adding Descriptive Flex Fields.
Involved in Workflow.
Interfaces/Conversions Developed Supplier invoice Conversion
Developed Supplier Conversion
Developed Back order Outbound Interface
Developed GL Balance Outbound Interface
Dev/Cust Reports Developed Purchase order Matching level Report
Developed GL Average Balance Report
Developed Credit Transfer Report
Customized Purchase order summary details Report
Customized Sales order Acknowledgement Report
Developed Invoice Expense Report with Accounting Flex fields
Dev/Cust Forms Customized PO Standard form to enable the Zoom functionality
and Calling the another Concurrent program
Customized item import correction form to correct error out
records from Staging table
Page 2 of 4
Project #2
Duration : Nov-08 to Nov-09.
Role : Oracle apps Technical Consultant
Client : TNT Express World Wide
Environment : Oracle Applications11.5.10.2, Sql loader,
Reports 6i, PL/SQL
Description:
TNT is a world leading provider of express delivery service.Using integrated air
and net works.TNT ensure customers documents parcels and freight or delivered
safely on Time. TNT is working Royal Thai Army to deliver food and drinking
water Maynmar.Over 100 new Electric and hybrid trucks for the UK,China&Aus.
Responsibilities
Developed Report from the scratch as per client requirements
Customization and development Interfaces. As per client requirements.
Creation of Value sets in various Modules of the application
Prepared UTC (Unit Test Cases) from various components.
Defining Concurrent Programs, Executables
PL/SQL Method of submitting Concurrent Programs
Developed interface program to Upload Journals into GL interface tables
from Legacy System in Oracle General Ledger and Used SQL * Loader to
upload data from flat files to pre_interface table and wrote a PL/SQL
procedure for all the business validations.
Dev/Cust Reports
AP Period Health check Report
Developed Reverse journal Report
Customized Recurring invoice Report
Interfaces/Conversions
Developed Material Transaction Interface
Developed Journals Open Interface
Developed Item Conversion
Dev/Cust Forms
Developed new query form to display the item attribute information
Customization of forms as per client Requirement
Developed form using Template.fmb to display purchase orders for Specific
Supplier
Customization of Forms as per client Requirement
Page 3 of 4
Project #3
Duration : july-07 to Oct-08
Client : Neenah Paper Inc, Georgia
Role : Oracle Developer.
Environment : Oracle Applications11.5.9, Sql loader,
Reports 6i, PL/SQL
Description:
Neenah Paper manufactures and distributes premium and specialty paper
grades and more than 700,000 metric tons of bleached Kraft pulp per year.
Their three primary operations are our Fine Paper, Technical Products and Pulp
businesses. The Technical Products business is a leading producer of durable,
saturated and coated base papers for a variety of end uses including tapes,
labels, abrasives, medical packaging and heat transfer papers. With customers in
over 40 countries, we are a global supplier of materials used to create customer-
specific components for original equipment manufacturer’s products.
Responsibilities
Written stored procedures, functions and triggers using PL/SQL.
Developing GUI Screens and Reports using Forms 6i and Reports 6i.
Customized menus so that the application will be menu driven easy for
navigation.
Written procedures and functions in forms to achieve functionality.
Enhancement of the application.
Perform Basic Validation Testing.
Data Conversion using SQL * Loader.
Technical designing for report customization and Written PL/SQL
packages.
Developing new reports to meet the Business requirement.
Created new and customized existing standard Oracle reports using Oracle
Reports and SQL*Plus Used Oracle Reports in most of the development.
Developed Pl/SQL Libraries, Packages, Sub Programs, Cursors.
Developed SQL Query and Oracle Reports according to the Super user
requirement
Page 4 of 4