We provide IT Staff Augmentation Services!

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

Hire Now