SUMMARY:

• Senior level Business Intelligence expert and Data Warehouse developer with 15+ years of broad experience across multiple technologies, often encompassing team lead and management responsibilities
• Areas of expertise across ETL, Data Warehousing, Microsoft stack and the IBM Cognos BI reporting stack
• Experienced with full life cycle project development including design, coding, testing and implementation, and support
• Experienced working with users, collecting information and/or requirements from users, analyzing requirements and creating a design plan and solution recommendation
• Experience mentoring and training end users and IT professionals

TECHNICAL SKILLS:

IBM Cognos: Cognos 8.4, through 10.2.2; Report Studio, Query Studio, Framework Manager, Analysis Studio, Metrics Studio, Transformer, Cognos Express, Data Manager, IBM Datastage

Microsoft: SQL Server 2005/2008/2008 r2/2012/2014, SSRS, SSIS, SSAS, Office, SharePoint, VB.NET, ASP.NET, Project

Business Objects: Business Objects XI, Crystal Reports, Crystal Xcelsius, Business Objects Data Services

Oracle 11g: Database, Discoverer

Other: Informatica 9; Data Warehouse Logical and Physical Design; Kimball Design Methodologies

PROFESSIONAL EXPERIENCE:

Senior Consultant

Confidential, Chicago, IL

Responsibilities:

• Created departmental data marts for Risk, Fleet, Purchasing, Facilities Management, Debt Collection, and Finance along with dashboards and Cognos reports for these state agencies.

Senior Consultant

Confidential, Tulsa, OK

Responsibilities:

• Created Cognos and Tableau reports for the Maintenance division. Worked on Maintenance data warehouse creation merging legacy AA data with US Airways data.

Senior Consultant

Confidential, Jefferson City, MO

Responsibilities:

• Major Cognos update project. Project Manager for Cognos environment tune - up. Implemented Cognos bursting. Created 6 data marts with SSIS packages and re-created current Cognos reports to run off the new data marts.

Senior Consultant,

Confidential, Austin, TX

Responsibilities:

• Data Warehouse development and SSIS build for Avnet in-house offering of software services for the attractions (zoo, parks, etc.) and sporting (Chicago White Sox, New York Yankees, etc.) industry.
• Complete Data Warehouse Design and implementation utilizing MS SQL Server 2012. Created SSIS ETL packages using SAP and flat file data sources.

Senior Consultant,

Confidential, Rolling Meadows, IL

Responsibilities:

• JDE upgrade impacting Cognos. Cognos Data Manager ETL modifications and updates, SSIS ETL modifications and updates. Cognos Report Studio report validation and updates.

Consultant

Confidential, Brea, CA

Responsibilities:

• Created dashboard and drill-thru reports off TM1 cubes in Cognos Express
• Configured settings and security for Cognos Express
• Created Cognos 10.1 Active Report

Consultant

Confidential - Dallas, TX

Responsibilities:

• Data cleansing for numerous distribution centers in the organization
• Created reports using Excel, SSRS, and in-house reporting tools
• Designed and developed SSIS packages to bulk load BizTalk transactions into SQL Server database
• Analyzed current reporting services structure
• Inventoried all reporting services reports across six reporting servers to implement report consolidation
• Created project plan to revamp reporting services structure. The plan will utilize a central report depository utilizing two or more load balanced reporting web servers
• The project plan also included a design for a standardized reporting template with company branding
• Designed and created regulatory and compliance data warehouse utilizing the Kimball methodology and conformed dimensions in an Oracle 11g database
• Created ETL using Business Objects Data Services
• Created application reporting module using Business Objects Crystal Reports for 14 reports
• Designed and created enterprise data warehouse in SQL Server 2008
• Performed complete Cognos 8.4 installation and implementation including security setup
• Designed Cognos Framework for Enterprise Data Warehouse for corporate reporting
• Designed Cognos Framework for Operational Data Store for near real-time reporting
• Created Dashboards for Executive C-level, Workgroup and Individuals in Cognos 8.4 Report Studio
• Implemented Cognos Query Studio and Analysis Studio with end-user training
• Created SSIS packages for data loads, table builds and database snapshots
• Created 12 reports utilizing SSRS, and 40 reports and 10 dashboards in Cognos 8.4

Consultant

Confidential, Dallas, TX

Responsibilities:

• Authored 50 Crystal Reports using CR 2008
• Developed Crystal Reports portal website using VS.NET 2008 and CR.NET
• Created SSIS packages for data loads, table builds and database snapshots
• Coded database data extraction web module for extracting data into Excel
• Created SSRS reports and MS Excel reports

Consultant

Confidential, Dallas, TX

Responsibilities:

• Designed and constructed an enterprise data warehouse and subsequent data marts on SQL Server 2005
• Coded all ETL processes and data cleansing procedures in SSIS and T-SQL
• Created Cognos Framework model and developed reports and dashboards in Report Studio
• Implemented Cognos Query Studio and Analysis Studio
• Created SSRS reports and MS Excel reports delivered through SharePoint
• Conducted Cognos end-user training

Confidential, Austin, TX

Data Warehouse/Business Intelligence Manager

Responsibilities:

• Implemented corporate reporting system utilizing Noetix on Oracle
• Developed dashboards using Crystal Xcelsius
• Designed and constructed an enterprise data warehouse on SQL Server 2005
• Coded all ETL processes and data cleansing procedures in SSIS and T-SQL pulling from Oracle, Informix and legacy systems
• Developed cubes using SSAS
• Created reports using SSRS, Noetix, Crystal Reports, Oracle Discoverer, and MS Office
• Managed group of DBA’s, BA’s and Report Authors
• Managed Oracle upgrade project and Noetix implementation project

Confidential, Dallas, TX

Senior Manager of Business Intelligence

Responsibilities:

• Created reports using Cognos, Crystal Reports, SSRS, MS Office, VB.NET and ASP.NET
• Created custom intranet reporting portal using ASP.NET and VB.NET
• Developed cubes using SSAS and Cognos
• Designed and constructed an enterprise data warehouse on SQL Server 2005
• Coded ETL and data cleansing processes in SSIS and T-SQL
• Led implementation team for Cognos 8 installation. Received award from Cognos for fastest successful launch
• Managed Cognos implementation project and all reporting projects
• Managed group of DBA’s, BA’s and Report Authors
• Conducted Cognos end-user training and trained users on custom reporting portal