Areas of Expertise: All aspects of Business Intelligence, Data Modeling, Data Warehousing, Data Mining, ETL, Database Administration, Master Data Management, Information Quality, and building of high-performance teams.

Functional Areas: Management, Financial Reporting, Sales and Marketing, Operations, Customer Service, Leadership Training, Human Development, Human Resources, Risk Management, Facilities Maintenance.

Industries: Professional Services, Insurance, Financial Services, Education, Government, Scientific Research, Health Care, Advertising, Entertainment, Publishing, Energy, Communications, Transportation, Engineering, Electronics, Automotive, Manufacturing, Mining, Pharmaceuticals, Cosmetics, Real Estate, Church and Ministry.

Training: Cognos 8 BI Advanced Report Writing and Advanced Data Modeling (2008); The Data Warehousing Institute (TDWI) World Conferences (2006 and 2004); Informatica PowerCenter 7 Developer and Administrator (2005); Indiana Informatica Users Group (founding member, presenter in 2006 on topic “Using Web Services in PowerCenter 7”), Toastmasters International (CTM), Zarvos Coaching and Consulting Leadership Trainings.

Technologies: IBM, Microsoft, Oracle, SAP, Cognos, SQL Server, SSIS Integration Services, PL/SQL, T-SQL, MDX, SSAS Analysis Services, SSRS Reporting Services, Informatica, DB2, Business Objects, MicroStrategy, DataStage, PeopleSoft, Hyperion, cubes, Erwin, ER/Studio, Crystal, Java, JavaScript, .NET, HTML, XML, Unix/Linux, COBOL, CICS, IBM Assembly Language, MVS/TSO/ISPF, VM/CMS, IMS, IDMS, Adabas, PL/I, FORTRAN, Pascal, Gnosis, DEC-10 Assembly Language, and many more.

• IBM Certified Solution Expert – Cognos 8 BI
• IBM Certified Developer – Cognos 8 BI Metadata Models
• IBM Certified Developer – Cognos 8 BI OLAP Models
• IBM Certified Designer – Cognos 8 BI Reports
• IBM Certified Designer – Cognos 8 BI Multidimensional Reports

Professional Experience:

Senior BI Consultant Confidential, Indianapolis, IN 05/2010-01/2012

Sallie Mae, Fishers, IN: Produced BI and ETL solutions for client schools using Business Objects and SSIS/T-SQL. Gathered requirements, modeled data dimensionally, and managed development efforts of technical staff.

Senior BI Consultant Confidential, Coast-to-Coast 04/2008-05/2010

Ceridian, Bloomington, MN: Implemented 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.

Del Monte Foods, Pittsburgh, PA: Implemented executive dashboard reporting for CEO and senior sales management.

Region 10 ESC, Richardson, TX (15 months): Gathered 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.

Howard Hughes Medical Institute, Chevy Chase, MD: Implemented financial reporting on laboratory budgets with responsibility-based security. Provided direction for modeling data marts and designing ETL to populate them from PeopleSoft.

Bowling Green State University (OH): Implemented staff scheduling reports using a Cognos Framework to extract from PeopleSoft.

Memphis City Schools (TN): Created annual budget books for regulatory reporting from Cognos Planning.

Senior BI Consultant Confidential, Coast-to-Coast 01/2008-04/2008

PMI Mortgage Insurance, Walnut Creek, CA: Converted reports from Cognos 7 to Cognos 8 BI. Tuned databases to shorten report execution times.

Sephora, San Francisco, CA: Resolved OLAP reporting issues using MDX and Hyperion Essbase with Cognos Multidimensional reporting.

Hennepin County, Minneapolis, MN: Resolved issues with existing Cognos 8 BI reports.

Senior BI Consultant Confidential, Indianapolis, IN 12/2007-01/2008

Health Care Excel, Indianapolis, IN: Evaluated current database administration and prepared formal recommendations for improvements.

Senior BI Consultant Confidential, Coast-to-Coast 06/2007-12/2007

Turner Broadcasting, Atlanta, GA; Discovery Channel, Silver Spring, MD; Time, NY, NY: 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.

Database Administrator Confidential, Indianapolis, IN 02/2001-06/2007

• 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.
  

Senior IT Consultant Confidential, Carmel, IN 06/2000-02/2001

Meridian Insurance, Indianapolis, IN: Developed Java applets to access CICS and DB2 data from web. Implemented customized billing system.

Senior IT Consultant Confidential, Indianapolis, IN 06/1999-03/2000

RealMed, Indianapolis, IN: 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.

Senior IT Consultant Confidential, Indianapolis, IN 10/1998-05/1999

Indiana Energy, Indianapolis, IN: 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.

Senior IT Consultant Confidential, Fishers, IN 03/1998-09/1998

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

Senior IT Consultant Confidential, Indianapolis, IN 03/1997-02/1998

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

Senior IT Consultant Confidential, Indianapolis, IN 05/1995-02/1997

Conseco, Carmel, IN: Converted purchased life insurance applications to standard corporate platform.

USA Group, Fishers, IN: 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.

Senior IT Consultant Confidential, Indianapolis, IN 10/1994–04/1995

Delco Electronics (EDS), Kokomo, IN: 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.

Agent Confidential, Kokomo, IN 05/1994–10/1994

Teamed to implement new Prudential Preferred Financial Services district office.

Agent Confidential, Indianapolis, IN 09/1991–05/1994

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

Formal Education:

Computer Science