Oracle Engineer
Resume:
Jhansi Swarna
*********@*****.***
Experience Summary:
. Over 5 plus years of experience in application management comprising
of Oracle PL/SQL, SQL, Oracle Data Integrator, UNIX Shell Scripting,
EDI, Oracle Transportation Management, Oracle SOA BPEL, Oracle Reports
and Core Java.
. Extensive Experience in writing complex SQL, performance tuning and
PL/ SQL statements to meet business needs.
. Expertise in writing Database Triggers, Packages, Procedures and
Functions.
. Experience in Oracle Data Migration Utilities like SQL*Loader, ODI.
. Have been active contributor in the area of service improvements to
the end client.
. Good Knowledge in Full Life Cycle Development of building a business
application inclusive of analysis, document, design, development and
testing.
. Exposure to client interaction and user-requirement analysis.
. Expertise in developing business applications using Oracle 8i, Oracle
9i, Oracle 10 g, Developers 6i (Forms 6i & Reports 6i), XMLs, Oracle
SOA BPEL and ODI.
. Have developed complex reports in OTM using Oracle reports builder.
. Strong project orientation with excellent team involvement.
. Team player with effective interpersonal communication and exceptional
analytical and problem solving skills.
. Good communication and interpersonal skills with good analytic power.
Technical Skill-set Summary:
Technology Experience
Application Servers & Web Servers Oracle Application Server, Apache
Tomcat,Weblogic
Oracle Fusion Middleware SOA Suite 10.1.3.x/11.1.2
EAI/SOA
Oracle Fusion - Oracle Application
Server 10g, Web Logic,, Oracle AS
Adapters( File, Oracle Ebusiness
Suite, File, JMS, AQ), Oracle SOA
Suite 10.1.3, BPEL, ESB, Web Services
Manager
BPEL/BPMN
Oracle BPEL and Workflow
B2B - EDI-X12
Oracle B2B
Oracle data Integrator ODI 11g
EAI Products Oracle Fusion Middleware, Axway
Integration Broker
Databases and Related API Oracle, Informix, PL/SQL, SQL
Programming Languages C, JAVA/J2EE, JSP, HTML, XML, XSLT,
BPEL, Basic knowledge in Python,
PL/SQL, Servlets, JavaScript, pl/sql,
XIB (Axway Integration Broker)
XML XML, XSD, XSL, DTD, DOM and SAX
parser API
SOAP and Web services WSDL, SOAP, UDDI Registry
GUI Technologies HTML, Java Script,JSP
Other Tools Toad 9.0, JDeveloper 10.1, Oxygen
9.0(xml editor), Oracle Data
Integrator ODI 11g, Oracle SQL
Developer 1.0.0.15, VSS, ODI (Oracle
data Integrator 11g), Oracle Reports
builder,XML publisher
Operating Systems Solaris, HP-UX, Linux (Red Hat),
Windows
Project: Fusion Applications product development
Sep'10-Feb'11
Role: Oracle ODI developer
Client: Oracle Corporation
Oracle Corporation has been developing a product Fusion Applications by
combining the best of breed qualities from the Oracle Applications E-
business Suite, Siebel and PeopleSoft. The client who is planning to
implement fusion apps need to first migrate all the meta data and the
transactional data from their current system to the Fusion applications
using the Migration pack which is a part of Fusion Apps.This project
involves development of the Data Migration pack from Oracle E-Business
Suite projects module to Fusion Apps Projects module.
Responsibilities:
* Understand the business requirement for migration of the data from EBS
to Fusion Apps.
* Create the Functional design document and the technical design
documents.
* Using Oracle Data Integrator 11g the migration was implemented.
* I have given the design for Resource Break down Structure migration to
the Fusion apps.
* Have developed complex staging tables to handle hybrid migrations
* Designed and developed several ODI Packages, Interfaces and scenarios.
Developed PL/SQL procedures.
* Have implemented ODI orchestration.
* Have gained a very good understanding of the Knowledge modules in the
ODI.
* Followed the error handling mechanism Oracle Diagnostic Framework ODF
proposed by the Oracle Corporation.
Environment:
Functional Oracle Projects module, Fusion Apps projects module.
Modules
Oracle Oracle data Integrator ODI 11g,Oracle PL/SQL,SQL 10g,SQL
Technologies Developer
Database Oracle 10g Enterprise Edition
Operating Linux/UNIX, Windows
Systems
Project: IKONOTMI - Integrating OTM with EBS & B2B for Planning and execution
of orders.
Feb'08-Aug'10
Role: Sr. Systems Engineer
Client: IKON
Oracle Transportation Management(OTM) provides a robust
transportation planning and execution capabilities to shippers and third
party logistics providers. The Order Created in E-Business Suite is
interfaced with OTM for planning and execution. The EDI files from B2B
server is interfaced to OTM for creating shipments and invoices in OTM.
Responsibilities:
* I was responsible for coding, testing, UAT & Production support and
bug fixing of the OTM deliverables.
* I was also involved in the preparation of high level technical design
document MD 70, installation document, test cases preparation T20 and
test data setup in OTM.
* I have developed an interface to integrate the Purchase Order
Shipments in the Order Management module of E-Business Suite to OTM
shipments using Oracle SOA Bpel 10g and Oracle PL/SQL,SQL,SQL
performance tuning.
* Involved in planning EBS orders to OTM shipments.
* I have also developed an Outbound Interface to interface all the
Vouchers create in OTM with AR and AR modules in the E-Business suite.
This involves developing complex PL/SQL procedures to extract huge
data from EBS OM module.
* I was involved in integration of the B2B EDI 214 Shipment status file
to create and update shipments in OTM using Oracle SOA 10g Bpel, XSLT
and Pl/sql.
* I was also responsible for integrating EDI 210 Invoice files coming
from various service providers DHL, UPS and FEDEX with OTM to create
invoices in OTM.
* I was able to handle all the PL/SQL and BPEL performance issues due
to the huge incoming data while integrating with OTM.
* I have been involved in creating Agents, saved queries in OTM and the
OTM reports. Have done trading partner set up in B2B for various
service providers.
Interfaces Developed Using Oracle SOA:
* OTM to EBS Interface for AP Invoice Creation
* EDI 214 to OTM Shipment Creation for UPS
* EDI 210 to OTM Shipment Creation for UPS.
* OTM to UPS Rating.
* Handled all the reports
* Handled Generic Error Handling.
Environment:
Functional Oracle Apps Order Management, Account receivables and
Modules account payables
modules, Oracle Transportation management Order management,
Shipments,Invoice and Voucher modules,B2b EDI X12
214,204,990,210,110.
Oracle Oracle PL/SQL,SQL, Oracle SOA 10g BPEL, Web Services, xml,
Technologies xsl, XSLT, Oracle, Oracle 10g Reports,Oracle SOA Suite
(10.1.3.1.0), Apache Tomcat 5.0, Oracle B2B application
server.
Database Oracle 10g Enterprise Edition
Operating Linux/UNIX, Windows
Systems
Project: MOTOTLDEV
June'07-Jan '08
Role: Sr. Systems Engineer
Client: Motorola
This project involves Oracle Time and Labor layout customizations in the
projects module in the E-Business Suite 11.5.The client has come up with a
requirement to display all the projects that comes under the user that has
signed in and in order to meet these requirements, we have customized the
ldt files and Java files.
Responsibilities:
* Understand the business requirement for customizing the Oracle Apps
projects module UI.
* Create the Functional design document, technical design documents, and
test scenarios to test the customizations in the User Inteface.
* Have been exposed to the Oracle Apps 11.5 and EBS Projects OTL data
model.
* Customized the ldt files,PL/SQL procedures and java files to meet the
business requirements.
Environment:
Functional Oracle Projects module, Fusion Apps projects module.
Modules
Oracle Oracle ldt customizations,Oracle Pl/sql,SQL Java and xml
Technologies
Database Oracle 10g Enterprise Edition
Operating Linux/UNIX, Windows
Systems
Project: DHLACG01
Dec '06-May'07
Role: Systems Engineer
Client: DHL
Ecommerce Gateway involves migration of DCON backend services (GAS) to the
same architecture as DCS. The systems worked on was, Synchrony Integrator
formerly known as Axway Integration Broker (XIB) and Informix.
Responsibilities:
* Understand the business requirement for migrating Generic Application
server GAS to DCS.
* Create the Functional design document, technical design documents,
and test scenarios to test the customizations in the DHL User
Interface.
* Responsible for the technical design, coding, testing, UAT support and
bug fixing.
* Involved in preparation detailed design document, high level technical
design document, deployment guide, test cases preparation and test
data setup.
* Have been trained by the DHL for 1and half months to gain the
logistics domain expertise
Environment:
Functional Order Management,shipment
Modules
Technologies Oracle PL/SQL, SQL, Axway Integration broker, make files
Database Oracle 10g Enterprise Edition, INFORMIX
Operating Linux/UNIX, Windows
Systems
Project: SBOTM01
July '05-Nov'06
Role: Systems Engineer
Client: Star Bucks
This project handles OTM planning and execution through integration of
Sales orders to OTM Shipments. Have worked thoroughly in the functional and
technical concepts & design of OTM (Oracle Transportation Management),
BPEL. Integrated OTM with other legacy systems (like EBS, B2B, OMS, etc.).
Responsibilities:
* Involved in coding, testing, UAT & Production support and bug fixing
of the OTM deliverables.
* I was also involved in the preparation of high level technical design
document MD 70, installation document, test cases preparation T20 and
test data setup in OTM.
* I have developed an interface to integrate the sales Order Shipments
in the Order Management module of E-Business Suite to OTM shipments
using Oracle SOA Bpel 10g and Oracle PL/SQL,SQL
* I was able to handle all the performance issues due to the huge
incoming data while integrating with OTM.
* I have been involved in creating Agents, saved queries in OTM and the
OTM reports.
Environment:
Functional Oracle Apps Order Management, OTM orders and planned
Modules shipments.
Technologies Oracle PL/SQL,SQL,Java, Oracle SOA BPEL, Web Services,
xml, xsl
Database jdeveloper 10.1, Oxygen 9.0(xml editor), Toad 9.0
Operating Linux/UNIX, Windows
Systems
Training:
Infosys Training on Oracle, Java, J2EE- May 2005-July 2005
Project Details
Contact this candidate