|
|
Data Integration Processes
|
|
|
Contact: |
Bruce Foley |
| Telephone: |
412-983-6595 |
| e-mail: |
bfoley at beesharp.com |
| Resumé: |
MS-Word DOC
Adobe PDF
HTML
|
| |
|
|
Over 20 years experience in the Retail, Manufacturing, Chemical,
and Utility Industries.
|
|
|
|
|
|
|
Clean, Reliable Data |
| Data Integration |
Data Conversion |
Legacy Migration |
|
Design and Development of Robust Processes Using:
- Database Programming -
Customized 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 tools
(ERwin, Toad, Quest, SQL*Loader, Mload, DTS, Perl DBI, etc.).
- ETL Scripts -
Including 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 9 years experience building
repositories, mappings (including re-useable objects such as
mapplets), implementing sessions/batches with Informatica Power Mart
and Power Center. Includes use of external UNIX shell connections
for integration with third party schedulers. Considerable experience
with loading both Oracle and Teradata databases using both file and
relational writers.
- UNIX Shell Scripting - 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 Scripting - over 17 years experience
on all versions of Windows. Development of rock-solid
automated ETL processes using CMD batch
scripting and Windows Task Manager.
- Creative Problem Solving -
flexible, common-sense and cost-effective approach to solving complex
problems using available
client software and/or appropriate open source solutions.
|
|
