Data Architect

SUMMARY OF QUALIFICATIONS

Senior Business Intelligence professional with 19 years of overall experience in the automotive, finance, healthcare, professional services, retail, and public utility industries.

Skilled at architecting data warehouses and data marts.

Skilled at coaching and mentoring business intelligence professionals.

Skilled at managing cultural turnarounds.

Skilled at designing and developing scorecards, dashboards, and reports.

Led teams of up to 8 direct reports.

Performed duties as a resource manager.

Managed budgets in excess of one million dollars.

Certified Project Management Professional and Six-Sigma Yellow Belt.

EXPERIENCE

Straightforward – MD LLC, Palm Desert, California

Owner/Consultant 10/2016 – Present

Experienced in project management, information management, and architecting solutions that are precise and easy to understand that lead to measurable positive business results.

●Subcontracted at Kinetic Personnel Group

oDesigned and developed BI solutions for a healthcare managed services organization utilizing SQL Server 2008, SSRS, and SSIS.

Eisenhower Medical Center Rancho Mirage, California

Data Warehouse Architect 07/2014 – 03/ 2016

Work with business and IT teams across the enterprise to identify, analyze, design and implement effective data warehouse (DW) and business intelligence (BI) architecture and strategies to support current and future business operations. Coordinate the DW/BI work effort and insuring milestones are delivered on time, in scope and on budget.

Managed portfolio for the clinic business by creating an open communication forum for the stakeholders and managing the projects that led to an increase in efficiency and accurate financial analysis.

Shaped and delivered architect standards for the team for consistency of deliverables.

Developed and delivered an easy to use and access BI data solution for the health clinic financials.

Developed and delivered a data mart and OLAP solution to accurately measure the length of stay and provider productivity metrics that replaced a manually intensive process.

Developed process to incorporate ICD10 information.

Harley-Davidson Motor Company Milwaukee, Wisconsin

Senior Business Intelligence Analyst 05/2000 – 04/2014

Lead teams in thinking critically to tackle complex challenges and thriving in a fast-paced environment working with cutting edge technology and large datasets.

Managed the business relationships. Participated in the building of the roadmap and strategy for information management. Increased customer engagement by implementing strategies to promote the value of IT service and alignment of IT strategy to business goals.

Delivered the business intelligence maturity assessment via the Gartner tool and list of heavy analytic/reporting users that resulted in a guided approach to increase the maturity level within the context of the business needs and initiatives.

Coached personnel who were making a career change to become business intelligence professionals.

Managed the team’s operational budgets and resource forecasts to provide a view into monetary or organizational constraints.

Liaised between the IT departments and other departments within the company to shape demand for Information Management technology solutions and services.

Managed and delivered the entire project lifecycle from scoping and planning, requirements gathering, design, development, testing, and implementation of a $1.5 million project for the Harley-Davidson subsidiaries, H-D Financial Services and Motor Company, which resulted in harmonized environment for data warehouse and business intelligence policies and procedures, tools, and data.

Delivered 4 data mart and business intelligence solutions, OLAP, reports, and dashboards, in the data warehouse portfolio for the captive finance subsidiary, H-D Financial Services through leadership of the solution design and implementation teams which provided the agile usage of the data for sound business decisions during the nation’s recession.

Increased customer engagement by implementing strategies to promote the value of IT service and alignment of IT strategy to business goals.

Represented Harley-Davidson in the SAP Business Intelligence executive briefing in Vancouver to deliver requirements to enhance the SAP BI tool suite.

Managed environment enhancement projects to enable or introduce tools and/or capabilities for data management and business intelligence.

Hired and managed a team to provide IT services which included tracking and closure of issues related to production systems operations which resulted in a planned approach to support business intelligence and data integration.

Conducted a speaking session on data integration at the IBM Information on Demand conference

Developed and executed a training plan to mentor and support the transition of employees to the Business Intelligence team.

Provided technical input into compelling business cases to further enrich and increase the data management capabilities of Harley-Davidson.

Delivered cost reduction in the management and strategy of the sales and marketing department by designing and delivering the architectural design for the 1st data warehouse for Harley-Davidson.

Reduced the business process of managing the field personnel in sales targeting to guide dealers in ordering parts and accessories at the bi-annual expo from a 2 day cycle to a 30 minute cycle through the design of a real time analytic solution to track orders and display via mobile devices.

Designed and developed 9 data marts, multidimensional OLAP cubes, and business intelligence solutions in the data warehouse portfolio for the H-D Motor Company to increase company profits via the growth of the descriptive analytic capabilities.

Established the data warehousing competency and data management standards with a team of data architects.

Developed logical and physical enterprise data models and data reuse strategies for the data warehouse/mart environment that resulted in reduction in future labor costs for data mart projects.

Represented Harley-Davidson at the Microsoft customer collaboration meetings for business intelligence in Redmond to drive enhancements into the SQL Server Analysis Services OLAP product.

Key Skills

Strategic Thinking

Team Building & Development

Communication

Effective Listening

Project Planning & Management

Data Warehousing & Business Intelligence Management

Resource Management

Business Relationship Management

Data Governance

IT Service Management

Business Analysis

Change & Risk Management

SDLC

Data Architecture, Analysis & Design

Supplier Management

TECHNOLOGY & METHODOLOGY PROFICIENCY

BI Tools: Dashboard: SAP Xcelsius

Data Discovery: SAP Explorer, SAP Lumira, Tableau Software

Data Model: CA Erwin, IBM InfoSphere Data Architect

ETL: IBM DataStage, Microsoft SSIS, SAP Data Services

OLAP: Microsoft SSAS, SAP Business Warehouse

Reporting: SAP Business Objects, SAP Crystal Reports, Microsoft SSRS

Data Model: Kimball Warehouse Methodology

Databases: Oracle, SQLServer, DB2, MySQL

Project Methodology: Iterative, Waterfall

Project Management: Microsoft Project

EDUCATION & CERTIFICATIONS

Master of Business Administration Keller Graduate School of Management Milwaukee, WI

Bachelor of Business Administration – MIS University of Wisconsin – Milwaukee Milwaukee, WI

Project Management Professional (PMP) Certified through Project Management Institute (PMI)

Six Sigma - Yellow Belt Certified through Harley-Davidson, Inc.

Contact this candidate