SUMMARY:

• Have worked on all phases of data warehouse and business intelligence development using Microsoft SQL Server including gathering business requirements, dimensional (star schema) data modeling based on the Kimball method, creating data warehouse structure including testing, implementation, and production support.
• Demonstrated ETL expertise utilizing SQL Server Integration Services (SSIS) against relational data base systems including SQL Server, Oracle, and DB2 as well as Excel and flat file data sources.
• Excellent technical and analytical skills with substantial OLAP experience using Analysis Services (SSAS) multidimensional and tabular, PowerPivot and Cognos Power Play Transformer.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Power BI, Microsoft Excel, and Cognos Impromptu.
• Team player with excellent communication and problem solving skills.

TECHNICAL SKILLS:

ETL: SQL Server Integration Services (SSIS)

Programming: SQL (T - SQL), MDX, DAX

Data Warehouse: MS SQL Server

OS: Windows Server

OLAP: SQL Server Analysis Services (SSAS), PowerPivot, Cognos PowerPlay, TM1

Reporting: Excel, SQL Server Reporting Services (SSRS), Power BI, Cognos Impromptu, Report Studio, PowerPivot

Other Software: Microsoft Office Suite, Cognos Framework Manager, SPSS, SharePoint (BI components), Dynamics AX/365

Data Modeling: Kimball Method (dimensional/star schema)

Project Management: Microsoft Project

PROFESSIONAL EXPERIENCE:

Confidential, Troy, OH

Business Intelligence Architect

• Designed data warehouse and business intelligence solutions using the Microsoft SQL Server database platform including conducting business analysis, building the Kimball model data warehouse against Dynamics AX/365 and other data sources, dimensional data modelling, developing ETL (SSIS) packages, building multidimensional cubes (SSAS), developing reports (SSRS, Excel), building Power BI reports and dashboards, and providing mentoring/training to IT and business staff.

Confidential, Sarasota, FL

Business Intelligence Architect

• Designed data warehouse and business intelligence solutions using the Microsoft SQL Server 2008 R2 and 2012 platform including the data warehouse, dimensional data model, ETL (SSIS), cubes (SSAS) and reports (SSRS).

Confidential, Princeton, NJ

BI Consultant

• Working with client (Axis Accident & Health Insurance) to design and build a data warehouse and business intelligence reporting system based upon the Microsoft SQL Server 2008 R2 platform utilizing SSIS, SSAS and SSRS and the Kimball methodology

Confidential, Conshohocken, PA

Business Intelligence Software Engineer

• Develop data warehouse and business intelligence products to facilitate the analysis of health insurance claims based on the Microsoft SQL Server 2008 R2 platform utilizing SSIS, SSAS and SSRS
• Develop dimensional data warehouses based on the Kimball methodology
• Develop SQL Server Integration Services (SSIS) ETL packages designed to move data from the company’s transactional systems into the data warehouse
• Build OLAP cubes using SQL Server Analysis Services (SSAS)
• Develop Reporting Services (SSRS) reports based on OLAP cubes and the relational data warehouse to analyze claims data
• Work with business analysts to identify reporting needs
• Create documentation including data models, ETL source to target mappings, report and cube specifications and user guides.

Confidential, Voorhees, NJ

Lead BI Developer

• Worked as part of a team to convert an existing customer service business intelligence system from Cognos to the Microsoft SQL Server BI stack
• Reverse engineered Cognos reports and Powerplay cubes and built new reports and OLAP cubes using SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Worked to develop a new dimensional data model to house customer service data mart
• Built ETL packages using SQL Server Integration Services (SSIS) to populate new data mart
• Worked with business to identify reporting needs

Confidential

Data Warehouse & Business Intelligence Architect (Manager, Decision Support)

• Developed and managed company’s data warehouse and business intelligence reporting system using Microsoft SQL Server 2005 platform.
• Managed the conversion of the company’s business intelligence system from Cognos to Microsoft BI
• Performed database administration responsibilities including creating maintenance plans, backups, restores, creating tables, views, indexes and automation of jobs using SQL Server Agent.
• Worked with business users from all levels including CFO, departmental vice presidents and analysts to gather requirements for data warehouse and reporting design
• Dimensional Data modeling using Kimball method
• Developed, maintained and ran Integration Services (SSIS) packages to move and transform data between transactional systems and the data warehouse involving Type 1 and Type 2 slowly changing dimensions and other complex transformations
• Developed and managed Analysis Services (SSAS) cubes to meet the needs of all sectors of the business.
• Created custom calculations using MDX in both SSAS cubes and SSRS reports.
• Developed and managed Reporting Services (SSRS) reports using both SSAS cube and relational database sources including distribution of reports using subscription services.
• Developed ad-hoc and customized reports from SSAS cubes using Excel 2007 pivot tables and customized cube formulas
• Provided training to business users on the use of reporting tools
• Created and maintained documentation on data warehouse and business intelligence reporting system including data models, ETL source to target mappings, SSAS cube and report design
• Extensive use of T-SQL in creating views in Management Studio and in writing queries and executing SQL processes in SSIS packages and SSRS reports.
• Created system for capturing, reporting, and correcting errors in the data and maintaining audit information
• Provided on-call support to resolve any issues with production system.
• Designed and managed Cognos Powerplay Transformer cubes

Confidential, New York, NY

Cognos Report Developer (Contractor)

• Developed Impromptu catalogs
• Wrote Impromptu and Report Net Report Studio and Query Studio reports
• Built PowerPlay Transformer OLAP Models

Confidential, PA

Enterprise Reporting Analyst

• Developed and managed Cognos applications for sales management, finance and compensation.
• Mentored Data Warehousing team members in the Cognos toolset.
• Gathered reporting requirements from Business Analysts.
• Built Impromptu catalogs.
• Developed PowerPlay Transformer OLAP Models.
• Managed Cognos security.
• Developed reports.
• Developed and modified Cognos Macros.
• Managed Impromptu Web Reports, PowerPlay Enterprise Server and upfront.

Confidential New York, NY

Business Intelligence Analyst

• Development centered on license management and tracking.
• Supervised two developers.
• Built Impromptu catalogs.
• Managed security.
• Developed reports.
• Managed Impromptu Web Reports.
• Performed Project Management for the Cognos implementation plan.
• Gathered business requirements from end users and clients.
• Developed PowerPlay Transformer Models.
• Trained end users.

Confidential Philadelphia, PA

Senior Manager

• Managed Cognos PowerPlay, Transformer, PowerPlay Enterprise Server, Impromptu and Impromptu Web Reports Server.
• Developed Cognos applications for various departments including sales, customer complaints, environmental health and safety, manufacturing, legal claims, human resources, purchasing and financial analysis.