Experienced data integrator & ETL consultant; Owner of BeeSharp, Inc.
Greater Pittsburgh Area
Experienced data integrator & ETL consultant; Owner of BeeSharp, Inc.
Greater Pittsburgh Area
* Database Programming - Design and development of data migration and data integration architectures for large data warehouses and major software applications (e.g. JD Edwards). Over 12 years experience with Teradata, Oracle, SQL Server and DB2 using SQL, PL/SQL, T-SQL and numerous database administration/access/loading tools (ERwin, Toad, Quest, SQL*Loader, Mload, DTS, Perl DBI, etc.).
* ETL Processes - Analysis of source systems and data quality. Development and performance tuning of complex Extract, Transformation, and Load processes. Automation of ETL processes with scheduling tools and exception-handling procedures. Development and execution of ETL test plans. Considerable experience with data cleansing processes to ensure accuracy (parsing structure & content, correction & validation, standardization, matching to business rules, supplementing with existing data)
* Informatica - over 8 years experience building repositories, mappings (including re-useable objects such as mapplets), implementing sessions/batches with Informatica Power Mart and Power Center. Development of robust Korn shell scripts for integration with third party schedulers. Considerable experience with loading both Oracle and Teradata databases using both file and relational writers.
* UNIX - over 12 years experience on AIX, Solaris, HP-UX platforms. Development of complex shell scripts for running ETL and integration processes. Development of standards and script templates for team projects.
* Windows - over 17 years experience on Windows 3.1 through Windows XP. Developed rock-solid automated load and extract processes using CMD batch scripting and Windows Task Manager.
Building robust data integration and data migration processes.
(Information Technology and Services industry)
July 1999 — Present (10 years 5 months)
Consulting company specializing in data integration projects.
(Public Company; 10,001 or more employees; AEO; Retail industry)
1999 — 2008 (9 years )
(Public Company; DKS; Retail industry)
October 2001 — August 2005 (3 years 11 months)
Several engagements working closely with business analysts, database admins and system admins.
(Privately Held; 11-50 employees; Information Technology and Services industry)
October 1997 — June 1999 (1 year 9 months)
Requirements gathering and determination; Lead teams in technical aspects and task management; Reporting to customer and Veratage management.
(Privately Held; 51-200 employees; Computer Software industry)
January 1995 — October 1997 (2 years 10 months)
BSCE , Civil Engineering, Computer Methods , 1982 — 1985
Assoc.Engr , Surveying Technology , 1980 — 1982
Irish music, golf.