SUMMARY:

• Senior business intelligence consultant with extensive experience implementing scalable solutions in a variety of reporting environments including OLTP, OLAP, ODS, Data Mart, and Data Warehouse systems.
• Possess a broad knowledge of the Business Intelligence life cycle, database design and data movement/migration principles (ETL).
• Adept at Kimball Data Modeling, including design and implementation of support systems via SSIS in SQL 2005/2008/2012/2014 .

TECHNICAL SKILLS:

Computer Languages: SQL, C#, MDX, CAML, VB.NET, C/C++, ASP.NET, JavaScript, AJAX, JQuery, PHP, Node.js, HTML, Linux, Pascal, Assembly, PL\1

Systems: AWS, MS SQL Server, 2005/2008/2012/2014, Microstrategy 9.4, Tableau 9.0, SharePoint 2010, Aginity Workbench, PerformancePoint, Windows 7/8, Windows NT Workstation, Windows NT Server

Tools: MS Team Foundations Server 2012, MS Excel Power Pivot 2013,Visual Studio .NET 2005, ProClarity Desktop, Access 2005, Frame Maker, MS Word

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

BI Architect

Responsibilities:

• Design, developed, and implemented various Tabular Models for the Transmission and Distribution teams such as: Equipment Interrupt model, Request model, Outage model, and Storm model.
• Introduced BI concepts to the team such as KPI’s, Year over Year metrics, Parallel Time metrics, and Rolling Time metrics.
• Full installation and configuration of the SSAS platform on their Dev servers
• Helped configure the Firewall Inbound and Outbound rules for the SSAS server
• Applied Kimball modeling techniques to all models, using only Star Schema whenever possible. For many instances, it had to be done logically, as opposed to physically, because most tables where transaction tables
• Programmed in DAX for all complex measure calculations
• Programmed in SQL for all complex query pulls into the SSAS models and views for logical implementation of Star Schemas

Confidential, Charlotte, NC

BI Architect

Responsibilities:

• Designed, developed, and implemented the Patch Data Model, the source of their monthly CIO Patch Metrics. Identifies counts of applicable patches, patches installed, and patch debt. Full drill through capability down to individual device and patch.
• Developed and implemented end - user reports for the Patch Model in both Tableau and Excel Pivot Tables. The Excel files were made available via SharePoint.
• Designed, developed and implemented the Patch Cube (SSAS). This was used predominantly via Excel Pivot Tables.
• Trained the team in Kimball modeling concepts, including Type 2 Dimensions and how to use them.
• Trained the team in TFS Source Control usage, including check-in/check-out and using changesets in TFS deployment plans (tasks).
• Implemented security requirements for the SSAS cubes using role-based or dimensional based
• Designed, developed and implemented Stored Procedures, Functions and other artifacts in TSQL for data migration from staging area to DW
• Designed, developed and implemented ETL processes using SSIS
• Created/maintained deployment plans to successfully implement IT-based solutions
• Functional/Technical Design documents
• Developed materials focused on end-users for various business functions
• Led the team in installing the MS Build feature to create TFS Builds
• Coached and mentored team members on the various aspects of BI development

Confidential, Charlotte, NC

BI/DW Data Modeler

Responsibilities:

• Dimensional Modeling: Designed Kimball models that eliminated or reduced processing bottleneck between the transactional layer and the reporting layer. This resulted in quicker response and processing times for all reports from the end-user perspective.
• Developed both in Microstrategy Architect and Microstrategy Web Services.
• Developed Microstrategy objects, including logical tables, facts, metrics (derived and external), transformations, report grids, prompts, filters, Confidential ributes, custom groups, and derived elements.
• Enhanced Microstrategy performance by tweaking VLDB properties.
• Successfully converted Cognos reports to Microstrategy reports.
• Developed new Microstrategy reports from conceptual proposals from the ECM business analysts.
• Requirements gathered for all reports from the business analysts, data analysts, and ETL team.
• Introduced new Microstrategy features and “tricks” to the reporting team to make reports far more robust than their Cognos counterpart.
• Introduction of the Junk Dimension concept to the ETL team to help reduce entry points into Fact tables in their model designs.
• Introduction of the Outrigger Dimension concept to encourage more context-driven and process-driven models that target specific user groups so as to make querying for reports and analysis far more intuitive and faster for just those users.

Confidential

Lead BI Developer

Responsibilities:

• Designed complete Dimensional Kimball Models (Star Schema) for all processes.
• Designed and implemented the supporting ETL system in MS SQL 2012/2008.
• Instantiated data models into the Logical Data Warehouse (LDW).
• Documented data models using Kimball modeling tool.
• Installed and configured OtisEd Data Pump to pull raw data from school districts and state level sources into the raw tables, both via FTP and direct Active Directory connections.
• Developed stored procedures that pulled raw (pre-transformed) data from the various source systems from school districts and state level agencies.
• Designed SSIS packages in a Master-Connector-Route-Step (4-tier) configuration for full scalability
• All data movements between points were handled by SSIS “step” packages. Those step packages were managed by route packages, which were in turn managed by connector packages and then a master package to control all connector packages. All routing configurations were table driven.
• Designed, configured, and deployed the SSIS “step” packages, meaning they used stored procedures to deliver data into stage tables, then finally to the ODS Data Warehouse.

Confidential, Charlotte, NC

Senior BI Consultant

Responsibilities:

• Full Data Warehouse architecture design along with a supporting, robust ETL System that includes Type 2 Dimensional updating and dynamic partitioning
• Implementation of The SSIS Framework (3-pass configuration by Jessica Moss, SSIS MVP) for their ETL System
• Creating their first OLAP Cube with 4 Dimensions, 7 conventional Measures, 4 calculated Measures
• Trained IT team members in Kimball Dimensional Modeling, SSIS and SSAS Best Practices
• Introduced team members to table partitioning for one of their over-burdened transactional tables (50 million records)
• Created an OLTP Data Mart for their Kontiki Video Content Management System

Confidential, Alpharetta, GA

Senior BI Developer

Responsibilities:

• Development and delivery of Data Warehouse and Business Intelligence solutions to support dashboards, scorecards, and reports.
• Development of current ETL environment to align with conventional Data Warehouse Models
• Worked with business users to document requirements to map project objectives to enterprise-level BI solution
• Developed Data Marts from existing Data Warehouse for ease of user accessibility.
• Optimized data warehouse and data marts to meet performance metrics
• Converted Type 1 Dimensions to Type 2 Slowly Changing Dimensions for Dimension Tables.
• Converted Transactional Fact Tables into Periodic Snapshot Fact Tables and Accumulating Snapshot Fact Tables.
• Introduced company to dynamic partitioning for OLAP Cubes and DB Tables to avoid data explosion and to improve processing performance.
• Develop OLAP Cubes and Tabular Models within SSAS

Confidential, Atlanta, GA

Sr. BI Developer

Responsibilities:

• SQL Server Analysis Services (SSAS) - developed a number of dynamically partitioned cubes to handle large volume of data for each client
• SQL Server Integration Services (SSIS) - automated OLAP cube updates by pulling data from FTP server, staging data and processed / updated SSAS cubes. Developed .NET component to generate new cube partitions on the fly.
• SQL Server Reporting Services (SSRS) - developed numerous SSRS reports that displayed complex trending and drill down. Used MDX for complex queries against SSAS cubes.
• Direct OLAP Client Access - assisted clients with direct access of SSAS cubes through Excel.

Confidential, Atlanta, GA

Sr. Developer

Responsibilities:

• Source Table Design
• Data Entry to Newly Created Source Tables
• Target Table Meta Data Draw
• Mapping from Source to Target Tables.
• All applications relied heavily on ADO.NET for connectivity issues and for DataGrid functionality.
• ADO.NET’s use of Data Views allowed for the re-population of the DataGrid without having to refill existing Data Sets.
• The developed applications used ADOX technology to dynamically create OLEDB tables designed by the user by creating an ADOX table, then appending it to an ADOX catalog object.
• Once the tables were created, the user could switch to the data entry form.
• For this, applications used an ADO.NET command object.

Confidential, Dallas, TX

Senior Programmer/Analyst

Responsibilities:

• Data import and cleansing via custom DTS packages.
• Development of specific SQL data cleaning stored procedures for each school.
• Development of C/C++ programs for customized directory pages generation for book-bind publication.