| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateRoger J. Cogswell, CPCU "BI is primarily a non-technical communications solution with a complex technical component."EMAIL AVAILABLE PHONE NUMBER AVAILABLE Enterprise Data Management/Architecture/Modeling/ConstructionI 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 requirementsIn 3 months produced a post-merger validated consolidated financial statement with integrated KPIs for a healthcare enterpriseIn two months designed and delivered highest-cost-of-delay information product, a top prospects list for school account executivesIn six months, reorganized personnel and leadership for an enterprise information team enabling it to meet contractual SLAsIn six weeks integrated operational information from an acquired business and migrated Dynamics CRM to AWSIn six months delivered 3 DWs with BI reporting to track flights for advertising campaigns sold by 3 major media outletsIn four months built foundational framework for enterprise data management for $100B US introducing broker/dealerSoft Skills:Scaled Agile Framework (SAFe) trained; leadership trainer and coach; guest lecturer, individual and group counselorWell-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 mentorTechnical Skills:Databases: modeling, architecture, hardware/cloud (AWS/Azure), and administration supporting applications, reporting, and analysisBusiness Intelligence (BI): data analysis, exploration, mining, profiling, quality, cleansing; self-service, push notificationsETL, integration, parallelization, SQL query and job execution optimization, star schema, data vault, dimensional, 3-6NFProgramming: systems, applications, procedural, ALGOL-like, and object-oriented languagesTools:SQL Server (SQL/SSIS/SSAS/DAX/MDX/SSRS/DQS/MDS), Oracle, DB2, Adabas, ER/Studio, Erwin, Visio, AWS, AzureIBM Cognos Certified Solution Expert, Power BI, QlikView, Tableau, SAP Business Objects with CrystalVisual Studio, Informatica, DataStage, DecisionStream, PL/SQL, T-SQL, ServiceNow, JIRA, Confluence, SlackC#.NET, VB.NET, Java, NetBeans, JavaScript, COBOL, IBM Assembly Language, Fortran, ALGOL, Natural, PascalCogswell Consulting LLC, Managing Partner Fishers, IN Jun 2016 presentMy 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 2021Manage 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 Capgeminis support contract with Entergy.Unified Womens Healthcare Boca Raton, FL Sep 2019 Mar 2020Merged NextGen and Athena data into an SSAS tabular model to provide consolidated financial reporting in Power BIEstablished a roadmap of data management and governance practices to support and sustain analytics deliveryCambridge Investment Research (CIR) Fairfield, IA Oct 2018 Jun 2019Implemented a structured agile framework approach to data management and data delivery for legal complianceServed agile team as data architect, BI/DW developer, and as coach for product owners and team membersEstablished a roadmap for the future of data management practices and procedures and for data governanceTexas Association of School Boards (TASB) Austin, TX Mar 2018 Aug 2018Implemented a structured agile framework approach to deliver weighted shortest job first (WSJF), a top prospects listServed agile team as data architect, BI/DW developer, scrum master, and product ownerSustained progress of data governance program in its initial stages of developmentWorked directly with business unit directors and their stakeholders to define WSJF while building a product backlogDeveloped roadmap for unifying business unit data and operations to provide integrated, improved customer serviceBrought 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 aimsTRIMEDX USA Indianapolis, IN Feb 2017 - Feb 2018Implemented scaled agile framework (SAFe) for BI/DW product development and delivery, coordinating that effort with a certified SAFe trainer and coachServed 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 rolesTrained existing staff how to create and use both data vault and dimensional modeling techniquesWorley Claims Services Fishers, IN Nov 2016 Feb 2017Designed and helped construct processes to integrate operations of newly-acquired subsidiaryExecuted migration of MS Dynamics GP from on premises to AWS cloudCentric Consulting LLC, Manager Fishers, IN Feb 2012 Jun 2016Participated in the growth of the companys 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, INDesigned and helped construct DW/BI solution using MS SQL Server 2014, SSIS, SSAS tabular, Power BI, and TableauEnsured deliverables met expectations of the clients executive team.Western Reserve Group Wooster, OHBrought low-performing MS SQL Server 2012 R2 SSIS ETL jobs up to expected performance levelsPresented to executive team a summary of options for improving overall data management efficiencyAscension Health St. Louis, MODesigned 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 SSRSDelivered roadmap for future improvements to enable more rapid integration of new data sourcesKeihin North America Anderson, INDesigned 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 suiteRoche Diagnostics Corporation Indianapolis, INModified a customized sales and marketing software package to accommodate organizational changesUnited States Infrastructure Corporation Indianapolis, INCompleted SSIS construction and resolved quality issues uncovered during solution implementationSimon Property Group Indianapolis, INPrepared and presented an introduction to Data Vault and Agile BI concepts and implementation strategiesImplemented reporting solutions for financial operations that the team used to reduce vacancies in mallsDeveloped project plan for upgrade to Cognos 10Navion Healthcare Systems Indianapolis, INDesigned reporting solution for cardiac registry reporting using ER/Studio, SSIS, and SAP Business Objects BI 4.0Evaluated MicroStrategy, IBM Cognos 10.2, and SAP Business Objects BI 4.0 for purchase for this implementationInterviewed and selected BO developer and SSIS ETL resourceMotorists Insurance Group Columbus, OHArchitected 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 methodologiesTheoris, Inc., Senior Consultant Indianapolis, IN May 2010 Dec 2011Sallie Mae (Navient) Fishers, IN Produced BI and ETL solutions and managed and mentored ETL development staffIBM Lab Services, Senior Cognos Consultant Jan 2008 May 2010Ceridian Bloomington, MN Implemented BI solutions using Cognos 8 BI with Cognos Planning, TM1, and Hyperion EssbaseRegion 10 Educational Service Center Richardson, TXCompleted 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 SystemMet with the superintendents and administrative staff members of client school districts to define requirementsServed 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 issuesHoward Hughes Medical Institute (HHMI) Chevy Chase, MD Implemented financial reporting on laboratory budgetsDel Monte Foods Pittsburgh, PA, and San Francisco, CA Developed executive dashboard reports for CEO and senior sales staffSephora San Francisco, CA Resolved OLAP reporting issue using MDX, Hyperion Essbase, and Cognos Multidimensional modelPMI Mortgage Insurance Walnut Creek, CA Rewrote Cognos 7 reports in Cognos 8 using materialized views for efficiencyDCG Software, Assistant to the CTO Indianapolis, IN Jun 2007 Dec 2007Time, Inc. New York, NY Turner Broadcasting Atlanta, GA Discovery Channel Silver Spring, MDDirected the overseas ETL development effort for both Oracle and SQL Server data warehouse platformsServed as the primary Cognos report developer while also providing support for simultaneous development using SAP Business Objects and MicroStrategyState Auto Insurance Companies, Database Administrator Architect Indianapolis, IN Jun 1999 Jun 2007As a member of the DBA staff, served as technical lead for State Auto's data warehousing initiativeBuilt marts and SSAS multidimensional cubes with MDX to support Actuarial Departments pricing of auto insurancePerformance 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 availabilityUpgraded instances from SQL Server 2000 to 2005, automated maintenance tasks, ended scheduled off-hours supportThe Twentieth Century Indianapolis, IN Boston, MA Louisville, KY New York City, NYMinister of the Gospel ordained by Louisville and New York City International Churches of ChristAgent, Life and Health Insurances, Northwestern Mutual Life (NMFN)IT engagements: Merrill Lynch, Dun & Bradstreet, Eli Lilly, Conseco, Mayflower Transit, Federal Home Loan Bank, othersThank you for reading all this! A full accounting of last centurys activities is at LINKEDIN LINK AVAILABLEEducationMassachusetts 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 CountryTrainingThe Data Warehousing Institute (TDWI) World Conferences 2004, 2006, 2014 Entered into writers agreement 2015Zarvos Leadership & Coaching - Leadership Mentoring and Life Coaching 2007 presentIBM Certified Solution Expert Cognos 8 BI 2010IBM Certified Developer Cognos 8 BI Metadata Models 2010IBM Certified Developer Cognos 8 BI OLAP Models 2010IBM Certified Designer Cognos 8 BI Reports 2010IBM Certified Designer Cognos 8 BI Multidimensional Reports 2010Cognos 8 BI Advanced Report Writing and Advanced Data Modeling 2008Chartered Property-Casualty Underwriter (CPCU) 2007Informatica PowerCenter 7 Developer and Administrator 2005Indiana Informatica Users Group 2006Toastmasters International (CTM) 2003 2007Series 6, Life, and Health Insurance licenses 1991 1994 |
