Oracle Engineer
Resume:
K OTESWARA RAO
Email: **********.****@*****.***
Mobile: 096-***-***-**
S umma ry
Around 8 Years of Experience as an O racle Applications T echnical
Consultant .
Technical Expertise to provide expert consultancy on Implementation,
M igration, In tegration of G L, AR, AP, OM, PO, I NV, BOM,CZ and ENG
( Financial, D istribution and Manufactu ring) Modules in Oracle
A pplications.
Having good knowledge about O rder to Cash (O2C), P rocure to Pay
( P2P) life cycles, T rading Community Architecture (TCA), O racle
Configurator ( CZ), AOL, System Admin, Coding Standa rds and AP I’s
i n Oracle applications.
Well versed in developing R ICEW Components ( Reports, Conversions,
I n te rface, Extensions and Workflow) .
Involved in Development of N ew Reports and Customization of Reports
f rom Various modules.
Experienced in Development of Conversions and I n te rfaces to validate
and load data from legacy and feeder system to Oracle applications.
Involved in Development of N ew Forms, Customization of Forms using
C ustom.pll and F orm Personalization f rom various modules.
Experienced in Development of Oracle Middleware SOA10g Components
developing and deploying B PEL, J Developer, SOAP, WSDL, XM L, XSL,
XSD P rocesses using technology adapters ( D B Adapter, F ile Adapter and
F TP Adapter), Using with different activities.
Having good experience in D evelopment & Customization of
OAFramework pages
Proficient in Programming Using P L/SQL, Forms 6i/10g, Reports 6i, XM L
P ublisher, Oracle Alerts, Oracle Workflow Builder, Oracle 9i/10g,
J Developer and Experience in Importing and Exporting Information into
O racle Applications through S QL* Loader and U T L_F I LE .
Efficient in Understanding the C lient Requi rements, Expert in A nalysis
t he requirements and having onsite T rouble Shooting.
Good Exposure to Oracle Application Implementation Methodology ( A I M) .
As a M anager handling team of 15 (FTE/FTC) people on various projects.
E ducation
B.Tech in Information Technology from Nagarjuna University, Andhra
P radesh.
Technical Skills
ERP – O racle Apps Technical F in ancia ls,
D istr ibutions and M FG
Apps Modules – G L, AR, AP, OM, PO, I NV, BOM, CZ and
E NG
Operating System – W indows XP/2000 and U N I X
L anguage – P l/SQL, Core JAVA and Shell
Scripting
2
Softwa re Used – E -Business Suite 11i/R12, SQL Loader,
Reports & Forms 6i / 10g, XML Publisher
5.5, Jdeveloper 9i/10g and Workflow 2.6
P rofessional Experience
Currently working as L ead Technical i n Schneider Electr ic f rom M ay-10
– T ill date .
Worked as a Senior Softwa re Engineer i n L & T I nfotech f rom N ov-09 –
A pr-10.
Worked as an Associate Consultant i n K P I T Cummins I nfosystems Ltd
f rom A ug-07 – Sep-09 .
Worked as a Software Engineer i n Covansys ( India) P r ivate Limited,
B angalore f rom J un-05 t o Aug-07.
Achievements
Received twice extra miler awards in Schneider Electric for excellent
performance.
Received PAT on the back award in Schneider Electric for support the team in
key issues.
Received Best Performance Award in KPIT Cummins for reaching beyond
expectation from client.
O nsite Experience
Traveled to United States of America and Mexico for various projects and
related workshops, t rainings.
P roject I R12 Upgradation
D escription
P roject Deals with upgradation of Oracle Applications 11i version to
Oracle Applications R12.
Total project has been divided into 2 phases.
1. Retrofit all the custom objects.
2. Transformation of Standard functionality available in R12.
Roles and Responsibilities
• Handling the team strength of 4 people on this project.
• Prepared CML I list for all custom objects based on integration process.
• Analyzing various integration processes with Legacy systems like
I n touch, Edifixio, Sabrix, ReadSoft, CMS, WMS, OTM, ASCP and
Websphere.
• Made small product to retrofit all custom objects to R12.
• Involved in project management meetings and vendor meetings for
T ransformation.
P roject I I My Schneider (MySE)
D escription
MySE is a global platform for all the customers to access their data
f rom different business applications. Edifixio application data f lows from
d ifferent sources and oracle application is the one of the source for MySE.
1. Synchronous Process (Java and Oracle Web services).
2. Asynchronous Process (PL/SQL programs process the data to
oracle staging table and Websphere middleware process same to
edifixio).
R oles and Responsibilities
• Developed Outbound In terfaces to t ransfer orders, invoices, returns
and product data to edifixio platform through IBM websphere
m iddleware platform.
4
• Developed different oracle Java Web services (Shipping, Pricing and
packing) and PL/SQL web services to sent data Sync to Edifixio
p latform .
• Sending Invoice PDF files from oracle to Edifixio user email id’s with
d ifferent language text through Web service .
• Extensively utilized UTL_FILE, shell scripting (sendmail and m ailx)
to send the emails to different regions customers.
• Extensively utilized UTL_HTTP feature to consume the websphere
Web service.
• Preparing the MD070 and MD0120 Documents after completion of the
component.
• Bug t racking and update the resolved defects using Quality center tool.
• Used Clearcase as a version control tool to update and promote the
changes in project.
• Actively participated and provided feedback in a constructive and
i nsightful manner during daily Stand up meetings and weekly
I terative review meetings to t rack the progress for each i terative cycle
and figure out the issues.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
P roject I I I Manufactu ring Execution System (MES)
D escription
ITAC is a thi rd party tool used to maintain the MES process in
Schneider Electric. BPEL service is used to t ransfer the data (WIP, BOM and
I nventory) from oracle applications to different ITAC instances by using End
Point Reference Concept and get the status from different ITAC instances to
O racle Business system through BPEL service.
R oles and Responsibilities
• Developed inbound and Outbound (BPEL Synchronous and
Asynchronous) to send the data from oracle to I tac and I tac to Oracle.
• Extensively used DB Adapters to connect the Oracle to I tac and I tac to
O racle.
• Created Connection pools, Data Sources and JNDI Connection Factory
to use same in Database Adapters.
• Creation of complex Transformation files (.xsl) or Mapper files.
• Actively participated and provided feedback in a constructive and
i nsightful manner during daily Stand up meetings and weekly
I terative review meetings to t rack the progress for each i terative cycle
and figure out the issues.
P roject I V GCOA Data M igration
Description
Project Deals with the migration of data from 3old operating units
to newly created OUs of all modules, complete P2P and O2C cycles including
W MS, OTM, ASCP modules.
R oles and Responsibilities
• Developed Conversions, Inbound and out bound interfaces between
d ifferent legacy systems and Oracle Apps.
• Created a custom workflow sub-process in OM Order Header to send
approve notifications to group of people when the booked order whose
total amount exceeds certain amount of limit.
• Involved in development of new Reports and customizing the existing
reports as per client requirement usin g XML Publisher/Reports 6i.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Extensively utilized the UTL_FILE features to create
i nbound/outbound interfaces and optimization techniques.
P roject V Credit Management System – FAST CUSTO MER SETUP
6
D escription
As Oracle does not have any built in functionality for the customer
approval process, Business has decided to use the Credit Management system
as a web technology wherein it has layout for fast customer setup by entering
t he details of customer and undergoing the customer approval process. All the
approved customers have to be t r iggered to Oracle ERP via middleware.
• User can keep t rack of the credit history of each customer.
• Switch the map between CMS and Oracle through middleware
technology (websphere).
• Revalidate the unapproved customer details and undergo for
evaluation through oracle ERP
R oles and Responsibilities
• Creation of OAF search pages and drill down pages for the unapproved
customers for detailed information allowing to update the data in the
pages and resubmit i t for t r iggering of plsql packages.
• Developed Conversions, Inbound and out bound interfaces between
d ifferent legacy systems and Oracle Apps.
• Involved in development of new Reports and customizing the existing
reports as per client requirement using X ML Publisher/Reports 6i.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Extensively utilized the UTL_FILE features to create
i nbound/outbound interfaces and optimization techniques.
• Handled various remedy tickets raised by the users and resolving them
according to SLA.
P roject V I Flowserve
C lient Flowserve Corporation, US
D u ration Nov 09 to Apr 10
Description
Flowserve is a leading manufacturer and aftermarket service
p rovider of f low control products and services for the world's most critical
applications.
R oles and Responsibilities
• Developed Conversions, Inbound and out bound interfaces between
d ifferent legacy systems and Oracle Apps.
• Involved in development of new Reports and customizing the existing
reports as per client requirement using X ML Publisher/Reports 6i.
• Involved in development of New Forms, Form Personalization’s and
form customization using custom.pll as per client requirement.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Developed Alerts on different Tables as per
r equirement.
• Extensively utilized the UTL_FILE features to create
i nbound/outbound interfaces and optimization techniques.
• Involved in interacting with the onsite coordinator.
P roject V I I Cummins P GBU R12 I mplementation.
C lient C ummins I nc. USA
D u ration Oct 08 to Sep 09
Description
Cummins Power Generation is a world leader in the design and
manufacture of power generation equipment, including PowerCommand
8
s tandby and prime power systems. To fulfill the day to day business needs i t
has implemented Oracle Applications R12. KPIT and Cummins Inc. have
collaboration for Oracle Apps implementation on Cummins worldwide BU.
R oles and Responsibilities
• Developed Conversions, Inbound and out bound interfaces between
d ifferent legacy systems and Oracle Apps.
• Involved in development of new Reports and customizing the existing
reports as per client requirement using X ML Publisher/Reports 6i.
• Involved in development of New Forms, Form Personalization’s and
form customization using custom.pll as per client requirement.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Developed Alerts on different Tables as per
r equirement.
• Extensively utilized the UTL_FILE features to create
i nbound/outbound interfaces and optimization techniques.
• Post implementation support and knowledge t ransfer.
P roject V I I I Cummins T TBU 11i I mplementation.
C lient Cummins I nc. U K
Du ration Aug 07 to Sep 08
Description
Cummins Turbo Technologies has been designing turbochargers
s ince 1960 and the company has established a t rack record for reliability
i ncluding being the fi rst to market the Variable Geometry Turbine (VGT)
t u rbocharger for heavy-duty diesel engines.
R oles and Responsibilities
• Developed Conversions, Inbound and out bound interfaces between
d ifferent legacy systems and Oracle Apps.
• Involved in development of new Reports.
• Worked On XML Publisher.
• Involved in development of New Forms, Form Personalization’s.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Developed Alerts on different Tables.
• Extensively utilized the UTL_FILE features to create
i nbound/outbound interfaces and optimization techniques.
• Post implementation support and knowledge t ransfer.
P roject I X V MSi
Client Ventana Medical Systems (U.S)
Du ration N ov-06 to Aug-07
Description
Ventana Medical is the world’s leading supplier of automated
d iagnostic systems to the anatomical pathology market. I t has Customers
spread all over the world. To deal with the business activities i t has
i mplemented Oracle Applications 11i.
Roles and Responsibilities
• Developed I nbound and out bound I nterfaces between
d ifferent legacy systems and Or acle Apps.
• Developed Outbound I nterfaces by using SQL * Loader,
U T L_F ILE util ities in Or acle.
• Involved in Development of New Reports .
• Worked on Form Extension and Customizations.
10
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Preparing the CV60, MD070 and MD0120 Documents after completion
of the component.
• Post implementation support and knowledge t ransfer.
P roject X SATO M igration
Client SATO (U.K)
Du ration F eb-06 to Oct-06
Description
SATO Corporation is a public listed company in Japan, which was
founded in 1940.SATO, also developed the innovative printer capable of
p rinting barcodes and OCR characters.
R oles and Responsibilities
• Worked on In terfaces.
• Worked on development of new reports.
• Worked on Form Extension and Customizations.
• Extensively utilized the application object library to register SQL *
L OADER programs, shell scripts, PL/SQL procedures, forms and
reports.
• Preparing the MD070, MD0120 and CV60 Documents after completion
of the component.
Contact this candidate