Roger Cogswell Email & Phone Number

Since 1/2023: Researching, writing, consulting, and connectingData Analyst, AEP Holdings, Inc. 5/2021 - 12/2022Analytics Manager, Entergy/Capgemini 3/2020 - 4/2021Analyst, Unified Women's Healthcare 9/2019 - 3/2020Data Architect, Cambridge Investment Research 10/2018 - 6/2019Enterprise Architect, Texas Association of School Boards 4/2018 – 8/2018Enterprise Data Architect, Trimedx International 1/2017 – 3/2018

Dayton, Ohio, Us

HEALTHCARE, FINANCIAL SERVICES, REAL ESTATE, HIPAA, ETL, SSRS, SharePoint, MicroStrategy, IBM Cognos, SAP, BusinessObjects, DB2, ER/Studio, Oracle, SSIS, SSAS, Data Vault

Indianapolis, In, Us

FINANCIAL SERVICESProduced BI and ETL solutions using Business Objects and SSIS/T-SQL. Gathered requirements, dimensionally-modeled data, and managed development efforts of technical staff.

Armonk, New York, Ny, Us

PAYROLL SERVICESImplemented BI solutions using Cognos 8 BI Framework Manager, Transformer, Report Studio, Analysis Studio, and Query Studio. Extracted data from Cognos Planning, Hyperion, and ODBC data sources. FOODImplemented executive dashboard reporting for CEO and senior sales management.EDUCATIONGathered requirements for BI solutions from public school district superintendents and modeled data for data warehouse implementation. Provided recommendations to Region 10 CIO and Director of Data Warehousing with regard to team structure and staffing requirements. Designed ETL to integrate data from 80+ school districts. Implemented customized dashboards and actionable alerts to notify principals of material changes to populations defined by No Child Left Behind. Mentored staff in BI reporting, dimensional modeling, ETL, and data warehouse design. Provided direction for tuning databases to meet service level agreements.Implemented staff scheduling reports using a Cognos Framework to extract from PeopleSoft.Created annual budget books for regulatory reporting from Cognos Planning.MEDICAL AND SCIENTIFIC RESEARCHImplemented financial reporting on laboratory budgets with responsibility-based security. Provided direction for modeling data marts and designing ETL to populate them from PeopleSoft.FINANCIAL SERVICESConverted reports from Cognos 7 to Cognos 8 BI. Tuned databases to shorten report execution times.

Ca

FINANCIAL SERVICESConverted reports from Cognos 7 to Cognos 8 BI. Tuned databases to shorten report execution times.HEALTH AND BEAUTYResolved customized OLAP reporting issues using MDX and Hyperion Essbase with Cognos Multidimensional reporting.GOVERNMENTResolved issues with existing Cognos 8 BI reports.

Menlo Park, Ca, Us

Evaluated current database administration and prepared formal recommendations for improvements for Health Care Excel.

Turner Broadcasting, Discovery Channel, and Time, Inc.: Designed and tuned databases and ETL processes to support advertising campaign management. Supervised ETL development and implemented BI reporting solutions using PL/SQL, Cognos, Business Objects, and MicroStrategy.

Columbus, Ohio, Us

Designed and built data mart and OLAP cube reporting solution for actuarial department using SQL Server, Analysis Services, Reporting Services, Pivot Tables, SSIS, and Informatica PowerCenter.Provided ongoing support, performance tuning, disaster recovery planning/implementation, and maintenance for 40+ SQL Server instances, utilizing maintenance plans, replication, and clustering to provide for failover and high availability. Upgraded from SQL Server 2000 to 2005.Automated migration and maintenance tasks, virtually eliminating any need for off-hours DBA support.Completed requirements for these insurance industry designations: Chartered Property Casualty Underwriter (CPCU), Associate in Information Technology (AIT), Associate in Service (AIS)Achieved Competent Toastmaster (CTM) designation as a member of Toastmasters International.

Indianapolis, In, Us

Meridian Insurance: Developed Java applets to make CICS and DB2 data web-accessible. Implemented customized billing system.

Indianapolis, Indiana, Us

RealMed: Integrated IBM mainframe data and applications into web-based, client/server claims processing applications for this pre-IPO company using thin-client, multi-tier technologies. Designed online claim adjudication system to interface with healthcare insurers and providers.

Indiana Energy: Provided legacy system support to IBM mainframe applications, including accounts payable/receivable, general ledger, State and Federal Income Taxes, scheduling of equipment maintenance and testing, management financial reporting, and regulatory and Y2K compliance.

Fiserv: Teamed with Sales and Marketing staff to design print and mail solutions. Managed implementation staff.

Eli Lilly: Updated COBOL/DB2 programs to support upgrade to PeopleSoft and changes to employee benefits.

Conseco, Carmel, IN, 12/1996-02/1997: Converted purchased life insurance applications to standard corporate platform. USA Group, Fishers, IN, 05/1995-12/1996: Designed and implemented Loans with Expired Repayment Period Report to support Federal regulatory compliance. Maintained Loan Status System using COBOL/VSAM, Quikjob, Culprit, Novell GroupWise, IDMS and ADS/O.

EDS and Delco Electronics: Implemented inventory control for automotive parts. Managed projects using EDS Lifecycle standards. Performed peer review of system and program design documentation, program code, and test results.

Newark, New Jersey, Us

Teamed to implement new Prudential Preferred Financial Services district office.

Milwaukee, Wi, Us

Licensed for Series 6, life, and health insurance. Added 350+ new clients. Completed LUTC Course in Advanced Business Insurance.

Golden Rule Insurance: Designed database and programming specifications for insurance Policy Print and Mail System.

Indianapolis, In, Us

CHAMPUS: Maintained CHAMPUS and BC/BS health insurance claims system from verbal specifications provided by nursing staff.

Bought, sold, developed, and managed residential real estate.

Indianapolis, In, Us

PSI Energy: Wrote screen and report programs for Arthur Andersen Cost Accounting System.

Dun & Bradstreet: Designed database and implemented Book Publication Customization System.

Managed outreach in Paterson, NJ, growing church membership in that city from zero to 40+. Led weekly Bible discussions for teens, single adults, and married couples. Provided counseling to people with alcohol and drug issues.

New York, Ny, Us

Designed and implemented Pension Plan Management System for Chrysler Corporation.

Federal Home Loan Bank of Indianapolis: Coded bank advance (loan management) screens using CICS/VSAM/COBOL.Amax Coal Company: Designed and implemented Maintenance and Repair System using Adabas/Natural and REXX.

As Assistant Director of the Third Step House, a residential addiction recovery facility, administered house policies and led group and individual treatment processes. Lectured on spiritual issues and the disease concept of alcoholism at the Jefferson Alcohol and Drug Abuse Center (JADAC). Facilitated multiple weekly Bible studies for single adults, providing life coaching and other mentoring for participants.

Fenton, Mo, Us

Converted Online Order Entry System to use Adabas and Natural.

Bloomington, Indiana, Us

Designed and implemented system to capture radio-immunoassay data for NIH statistical analysis. Installed and customized system software using Pascal, Basic, DEC Assembly Language, COBOL, and ALGOL on DEC-10, IBM 4300, and Burroughs 6600.

Designed and implemented Safe Deposit Box System for client banks, while supporting their account management systems.

Capital Consolidated: Coded and installed data entry screens for Pertec XL40.

Indianapolis, Indiana, Us

Identified and corrected logic errors in market research data.

Reduced billing errors by more than 95%.

Nutrition And Food Science - Course 7B

Diploma, Math, Music, Chemistry, Physics, English, Social Studies, Latin, Economics, Government

Finance

Computer Science