Michael J. Lack

  • Enterprise Data Architect
  • Batavia, OH
  • Member Since Mar 27, 2023

Candidates About

 

Michael J. Lack   

                   

PROFESSIONAL SUMMARY:

 

I am an experienced professional in the field of technology designing, implementing and managing the

creation of customer solutions to address business issues to increase revenue and reduce operating

expenses through architecture upgrades, consolidation or replacement of existing hardware and software with

new strategic, state-of-the-art, more cost effective enterprise solutions.  I have successfully designed and

managed projects for large local, regional and international corporations while working for IBM as a senior

architect.

 

My responsibilities vary by project and generally involve a hybrid role of enterprise architect and

manager throughout the Agile and systems development life cycle. My primary focus has remained within the

data management, project management and business intelligence domains, I incorporate my many years of

enterprise hardware platform implementation, software integration, application development knowledge and

management experience into the architectural design to provide a strategic, state of the art,

end-to-end solution.  I have managed teams from 5 to as many as to 26 associates and implemented

architectural solutions utilizing the latest in virtualization, private cloud, SOA, middleware, data security,

and eCommerce based technologies.

  

 

  

 

  

WORK HISTORY:

 

April 2016 – April 2017                           Anthem                                                                                                                

Enterprise Architect Executive/Team Lead

Managed the data quality team and data governance design efforts for the construction of a centralized, customer centric, real time data warehouse and operational data store to support a consumer portal utilizing microservice API’s that facilitates access to all membership, product and claims data originally housed in mainframe legacy systems.

·          Managed the data profiling team to evaluate the actual content, structure and quality of the data by

   exploring relationships that exist between value collections within data sets to produce metrics scorecards

   and profiles utilizing the Informatica Data Quality software.

·          Managed the data discovery process to determine where Personal Identifiable Information is stored and

   how it conforms to specific rules and processes where obfuscation or data masking is needed.

·          Designed the meta data repository processes and data stores to enable the creation, capture and sharing

·                    of the full business context around critical business data elements including attributes, coded values,

·                    business rules, policies, reference data, links and data lineage utilizing Informatica Metadata Repository

·                    software.

 

 

July 2015 – April 2016          Computer Science Corporation- Commercial Business Process

Enterprise Solutions/Project Architect

Created the strategy, processes, design, integration points and project plans

to migrate client I/T systems from an in house infrastructure model into a CSC hosted environment.

The overall client goals of outsourcing the systems supporting the banking and insurance

applications is to reduce I/T costs and risks, implement new and emerging technologies

including but not limited to big data, cloud computing, cyber security, mobility,

social networks and web based services while maintaining core business systems.

 

April 2013 – May 2015          American Modern Insurance Group

Enterprise Solutions/Data Architect

Formulated and implemented an enterprise data management strategy to retire

multiple thirty year old mainframe systems and replace their three data warehouses

and data integration processes with strategic, cost effective and industry

leading packaged Insurance Suite and data warehouse software from Guidewire.

  •   Designed and Implemented a multi-tier scalable Cognos Business Intelligence Infrastructure
  •   Created an industry standard property and casualty enterprise data model
  •   Implemented an enterprise, self serve reporting and analytic data warehouse
  •   Implemented an IBM Business Glossary metadata solution within the enterprise
  •   Defined an architecture to support master data management and data governance
  •   Implemented 3 Oracle Exadata Appliances for the Guidewire Suite and Enterprise Data Warehouse        

  

 

Independent Consulting Contracts: 

 

December 2012 – April 2013              Kroger Company  

Project Architect Consultant  

Defined the business requirements, functional design specifications, integration

components and candidate services within a service oriented architecture for the

digital customer loyalty program.

  •   Defined data integration flows from the electronic point of sales systems into the dunnhumby

         analytical environment for customer product purchase analysis and product ranking

  •   Designed intersystem and intra-system integration points and data stores
  •   Implemented Cassandra partitioned data stores supporting structured, unstructured and  

         semi-structured customer analytic data

  •   Defined, documented and presented all design patterns to the technology review board for

         compliance and fulfillment of the overall corporate software implementation strategy

    

July 2012 – October 2012                   NewPage

Enterprise Data Architect Consultant  

            Implemented a set of dashboards to track the manufacturing process of coated specialty paper

products across the paper mills located in Kentucky, Maine, Maryland, Michigan, Minnesota and

Wisconsin.

 

Sept. 2011 – June 2012                    General Electric 

Data Base Architect Consultant  

            Created a data base architecture to fulfill the corporate directive to provide a private cloud

based shared resource infrastructure in support of a highly available, scalable, reduced hardware,

software and environmental cost solution with automatic failover for all GE products and services.

 

July 2011 – Sept 2011                        Devicor

Integration/Data Architect Consultant   

Designed and implemented a marketing and sales data mart and business intelligence reporting

solution to track the revenue and marketing activity of their medical biopsy instruments.

 

 

December 2010 – March 2011          DRS Technologies

Cognos BI Architect Consultant  

            Completed the design and consolidation of two distinct Cognos business intelligence reporting

environments and associated data stores into a single, hardware and software platform secured

by a single sign-on active directory network.  

 

 

August 2010 – December 2010        Fifth Third Bank

Data Architect Consultant   

            Designed and constructed a consolidated data mart populated from 4 separate data sources to track,

report and analyze Treasury core products sold and managed by the various 5th/3rd officers.  

 

 

 

 

 

 

May 2010 –August 2010                     Accenture

Solutions Architect Consultant  

Migrated three Coach Handbag e-Commerce web and database servers located in the United States, China and Japan to the Accenture data centers in Cincinnati, Cleveland and India as part of an outsourcing effort

by Coach in order to reduce ongoing support costs and standardize on the IBM Websphere e-Commerce software platform.

    

December 2009 – May 2010       A La Carte Promotions, LTD.

Business Owner / eCommerce Architect

            Architected and managed the creation of an e-Commerce sporting goods franchise.

  •   Selected sporting goods and apparel products and suppliers
  •   Established product pricing and inventory
  •   Created product catalogs and order tracking dashboards on both Amazon and company website
  •   Designed and installed the company e-commerce website and associated shopping cart software
  •   Installed, customized and integrated PayPal software with Amazon and the company website
  •   Optimized search engine ranking on Google and other major search engines

 

May 2009 – December 2009                WellPoint/Anthem

Senior Infrastructure Architect Advisor

Implemented designs and processes to consolidate physical web servers, exploit the latest IBM Z series processors and ZIPP specialty engines in order to offload MIPPS, and migrate to service oriented architecture. The following tasks were completed in support of this strategic initiative:       

  •   Created and implemented a strategic design to consolidate four IMS claims processing systems

         into a single centralized DB2 operational data store using real time messaging services

         to support query and analysis of member claim data 

  •   Reduced the number of physical web servers by implementing virtualized servers using

         IBM’s Virtual Machine software and the z/Linux operating system

  •   Created the strategic directional roadmaps and upgrade paths for the enterprise data

         management software to support future Service Oriented Architectures and Z Series Processors   

 

    

January 2008 – January 2009        Great American Insurance

Data Warehouse Architect Consultant  

Designed and implemented an equipment lease data mart and business intelligence solution

by consolidating 6 disparate data sources with 15 years of history each into a dimensional

data model to facilitate the analysis and reporting of leased products.  

           

Other Experiences and Positions:

 

Information Technology Manager

Managed all I/T systems, resources and a staff of 6 associates for a chemical manufacturing company with headquarters in Cincinnati, OH and manufacturing facilities in Fresno CA, Belgium, Luxembourg and Singapore.

    

Systems Development Manager

Managed a staff of 13 FTE’s to support the enterprise data warehouse and business intelligence

environments utilized by 7 business units with an estimated 13,000 user base.  Managed

all project related tasks, schedules, deliverables, budgets, architectural designs, standards and

processes during the systems development life cycle for the construction and delivery of data

warehouse, content archiving, internet security, reporting and analytic solutions across the enterprise.

 

Enterprise Data Architect

Assembled and managed a team of 12 associates and consultants to architect and implement a

solution to consolidate securities data from 15 legacy systems into a single operational data store

in response to the Securities and Exchange Commission initial audit of the internal controls

and processes for dealing with investment instruments bought and sold in financial markets.

 

Business Intelligence Architect/Project Manager

Designed, implemented and managed a team of 6 project consultants to build multidimensional

cubes and dashboards for the executive management team to track the engine overhaul

process across three separate manufacturing plants in order to monitor progress of the various

engine components and identify potential bottlenecks.

 

Pre-Sales Technical Marketing Specialist 

Successfully marketed and delivered Cognos business intelligence solutions at multiple  

clients in the Cincinnati area.

 

Vice President – Data Management/Data Warehouse/Business Intelligence   

Managed the data base administration, business intelligence and Focus reporting teams and their

effort to support all Specialty Division data bases, data warehouses, data marts, business intelligence

reporting and analysis platforms.

           

Project Manager/Pre-Sales Technical Marketing Specialist

Successfully marketed, installed, and managed the delivery of data management products for

this IBM Business partner.

 

Project Manager/Senior Systems Architect /Data Architect & Business Intelligence Specialist

  •   Senior Project Manager for teams ranging from 5 to 50 consultants
  •   Database and business intelligence marketing and technical specialist across the United States

 

 

 

EDUCATION:

College of Mount St. Joseph-Cincinnati Ohio

Degree:                Bachelor of Arts

Major:          Liberal Arts

GPA:             3.9

Academic Honors:   Summa Cum Laude
Alpha Chi Honor Society
National Deans List

 

Cincinnati Technical College-Cincinnati, Ohio

Degree:               Associate of Science

Major:        Business Data Processing/Computer Science

GPA:           3.8

Academic Honors:   Cum Laude

 

Certifications:            Six Sigma

 

References:      Available upon request

 

Domain:

Hands On Experience with the Following:

Languages: 

COBOL,Java

Operating Systems:

z/OS, DOS, VM, VMWare VMotion, Unix, Aix, Linux,Windows

Job Control:  

Cron, Rexx 

Data Bases/Access Methods:

IMS/DB/DC, CICS, Oracle 12C, DB2 LUW, DB2 Connect, DB2 z/OS, VSAM, SQL/DS

                                               

SQL Server, Postgress, Cassandra, Red Cap, MySql, NoSQL, Big Data(unstructured)

Security/Masking:

Oracle Encryption, Oracle Redaction/Masking, RACF, Active Directory,

                             

LDAP, Cognos Access Manager, Oracle Advanced Security Feature

Business Intelligence: 

Cognos Report Studio, Cognos Analysis Studio, Tableau

                                    

BusinessObjects(SAP/BO),SSRS,SSAS, QMF

Development: 

TSO, ISPF/PDF, Visio

DW Appliances:

Oracle Exadata

Extract Transform Load:

Datastage,Informatica, SSIS, SAP/BODS

House Holding & Profiling:

DataFlux, QualityStage, Informatica Data Quality

Data Modeling/OLAP: 

Erwin, PowerDesigner, Concensus for OLAP Design, Dimensional Modeling

                                    

Star/SnowFlake), Normalized(3NF), Data Vault   

Packaged Software:

Guidewire Insurance Suite, SAP/ERP, e-Commerce on IBM Websphere, Quickbooks

MS Office Tools: 

Excel,Word, Powerpoint, Sharepoint

Web Development :

HTML, XML, SOA

Project Management:

MS Project, Agile, Waterfall, SDLC, MADP

System Monitoring:

Hyperic, Strobe

Application Server: 

Jboss, Websphere

Process Improvement:

Six Sigma

IBM Mainframe

Operating systems, MVS, VM, JCL, JES, RACF, CA-7, LPAR, Z-Series Processors and  ZIPP Engines     

I/T Management

Former Business Intelligence Manager for a Uniform and Services Company, , I/T manager with a multinational Chemical Company and  AVP of Data Management with large Property and Casualty Insurance Company

Project Manager

Successful project manager with IBM and other consulting companies

Business Owner

Successful Business Owner of an Sporting Goods Franchise 

Metadata Management

Informatica Metadata Repository