Owner, BEESHARP, INC.
Greater Pittsburgh Area
Owner, 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 processes.
(Privately Held; Myself Only; Information Technology and Services industry)
July 1999 — Present (9 years 1 month)
Consulting company specializing in data integration projects.
(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
AssocEngr, Surveying Technology, 1980 — 1982
Irish music, golf.