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

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.

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, Indianapolis, IN 12/2007-01/2008

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

Senior BI Consultant Confidential, 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

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

Senior IT Consultant DSS Consulting 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

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

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 Software Synergy 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 Software Synergy 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 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 National 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.

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

Identified and corrected logic errors in market research data.

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

Reduced billing errors by more than 95%.

Formal Education:

Computer Science
Massachusetts Institute of Technology (MIT) Nutrition & Food Science

References Available on Request