SWAPNA GOUTHAMI Mobile: +91-801*******
Oracle Apps Technical Consultant Email:
************@*****.***
[pic]
Looking forward for an opportunity in a challenging environment, where I
can utilize my experience and skills in contribution effectively to the
success of the organization and also for the improvement of my personal
skills.
Professional Experience:
. Over 3.1 years of experience in Oracle Applications and Worked
extensively in Development, Enhancement and migration projects of
Oracle Apps R12.
. Exposed towards Oracle apps modules PO, INV, OM, AP, AR, GL, PA
Modules.
. Worked on BI Publisher Reports (XML publisher).
. Extensively worked on Discoverer Reports.
. Good hands on Interfaces.
. Proficient in Oracle Technologies like SQL, PL/SQL and Developer
Reports 10g/6i.
. Had good exposure in Conversions in SCM and Financial modules.
. Proficient in writing stored procedures, Packages and functions using
SQL & PL/SQL.
. Provided instant solutions to issues which were reported in the
production instance.
. Strong knowledge in Application Object Library (AOL) module.
. Preparing Technical Documents Like MD'S
Education Details:
. Completed B.Tech from JNT University, Hyderabad in the year of 2010.
Technical Skills:
Oracle Oracle Applications R12
Applications
Reporting Tools Developer 2000,XML Publisher, Discoverer
Utilities Tools TOAD, SQL *Plus, SQL *Loader
Operating System UNIX,Windows
DBMS Packages Oracle 9i/10g.
Programming SQL, PL/SQL.
Languages
Experience Details:
* Working as a Oracle Apps Technical Consultant for Sonata Software,
Hyderabad Aug-2011 to Till Date.
* Previously Worked with NOETIX, Hyderabad from Jun-2010 to Aug-2011.
Project 3 #
Client Su-Kam
Project type Oracle Applications R12 Implementation
Organization Sonata Software
Duration May-2012 to Till Date
Modules PO,INV,OM,GL,AP,AR
Environment Oracle Applications R12, XML Publisher, Discoverer,
TOAD, Oracle 11g, PL/SQL
Role Technical Consultant
Team Size 12
Client Su-Kam, a leading manufacturer of power electronics,
Description is widely acknowledged as a pioneer in the field of
inverters in India. The company also manufactures
advanced Uninterruptible Power Supply (UPS) systems
and is the largest exporter of Power Inverters. On
the strength of its ongoing R&D initiatives, Su-Kam
is now poised to venture into a number of new,
futuristic areas like Power Protection Systems, Solar
Photovoltaic Systems, Wind Energy Systems and Hybrid
Systems
Responsibilities:
. Development and Customization of Developer Reports
. Involved in development of Conversions in GL Module
. Development of XML Publisher Reports in PO, INV module.
. Preparation of SQL Loader scripts
. Development of XML Reports.
. Registrations of Tables.
. Executing concurrent programs from PL/SQL.
. Creation of Value sets in various Modules of the application.
. PL/SQL method of submitting Concurrent programs
. Development and Customization of Reports, PL/SQL Procedures, and
Packages.
. Registering reports in Oracle Applications
. Registering forms in Oracle Applications
. Developed inbound interface to transfer data from legacy system to
oracle applications
. Developed outbound interface to extract the data from the Oracle Apps
Tables to the Flat file using UTL_File utility.
Project 2 #
Client ICOMM
Project type Oracle Applications (R12) Implementation & Support
Organization Sonata Software
Duration Aug-2011 to Apr-2012
Modules AP,AR,GL,OM
Environment Oracle Applications R12, XML Publisher,
TOAD, Oracle 10g, PL/SQL
Role Technical Consultant
Team Size 9
Client ICOMM is one of India's leading manufacturers and
Description turnkey solution providers in the diverse domains of
Telecom, Power, Defense and Solar Energy and
Infrastructure. The strength of our core competencies
has garnered us the status of the most preferred
partner to telecom giants, both in the public and
private sectors.
Responsibilities:
. Development of Developer Reports
. Customization of Existing Reports
. Developing New Conversions & Interfaces
. Involved in BI publisher(XML Publisher) Reports
. Involved in customizing and developing the Reports.
. Involved in Discoverer Reports
. Code review and testing and fixing the problems.
. Preparing Technical Designing Documents.
. Provided instant solutions to issues which were reported in the
production instance.
. Created various PL/SQL procedures/packages according to the Client
requirements.
PROJECT # 1:
Client Thermo King Corporation
Project type Oracle Applications R12 Implementation
Organization NOETIX.
Duration Jun-2010 to Aug-2011
Modules PO,INV,OM,GL,AP
Environment Oracle Applications R12, XML Publisher, Discoverer,
TOAD, Oracle 11g, PL/SQL
Role Technical Consultant
Team Size 14
Client Thermo King Corporation, based in Bloomington,
Description Minnesota and a unit of Ingersoll Rand Company
Limited, is a manufacturer of transport temperature
control systems for trucks, trailers, shipboard
containers and railway cars as well as HVAC systems
for bus, shuttle and passenger rail applications.
Thermo King also manufactures the highly successful
"TriPac" hybrid auxiliary idle reduction and
temperature management system for truck cabs.
Responsibilities:
. Development and Customization of Developer Reports
. Involved in development of Conversions in GL Module
. Development of XML Publisher Reports in PO, OM, INV module.
. Involved in Discoverer Reports
. Involved in conversions through sql * loader
. Involved in preparing documents as per standards.
. Code review and testing and fixing the problems.
. Registrations of Concurrent Programs.
. Provided instant solutions to issues which were reported in the
production instance.
[pic][pic][pic]