|
|
Information Technology Consulting
|
|
|
Over 20 years experience in the Retail, Manufacturing, Chemical,
Pharmaceutical, Healthcare, and Utility Industries.
|
|
|
Contact: |
Bruce Foley |
| Telephone: |
412-983-6595 |
| e-mail: |
bfoley at beesharp.com |
| Resumé: |
MS-Word DOC
Adobe PDF
HTML
|
| |
|
|
|
|
Data Warehouses - Data Marts |
|
Data Integration |
Data Conversion |
Legacy Migration |
|
- Database Programmer -
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 Developer -
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 Developer - over 9 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 Developer - over 20 years experience
on AIX, Solaris, HP-UX platforms. Development of complex
shell scripts for running ETL and integration processes. Development of utilities
to automate ftp and sftp for gathering remote data.
Development of standards and script templates for corporate IT departments.
- Windows Developer - over 17 years experience
on all versions of Windows. Development of rock-solid
automated ETL processes using CMD batch
scripting and Windows Task Manager.
- Problem Solver -
creative, flexible and cost-effective approach to solving complex
problems using available
client software and/or appropriate open source solutions.
|
|
