SUMMARY:

• An analytical and results - driven information technology professional with extensive expertise in systems engineering, mainframe programming analysis, system migrations, quality assurance, user acceptance testing, data warehousing,
• SQL design/development, team mentoring/, and technical support. Specializes in extraction, transformation, and loading (ETL) of the data warehouse.
• Skilled in detail design, system flow diagrams, data mapping documentation, and program specification.
• Demonstrated track record of success in the design, development, testing, and deployment of business applications that exceed customer expectations in both the retail and manufacturing industries.

TECHNICAL SKILLS:

Languages: SQL, COBOL3, MVS JCL, Eztrieve, CICS Command Level Programming, CICS BMS, SDF2, CICS RDO

DBMS: Teradata, DB2, MS SQL Server, IMS/DB, VSAM

Tools: Teradata SQL Assistant, Teradata Utilities (FastLoad, MultiLoad, FastExport, BTEQ), Datastage Designer/Director, IBM File Manager for DB2, IBM Debug Tool, Xpeditor, Intertest, BMC Catalog Manager for DB2, DB2 Commands & Utilities, File-AID for DB2, Sync Sort, Visio

Environment: IBM Mainframe z/OS, MVS/XA/ESA, TSO/ISPF, Panvalet, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Bentonville, Arkansas

Programmer Analyst, Data Integration

Responsibilities:

• Managed numerous Teradata migrations for the Data Integration team, including confidential.
• Achieved savings of roughly $confidential through work on Teradata migrations by replacing older and more expensive hardware with newer and more cost-effective hardware.
• Directed team of up to five domestic/international contractors to perform significant program modifications, resulting in store's ability to expand product offerings.
• Served as tech lead for Data Integration team, performing initial analysis to determine necessary code changes, and then worked with team of contractors to estimate work.
• Developed plan, tracked contractors’ work, and validated functionality of changes after installation into production.
• ETL Online Migration to DataStage:
• Reviewed work of developers and ensured adherence to company standards.
• Coded, tested, and installed 54 DataStage jobs.
• Conducted second testing and assisted in UAT testing.
• DataStage migration from 8.1 and 8.5 to 9.1.
• Led team of up to five contractors (both domestic and international) to perform upgrade of Data Integration team's DataStage jobs to newer version of DataStage software.
• Developed plan and tracked work during testing and installation of code at newer version of DataStage software.
• Contributed to preparation and execution of numerous Teradata migrations during FYE12 (fiscal year ending 2012), including:
• Completed changes to jobs with invalid scheduling environments in preparation for data migration, and created CCCL and CC’s for implementation day.
• Installed SCHENV change to FIUS586M and FIUS593M to prepare for Teradata migrations during FYE12.
• Setup change records for all DI (Data Integration)-related changes on each Teradata migration Implementation Day Flowchart.
• ETL Online Migration to DataStage:
• Converted ETL Online process for WW GRT TABLES.Delivery Trlr Dim to DataStage (TXWW018 replacement).
• Worked on removing audit table updates and logs from sequencers for delivery trlr dim table.
• Completed unload and load jobs for delivery trlr dim txt table and coded sequencer for Trailer Type Dim Prep job.
• Prepped for and conducted meeting to discuss moving db server.cfg configuration file to common/central location for one copy of file for use by all projects; received buy-in from all parties.
• Oversaw enhancement of DSEXT to work with DataStage Environments (DEV, QA, and PROD) without changes to mainframe code.
• Installed DSEXT proc and DSEXT01 program in production.
• Converted ETL Online process for WW GRT TABLES.MDSE TYPE DIM TXT to DataStage (TXWW008 replacement).
• Requested DBCID’s for all jobs for Track 1 of ETL conversion project.
• Coded basic unload and load jobs for Trailer Type Dim and Delivery Type Dim tables, as well as job sequences controlling unload job for Delivery Type Dim.
• Copied all Teradata Macros for tables in Track 1 of ETL conversion project to R6005 test set, executed table, created macros for tables not yet created in R6005 test set, and TeraCopied data from production into all ten tables.

Confidential, Grand Rapids, Michigan

System Coordinator, ETL Developer, Data Warehousing

Responsibilities:

• Developed ETL (extract, transform, and load) code to take data from operational systems, perform minor transformations, and load data into data warehouse platform for management reporting.
• Provided on-call support for existing data warehouse applications to troubleshoot and problem-solve any issues.
• Performed analysis on existing code to determine changes required to provide additional functionality base on project requirements.
• Executed code changes, performed unit testing, and user acceptance testing (UAT), installed code changes in production environment, and validated to ensure changes yielded desired results.
• Developed ETL for CRM (customer relationship management) to provide weekly guest household segmentation report history.
• Reverse-engineered and re-designed “ Confidential ” ETL’s summary program to correct defective reporting of sales information.Keane
• Created data mapping document for Data Collect to Confidential ETL process.
• Established process to handle changing dimensions within householding database.
• Designed and developed ETL processes for e-commerce subject area.
• Created process to support business continuity.
• Mentored and trained new team members on ETL best practice.

Application/ETL Developer

Confidential

Responsibilities:

• Cut run times by 50% for “ Confidential ” ETL using overlap processing within ETL.
• Designed and developed ETL for competitive index reporting.
• Completed low level design and development of ETL’s to provide CRM aggregate report tables (daily, weekly, and monthly) containing de-normalized sales and cost data.
• Developed competitive pricing ETL, including completing low level specifications, coding five competitive pricing procs, writing test cases for each proc, executing test cases, and turning over into production (DB2 Unloads, Teradata Utilities, and MVS JCL).
• Completed UPC expansion/conversion for Billback System.

Application Developer

Confidential

Responsibilities:

• Utilized DB2 expertise to design, develop, code, test, and implement UPC pull process to provide UPC information for physical inventories at stores for corporate random counts project.
• Converted 12 programs from accessing total files to DB2 tables, and parallel tested each change.
• Developed and tested application to load CICS TSQ’s with data from DB2 tables in order to improve rapid availability for online processing of Data Collect transaction coming up from stores.
• Modified and tested changes to Data Collect I/O routine to provide additional functionality for rewrite project (CICS, DB2, and COBOL).

Lead Analyst

Confidential

Responsibilities:

• Orchestrated mainframe portion of system test for upgrade to distribution system.

Lead Analyst, Manufacturing System

Confidential

Responsibilities:

• Led team of three programmers to provide application support for AMAPS manufacturing system.

System Analyst, Data Collect

Confidential

Responsibilities:

• Provided enhancements for Data Collect system to interface with software change in Confidential stores.