Peter M. Hackley

6441 Scenic Drive South                                                                                                Phone:  (626) 644-0699

San Diego, CA  92037-6446                                                                   eMail:    p_hackley@hotmail.com 

Career Related Skills

·          Twelve years of experience in relational database design, data warehousing, programming and development
·          Excellent communication skills	·          Self-motivated hard worker
·          Diverse management experience	·          Strong leadership abilities
·          Analytical and problem solving skills	·          Works well with others in a team environment

Technical Expertise

SQL Server 7.0 / 2000 / 2005	ASP / DHTML / XML / MDX	SSIS / SSAS / SSRS
Transact - SQL	Intranet and Dashboard Development	VB & VB Script
Cognos / Crystal Reports	MS Project / Project Workbench / ERwin	Oracle 7 / PLSQL
DW Kimball Methodology	Database Modeling & Implementation	SDLC / RAD / MSF methodologies

Professional Experience

 

IndyMac Bank, FSB, Pasadena, CA                                                                                Mar. 2000 - Present

Position:  Data Warehouse ETL Development, Reporting Solutions & Team Manager 

Responsibilities / Accomplishments:

·       Designed and implemented a dimensional data warehouse (multiple data marts) for Mortgage Loan Origination using the Kimball methodology.

·       Technical  manager in charge of designing and building ETL processes to load data marts using Dynamic SQL, Stored Procedures and MS SQL Server DTS packages.

·       Team lead to develop data marts, cubes, MDX statements and reports to allow users to easily access data.

·       Designed and developed “Near Real Time” reporting system to drive production reports.

·       Managed upgrade projects and system migrations from SQL 7.0 and SQL 2000 to SQL 2005 platform.

·       Created Dashboard reporting solutions using ASP, HTML, Cognos and SSRS reporting products.

·       Responsible for understanding the bank’s businesses and communicating clearly with business resources.

·       Managed client expectations and identified, tracked and resolved technical issues.

 

 

Kroger/Ralph’s Grocery, Inc., Los Angeles, CA  (through Keane, Inc.)         Feb. 1999 – Mar. 2000

Position:   Program Manager of the Corporate Services Project Office

Responsibilities / Accomplishments:

·       Managed the design and development of an Inventory Tracking System (Access Interface, SQL 7.0 DB).

·       Designed and implemented methodology for resolving and documenting issues throughout the corporation.

·       Identified, analyzed and resolved technical issues and problems.

·       Managed technical team  in development, testing, conversions, and all other project aspects.

·       Achieved program goals and managed program to closure.

 

 

Home Savings of America ISD, Los Angeles, CA  (through Keane, Inc.)     Mar. 1997 - Jan. 1999

Position:   Team Lead of the conversion team for Y2K compliance project

Responsibilities / Accomplishments:

·       Performed program conversions, modifications and full file unit tests.

·       Identified and resolved technical issues and problems.

·       Defined and documented development and modification procedures and trained others on methodologies.

·       Managed team of programmers, maintained status, inventory and assignment lists.

 

 

General Dynamics/Martin Marietta Space Division, San Diego, CA                                    1989 - 1994

Titan and Atlas/Centaur Launch Vehicle Programs and SLC-3E Launch Pad Development Program.

Responsibilities / Accomplishments:

·       Designed and developed database system to automate status of all subcontractor data requirements using Omnis 7 and Oracle.

·       Designed and developed database system to manage global contract requirements and reports using Access and Oracle.

·       Performed requirements analysis, user interface design, and end-user training.

·       Management of multiple relations with sub-contracted engineering firms.  Created Statements of Work and managed sub-contractor deliverables, timelines and goals.

 

Certified Courses and Training

Relevant coursework:

·          R. Kimball’s Data Warehousing In Depth	·          Designing Bus. Logic using Microsoft MDX
·          Microsoft OLAP Solutions	·          Oracle Design and Development
·          Transact-SQL Programming	·          Advanced Oracle Programming
·          Mastering VB6 (Advanced Topics / Active X)	·          Oracle Developer 2000 & Oracle Forms

 

Additional Training:

·          Accelerated training through Keane, Inc. and Indymac in system design, coding, unit testing, debugging in mainframe, MSF and other PC environments, various application development languages.

 

Education

Master of Applied Science, University of Waterloo, Canada                October 1996

Information Systems, Department of Management Sciences                    Cumulative GPA:  3.8 / 4.0

 

Thesis:   Factors Influencing Multimedia Communication Systems Success

 

 

Bachelor of Arts, University of California at Riverside                           June 1988

Business Administration, Faculty of Business

 

 

Awards/Scholarships

·       Corp. IT Employee Recognition Award at IndyMac Bank, Fall 2006

·       Corp. IT Employee Recognition Award at IndyMac Bank, Spring 2001

·       Consultant of the Year Award, Keane Inc. Los Angeles Branch, 2000

·       Excellence Award for Client Recognition, Keane Inc., 1997

·       Rookie of the Year Award, Keane Inc. Los Angeles Branch, 1997

·       Core-Values Award for Exemplary Performance in Client Success, Keane Inc., 1997 and 1999

·       Performance Awards, Keane Inc., 1997 and 1998

 

References available upon request.