We provide IT Staff Augmentation Services!

Data Warehouse Developer Resume Profile

5.00/5 (Submit Your Rating)

Charlotte, NC

Professional Skills

Project Leader 11 years of experience

Managed up to 13 senior programmers on large-scale projects. Managed onshore and offshore contractors and demonstrated a proven ability to multitask and work on several projects at one time.

Informix/Unix ETL/DataStage/Data Warehouse 5 years of experience

Linux, ETL, DataStage 8.5, Director 8.5, Data Lineage, QualityStage, Metadata Workbench, Autosys, Netezza Data Warehouse, Tableau, Teradata, Unix, Scripting, SQL, T-SQL,Aginity, FastTrack, Agile Methodology. TFS. Wrote 215 DataStage jobs and sequencers. SSIS Sequel Server Integration Services.

IBM Mainframe 27 years of experience

Cobol I and II, CICS, BMS, XML, DB2, VSAM, JES, Z/OS, ISPF, CICS, TSO, FileAid, Endevor, Platinum, Intertest, Spufi, QMF, JCL, Procs, Data Mapping, Business Objects Web Intelligence, SQL, FTP, TOAD 9.7.2., Expediter, ISPF, NDM, ABEND-Aid, CA-7, Librarian, File Manager, Rexx, Changeman, ABEND-AID, Expediter, SQL, IBM Batch Pipes, Roscoe, EZtrieve, Stored Procedures, Agile Methodology. Developed test plans and scripts.

AS/400 6 years of experience

Cobol/400, RPG I thru IV and RPG/400, QUERY/400, CL, DFU, SEU, PDM, IDDU, DDS.

JD Edwards on Unix Environment 2 years of experience

JD Edwards 8.12, Oracle, JD Edwards 8.96 toolset, Report Design Aid, Object Management Workbench, Batch Versions, TOAD 9.7.2.

Professional Experience

Confidential

Data Warehouse Developer

  • Oversaw and building and implementation of databases and file structures.
  • Retrieved data from multiple sources and worked to generate XML, DOS, Excel Spreadsheets, and Unix versions of this data.
  • Met with end users bi-weekly and discuss project needs and strategies for various projects using TFS.
  • Worked with SQL and T-SQL onUnix to perform Perl Scripting and Unix Scripting.
  • Copied the retrieved files to VM's using FileZilla and wrote DataStage 8.5 jobs and sequences that transformed the data then loaded the results into Netezza Databases.
  • WroteUnix scripts inside and outside of DataStage jobs.
  • Utilized Aginity to verify the written results in Netezza databases
  • Wrote 155 DataStage jobs to date.
  • Used Director 8.5 for debugging.
  • Worked with Visual Studio to track tasks per Agile Development.
  • Utilized SSIS Sequel Server Integration Services.

Confidential

Mainframe Programmer

  • Acted as project lead to manage on shore contractors.
  • Performed all work in the Institutional Systems area.
  • Worked with CICS, TSO, COBOL, VSAM, CA-Easytrieve/Plus, Insync, Apptune, Endevor, DumpMaster, JCL, batch and online programming.
  • Utilized tools which includedMicroFocus Mainframe Express and Intertest and worked on a Z/OS operating system.

Confidential

Senior Programmer/SME Permanent Employee

  • Served as the Senior Programmer/SME in the Customer Systems area.
  • Designed and managed projects by using XML, XSD, Cobol II, DB2, TSO, Z/OS, IBM Utilities, SPUFI, DCLGEN, Teradata, VSAM, ISPF, TSO, FileAid, SAN Shared DASD , FTP, NDM, Stored Procedures, and IBM Batch Pipes.
  • Worked with SQL on DB2, Oracle and Unix to perform Perl Scripting and Unix Scripting.
  • Conducted code reviews.
  • Wrote BRD's, HLD's, and LLD's.
  • Managed all projects via DMAIC Design, Measure, Analyze, Improve, and Control processes.
  • Acted as the Release Lead on 24 releases.
  • Involved in migration from mainframe to Data Integration platform using: Agile process, Linux, ETL Informatica, DataStage 8.5, QualityStage, Metadata Workbench, FastTrack, Autosys, and Data Lineage.
  • Gained an understanding of business objects and SSRS reports.

Confidential

Remote Contract Mainframe Developer

  • Worked on Programming Commercial Leasing systems using XML, Cobol II, DB2, VSAM, ISPF, CICS, TSO, FileAid, NDM, WebSphere MQ Series.

Confidential

Contract Developer

  • Worked with programming systems using XML, Maui, Cobol II, DB2, VSAM, ISPF, CICS, TSO, FileAid, Endevor, Platinum, Intertest, Spufi, QMF, and JCL on an IBM mainframe Z/OS.
  • Wrote all CICS programs written on mainframe backend with web based Java front end.
  • Systems involved were investment financials and brokerage.
  • Installed all new and modified modules into production error free.

Confidential

Developer/Project Leader

  • Managed in house and off shore JD Edwards 8.12 reporting project.
  • Used 8.96 Toolset and other tools included Report Design Aid, Object Management Workbench, Batch Versions, Business Objects Web Intelligence, Visio, SQL, Oracle, and TOAD 9.7.2. Applications were both manufacturing and finance.
  • Managed and programmed large systems in Cobol II, VSAM, ISPF, TSO, CICS, BMS, FileAid, and JCL on an IBM mainframe.
  • Developed business functions and test cases. Systems involved manufacturing, Supply Chain, and financial applications.
  • Performed multiple tasks which included: writing new programs, Data Mapping, modifications, analysis, writing technical and user manuals.
  • Managed up to 7 programmers on different projects.
  • Performed all work using System Development Life Cycle SDLC.
  • Reduced inventory planning time from 5 days/week to 1.5 days/week.

Confidential

Contract Programmer

  • Programmed and consulted on systems written in Cobol II, RPG/400, RPG III, VSAM, CICS, DB2, QMF, SPUFI, and JCL on an IBM mainframe and AS/400 Cobol systems involving different banking and financial applications.
  • Worked with SQL on DB2 and Unix to perform Perl Scripting and Unix Scripting.
  • Performed all tasks which included writing new programs, modifications, and analysis.
  • Related software: Expediter and Endeavor.
  • Performed work using System Development Life Cycle.
  • Completed all work flawlessly ahead of schedule.

Confidential

Contract Programmer/Technical Writer

  • Programmed systems in Cobol II, VSAM, ISPF, CICS, and JCL on an IBM mainframe.
  • Involved systems were for Emergency Service Restoration.
  • Performed duties included writing new programs, modifications, and analysis.
  • Documented all systems using Word.
  • Used other systems involved for project costing and accounting.
  • Performed work included new programming and modifications as well as analysis and design.
  • Developed business functions and test cases.
  • Related software included PeopleSoft and SQR.
  • Wrote all technical documentation for projects.

We'd love your feedback!