SQL Developer Resume Profile

Experience Summary:

6 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 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
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, 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 Details

Confidential

Role: Oracle ODI developer / Oracle PL/SQL developer

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.
Designed and developedseveral ODI Packages, Interfaces and scenarios. Developed PL/SQL procedures.
Followed the error handling mechanism Oracle Diagnostic Framework ODF proposed by the Oracle Corporation.

Environment:

Functional Modules	Oracle Projects module, Fusion Apps projects module.
Oracle Technologies	Oracle data Integrator ODI 11g ,Oracle PL/SQL ,SQL 10g,SQL Developer
Database	Oracle 10g Enterprise Edition
Operating Systems	Linux/UNIX, Windows

Confidential

Role: Oracle SOA developer / Oracle PL/SQL developer

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 ans Oracle PL/SQL ,SQL.
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 Modules	Oracle Apps Order Management, Account receivables and account payables modules, Oracle Transportation management Order management, Shipments ,Invoice and Voucher modules,B2b EDI X12 214,204,990,210,110.
Oracle Technologies	Oracle PL/SQL,SQL, Oracle SOA 10g BPEL, Web Services, xml, 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 Systems	Linux/UNIX, Windows