Michael Hodges Email & Phone Number

Berrien Springs, Mi, Us

• Managing a group of employees and contractors to build a Kimball-based Data Warehouse to be the single source of truth. Integrating multiple systems into a large-scale Data Warehouse to enable data-driven decision-making.• Upgrading corporate-wide reporting from emailed reports to self-service BI.• Implementing a data governance council to ensure data integrity.• Reviewing 200+ SSRS written over the last 30 years to depreciate, combine or migrate to Power BI, with an emphasis on ensuring financial integrity and building trust in reporting.

Kansas City, Mo, Us

• Managed the Data Engineering and Data Analysis teams in an Agile environment building out data lake comprised of on-premises and cloud systems to provide real-time reporting.• Developed and implemented a DMBOK approach to data governance, data quality, data modeling, and data security.• Overhauled real-time Auditing, Accounting and Financial reports and dashboards. • Helped with 1st and 2nd level helpdesk tickets for applications, platforms, cloud, and data.• Oversaw a cloud initiative to move legacy systems to Snowflake, estimated to save over $250k annually.

South Bend, In, Us

Head of Analytics and Integration for an International Steel Processing Company with factories in North, Central and South America. Utilizing the latest technologies, we are merging data from on-premises and cloud systems to enable a comprehensive view of the company’s financials, operations, logistics, and smart manufacturing.• Managing the Data Analytics and Integration group, specializing in global reporting and data integration, supporting a company of over 1000 employees.• Directing a Digital Signage initiative to provide real-time information to all corporate staff; Operations information on the shop floor; Marketing and Human Resources information in lobby and break areas.• Incorporating “Smart Manufacturing” by pulling in real-time data from the factory floor. This allows Executives to see and resolve issues much faster, saving labor and materials.• Working on a new Artificial Intelligence/Machine Learning project designed to improve production.• Managing transition to cloud services, where appropriate. Utilizing Microsoft Azure and Dynamics 365.• Integrating disparate data sources into one data repository, enabling reporting across the entire business.• Implementing a corporate-wide Master Data Management program to ensure our data provides excellent value to the company and single source of truth.

Advising IT Executives within the data space; PaaS, SaaS, IaaS, Infrastructure, and Digital Transformation necessary to integrate data into their decision-making.• Consulting with Executive Teams to set direction and translate business priorities into a manageable technical agenda. • Collaborating with SAP and Microsoft to demonstrate Enterprise Data Solutions for small to mid-sized companies. Delivering projects that measure, collect, analyze and report business intelligence and analytics providing critical business solutions.• Delivering in partnership with Management to perform IT Assessments and advise on best practices, data solutions, governance, quality and strategic planning.

Bellevue, Washington, Us

Head of Mid-America Data Practice utilizing Microsoft Azure Cloud Development. Responsible for $2+ million in projects managing a combination of on-premises and offshore Cloud Architects, ETL Developers and Business Analytics Developers. Responsibilities included staffing, Executive briefings, strategic sales and product development for PaaS/IaaS/SaaS projects in Microsoft Azure.• Program Director for the implementation and custom development for a Transportation solution.• Pre-sales Technical Manager for two Sales Directors, giving presentations, demonstrations and proof of concepts to prospective clients across the United States. Delivered technical talks at conventions to bring in new clients.• Experienced in Microsoft Azure, Microsoft BI Stack, Informatica, Hadoop and Data Management.• Introduced smart technical decisions while collaborating with leaders on the business-side by providing the technology vision and leadership in the development, implementation and support of the business.

Novi, Michigan, Us

• Helped establish a practice in Ohio to consult with companies in Data Warehousing and Business Intelligence utilizing offshore development staff.• Managed a 6-month project to ingest data into Microsoft Azure and present self-service dashboards in Power BI.

Global, Us

Accomplished Data Management Architect working with Fortune 500 companies to help solve unique problems using Data Warehousing, Business Intelligence, Big Data Technologies, and Advanced Analytics. Managed onshore and offshore resources, consulting with Business Leadership to help companies gain insight into its critical operations through reporting and analysis tools. Interviewed, hired, mentored and managed a staff of data architects.• Project Leader, Analyst, Data Modeler and Architect for Healthcare projects. Responsibilities include working with Business Leaders to document the business process and design a new Data Warehouse system pulling data into a Cloud-Hosted Oracle Data Warehouse using customized Informatica OBIA ETL and OBIEE. PeopleSoft Modules accessed and modeled for Oracle Data Warehouse and OBIEE include Asset and Maintenance Management, Contracts, and Supply Chain modules.• On-premises Project Leader and Informatica Power Center and Power Exchange Developer directing a 25-member Offshore Development Group. Informatica development on a Banking project, consolidating data from many AS/400 systems into a SAP HANA Business Warehouse. • Subject Matter Expert for Telecommunications, Financial Services and Healthcare Industries to assist in project estimations and sales presentations to prospective Clients globally.

Kansas City, Missouri, Us

Client-Facing Data Warehouse and Business Intelligence Architect developing customized solutions to manage and integrate electronic medical records, computerized physician order entry and financial information, enabling executive reporting, planning, daily schedules and key performance indicators. • Consulted with Healthcare organizations to utilize the Cerner Millennium Data Framework by incorporating external data sources into the Data Warehouse model, enabling Master Data Management for more robust Business Intelligence Reporting.• Created Informatica Power Center and Power Exchange ETL, SAP Business Objects Reports and Xcelsius Dashboards for Healthcare Staff.

Minneapolis, Mn, Us

Consultant with an E-Commerce company to create a Business Intelligence platform for Corporate Strategy, Customer Relationship Management (CRM) and Marketing ROI.• Collaborated with Sales and Marketing Executives to determine their E-Commerce Data Warehousing and Business Intelligence needs.• Data Modeling and Microsoft SSIS ETL to design and develop a Marketing Data Warehouse that keeps track of unique visitors and their shopping habits. Enabled the Client to sell advertising on their website, creating an additional revenue stream for the Company.

Plano, Tx, Us

Consultant for the Rochester City School District to deliver the School Performance Analytics (SPA) Program, a Federal Government Initiative, tasked to deliver a Data Warehouse to provide a comprehensive view of students, staff and school performance.• Responsible for all Extract, Transform and Load (ETL) operations on a Sun Unix-based system. • Utilized Oracle Warehouse Builder 11g (OWB) to import data from six data sources of record into a multi-dimensional database layout enabling quick and easy access for reporting purposes.• Created OWB mappings to load 50+ dimensions and 10+ fact tables for use with Oracle Business Intelligence (OBIEE) for comprehensive reporting.

Ingelheim Am Rhein, Rhineland-Palatinate, De

Project Manager, Data Warehouse and Business Intelligence Developer for the Enterprise Corporate Gateway, an Oracle 10g Data Warehouse and Cognos Reporting System used for Strategic Business Solutions, Financial Analytics, Customer Relationship Management and Executive Dashboards.• Enterprise Architect for the Cognos Planning Group that gave the Financial Group an Enterprise-wide Financial Performance Management Product. Defined the system architecture to setup a multi-server, scalable system that improved performance by 800%• Project Manager of Business Intelligence solutions for Finance, Operations, Human Resources, Sales and Marketing by developing Business Requirements, Flexible Dimensional Models, Data Cubes and Structured Reports• Project Leader and Developer for multiple simultaneous projects requiring coordination with key business sponsors, developers, analysts and end-users to maintain timelines, milestones and ensure successful launch of our products. Key Projects include a Sales and Marketing Territory Alignment System that allowed Sales Territories to be reconfigured easily, a Financial Gateway Project that saved more than $100,000 annually to create Executive Annual Financial Statements and Data Quality initiatives

Toronto, On, Ca

Project Manager and Senior Financial Software Architect for Financial Management Products.• Project Manager of an Offshore Development Project that developed and maintained Premier Retail Equity Products serving Financial Advisors and other Wealth Management Professionals by offering real-time, historical and fundamental stock price data• Lead Developer for the Stock Price Retrieval Interface, an application designed for speed and accuracy to capture asset (stocks/bonds) prices and perform adjustments (splits/mergers)• Key Accomplishments include conceiving of, presenting to management and developing a new database application for customer support personnel. This application fulfilled a corporate initiative to decrease client requests by giving top-level Support staff, their own tools to investigate issues.

Overland Park, Kansas, Us

Team Leader for a 100+ Terabyte DB2 Data Warehouse Project designed to help Marketing, Operations and Executive Management.• Project Lead for six Developers and Database Administrators to create a massively parallel processing (MPP) DB2 Data Warehouse storing Call Detail Records on the Sprint Network• Developed in C++ to create a parallel bulk insert of data and create aggregation tables

Memphis, Tn, Us

Designed and developed client-server based Unix applications interfacing with a Sybase relational database.• Design Team member and Lead Developer of a high profile application projected to generate over $10 million in revenue per year. Due diligence was performed at every phase of the Software Development Lifecycle, including gathering requirements, design, development, testing and end-user training.

Basking Ridge, Nj, Us

C++ Developer on a joint venture between Telefonos de Mexico and MCI called AvanTel, delivering long distance services to Central and South America.

Project Leader and Software Developer in the Billing and Archival Division, directed to ensure 100% billing and archival of customer call data for problem resolution and fraud detection.

Armonk, New York, Ny, Us

ADA Software Development Consultant on two large-scale Department of Defense projects.