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.

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   State Auto Insurance                                        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.

Senior IT Consultant          Confidential,
                Indianapolis, IN                    06/1991–09/1991

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

Senior IT Consultant          Confidential,
                                Indianapolis, IN                    07/1990-05/1991

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

Property Manager              Confidential,
                                Carmel, IN                            02/1990-07/1990

Bought, sold, developed, and managed residential real estate.
Senior IT Consultant          Confidential,
                                                Indianapolis, IN                    10/1989-02/1990

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

Senior IT Consultant          Confidential,
                                                Montvale, NJ                        10/1988-10/1989

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

Minister of the Gospel       Confidential,
                                New York, NY                        06/1987-10/1988

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.

Senior Analyst                     Confidential,
                                                Somerset, NJ                       06/1986-06/1987

Designed and implemented Pension Plan Management System for Chrysler Corporation.

IT Consultant                       Confidential,
                                Indianapolis, IN                    02/1985-05/1986

Federal Home Loan Bank, Indianapolis, IN:  Coded bank advance (loan management) screens using CICS/VSAM/COBOL.

Amax Coal Company, Indianapolis, IN:  Designed and implemented Maintenance and Repair System using Adabas/Natural and REXX.

Minister of the Gospel       Confidential,
                                Louisville, KY                        08/1983-02/1985

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.

Senior Analyst                     Confidential,
                                Carmel, IN                            08/1981-08/1983

Converted Online Order Entry System to use Adabas and Natural.

Systems Programmer      Confidential,
                                Indianapolis, IN                    01/1980-08/1981

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.

Programmer                        Confidential,
                                Indianapolis, IN                    07/1979-01/1980

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

Terminal Operator              Confidential,
                                Indianapolis, IN                    03/1978 -07/1979

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

Coder                                    Confidential,
                                Indianapolis, IN                    01/1978-03/1978

Identified and corrected logic errors in market research data.

Billing Coder                        Confidential,
                                                Boston, MA                           06/1976-01/1977

Reduced billing errors by more than 95%.

Formal Education:

                Computer Science              Indianapolis, IN    1980-1981
                                                Finance                                 Terre Haute, IN     1977
                Nutrition & Food Science   Cambridge, MA   1974-1976
                                                Math/Science/Music            Indianapolis, IN    1971-1974
                                Social Studies/Athletics      Indianapolis, IN    1968-1971
                                                English/Reading                  Indianapolis, IN    1961-1968