Roger J. Cogswell, CPCU "BI is primarily a non-technical communications solution with a complex technical component."

adlg6o@r.postjobfree.com 1-317-***-**** Enterprise Data Management/Architecture/Modeling/Construction

I use SAFe agile principles to deliver value quickly and to establish a culture of continuous improvement. By fostering contribution, collaboration, and cooperation among team members, I inspire personal growth and previously unrealized levels of group performance. I do it by personal example, having a genuine interest in the welfare of others. I show product development teams how to add value in alignment with organizational objectives. This empowers leaders to prioritize feature delivery while allowing teams to be creative in determining how best to design those features. I am effective as a salesperson, technician, pre-and post-sales account manager, counselor, and confidante.

I have contributed articles to the international business intelligence community in collaboration with Max and Max Communications for The Data Warehousing Institute (TDWI) and 1105 Media, including Where Their World Begins to Change and Say "Yes" to Your Business Users.

Quick Value Delivery:

In 15 months I designed and guided implementation of the data warehouse for the Texas Student Data System – still in use more than a decade later - overcoming issues with multi-tenancy, data non-conformity, and changing legal requirements

In 3 months produced a post-merger validated consolidated financial statement with integrated KPIs for a healthcare enterprise

In two months designed and delivered highest-cost-of-delay information product, a top prospects list for school account executives

In six months, reorganized personnel and leadership for an enterprise information team enabling it to meet contractual SLAs

In six weeks integrated operational information from an acquired business and migrated Dynamics CRM to AWS

In six months delivered 3 DWs with BI reporting to track flights for advertising campaigns sold by 3 major media outlets

In four months built foundational framework for enterprise data management for $100B US introducing broker/dealer

Soft Skills:

Scaled Agile Framework (SAFe) trained; leadership trainer and coach; guest lecturer, individual and group counselor

Well-read (personal development, sciences/technology, history, psychology, philosophy, spirituality)

Wide variety of hobbies/interests (music/trumpet, running/hiking, Transcendental Meditation, human potential)

Marriage and pre-marriage counselor, life coach, spiritual advisor, personal and professional mentor

Technical Skills:

Databases: modeling, architecture, hardware/cloud (AWS/Azure), and administration supporting applications, reporting, and analysis

Business Intelligence (BI): data analysis, exploration, mining, profiling, quality, cleansing; self-service, push notifications

ETL, integration, parallelization, SQL query and job execution optimization, star schema, data vault, dimensional, 3-6NF

Programming: systems, applications, procedural, ALGOL-like, and object-oriented languages

Tools:

SQL Server (SQL/SSIS/SSAS/DAX/MDX/SSRS/DQS/MDS), Oracle, DB2, Adabas, ER/Studio, Erwin, Visio, AWS, Azure

IBM Cognos Certified Solution Expert, Power BI, QlikView, Tableau, SAP Business Objects with Crystal

Visual Studio, Informatica, DataStage, DecisionStream, PL/SQL, T-SQL, ServiceNow, JIRA, Confluence, Slack

C#.NET, VB.NET, Java, NetBeans, JavaScript, COBOL, IBM Assembly Language, Fortran, ALGOL, Natural, Pascal

Cogswell Consulting LLC, Managing Partner – Fishers, IN Jun 2016 – present

My intention for Cogswell Consulting has been to collaborate with other experts in the various disciplines involved in the art and science of information management so that I can provide my clients with sustainable solutions that support and encourage their continuous improvement.

Entergy / Capgemini – New Orleans, LA Mar 2020 – Apr 2021

Manage Analytics Reporting and Data Warehousing support teams to fix breaks and deliver minor enhancements using ServiceNow, Cognos, SAP BOE, Crystal, Power BI, and Informatica technologies.

Responsible for meeting SLAs under Capgemini’s support contract with Entergy.

Unified Women’s Healthcare – Boca Raton, FL Sep 2019 – Mar 2020

Merged NextGen and Athena data into an SSAS tabular model to provide consolidated financial reporting in Power BI

Established a roadmap of data management and governance practices to support and sustain analytics delivery

Cambridge Investment Research (CIR) – Fairfield, IA Oct 2018 – Jun 2019

Implemented a structured agile framework approach to data management and data delivery for legal compliance

Served agile team as data architect, BI/DW developer, and as coach for product owners and team members

Established a roadmap for the future of data management practices and procedures and for data governance

Texas Association of School Boards (TASB) – Austin, TX Mar 2018 – Aug 2018

Implemented a structured agile framework approach to deliver weighted shortest job first (WSJF), a top prospects list

Served agile team as data architect, BI/DW developer, scrum master, and product owner

Sustained progress of data governance program in its initial stages of development

Worked directly with business unit directors and their stakeholders to define WSJF while building a product backlog

Developed roadmap for unifying business unit data and operations to provide integrated, improved customer service

Brought clarity to communications between IT staff and business stakeholders through development of data models and data profiles to illustrate opportunities to align enterprise architecture with organizational aims

TRIMEDX USA – Indianapolis, IN Feb 2017 - Feb 2018

Implemented scaled agile framework (SAFe) for BI/DW product development and delivery, coordinating that effort with a certified SAFe trainer and coach

Served the agile BI team as data architect, BI/DW developer, scrum master, and product owner while helping management to attract and hire qualified staff to permanently fill these roles

Trained existing staff how to create and use both data vault and dimensional modeling techniques

Worley Claims Services – Fishers, IN Nov 2016 – Feb 2017

Designed and helped construct processes to integrate operations of newly-acquired subsidiary

Executed migration of MS Dynamics GP from on premises to AWS cloud

Centric Consulting LLC, Manager – Fishers, IN Feb 2012 – Jun 2016

Participated in the growth of the company’s data and analytics practices both in Indianapolis and nationally. Introduced two new clients and created many new prospecting and networking opportunities. Brought favorable attention to the company through the publication of articles written for TDWI and 1105 Media.

Indiana Farmers Mutual Insurance Company – Indianapolis, IN

Designed and helped construct DW/BI solution using MS SQL Server 2014, SSIS, SSAS tabular, Power BI, and Tableau

Ensured deliverables met expectations of the client’s executive team.

Western Reserve Group – Wooster, OH

Brought low-performing MS SQL Server 2012 R2 SSIS ETL jobs up to expected performance levels

Presented to executive team a summary of options for improving overall data management efficiency

Ascension Health – St. Louis, MO

Designed and constructed an enterprise data warehousing solution to satisfy reporting requirements for clinical care excellence team using MS SQL Server 2014, SSIS, SSAS multidimensional, and SSRS

Delivered roadmap for future improvements to enable more rapid integration of new data sources

Keihin North America – Anderson, IN

Designed and constructed an enterprise DW/BI solution to warehouse and report information measuring overall equipment effectiveness using MS SQL Server 2014, SSIS, and IBM Cognos 10 Business Intelligence suite

Roche Diagnostics Corporation – Indianapolis, IN

Modified a customized sales and marketing software package to accommodate organizational changes

United States Infrastructure Corporation – Indianapolis, IN

Completed SSIS construction and resolved quality issues uncovered during solution implementation

Simon Property Group – Indianapolis, IN

Prepared and presented an introduction to Data Vault and Agile BI concepts and implementation strategies

Implemented reporting solutions for financial operations that the team used to reduce vacancies in malls

Developed project plan for upgrade to Cognos 10

Navion Healthcare Systems – Indianapolis, IN

Designed reporting solution for cardiac registry reporting using ER/Studio, SSIS, and SAP Business Objects BI 4.0

Evaluated MicroStrategy, IBM Cognos 10.2, and SAP Business Objects BI 4.0 for purchase for this implementation

Interviewed and selected BO developer and SSIS ETL resource

Motorists Insurance Group – Columbus, OH

Architected framework for enterprise data warehouse and business intelligence reporting using ER/Studio, Oracle DB, SSIS, and SSAS multidimensional models, along with Data Vault and Agile BI development methodologies

Theoris, Inc., Senior Consultant – Indianapolis, IN May 2010 – Dec 2011

Sallie Mae (Navient) – Fishers, IN Produced BI and ETL solutions and managed and mentored ETL development staff

IBM Lab Services, Senior Cognos Consultant Jan 2008 – May 2010

Ceridian – Bloomington, MN Implemented BI solutions using Cognos 8 BI with Cognos Planning, TM1, and Hyperion Essbase

Region 10 Educational Service Center – Richardson, TX

Completed delivery of four complex interactive reports critical to the success of Region 10's multimillion-dollar EMPOWER Data Warehouse and Business Intelligence offering, now the Texas Student Data System

Met with the superintendents and administrative staff members of client school districts to define requirements

Served as a close and trusted adviser to the CIO and the Director of Data Warehousing in matters of the BI road map, allocation and acquisition of staff, and personnel issues

Howard Hughes Medical Institute (HHMI) – Chevy Chase, MD Implemented financial reporting on laboratory budgets

Del Monte Foods – Pittsburgh, PA, and San Francisco, CA Developed executive dashboard reports for CEO and senior sales staff

Sephora – San Francisco, CA Resolved OLAP reporting issue using MDX, Hyperion Essbase, and Cognos Multidimensional model

PMI Mortgage Insurance – Walnut Creek, CA Rewrote Cognos 7 reports in Cognos 8 using materialized views for efficiency

DCG Software, Assistant to the CTO – Indianapolis, IN Jun 2007 – Dec 2007

Time, Inc. – New York, NY Turner Broadcasting – Atlanta, GA Discovery Channel – Silver Spring, MD

Directed the overseas ETL development effort for both Oracle and SQL Server data warehouse platforms

Served as the primary Cognos report developer while also providing support for simultaneous development using SAP Business Objects and MicroStrategy

State Auto Insurance Companies, Database Administrator Architect – Indianapolis, IN Jun 1999 – Jun 2007

As a member of the DBA staff, served as technical lead for State Auto's data warehousing initiative

Built marts and SSAS multidimensional cubes with MDX to support Actuarial Department’s pricing of auto insurance

Performance tuning, disaster recovery planning and implementation, and maintenance for over forty SQL Server instances, using maintenance plans, replication, and clustering to provide for failover and high availability

Upgraded instances from SQL Server 2000 to 2005, automated maintenance tasks, ended scheduled off-hours support

The Twentieth Century Indianapolis, IN Boston, MA Louisville, KY New York City, NY

Minister of the Gospel ordained by Louisville and New York City International Churches of Christ

Agent, Life and Health Insurances, Northwestern Mutual Life (NMFN)

IT engagements: Merrill Lynch, Dun & Bradstreet, Eli Lilly, Conseco, Mayflower Transit, Federal Home Loan Bank, others

Thank you for reading all this! A full accounting of last century’s activities is at www.linkedin.com/in/rogerjohncogswell

Education

Massachusetts Institute of Technology (MIT) – Cambridge, MA Nutrition and Food Science (Biology - Course 7B)

Lambda Chi Alpha Fraternity, MIT Orchestra, Concert and Jazz Bands, Chamber Music Society, The Tech, Wrestling, Cross Country

Training

The Data Warehousing Institute (TDWI) World Conferences 2004, 2006, 2014 Entered into writer’s agreement 2015

Zarvos Leadership & Coaching - Leadership Mentoring and Life Coaching 2007 – present

IBM Certified Solution Expert – Cognos 8 BI 2010

IBM Certified Developer – Cognos 8 BI Metadata Models 2010

IBM Certified Developer – Cognos 8 BI OLAP Models 2010

IBM Certified Designer – Cognos 8 BI Reports 2010

IBM Certified Designer – Cognos 8 BI Multidimensional Reports 2010

Cognos 8 BI Advanced Report Writing and Advanced Data Modeling 2008

Chartered Property-Casualty Underwriter (CPCU) 2007

Informatica PowerCenter 7 Developer and Administrator 2005

Indiana Informatica Users Group 2006

Toastmasters International (CTM) 2003 – 2007

Series 6, Life, and Health Insurance licenses 1991 – 1994

Contact this candidate