Phil Infante

Current

Consultant at Booz Allen Hamilton

Past

Solution Architect at LUCRUM, Inc.
Data Management Director at Columbia Sussex/Tropicana Casino and Resorts
Consultant at Computer Sciences Corporation

Claims/Programmer Analyst at Aerotek Contractor for General Motors

see less...

1 more...

Education

Power Memorial Academy High School, NYC
University of Cincinnati

Recommended

1 person has recommended Phil

Connections

214 connections

Industry

Defense & Space

Websites

Phil Infante’s Summary

IT professional with more than ten years experience as Data Architect and Developer with integration, conversion, modeling, data analysis, OLAP, OLTP, and production support in areas of business intelligence/data warehousing. Work experience with all phases of the data architecture using Kimball methodology for data profiling, cleaning, and auditing along with strong communication and technical proficiency in all aspects of program design, coding, testing, implementation and documentation.

**Interested in networking nationwide within IT industry and government.

Phil Infante’s Specialties:

• Development Tools: Eclipse, TOAD, Visual Studio.Net, SQL Developer
• Databases: DB2, SQL Server, Oracle
• Data Modeling: CA Erwin, Embarcadero ER/Studio
• Languages: C#, ASP.Net, SQL, PL/SQL, UNIX Script, VB.Net
• Methodologies: Kimball
• BI Tools: DTS, SSIS, Business Objects, Cognos
• ETL: Informatica
• Midrange: AS/400
• Operating Systems: AIX-UNIX, Linux, Windows
• Packages: Test Director

Phil Infante’s Experience

Consultant

Booz Allen Hamilton

(Privately Held; BAH; Management Consulting industry)

June 2008 — Present (1 year 6 months)

Project Management, Developer, and Architect in Data Warehousing. Extensive use of kimball methodology towards dashboards, business intelligence, Web 2.0 (SharePoint), and ETL throughout requirements, design, development, and implementation phases with Department of Defense on engagements with Air Force Materiel Command (AFMC), Air Force Safety Center (AFSC), and Air Force Research Laboratory (AFRL) in the past.
Solution Architect

LUCRUM, Inc.

(Privately Held; 51-200 employees; Information Technology and Services industry)

February 2008 — May 2008 (4 months)

• Identify metrics for measuring the ongoing effectiveness of the data warehouse
• Define key business drivers and data warehouse architecture (e.g., ETL process, ODS, EDW, Data Marts, cubes, 3NF,meta data standards)
• Define technical requirements, technical and data architectures for the data warehouse including data quality and testing
• Recommend/select data warehouse technologies (e.g., ETL, DBMS, Data Quality, BI)
• Design and direct the information access, implementation of security requirements, and delivery effort for the data warehouse
Data Management Director

Columbia Sussex/Tropicana Casino and Resorts

(Gambling & Casinos industry)

April 2007 — February 2008 (11 months)

• Designed iterative best practices to establish efficient business processes and risk management for marketing department along with implementing data architectural and technical standards to centralize data from various legacy systems in 13 casinos into data warehouse in aspects of data transformation, load procedures, metadata, documentation, and SOX compliance.
• Interacted with senior management for business processes and data analysis solutions.
• Implemented business analytic rules for data profiling customers for marketing purposes to maximize profit margins.
• Designed the overall data warehouse architecture with ETL Instrumentation for measures (e.g., ETL SSIS/DTS process, Visual Studios.NET, ODS, EDW, Data Marts, OLAP, Report Services).
• Directed and managed three data analysis nationwide for marketing department.
Consultant

Computer Sciences Corporation

(Public Company; 10,001 or more employees; CSC; Information Technology and Services industry)

June 2005 — April 2007 (1 year 11 months)

• Member of Health Care ETL team responsible for testing 80 TB of data for aggregated function/load processes for 13 Health Care providers.
• Member of Data Conversion team responsible for ETL and testing of the 30 TB of data conversion/load processes for replacement of legacy retail pharmacy system.
• Lead for Testing team responsible for designing, developing, and testing cases of a replacement legal application.
• B.A. during the Joint Application Design (JAD) sessions which were designed to gather the requirements for the enhancements of existing Web based Application interface implementation along with evaluating enterprise solution.
Claims/Programmer Analyst

Aerotek Contractor for General Motors

(Public Company; 10,001 or more employees; GM; Automotive industry)

October 1999 — April 2005 (5 years 7 months)

• Design, research, enhance, maintain, and develop application tools for tracking parts quality, claims of parts, and control of distribution of automobile parts in a warehouse for implementation of production and quality assurance procedures.
• Developed various applications to a centralize database too log, track, and organize credit for parts returned from 200 dealership part managers over a 7 state region for data analysis.

Phil Infante’s Education

Power Memorial Academy High School, NYC

1981 — 1985
University of Cincinnati

B.S. , Information Engineering Technology

Additional Information

Phil Infante’s Websites:

Phil Infante’s Interests:

Planning to work on MBA sometime in the near future. Family & Kids, Baseball, Football, History, & Travel.

Phil Infante’s Groups:

I.T. Professional

Enterprise Architecture Forum
American Cancer Society Supporter
Business Intelligence Professionals
LinkedCincinnati
Aerospace Professionals
TDWI's Business Intelligence and Data Warehousing Discussion Group
GHIP- GAMING & HOSPITALITY INDUSTRY PROFESSIONALS GROUP (CASINOS-HOTELS-RESTAURANTS)
DWBI, Data Governance, CPM, Dashboard & Scorecarding
Linux Community
ex-CSC Alumni
ClearedPro Network
U.S. GOVERNMENT CONNECTIONS
DEFENSE AND AEROSPACE CONNECTIONS
Federal Government Contractors Group
Booz Allen Hamilton Alumni Network
University of Cincinnati, Department of Information Technology
US Government Security Clearance
Department of Defense
Pentaho - open source business intelligence
IFRS forum
Security Cleared Oracle Specialists
ETL Architects
Jobs@Oracle EMEA
Global Jobs Network
USA JOBS
IT Jobs USA
Careers @ Oracle Consulting. Sales, Delivery & Executive level.
Jobs @ Morgan Stanley - Smith Barney
The Wall Street Job Report
Royal Bank of Scotland - Vacancies
U.S. Department of Justice
U.S. Department of The Treasury
Cleared Networkers