MICHAEL HOLLINGSWORTH

Bolingbrook, Illinois *****

Cell: 630-***-****

ac5h4v@r.postjobfree.com

SUMMARY

Systems and software professional with over 25 years of experience in Information Technology and Business Analytics with emphasis on end to end data structures, solution design and integration. My goal is to be a Trusted Partner with stake holders, defining business objectives and providing a taxonomy that is centered on sound design principles, best practices, security economies of scale within a full stack visualization of data and systems. This ensures alignment and understanding of solutions with teams internally. Additionally, my goal is to provide a vision of a Flexible, yet robust process that can be used for years. This results in Design and implement highly scalable Customer Engagement application. ACCOMPLISHMENTS

Snowflake Cloud Analytics Data Warehouse Development building tool; Oracle Database, SQL Server Database Logical & Physical Data Modeling for Data Warehouses (Star Schema). System & Data Architecture.

Manage Cognos Support Process including PMR resolution and Issue Management. Apache Hadoop; Apache Spark.

TOGAF Framework.

Version Management.

Master Data Management and Data Governance.

Data Lineage Mapping Project Management Platforms. Experience in Agile Methodology (Scrum).

Experienced in delivering agile, Scrum and Waterfall models. ETL & Data Architecture: Informatica PowerCenter; IBM InfoSphere DataStage. Design data flows that extract information from multiple source systems, transform the data as required, and deliver the data to target databases or applications.

ETL Lifecycle Management.

I have created detailed specifications including diagraming, interface design, stream diagrams. SQL Tuning to produce rapid and accurate data uploads. Creating Database functions (Oracle\SQLServer) to pre-process data in the database minimize data uploads and data throughput.

(Database Functions and Procedures).

Data Dictionaries (InfoSphere Business Glossary).

Data Warehousing.

IBM DB2, SQW, Data Architect, Design Studio, Cubing Services and Data Architect (Rational Data Architect). SKILLS

Administrative, Apache, Architect, Business Automation, AWK, Backup, Bash,Capacity Planning, Intelligence, Business Strategy, Client facing Change Management, Cloud based and engagements, Data Modeling, Database Client/Server, Cognos 10 and 11 (Analytics 11), Administrator, Database Warehouse and Mart design Cloud based and Client/Server, Cognos 10 and 11 using Snowflake /Cloud Data Warehouse (Analytics 11), ETL, XML, Firewall, HP-UX, IBM, toolkit/Oracle PL/SQL /SQLServer SSIS/SSAS, IIS 7, Linux, Data and Application Migration, NFS, Database building and integration, Application OS optimization, Oracle, White Boarding and PPT delivery, SQLServer, Win7/Win10, personnel presentations, Red Hat, report development and management,coding, project management, requirements gathering, Shared Services platforms, prototyping, QA, RDBMS, Scrum & Waterfall, SDLC Python Automation scripting, third tier technical support, systems development and support, System

Administration, Unix Shells, UNIX scripts, Upgrades, Web Servers, IBM WebSphere

EXPERIENCE

BMW MC

Technical Product Owner 07/2015 to 12/2017

Solutions Architect IBM Cognos 10 BI Products.

The Cognos BI Global Shared Services project was 5 months delayed, due to no viable architect/technical integrator. The Go to Production Gateway was due in 4.5 months and the existing ecosystem was useless Systems Architect working in the PaaS Space providing global, internally managed Cloud environments for the IBM Analytics Applications stack.

Responsible for design, architecture, building and managing the Business Intelligence IBM Cognos TM1 and IBM SPSS Platforms for the Shared Service Platforms group utilizing Lean and Scrum project management methodologies.

This task results in a Reference Architecture for the product platform. Design of System Interfaces, Firewall Rules, system sizing, Load Balancing, SoD, Failover and B/R. Experience developing, documenting, and communicating governance processes across an enterprise. Managing the product release lifecycle, development of migrations concepts. Role serves as Operation Manager for assigned product stack including oversee of all internal product support. Works with third party support provider to assure all SLA's are met. Build responsibility and technical support/consulting for internal IBM Cognos TM1/SPSS related projects. Maintain product and platform robustness through testing schemes (penetration, interface & load testing). Organized and coded all documents related to due diligence for acquisitions. Includes IPv4 and IPv6 dual stack verification.

Develop and maintain Cognos user guidelines, best practices handbook Technical Experience Architecture & Administration.

JONESLANGLASALLE, INC

IBM Cognos Business Intelligence Administrator 07/2014 to 05/2015 Database Administration: DB2EE, Oracle, MS-SQLServer. Physical and logical database design for Relational and Multidimensional databases. Design and Implementation of Backup and Recovery strategies. Space management, user access, performance monitoring and tuning. Database Monitoring, Buffer pool Usage and Tablespace Usage Reporting. RDBMS interface languages: ANSI SQL, PL/SQL, and TSQL. Linux/Unix Systems Experience: Solaris, HP-UX, RHEL (Red Hat), SUSE and z for Linux. Unix Shells and Shell scripting: Korn, Bourne and Bash Shell, Sed and Awk. Web Servers: IIS 7, 7.5 & 8, Apache Tomcat.

Application Servers: IBM WebSphere 7, 8 and 8.5.

Windows-based O/S platforms including, Windows7, Windows 2012/2008 Servers. JLL Project Blue is a Corporate Solutions Reporting and Dashboard application providing JLL Global Commercial Real Estate Customers with key marketing analytics to assist in Business Strategy and Portfolio Management. Position required Installation, configuration, tuning and maintain all Cognos BI components in a Global, 24x7 environment from Development phase through to Production and hand off to Technical Services Organization. THE IRONSIDE GROUP

Senior Business Intelligence Consultant 03/2013 to 01/2014 Installations and configurations of IBM SPSS Modeler, Statistics and SPSS Collaboration and Deployment Services. Upgrades of Cognos 10.x for multiple server, distributed systems on z/OS and Windows 2008 platforms. Performed Training classes in IBM Cognos Workspace (Business Insight Advanced). PRAGMATEK CONSULTING GROUP

Principal Consultant 04/2011 to 01/2013

Consulted in multiple client projects, primarily in the mid-cap market. Provide systems architecture design and deployment and optimization services for IBM Cognos, TM1 and SPSS applications on multiple platforms on Stand-alone and Distributed environments. Implement ETL processes for staging data for reporting. Develop and Maintain Framework Manager models.

Logical Data Modeling and Architecture on Client projects. Implemented Security for IBM Cognos, TM1 and SPSS applications. Advised clients on Best Practices, Administration and optimization techniques. Evaluated client System Infrastructure to determine efficacy of the Landscape for project use. Performed Administrative tasks in support of project delivery. MDH CONSULTING

Principal Consultant 03/2009 to Current

Consulting Services on a sub-contract basis, specializing in Analytics & Business Intelligence development and deployment projects.

COGNOS, an IBM COMPANY

Solutions Architect 12/2006 to 03/2009

Developed comprehensive technical account plans in conjunction with Account manager that expanded the Cognos footprint including: requirements gathering, trial/prototype plans and closure planning. Performed advanced, complex prototyping for suite of Cognos 8 BI and CPM products. Successful engagements with all General Motors Domains including establishment of Cognos as the IT Mobile Reporting Platform.

Design and prototyping of the Executive Information Dashboard and Corporate Project Tracking System Dashboard. Led Implementation teams for these projects.

Developed BI Roadmap for GM utilizing Cognos 8 as a basis, gained approval for implementation. Developed a Trusted Advisor relationship with key technical and business personnel. IPLOCKS, INC

San Jose, CA

Database Security Engineer 01/2004 to 01/2006

Helped build an undeveloped Midwest Sales Region for product launch by playing an active role in marketing, conducting presentations, constructing initial prospect pipeline, enlisting 3 resellers, and closing 3 key accounts for beta program.

Evaluated Client Database Security infrastructure and advised as to possible improvements. HYPERROLL, INC

Mountain View, CA

Sales Engineer 01/2002 to 01/2004

Drove technical Proof of Concept (POC) cycles for a number of successful sales, including the single largest sale at that time in company history, Wachovia.

Responsible for providing and coordinating technical support during the entire sales cycle from qualification to closure.

Developed Multi-Dimension Cubes utilizing XML scripting. BMC SOFTWARE, INC

Lisle, IL

Senior Software Consultant 01/1998 to 01/2002

Pre-Sales consulting specialist position responsible for all BMC Distributed Database Products, specializing in database Backup and Recovery tools.

Performed formal product presentations, product demos and chalk talks for both Technical and Business level audiences.

Received Performance Bonus and an award for Product Replacement success at large customer. FLORISTS' TRANSWORLD DELIVERY, INC

Downers Grove, IL

Oracle Database Administrator / UNIX System Administrator 01/1997 to 01/1998 Database Administrator for all databases and System Administrator for all UNIX systems. Performed physical design and creation of numerous databases, as well as database monitoring and schema management.

Implementation of Backup and Recovery strategies.

Provided Unix System Administration to include Backup and Recovery of operating and file systems, patch installation, system upgrades, user creation and maintenance, file system management and NFS. EQUIFAX MARKET KNOWLEDGE, INC

Lombard, IL

Database Systems Developer / Unix Programmer II 01/1994 to 01/1997 Provided database administration, systems development and support for clients in a Client/Server environment. Performed coding, database and QA support for their Predictive Analytics and Scorecard business practice. Developed ETL processes from physical database design through the complete production cycle, script creation, database creation, data loading, code development, quality control and creation of output data sets. Logical and Physical design and creation of numerous Oracle databases. Utilized various UNIX command and scripting utilities including AWK, SED, CPIO and TAR. SQL, PL/SQL, ProC, OCI and UNIX scripts (Bourne and Korn Shells). Product Owner and Systems Architect

(Statistics, Modeler and Collaboration and Deployment Services). Cognos 10 BI Administration & Architecture in 24x7 LUW global environments. IBM Cognos 10/8 BI product suites including Framework Manager and Cognos 10 BI and TM1 Suites. Product Certifications in Cognos 10 and 8 Administration and Technical Specialist. Change Management (Report & Package Deployment through SDLC). Version Migration including Fix Packs and Upgrades preparation & Installation. System Performance including Performance Tuning and Capacity Planning. Infrastructure, Configuration, Installation & Customization of Cognos BI Components. Automation of Processes and delivery of Cognos Artifacts. The Cognos BI Global Shared Services project was 5 months delayed, due to no viable architect/technical integrator. The Go to Production Gateway was due in 4.5 months and the existing ecosystem was useless The Cognos BI Global Shared Services project was 5 months delayed, due to no viable architect/technical integrator. The Go to Production Gateway was due in 4.5 months and the existing ecosystem was useless Developed and managed a stable Cognos 10 BI distributed ecosystem including TM1 10. Developed the Data Lineage Maps for the Cognos Development Team. Developed the Operations Support processes and trained Offshore Ops team and handed off the systems. Developed and managed a stable Cognos 10 BI distributed ecosystem including TM1 10. EDUCATION AND TRAINING

BACHELOR OF SCIENCE: MATHEMATICS AND COMPUTER SCIENCE 1992 IBM COGNOS 10 BI CERTIFIED ADMINISTRATOR (COG-122) IBM COGNOS 8 BI CERTIFIED ADMINISTRATOR (COG-122) IBM COGNOS 8 BI CERTIFIED BUSINESS INTELLIGENCE TECHNICAL SPECIALIST (COG-105) IBM SPSS STATISTICS CERTIFICATION LEVEL 1 (IBMSPSSSTATL1P): INFORMATION TECHNOLOGY

University of Illinois at Chicago