SUMMARY:

• Highly Experienced and Capable Developer/Architect
• Certified MCSE Business Intelligence & 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.

MICROSOFT FULL STACK:

Back End: NodeJS, Windows Services, Console Programs, Full Application Systems.

Middleware: Web Services/REST, SOAP, JSON, XML, Database Interfaces - MongoDB (NoSQL), SQL Server (ADO.NET, SMO, Entity Framework), Cubes (ADOMD.NET).

Database: SQL Server 2016/2014 Certified + Azure Cosmos DB/Mongo DB NoSQL, Oracle, Teradata with SQL, Transact SQL, PL/SQL, stored procedures, triggers, CLR.

Front End: C# .NET ASP.NET MVC & Web Forms, Windows Forms, HTML, CSS, Bootstrap, JQuery, JavaScript, KnockoutJS, DevExpress, Telerik, Visual Studio.

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 ” Confidential &T - 2013.

Cloud: Microsoft Certified Azure Architect (2019), AWS Development and Administration

Complete Software Development Environment: GitHub, Agile Scrum, Rapid Prototyping.

PROFESSIONAL EXPERIENCE:

Database Developer

Confidential, Atlanta, Georgia

Responsibilities:

• 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

Confidential, Norcross, Georgia

Responsibilities:

• 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 Confidential 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

Confidential, Atlanta, Georgia

Responsibilities:

• 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 Confidential &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 Confidential &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

Confidential, Atlanta, Georgia

Responsibilities:

• 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

Confidential, Alpharetta, Georgia

Responsibilities:

• 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

Confidential, Denver, CO

Responsibilities:

• 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

Confidential, Golden, CO

Responsibilities:

• Data Analysis using statistics and the statistical model developed by Confidential 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

Confidential, Atlanta, GA

Responsibilities:

• 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 an 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.