Mark Ware Email & Phone Number

Marcus Hook, Pa, Us

King Of Prussia, Pa

Conshohocken, Pa

-Designed and Implemented a warehouse for marketing data utilizing Amazon's cloud environment (S3/Redshift) using Matillion ETL and Python scripts.- Designed and implemented a sophisticated shell scripts to manage ETL jobs using UNIX shell scripts (ksh), Fastload and BTEQ to automate the loading of various source files into a Teradata data warehouse. Functions included a comprehensive batch and file auditing subsystem used to present a dashboard detailing the status of the warehouse to users.- Designed and implemented a SSIS/SQL Server data warehouse to support reporting (QLIK) for various marketing campaigns

- Designed and coded a set of common module UNIX shell scripts used in nearly every production job in IBC's Informatics data warehouse.- Created Teradata procedures to automatically update our dimensional database from a normalized core database including ETL, auditing and validation scripts.- Developed optimized BTEQ scripts for loading and extracting data from Teradata databases.- Implemented sophisticated data file preprocessors for data validation and scrubbing using UNIX shell scripts. (ksh) - Experience with Teradata MultiLoad, FastLoad and FastExport utilities as well as Datastage ETL.

- Developed sophisticated sales and expense budget forecasting system for Glaxo SmithKline Government Pricing Programs department in MS SQL Server/SSIS.- Created HR data warehouse application using Oracle, PLSQL, ETL & Visual Basic.- Developed an enhanced reporting user interface using Visual Basic (VBA) and Excel for the Finance department's SQL Server data warehouse.

- Utilized broad range of development tools including Visual Basic 5.0, Access 95, Oracle 7.1, Visual Source Safe, UNIX shell scripting, Oracle SQL*Plus and Oracle Pro*C.- Successfully migrated data from physician information database to centralized data warehouse.- Design/Coding using ERwin, Visual Basic, Access, Sybase SQL Server, and UNIX shell scripting.

- Designed and implemented significant improvements to catalog layout software for Verizon/ Bell Atlantic. utilizing shell scripts and Perl

- Led and directed major project to place GUI front end on terminal-based system for national financial software company utilizing Viaual Basic and SQL.- Created a GUI/Reporting Application utilizing Powerbuilder for data extracted from SAP.- Developed online job lead database for international management consulting firm using Visual Basic

- Coded a database application to manage mechanical drawing utilizing Oracle's Pro*C, SQL*Plus and SQL*Loader..