Bruce Foley

Current

• Consultant, Owner at BEESHARP, INC.

Past

• Database and ETL Consultant at American Eagle Outfitters
• Database and ETL Consultant at Dick's Sporting Goods
• Technical Lead at Veratage

• Engineering Manager/Technical Lead at Daxus

see less...

1 more...

Education

• Carnegie Mellon University
• Pennsylvania State University

Connections

21 connections

Industry

Information Technology and Services

Websites

• My Company
• Irish Group
• Irish Group 2

Bruce Foley’s Summary

* 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.

Bruce Foley’s Specialties:

Building robust data integration and data migration processes.

Bruce Foley’s Experience

• Consultant, Owner

  BEESHARP, INC.

  (Information Technology and Services industry)

  July 1999 — Present (10 years 5 months)

  Consulting company specializing in data integration projects.

• Database and ETL Consultant

  American Eagle Outfitters

  (Public Company; 10,001 or more employees; AEO; Retail industry)

  1999 — 2008 (9 years )

• Database and ETL Consultant

  Dick's Sporting Goods

  (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.

• Technical Lead

  Veratage

  (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.

• Engineering Manager/Technical Lead

  Daxus

  (Privately Held; 51-200 employees; Computer Software industry)

  January 1995 — October 1997 (2 years 10 months)

Bruce Foley’s Education

• Carnegie Mellon University

  BSCE , Civil Engineering, Computer Methods , 1982 — 1985

• Pennsylvania State University

  Assoc.Engr , Surveying Technology , 1980 — 1982

Additional Information

Bruce Foley’s Websites:

• My Company
• Irish Group
• Irish Group 2

Bruce Foley’s Interests:

Irish music, golf.

Bruce Foley’s Groups:

•    Carnegie Mellon Alumni
•    Irish Music group

Bruce Foley’s Contact Settings

Interested In:

• consulting offers
• expertise requests
• reference requests
• getting back in touch