SUMMARY

• Fourteen years of professional experience with data warehousing in a reporting and analytics environment —creating and maintaining data marts and semantic layers to fulfill the business’ need for data and information in the healthcare, manufacturing, mortgage and finance industries.
• Twelve years of professional experience designing comprehensive Business Intelligence systems with OLAP, reporting and dash - boarding capabilities.
• Fourteen years of professional experience analyzing data, and architecting processes to enable research and ensure high quality data.
• MSCA SQL Server, MSCE Business Intelligence Certified
• Twenty years of professional experience utilizing technology to support business functions.

TECHNICAL SKILLS

• SQL Server 2005/2008/2008 R 2/2012/2014/2016 (SSIS
• SSAS
• Analysis Services Multidimensional and Tabular models
• Reporting Services
• Management Studio
• Stored Procedures
• T-SQL)
• MS Excel (2003
• 2007
• 2010
• 2013
• 2016
• PowerPivot)
• GIT
• SQL Profiler
• DAX Studio
• Teradata 14.10
• Johns Hopkins ACG 9.0 and 10.0
• Atacama DQC 8
• Sybase PowerDesigner 16.5
• Qlikview 11
• Tableau 8.2
• Agile/SCRUM
• SDLC
• SQL Server 2000 (Enterprise Manager
• Query Analyzer
• DTS
• Stored Procedures
• T-SQL)
• Oracle 10g/11g (PL/SQL Developer
• PL/SQL
• SQL Plus
• T.O.A.D
• Oracle Discoverer)
• Sybase (Advanced Query Tool)
• Embarcadero ER/Studio
• MS Access
• MapPoint
• Business Objects
• Business Objects Designer
• Informatica
• Datastage
• ERWIN
• SAS
• MS Office 2010 2013 2016
• Visio
• PowerPoint
• Visual BASIC
• UNIX many others.

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, MN

Principal Business Intelligence Data Architect

Responsibilities:

• Responsible for the creation, configuration and maintenance of an end-to-end business intelligence analytics application—data warehouse, user data access layers, SSAS tabular models, visualization layer (Excel, PowerBI)—as a product for the clients of a software development company in the senior care industry.
• Responsible for the data modeling, ETL development (using SSIS) and SSAS tabular model creation.
• Responsible for the creation of numerous measures using DAX programming language.
• Responsible for the data modeling, data profiling and data analysis of member, financial, census and clinical data from skilled nursing facility and senior living data.
• Responsible for leading a team of six developers (4 US, 2 India), one BA and two QA team members.
• Responsible for creating reports, dashboards and visualizations.
• Create and deliver presentations to various audiences as needed.

Environment: (s): SQL Server 2012/2016, MS Excel 2013/2016, SSIS, SSAS Tabular, Visual Studio 2012/2015, SharePoint, GIT, Azure

Confidential, Maple Grove, MN

Business Intelligence Data Architect

Responsibilities:

• Responsible for the creation of several data marts as well as architecting a business intelligence solution for a start-up wellness company.
• Responsible for the data modeling, data profiling and data analysis of medical claim, pharmacy claim, member and clinical data.
• Responsible for installing several instances of SQL Server 2012 and maintaining several SQL Server 2012 databases.
• Responsible for operational and managerial reporting.
• Create and deliver presentations to various audiences as needed.

Environment: (s): SQL Server 2012, MS Excel 2013

Confidential, Eagan, MN

Business Intelligence Data Architect

Responsibilities:

• Responsible for the data modeling, data profiling, view creation and performance tuning for several business intelligence semantic layers used for reporting and analytics.
• Responsible for creation and maintenance of mapping documents and metadata for the semantic layers as well as preforming various data governance tasks.
• Create and deliver presentations to various audiences as needed.

Environment: (s): Teradata 14.10, MS Excel 2013, Sybase PowerDesigner 16

Confidential, Eden Prairie, MN

Senior Business Intelligence Data Analyst

Responsibilities:

• Using medical claims, pharmacy claims and clinical data, responsible for creating data marts, data sets and reports for researchers to enable them to do case finding and research in the following areas: Health Care Utilization (Inpatient admissions, ED/ER, Outpatient services, SNF, Home Health, Hospice, Office Visits, etc.), High Risk Medications, Potentially Inappropriate Medications, Candidates for internal programs, Readmissions, Utilization Management, Complex Case Management, Care Plans, Interventions, Top Providers, etc.
• Responsible for analyzing, organizing and reporting upon clinical care data.
• Acts as liaison between the business users and analytics group and the data warehouse development team.
• Responsible for overseeing the gathering of functional and technical requirements, data element selection, data modeling, data architecture, ETL design and data quality of several data mart development projects..
• Troubleshoots and tracks any data issues, proposing solutions for remediation.
• Responsible for the development and execution of SQL scripts needed to create inputs for the Johns Hopkins ACG predictive modeling software. Also responsible for execution of the ACG data processing as well as post-run analysis.
• Create and deliver presentations to various audiences as needed.

Environment: (s): SQL Server 2008R2, SSIS, SSAS, SSRS, MS Excel 2010, Johns Hopkins ACG 10.0

Confidential, Hopkins, MN

Data Architect

Responsibilities:

• Responsible for the data modeling for a project in which an application was being moved from MS Access to SQL Server 2005.
• Create and deliver presentations to various audiences as needed.

Environment: (s): SQL Server 2005, SSIS, SSAS, SSRS, MS Excel 2007, Embarcadero ER/Studio

Confidential - Plymouth, MN

Senior Data Warehouse Developer

Responsibilities:

• Responsible for the business analysis and data analysis to enable the creation, enhancement and maintenance of Data Marts that make up the North American Data Warehouse. This includes data profiling, data modeling, ETL development, Cube creation, report creation, data source view creation, quality assurance, complex trouble shooting and extensive interviewing of the business users and subject matter experts.
• Focus on the subject areas of service, warranty and sales.
• Responsible for the creation and maintenance of data models, business (functional) specifications and technical specifications as well as creation and maintenance of metadata available to technical personnel and business users.
• Architects design of ETL processes, database structures, error handling and best practices, ensuring the needs of the business are met, the nature of the data is considered and data and information is made available efficiently and accurately.
• Create and deliver presentations to various audiences as needed.

Environment: (s): SQL Server 2005/2008, SSIS, SSAS, SSRS, Oracle 10g, MS Excel 2007, Baan LN (ERP)

Confidential, Golden Valley, MN

Data Architect

Responsibilities:

• Responsible for the data analysis and business analysis to enable the creation, enhancement and maintenance of an Enterprise Data Warehouse servicing several data marts. This includes data profiling, data modeling, and quality assurance, complex trouble shooting and extensive interviewing of the business users and subject matter experts.
• Focus on the subject areas of health care analytics including
• Serves as the liaison between the many business users, the SAS developers and project managers.
• Responsible for the creation and maintenance of data models, business (functional) specifications and technical specifications as well as creation and maintenance of metadata available to technical personnel and business users.
• Assists SAS developers in the design of ETL processes, applications and database structures, ensuring the needs of the business are met, the nature of the data is considered and data and information is made available efficiently and accurately.
• Create and deliver presentations to various audiences as needed.

Environment: (s): Oracle, SAS, MS Excel, MS Access, ERWIN