We provide IT Staff Augmentation Services!

Etl/dw Contractor/oracle Database Developer/contractor Resume

Phoenix, AZ

SUMMARY:

  • 20+ years experience in Information Technology. I have experience in relational databases, SQL, PL/SQL, stored procedures, functions, triggers, performance tuning, and Oracle related objects.
  • Experience in Oracle Data Warehousing including the design of Star Schema relationships as well as Oracle Application CRM for coding, implementation and performance tuning.
  • Performing data modeling and developing fact and dimension tables
  • Developing processes using MS SQL Server and MS Visual Studio 2005/2008
  • Developing historical and incremental processes to load staging tables using PL/SQL
  • Developing PL/SQL scripts to partition production fact tables into daily partitions
  • Developing programs using Toad on Oracle 10g RAC using PL/SQL, Oracle Analytical functions to load pricing information into Type2 tables, and PL/SQL stored procedures to drop indexes, load dimensions, and rebuild indexes
  • Developing functions and procedures in packages to load and maintain databases
  • Developing reports using Crystal Reports
  • Developing PL/SQL stored procedures in Oracle 9i,10 and 11g using Toad SQL Developer
  • Installing Oracle Application CRM to interface with data warehouses
  • ETL development using Informatica 9.1 and Business Objects DI tools
  • Writing Unix Korn shell scripts and manipulating existing Perl scripts
  • Performance Tuning: Bulk Collections, Partitioning, Nested Objects and Snapshots

TECHNICAL SKILLS:

Languages: SQL, COBOL, ASP, HTML, MS Visual Basic, and XML

Operating Systems: Unix, MS Windows, and Linux

Databases: DB2, Informix - 4GL, and Oracle

Scripting Languages: Perl, Unix, Korn, JCL, Shell Scripting, VBScript, and JavaScript

Data Modelling Tool: ERWin

Data Warehouse Tools: SAS, Informatica PowerCenter, and Business Objects, Viso

OLTP Systems: CICS, TSO, and ISPF

Other Tools: MicroStrategy and Crystal Reports and AutoSys

Others: Toad, SubVersion(SVN), JSP, SQL Loader, and SQL Navigator,DataPump,SQLPLUS, Autosys and Direct Connect NDM

PROFESSIONAL EXPERIENCE

Confidential

ETL/DW Contractor/Oracle Database Developer/Contractor

Responsibilities:

  • Currency Transaction Report DW developer Tuning queries in procedures and functions
  • Creating new ETL Work Flows for Currency Transactions System Creating CTR Reports using Oracle pl/sql

Confidential

ETL/DW Contractor/Oracle Database Developer /Contractor

Responsibilities:

  • Working with the data warehouse group as a Oracle Developer to develop and maintain the daily fact and dimension loads to the data warehouse. There are two warehouses: international and U.S. Source comes from a SAP environment that’s is picked up as a source to the ETL loading target tables in Oracle 10g and 11i Databases.
  • ETL tools are Business Objects DI and Informatica PowerCenter. My role is mainly ETL development in BODI and Maintain of the Repositories in the QA and Production environments. I also maintain the job servers for these ETL. Creating schedules by exporting the command file to Unix and scheduling with Autosys. Maintaining the BO job server.
  • Wrote and maintain many pl/sql ETL loads using either merge or by populating collections (pl/sql table’s) and FORALL inserts into DB tables.

Environment: Oracle, Unix and BO/DI

Confidential, Phoenix, AZ

Consultant /Data Marts

Responsibilities:

  • Involved in the development of clinical data marts for hospital personnel.
  • His responsibilities included: Performing data modeling and developing fact and dimension tables
  • Developing processes using MS SQL Server and MS Visual Studio 2005/2008
  • Developing fact and dimension MS SQL Server target tables using Business Objects DI for development of the target tables used in creation of the Clinical dashboards for the hospital
  • Developing both historical and incremental data loads
  • Developing IT standards for programming in the IT department
  • Creating procedures for Type2 tables to expire and add new patient information for historical reporting.

Environment: MS SQL Server 2005/2008 and MS Visual Studio 2005/2008

Confidential, Tempe, AZ

ELT Consultant

Responsibilities:

  • Working on the ETL project with the data warehouse team to design and build a new data warehouse for Confidential
  • Developing historical and incremental processes to load staging tables using PL/SQL
  • Developing PL/SQL scripts to partition production fact tables into daily partitions
  • Creating scripts to swap previous days data into the daily partitions in the production fact tables
  • Developing Oracle Analytical functions to load pricing information into Type2 tables for historical reporting and billing
  • Developing PL/SQL stored procedures to drop indexes, load dimensions, and rebuild indexes
  • Developing reports using Crystal Reports
  • Modifying Oracle PL/SQL stored procedures, which replaces Global Temp tables with in-line views to reduce resources and speeding up processes on the Unix server
  • Creating fact and dimension tables to hold all the calls both voice and data. The system was designed to track all calls and rate them depending on the satellite to ground, roaming through 3 party carriers (ATT, REACH…)
  • Writing processes using Oracle PL/SQL scripts, stored procedures, and functions with Toad on Oracle 10g RAC on the Unix platform
  • Creating PL/SQL scripts to load historical data into Type1 tables
  • Creating incremental Type2 scripts for on-going call information
  • Developing the decision support system using the warehouse with MicroStrategy
  • Working with the team in installing Oracle Application CRM to interface with the data warehouse
  • Created management reports using Oracle Reports using Oracle Developer 2000
  • Creating import and export scripts on Unix to retrieve and store the data using PL/SQL on Oracle 10g and developing programs using Toad on PC and VI on Unix

Environment: Toad, PL/SQL, Oracle App CRM, Crystal Reports, Oracle 10g, and Unix

Confidential, Scottsdale, AZ

Senior Oracle Developer / ETL Project

Responsibilities:

  • Clarifying client requirements, business needs, and project objectives through feedback sessions and client meetings, in collaboration with all stakeholders
  • Writing scripts and procedures using Oracle 10g PL/SQL
  • Writing more than 100 fact and dimension tables, views, triggers, and stored procedures using Oracle 10g and programs using PL/SQL Oracle 10g database on Linux
  • Developing programs using Toad on Oracle 10g RAC using PL/SQL
  • Developing PL/SQL programs using Oracle Spatial features to support GIS and LBS solutions
  • Supporting the .net developers writing all queries with stored procedures outputting ref cursors (s pointing to list of data)
  • Developing functions and procedures in packages to load and maintain the company database
  • Creating procedures to use SCCS version control on Unix
  • Monitoring and scheduling stored procedures in Oracle OEM, which was written using PL/SQL

Environment: Toad, PL/SQL, Oracle 10g RAC, Oracle 10g, Unix, and Linux

Confidential, Phoenix, AZ

Data Analyst / Migration/Conversion

Responsibilities:

  • Working with executive teams to define and develop a migration path for MBNA data to Confidential ’s Confidential (Oracle 9i) database
  • Converting SAS programs and SQL scripts to use new mapped fields in DB2 and on Unix
  • Writing extract programs on mainframes using COBOL/DB2, QMF, and TSO
  • Developing PL/SQL stored procedures in Oracle 9i using Toad SQL Developer
  • Created Oracle Forms to validate and fix data errors

Environment: COBOL/DB2, QMF, TSO, SQL, PL/SQL, Toad SQL Developer, DB2, Oracle 9i, Unix, and Mainframe

Confidential, Scottsdale, AZ

Consultant

Responsibilities:

  • Gathering requirements from airborne customers and developing individual conversion plans
  • Working with over 40 airborne customers to convert their standalone shipping systems over to the Confidential Easy Ship software
  • Developing custom modifications to the Confidential Easy Ship software for new customers migrating from the legacy mainframe CICS system to Confidential software
  • Writing reports using Crystal Reports and standalone export programs using Perl, VBScript, MS Visual Basic, C, C++, and ASP
  • Connecting to customer sites using logmein IT secure remote control to install, manage, and maintain remote systems
  • Installing DB Connect ETL tool using XML, XSL, and DOM for transferring the data over the Internet
  • Converting the migration custom programs from DB2 to the MS SQL Server database

Environment: Perl, VBScript, MS Visual Basic, C, C++, ASP, XML, XSL, DOM, DB2, MS SQL Server, and Mainframe CICS

Confidential, Scottsdale, AZ

Data Analyst / Credit Card Applications

Responsibilities:

  • Creating reports using Crystal Reports for validating Credit Card applications
  • Developing Unix test scripts to retrieve 3rd party files with credit card applications to parse and validate to enter the data into the Informix database
  • Working with QA to create a process to test the application data faster using Unix scripting and Informix 4GL

Environment: Informix 4GL, Crystal Reports, and Unix Scripting

Confidential, Phoenix, AZ

Senior Programmer

Responsibilities:

  • Creating programs for the Vitals E-commerce application using Java and Informix-4GL stored procedures
  • Serving as Backend Developer using Informix-4GL
  • Coordinating with the team that developed the Company Time Tracking system using Java, JS, Struts 1.0, and HTML running on the TomCat web server
  • Writing complex queries, stored procedures, and functions
  • Designing large scale applications
  • Analyzing and implementing using Oracle, Informix, and MS Visual Basic 6 VRU Phone interface using Informix stored procedures
  • Developing a third party file retrieval system using XML, Perl, and an Informix database
  • Creating Intranet research tools using ASP with Informix stored procedures
  • Developing reports using Crystal Reports and viewing them on Crystal Web Server

Environment: Java, JS, Struts 1.0, HTML, XML, Perl, ASP, MS Visual Basic 6, Informix, ESQL/C, Crystal Reports, TomCat Web Server, Crystal Web Server, and Oracle

Confidential, Phoenix, AZ

Application Development Lead/Oracle Developer

Responsibilities:

  • Involved in the development, enhancement, and maintenance of various projects. Maintaining and enhancing the Customer Service system, which is developed in Oracle 8 using PL/SQL
  • Engineering the Loyalty and Rewards system with both the front and backend in Informix 4GL and a web interface written in ASP
  • Developing all loyalty system reports using Crystal Reports, web locator sites for Group Sales system using HTML and ASP, and many Intranet sites for HR and the Hotel system using ASP, VBScript, JavaScript, and ADO accessing the Informix database
  • Re-engineering the Group Sales system using Vantive 7, Oracle PL/SQL, and MS Visual Basic 6
  • Mentoring junior programmers and web and application developers on using ASP

Environment: ASP, PL/SQL, HTML, VBScript, JavaScript, ADO, MS Visual Basic 6, Vantive 7, Crystal Reports, Oracle 8, and Informix

Confidential, Phoenix, AZ

Application Development Lead

Responsibilities:

  • Leading a team of four developers to write applications including Shop At Home Order Entry system. Writing all programs for the client/server architecture using Informix-4GL and stored procedures and C on Unix Sun/Solaris
  • Participating in the design and development of: Shop At Home, Amoco Motor Club, Credit Card Sentinel, and AARP websites on MS Windows NT using Active Server pages using MS Visual Interdev and MS FrontPage software
  • Creating Informix stored procedures that are executed by VRU, which is a 24 hour telephone order system
  • Developing Locator websites for the Group Sales system using HTML and ASP and many Intranet sites for HR and the Hotel system using ASP, VBScript, JavaScript, and ADO accessing an Informix database
  • Re-engineering Loyalty and Rewards system with a front and backend in Informix 4GL and a web interface in ASP

Environment: ASP, C, HTML, VBScript, JavaScript, MS Visual Interdev, MS FrontPage, Informix-4GL, ADO, and Unix Sun/Solaris

Confidential, Garden Grove, CA

Project Lead / Inventory Control System

Responsibilities:

  • Supervising 3 junior programmers in the development of Company’s Legal Franchise system, written in Informix-4GL on HP9000. This system was used to sell money mailer franchise throughout the US

Environment: Informix-4GL and HP9000

Confidential, Colorado Spring, CO

Consultant

Responsibilities:

  • Designing the interface using AutoCAD and Informix online DB using a client/server architecture
  • Writing the interface using Q&Es ODBC on 486 PC using C to retrieve data from Informix and Sybase
  • Writing data access screens using Informix-4GL for MS Windows to run inside AutoCAD Windows

Environment: C, AutoCAD, Informix, DB, Sybase, MS Windows, and 486 PC

Confidential, Phoenix, AZ

Consultant / Court Management System

Responsibilities:

  • Designing and writing the Court Management system with team of 12 programmer analysts using FOURGEN Case tools with INFORMIX-4GL on Tandem and Sequent computers
  • Installing the FOURGEN accounting system, Accounts Payable, Accounts Receivable, and General Ledger

Environment: FOURGEN Case, Informix-4GL, Tandem, and Sequent

Confidential, Tempe, AZ

Application Developer / MRP II System

Responsibilities:

  • Leading the design and development effort of MRP II system using COBOL
  • Creating Dialog Manager panels to view MRP reports and print selected pages

Environment: COBOL, CICS, DB2, and IBM 3090

Hire Now