We provide IT Staff Augmentation Services!

Etl Programmer Resume

5.00/5 (Submit Your Rating)

Grand Rapids, MI

Hire Now

PROFESSIONAL SUMMARY:

Twenty years of professional IT experience as a Programmer and Business Analyst. Developing, enhancing, and maintaining applications for ETL, Marketing/Legal Reporting, Conversion, and Payment Processing. Application expertise in Data Warehousing, Automotive Financing and Insurance Systems. IT Responsibilities have included End - User Analysis, Design (following SAfe Agile and Ford's System Life Cycle/USDM approach), Specifications, Extensive Coding, Testing (Unit and System Testing), Documentation (including user manuals), and Training (both individual and small groups). Technical expertise in Teradata, Datastage, COBOL (with embedded DB2 and IMS), VSAM, DB2 Stored Procedures.

PROFESSIONAL IT EXPERIENCE:

Confidential, Grand Rapids, MI

ETL PROGRAMMER

Responsibilities:

  • Implement, maintain, support and make improvements on various ETL projects with primary focus on ShopperView, a Marketing project that provided data to internal users and vendors to perform analysis on comparative sales and product class sales by Household segment.
  • Utilizing AIX and z/OS platforms, DB2 Unload, Teradata (BTEQ, MLOAD and FASTEXPORT), SQL Server, Datastage, DB2/Teradata Stored Procedures, COBOL and Confidential Mainframe
  • Utilities for Marketing/Analytics and Household Segmentation.

Confidential, Grand Rapids, MI

ETL PROGRAMMER

Responsibilities:

  • Developed new and maintained existing ETL processes on a z/OS platform using DB2 Unload, Teradata (BTEQ, MLOAD and FASTEXPORT), SYNCSORT, COBOL and Confidential Mainframe Utilities for the migration of Sales Information from POS Collection to a Data Warehouse.

Confidential, Columbus, OH

PROGRAMMER ANALYST

Responsibilities:

  • Maintained and enhanced the ETL processes on AIX and z/OS platforms using DB2 Unload, Teradata (BTEQ, MLOAD and FASTEXPORT), COBOL, Confidential Mainframe Utilities and FILEAID for the migration of policy information from premium reporting systems to a Data Warehouse.

Confidential, Lansing, MI

MAINFRAME PROGRAMMER

Responsibilities:

  • Developed mainframe modules on a z/OS platform using COBOL and Confidential Mainframe
  • Utilities for the migration of policies from the Legacy Administration system.

Confidential, Minneapolis MN

MAINFRAME PROGRAMMER

Responsibilities:

  • Developed mainframe modules on a z/OS platform using DB2 Unload, Teradata (BTEQ, MLOAD and FASTEXPORT), SYNCSORT, BMC
  • Utilities, COBOL, FILEAID and Confidential Mainframe
  • Utilities for the migration of customer loyalty data to a 3rd party vendor.

Confidential, Lansing, MI

PROGRAMMER ANALYST

Responsibilities:

  • Assisted in the expansion and maintenance of a DB2 based Data Warehouse on a z/OS platform using DB2 Unload, DB2 Stored Procedures, Embarcadero, COBOL (with embedded DB2) and Confidential Mainframe
  • Utilities for the Corporate Reporting Database System (CRD). CRD receives daily, weekly and monthly updates from 3 major Policy Administration systems and is used for ad hoc reporting on approximately 3 million policies.
  • Redesigned the entire CRD, normalizing the data and incorporating industry’s best practices to the updating and reporting processes.

Confidential, Dearborn, MI

PROGRAMMER ANALYST

Responsibilities:

  • Developed and enhanced the on - line and batch modules of a Business Tool Set on a z/OS platform using DB2 Stored Procedures, COBOL (with embedded DB2 and IMS), FILEAID and Confidential Mainframe Utilities for supporting a reorganization of Customer Service Centers and Dealer Service Field Branches, resulting in the successful consolidation of 53 branches into 25 multi-branded branches.
  • Acted as a Business Analyst using Microsoft Office to create Mainframe design documents for a project which involved implementing Workflow processes in Customer Service Centers.
  • Worked as a liaison between the Business users and the JAVA/Mainframe programmers to design the necessary Business objects and to verify the Web based application met the load requirements using Loadrunner.
  • Enhanced the on-line and batch modules of a GUI on z/OS and Confidential OS2 using C++ Confidential Visual Age, COBOL, FILEAID and Confidential Mainframe
  • Utilities to allow Customer Service Center to perform Retail Account Adjustments.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship