Michael J. Lack
- Enterprise Data Architect
- Batavia, OH
- Member Since Mar 27, 2023
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.
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.
analytical environment for customer product purchase analysis and product ranking
semi-structured customer analytic data
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.
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:
into a single centralized DB2 operational data store using real time messaging services
to support query and analysis of member claim data
IBM’s Virtual Machine software and the z/Linux operating system
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
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 |