We provide IT Staff Augmentation Services!

Sr.oracle Developer Resume

Somerset, NJ

SUMMARY

Over 10+ years of IT Experience in Software Design, Development, Testing, Implementation and Supporting applications that includes about 6+ Years of experience using Oralce 10g/9.x/8.x/7.x and 3+ years of experience in Data Warehousing.

  • Involved in all phases of Software Development Life Cycle (SDLC) like Requirement Capturing, Data Modeling, Designing, Developing, Testing, Implementing, Documenting and User Training of various business applications using Oracle Tools and Utilities, PL/SQL web toolkit, JavaScript and Java
  • Expertise in Procedures, Functions, Packages & database Triggers and working withPL/SQL, Oracle Scheduler and SQL.
  • Experience in converting/interfacing legacy systems with Oracle Database using PL/SQL, ETL, EAI and Java Stored Procedures.
  • Experience in web application development using PL/SQL web toolkit, JSP, ASP and JavaScript.
  • Experience with EDIFACT and X12EDI transactions and worked with EDI 810 Invoice - Outbound, 850 Purchase Order , 856 Advance Ship Notice and IFTMIN messages
  • Proficient in tuning of application using EXPLAIN PLAN and TKPROF for performance enhancements.
  • Extensively involved in developing programs to import/export data from legacy system into oracle database using SQL*Loader and PL/SQL andassisted users in QA & UAT test cycles.
  • Proficient in using Oracle Tools and Utilities such as SQL*Loader, Export/Import, Oracle Data Pump, External Tables, TOAD, SQL*Navigator and PL/SQL Developer.
  • Experienced in using the features of Autonomous Transactions, Ref-Cursors, PL/SQLTables, Materialized Views and Dynamic cursors
  • Experience in working with OLAP, OLTP, ERWIN to construct Logical and Physical data models, Forward & ReverseEngineering, Database Design and Data Warehouse/Data Mart Dimensional Data modeling with Dimensions & Fact Tables using STAR SCHEMA and also with Mining.
  • Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organizational goals

TECHNICAL SKILLS

RDBMS : ORACLE 10g/9.x/8.x/7.x, SQL Server 7.0/2000/2005
EAI: SeeBeyond e*Gate
Languages : JAVA , C++, C, SQL, and PL/SQL
OS : Windows NT/2000, Solaris/Unix, VMS
App. Servers : Weblogic 8.x/7.x, WebSphere 5.1/4.0 & Apache Tomcat 4.x
Web Technologies : JSP, ASP, JavaScript, VBScript, XML, XSLT, PERL
Messaging API : JMS and MQ Series
ETL Tools : Informatica 7.1
Reporting Tools : Business Objects 5.1 & Crystal Reports 8.5
Other Tools : TOAD 9.0, WSAD 5.1, Autosys 4.5,Visual Studio.net 2005

CERTIFICATIONS

  • Oracle Certified Associate (OCA) on Oracle 9i
  • Sun Certified Java Programmer 1.4
  • Microsoft Certified Professional in Visual Basic 5.0 and MS-SQL Server 6.5

PROFESSIONAL EXPERIENCE

Confidential, NJ Aug'2006 - Sep'2009

Sr.Oracle Developer

Confidential, offers a wide range of products and business services like Life Insurance, Brokerage Services, Mutual Funds, Fixed Income Investments and Annuities etc. that are designed to help companies meet their employee benefit, investment, and real estate needs. Project involves in maintenance of the LifeCAD & RCMA applications that supports Life insurance & Annuities

Responsibilities:

  • Developed technical specifications from business requirements as per standard specification formats.
  • Involved in translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers, Materialized Views and stored procedures.
  • Involved in resolution of support service issues,involved in writing complex queries and enhancements to existing system.
  • Coordinated with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing DDL Scripts, tables, indexes, tablespaces, triggers, db links and privileges.
  • Developed stored procedures to move data from staging table into base tables using Oracle UTL files and to extract data from database tables into flat file using PL/SQL.
  • Responsible for loading data from legacy systems to Oracle 10g using SQL*Loader and PL/SQL programs.
  • Developed and modified scripts for creating schema objects, for fixing data errors and for running regular jobs
  • Involved in creating JIL scripts for creation of Autosys jobs and created various SQL scripts for creating new products and modifying existing products.
  • Modified existing Korn shell scripts as per technical specifications and automated Batch Jobs using Autosys.
  • Developed UNIX shell scripts to execute various Oracle processes, stored procedures, SQL/DDL scripts, capture all errors related to Oracle and for secure file transfer.
  • Converted the business rules into technical specifications for ETL process for populating Fact and Dimension table of data warehouse.
  • Involved in Relational modeling, constructing Logical and Physical data models, Forward & Reverse Engineering and Data Warehouse/Data Mart Dimensional Data modeling using ERWIN.
  • Involved in assisting users in QA and UAT test cycles, involved in production releases and post implementation support of various projects.
  • Developed Test cases and Test scripts to test the functional requirements.

Environment: Oracle 10g, SQL, PL/SQL,SQL*Loader, Erwin 4.1,Autosys, PB10.0, Java, J2EE, WebSphere 6.1, JDBC, TOAD 9.0, C#, MS-SQL Server 2005, Windows XP and Solaris 10.x

Confidential, Uniondale, NY Feb'2006 to July'2006

Oracle Developer

The project involves in developing Customer Service Tracking application using PL/SQL web toolkit. The customer service orders are maintained in VAX and the java-stored procedures are used to maintain the replication of data between VAX and Oracle.

Responsibilities: -

  • Developed front-end screens for user input using PL/SQL Web tool kit
  • Developed PL/SQL Scripts, Stored procedures and database triggers to enforce data integrity
  • Configured Database Access Descriptor (DAD) on Oracle Application Server to allow the web server to connect to the database when a specific URL is requested.
  • Developed UNIX Shell scripts to process files, executes PL/SQL blocks and load data using SQL*Loader and Oracle UTL files.
  • Development of the Extract/Transform/Load processes to source the appropriate data to be delivered to the Data Warehouse.
  • Developed transaction mechanism using JAVA Stored Procedures and JDBC to retrieve order information from the VAX database and replicate the same into Oracle.
  • Created and modified SQL scripts for creating various schema objects - tables, views, synonyms, integrity constraints, indexes and views in the database.
  • Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica and Oracle SQL.
  • Developed and Tuned SQL and PL/SQL data extract scripts for Data warehousing
  • Gathering the requirements from the users and creating the reports as per the user requirements.

Environment: Oracle 9i/10g,PL/SQL, PL/SQL web toolkit, TOAD 8.5,Infromatica 7.1, JDBC, Oracle 9iAS, Java, JDBC, VAX ,Windows XP and RedHat Linux 9.x

Confidential, Peapack, NJ Aug'2005 to Jan'06

Oracle / EAI Developer

Application Integration of interfaces of Global Supply Chain of Pfizer pharmaceuticals. The project involves integration of data between various plants, markets and distribution centers of Pfizer across the world, taking care of the conversions between the 'Unit of Measurement', 'Location' and 'Item descriptions'

Responsibilities: -

  • Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per customer requirement to make new enhancements or resolve problems
  • Involved in Unit testing, Integration testing and Load testing of the interfaces
  • Created various schema objects oracle tables, integrity constraints, indexes and views in the database.
  • Involved in running the batch jobs for loading database tables from flat files using SQL*Loader
  • Involved in documenting the modifications and intended functionalities of the interfaces Developed and Tuned SQL and PL/SQL data extract scripts for Data warehousing
  • Developed ETL procedures to translate business rules and functionality requirements into ETL procedures.
  • Gathering the requirements from the users and creating the reports as per the user requirements.

Environment: Oracle 9i. PL/SQL, SQL Navigator 4.x, XML, Informatica 7.1.x, SeeBeyond 4.5.1,JDBC, Java, Windows XP and Solaris 9.x

Confidential, HOUSTON, TX Jun'03 to July'05
Oracle Developer/EAI Developer

Confidential, is a leading provider of end-to-end supply chain solutions demonstrating core competencies in domestic and international freight transportation, integrated logistics management and information technology.

The task at EGL is to convert the IFTMIN messages into XML format and loading XML format data into different systems like TnT, OnForwarding, EDI and Database IFTMIN is an Instruction Message to be used in fulfilling the requirements of trading partners in the transport chain worldwide, in the interchange of cargo and transport related information using Electronic Data Interchange (EDI). Involved in sending the PreAlert Messages to Shipper, Consignee, Origin and Destination stations using Fax and E-Mail.

Responsibilities: -

  • Interacting with Business Analyst to understand the business logic and mapping it with SeeBeyond 4.5.3.
  • Developed PL/SQL Scripts, Stored Procedures, Packages and database triggers to enforce data integrity
  • Involved in maintaining the partner profiles and developing EDI transactions 810 Invoice - Outbound, 850 Purchase Order and 856 Advance Ship Notice
  • Used XSL and XSLT transformations for converting XML data into HTML format.
  • Coverted/interfaced customer/vendor information from legacy AS/400 system with Oracle Applications.
  • Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects 5.1 connected to Oracle 9i data source.
  • Created various schema objects tables with integrity constraints, indexes and views in the database.
  • Developed store procedures to move data from staging table into online tables using PL/SQL

Environment: Oracle 9i, PL/SQL Developer 5.0,Java, XML, XSLT, SeeBeyond 4.5.3,JDBC, J2EE, SQL, PL/SQL, Business Objects 5.1,AS/400, DB2,MS-SQL Server 2000, MQ Series, Windows 2000 and Solaris 8.x

Confidential, Houston, Tx Oct'02 to May'03
Oracle Developer

Responsibilities: -

  • Designed and created Database objects: tables, Indices, Views, Procedures, Packages and Triggers.
  • Written Oracle Stored Procedures to load the legacy data into Oracle database.
  • Involved in performance tuning of SQL queries using Explain Plan
  • Used SQL*Loader for loading flat file data into Oracle database.
  • Developed UNIX Shell scripts to process files, executes PL/SQL blocks and load data using SQL*Loader.
  • Analyze and make Specifications for the development of the reports for modules like Scheduling, Tracking and Billing using crystal reports.
  • Regularly analyze the reports in earlier builds and make enhancements to them if possible, and include them in the current build.
  • Develop the Stored procedures to be able to customize the report according to specifications.
  • Developed views using base tables and customized them to use it in the reports.

Environment: Oracle 8i, Java, Java Servlets, Crystal Reports 8.5,SQL, PL/SQL, Windows NT and Unix

Confidential, Houston, Tx Mar'02 to Sep'02
Oracle Developer

Confidential, Oilfield Services supplies products, services and technical solutions to the oil and gas exploration and production (E & P) industry.

Responsibilities: -

  • Involved in developing customer and vendor interfaces using SeeBeyond
  • Developed PL/SQL Scripts, Stored Procedures, Packages and database triggers to enforce data integrity
  • Developed store procedures to move data from staging table into online tables using PL/SQL
  • Tuned SQL for performance improvement using Explain plan and SQL*Trace.
  • Involved in unit testing and integration testing of the entire application.

Environment: Oracle 8i, Java, SeeBeyond 4.5.1, SQL, PL/SQL, Windows NT and Unix

Confidential,Atlanta, GA Sep'01 to Feb'02

Oracle Developer /Java Developer

This is an Intranet application that keeps track of all the GE Customers around the Globe. The System creates a new Project whenever an order is received by GE (Power Systems) for Gas, Steam or Generator Turbines/Power Plants. It is designed to track the Project from order receiving to project installation, execution and monitoring. The system generates various reports for Management, which is useful in decision-making.

Responsibilities: -
  • Involved in developing the front-end screens using HTML and performed data validations using JavaScript and performed business logic using JSP
  • Developed PL/SQL Scripts, Stored Procedures, Packages and database triggers
  • Created schema objects like tables, views, indexes etc in the database.
  • Written complex SQL queries and used EXPLAIN PLAN to optimize the query performance.

Environment: Oracle 8i, Java, Swing, XML,JSP, JDBC, Java Servlets, SQL, PL/SQL, Windows NT and Unix

Confidential
Project: Configuration Utility for Siebel Sept'00 to Aug'01

Sr. Developer

Confidential
Project: Configuration Utility for Siebel Sept'00 to Aug'01

Sr. Developer

This application is used to update the configuration files of Siebel as per options selected by the user. The application reads the data from a text file and updates the user configuration files and the text file is subject to change more frequently. This application provides the multi language support to Siebel if user chooses the non-English language. This application checks the data in the text file every time the user starts Siebel and the configuration files are updated accordingly.
Responsibilities: -

  • Responsible for Design, Coding and implementation of this Application.
  • Gathering the requirements from the users and creating the reports as per the user requirements.
  • Involved in developing the front-end using VisualAge, utilizing Java Swing Components.
  • Java I/O Streams are used to store the user information and to prepare the statistics.

Environment: JDK 1.2.2, Java Swing, Visual Age 3.5, WebSphere 4.0, Java I/O Streams, Siebel 2000/Siebel 99, DB2, DB2 Connect, VMS & UNIX

Confidential, ATLANTA, GA, USA Jun'00 to Aug'00

Java Developer

DNServer handles the requests from the various clients that are used by BellSouth.net in day to operations. The various clients which access the DNServer are BNVer, SISVer, Provisioning, Cybercash, Encryption and NPANXX. The clients use a framework called Application Objects to communicate with DNServer

Responsibilities: -

  • Involved in developing the front-end screens using HTML and performed data validations using JavaScript and performed business logic using Java Servlets.
  • Involved in developing the load balancing of the DN Server and developed a servlet which balances the load using the concept of multi threading.
  • Developed complex SQL queries, Stored procedures and database triggers to enforce data integrity
  • Assisted developers to improve program response and worked on improving response times in case of long running reports.
  • Created database tables, integrity constraints, indexes and views in the database.

Environment: JDK 1.2.2, Java Servlets, JSDK1.1, JDBC, JSP, Oracle 8.0.4, HTML, Java Script, C++, Apache 1.3.9 and SUN SOLARIS 2.6

Confidential, New Jersey, USA Jan'00 - Jun'00
Physician Practice Management System

WebSmartMed is a 3 Tier Architecture based, fully integrated software system that provides a paper less solution to a physician's practice including Web access to patient healthcare information from the insurance carriers. WebSmartMed is designed to provide Patient Management, Appointments, Accounting, Insurance Claims, Reports, Billing claims and on-line reporting capability feature.

Responsibilities: -

  • Involved in designing the screen layouts in Java Swing using JBuilder 3.0 and validating the data as per the specifications.
  • Establishing the applet-servlet communication for sending and receiving data between applet and servlet.
  • Used XML for communication between the front end the back-end.
  • Established the database connectivity using JDBC.
  • Developed Stored Procedures, Packages and database triggers to enforce data integrity
  • Created database tables with integrity constraints, indexes and views in the database.
  • Written complex SQL queries to optimize the query performance.
  • Involved in unit testing of the entire application.

Environment: JBuilder 3.0, JDK 1.1, Java Servlets, Java Swing, JDBC, XML, EJB 1.0, WebLogic 4.0, Oracle 8.0, HTML, Java Script, and UNIX

Confidential, Hyderabad, India Jun'99 to Dec'99
Material Management System

The Company is a medium sized Engineering company and is involved in manufacturing and selling a selected type of paper making machinery. An application was developed to exclusively deal with the activities of materials purchase, inventory and accounting at clients' site.
Environment: Visual Basic 6.0, Oracle 7.3, and Windows 95.

EDUCATION
B.S in Electronics & Comm Engineering
Post Graduate Diploma in Computer Applications

Hire Now