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

Confidential, 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 IBM
Confidential 04/2008-05/2010

Confidential, 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.

Confidential, Pittsburgh, PA: Implemented executive dashboard reporting for CEO and senior sales management.

Confidential, 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.

Confidential, 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.

Confidential: Implemented staff scheduling reports using a Cognos Framework to extract from PeopleSoft.

Confidential: Created annual budget books for regulatory reporting from Cognos Planning.

Senior BI Consultant Cognos
Confidential 01/2008-04/2008

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

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

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

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

Confidential, Indianapolis, IN: Evaluated current database administration and prepared formal recommendations for improvements.

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

Confidential, Atlanta, GA; Confidential, 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

Confidential, 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

Confidential, 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 Management Information Disciplines Indianapolis, IN 10/1998-05/1999

Confidential, 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

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

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

Confidential, 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

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

Confidential, 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

Confidential, 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.

Confidential Kokomo, IN 05/1994-10/1994

Teamed to implement new Prudential Preferred Financial Services district office.

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 Management
Confidential Indianapolis, IN 06/1991-09/1991

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

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

Confidential, 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 Software
Confidential Indianapolis, IN 10/1989-02/1990

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

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

Confidential, Parsippany, NJ: Designed database and implemented Book Publication Customization System.

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 Software
Confidential Indianapolis, IN 02/1985-05/1986

Confidential, Indianapolis, IN: Coded bank advance (loan management) screens using CICS/VSAM/COBOL.

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

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.

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 Computer Management Systems Indianapolis, IN 03/1978 -07/1979

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

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
• Finance
• Nutrition & Food Science
• Math/Science/Music
• Social Studies/Athletics
• English/Reading