All this and more!

BI Azure Developer Architect

Phone: 770-715-8466 [email protected]

Buford, Georgia

Summary - Highly Experienced and Capable Developer/Architect

  • Microsoft Business Intelligence - Microsoft Certified MCSE Business Intelligence & MCSE Data Management and Analytics, Tabular and Multidimensional OLAP cubes, DAX, MDX, SQL Server 2016/2014/2012, SSAS, ETL, SSIS, Power BI, cube tools, NoSQL, JSON, SSRS.
    • "The consultant that reviewed your work said it was "Superb!" CEO - 2016
    • "The (OLAP) cube experience and talent that was exhibited…is of exceptional nature."
      • Microsoft Solution Review quotation - 2007.
  • Microsoft Full Stack - Database, Back End, Front End ASP.NET -
    • Database - Microsoft Certified MSCA SQL Server 2012/2014 and 2016+, Azure Cosmos DB/Mongo DB NoSQL, Oracle, Teradata, SQL, PL/SQL, stored procedures, triggers, CLR.
    • Back End - C# .NET Core, Minimal Web API, Windows Services, tools and apps.
    • Middleware - Database Interfaces - MongoDB (NoSQL), SQL Server (ADO.NET, SMO, Entity Framework), Cubes (ADOMD.NET) and Web Services/REST, SOAP, JSON, XML.
    • Front End - ASP.NET MVC, ASP.NET Core, Windows Forms - C#, .NET Core, DevExpress
    • Quote - "Grant, the DnF Chart Tool is incredible! It looks like a professional commercial application! The software you replaced cost $2.2 million dollars to develop…And you built it all by yourself in a couple of months!" AT&T - 2013.
  • Cloud - Microsoft Certified Azure Architect (2019)
    • Azure - VMs, Cosmos DB, BLOBs, Key Vault, Web Jobs, Microservices.
    • AWS - .NET on AWS with Lambdas, Python.
  • Data Science - Certified Data Scientist, John Hopkins University - R, Machine Learning, etc.
  • Complete Software Development Environment - GitHub, Agile Scrum, Rapid Prototyping.
    • "In all my years of experience I've never encountered a developer as good as you." AT&T - 2013
  • Complete Software Development - Requirements, Architecture, Design, Development, Testing, Deployment, Documentation, Training, and Support - "One Man Development Army!"
    • "Grant can do it all!", "Grant's a one-stop shop for development!" AT&T - 2009, 2010
  • Author - The OLAP Cube Users Answers Book (2019)
  • Initiative - When I need a tool or something automated…Instead of being stopped cold or needing a big team or formal project…I just build it.

BI Consultant/Developer 6/2019 - Present

DaVinci Minds Software and SoftwareWarrior.NET, Remote from Atlanta, Georgia

Software development team management with ASP.NET and C#. Development of custom software, ETL, database systems and multidimensional cubes and reporting systems using a custom OLAP database, SQL Server, C#, Power BI, and AWS. Microsoft Azure and ETL development and WordPress website development as well as project consulting. Mobile dev with both Xamarin and .NET Maui.

Database Developer 7/2016 - 5/2019

Cognosante, LLC, Remote from Atlanta Georgia

Development of tabular OLAP cubes, ETL and database systems (SQL, stored procedures, and SSIS), C# programs for ETL, data loading, test record generation, web services, and utility tools on Azure cloud.

  • Developed complete MCR tabular cube reporting system with DAX including custom C# ETL programs to interface and extract data from an Azure Cosmos DB NoSQL JSON database using MongoDB drivers in C# and Azure Storage BLOB containers as data sources.
  • Developed Smarty Streets web services interface as C# module for SSIS for address validation.
  • Developed ASP.NET MVC cube Status Website to monitor cube, ETL, and database server status including an ETL status performance logging system to power it.
  • Worked with SQL Server, SSIS, Tableau, Excel Pivot Tables and PowerPivot, SharePoint, Amazon AWS, Agile SCRUM, PowerBI training, NoSQL, and others in high security Azure Government environment.

Senior Business Intelligence Developer/Architect 6/2015 - 5/2016

Intelligent Hospitality, Norcross, Georgia

Responsible for full refactoring of an Amazon AWS cloud based international business intelligence reporting system for the hotel industry while maintaining the 24x7 production system.

  • SQL Server 2014 and BI stack, SSIS, SSRS, custom ASP.NET MVC web GUI interface, and custom ETL Windows services and data collection programs.
  • Refactoring/rebuilding it one module at a time while maintaining production online 24x7.
  • Developed custom built.NET C# Data Collection Application (DCA) for real time data collection and ETL instead of the old unreliable script-based system.
  • Full architecture and development and built many utility programs, components, and tools.
  • Solved production problems 24x7 and technical liaison to customers.

Senior Engineer/Developer/Architect 9/2010 - 6/2015

AT&T Mobility - Cricket, Atlanta, Georgia

Architected, designed, and developed OLAP Cubes using Microsoft SSAS (Analysis Services) 2012 and data warehouse staging ETL with SSIS (Integration Services) as well as .NET software applications in both Windows forms and ASP.NET web forms in C# using SQL Server 2012.

  • Data Science Certificate - Coursera.org and John Hopkins University.
    • First graduating class of 500 out of 1.2 million students.
  • Data analysis of the Cricket national sales and subscriber data (3+ TB of data).
  • Responsible for the Cricket national OLAP cube serving reports to all AT&T Cricket store and sales managers and executives.
  • Developed LTE SPG/SPW OLAP production cube with ETL in six weeks.
  • Developed two OLAP Cube and Excel Pivot Table learning videos for AT&T University and provided training and mentoring.
  • C# development with DevExpress components - Both Windows and Web (ASP.NET).
  • ERD - Engineering Rules Database and Budget Tool applications (ASP.NET).
  • DnF Chart Tool (Windows with ClickOnce deployment) - Automatically generate 3,000 charts with from SQL Server database to PowerPoint slide set in less than 15 minutes.
  • Developed the Aspire ASP.NET Framework to replace Iron Speed applications.
  • Developed 17 dashboards with Dundas Dashboards and trained in LogiXML Dashboards.
  • Developed Software Innovation Psychology - What's the foremost reasons software development projects succeed or fail? Cognitive and Innovation Factors...

Senior BI Consultant/Architect/Team Lead 3/2010 - 9/2010

Bright Byte Consulting at Incomm, Inc., Atlanta, Georgia

Developed iRIS a specialized Business Intelligence front end GUI and automated report generator for SSRS reports in C# ASP.NET.

  • Built and ran the development team, designed and architected the solution, functioned as technical team lead, and prototyped the development solution and code.
  • This solution acted as a user-friendly front end to the corporate data warehouse and generated SSRS RDL code programmatically allowing non-technical users to develop SSRS reports through an automated report manager and wizard.
  • Developed OLAP cube for monitoring development progress.

Senior BI Consultant/Data Warehouse OLAP Cube Developer 9/2008 - 3/2010

AT&T Mobility, Alpharetta, Georgia

Developed two terabyte data warehouses with OLAP cubes for wireless UMTS cell phone traffic performance tracking using SQL Server 2008, SSIS, SQL, SSAS, C#, and Alteryx.

  • Two complete terabyte size data warehouses and OLAP cube systems.
  • Custom KPIs and Busy Hour tracking with Data Dictionary database and GUI front end.
  • Oracle source system, SSIS ETL, SQL Server 2008 staging databases, and SSAS (Analysis Services) 2008 OLAP cubes for analysis and reporting.
  • Developed the Trinity cell phone reporting system a one stop application to combine reporting for SSRS reports, SQL databases, and OLAP cubes in one easy to use high performance application.
  • Developed Trinity ASP.NET web portal with user login, apps, and dashboard areas.
  • Included unique Dynamic Reports allowing the users to modify and customize reports.
  • Included OLAP cube browser, MDX reports, and SSRS reports.
  • Built in C# .NET 2.0 for Windows and ASP.NET with SQL Server 2008 back end and Developers Express Windows and ASP.NET controls.

Senior BI Consultant - Data Warehouse and OLAP Developer 11/2007- 6/2008

Colorado Home and Finance Authority (CHFA), Denver, CO

Senior BI Consultant on a project to resurrect a stalled BI data warehouse/OLAP cube project, train staff, and develop new cubes, a data warehouse, and a dashboard prototype with Dundas controls.

  • Data warehouse with multiple OLAP cubes and dimensional schemas developed for single family mortgage loan data, workflow data, and loan servicing data.
  • Development of all ETL with SQL and SSIS with SQL Server 2005.
  • Extensive data analysis of health care data.
  • Extensive hands on training of staff members for OLAP cube development with AS2005.
  • Full design and deployment documentation of all work.
  • Development of tools and utilities in C# include SQL Log Truncation Tool and OLAP Cube Explorer and Documentation Tool.

Data Architect/OLAP Cube and .NET Developer 1/2006 - 10/2007

Health Grades, Inc., Golden, CO

Data Architect and Database Developer responsible for developing BI and database solutions using Microsoft SQL Server 2005 and Analysis Services 2005.

  • Data Analysis using statistics and the statistical model developed by Health Grades for the analysis and classification (star ratings) of health care providers and organizations.
  • Implemented OLAP multi-dimensional database architecture and database cubes and infrastructure for the QAI (Quality Assurance Initiative) product using Microsoft Analysis Services 2005, SQL Server 2005, SQL, SSIS, MDX, and custom .NET C# tools, with ProClarity and MS Reporting Services reports.
  • Developed additional OLAP database cubes for MedPar data, hospital Ratings and Rankings data, web analytics, and prototype cubes.
  • Initiated a database re-engineering program for a complex statistical database system (QAI).
  • Developed multi-dimensional cube processes and tools in Microsoft Visual Studio 2005 using C# ASP.NET, Windows Forms, ADO.NET, ADOMD.NET, and SSIS.
  • Developed Reporting Services extensions and a batch reporting tool in C# to run multiple SSRS reports simultaneously through multi-threading with only one set of input parameters.
  • Developed flexible data importer tool in C# to input data in many formats
  • Internal consultant for database design, re-engineering, and best practices.
  • Scored 4.4 out of 5 in last job review.

Senior Consultant - BI Developer 1/2005 - 11/2005

Norfolk Southern Railroad, Atlanta, GA

BI Developer for a major transportation company in their Operations Research department.

  • Developed and enhanced multi-dimensional database cubes, web-based access and reporting software, and utility programs to access, browse, and report on payroll data OLAP cubes (Analysis Services 2000) with Microsoft BI Stack and SSIS DTS ETL.
  • Complete re-development of a cube report browsing tool with Visual Studio and .NET 1.3 and ASP.NET 1.3 and ADOMD.NET with integrated security, user settings, logging, and enterprise level database support to replace a problematical JavaScript based tool.
  • Provided complete project development and support including project planning, architecture, deployment, documentation, and user support.
  • Deployed and provided support for the 380 online users in multiple states.
  • Developed prototype OLAP database cubes.

Certifications

Education

  • Masters of Transpersonal Psychology - 2013 - 4.0 GPA
    • With practical applications towards Software Psychology.
    • Sofia University (formerly the Institute of Transpersonal Psychology), Palo Alto, CA
  • Graduate courses towards MS degree in Computer Science - 1992 - 4.0 GPA
    • Florida Atlantic University, Boca Raton, Florida
  • Training in Knowledge Engineering, Expert Systems, and LISP - 1987
    • GM AI/Knowledge Engineering Lab, GM Research Center, Detroit, MI
  • Bachelor of Science, Computer Science and General Engineering - 1986 - 4.0 GPA
    • State University of New York, Regents Program (now Excelsior College), Albany, NY

Work Industries List

  • Telecomm/Mobile
  • Health Care
  • Startups
  • Transportation
  • Hospitality/Travel
  • Financial
  • Government
  • Manufacturing
  • Dot Com
  • Consulting
  • Advertising
  • Entertainment

Technical Publications

  • The OLAP Cube Users Answers Book (2019)
  • "Substring Instance SQL CLR - Find nth Instance of a String", http://www.codeproject.com (2013)

Professional Memberships

Current Projects

  • Completing new Microsoft Certifications: Azure Architect and Azure AI Engineer
  • Working on a book project.
  • Working on an Azure AI demo website.

Websites

Cary Grant Anderson - Resume -BI Azure Developer Architect - 030225.docx