PROFESSIONAL EXPERIENCE

Database Developer/Architect

Confidential

Responsibilities:

• Architected, designed, and developed complete Azure based 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 C# drivers and Azure Storage BLOBs.
• Planned, designed, and implemented Azure functionality, systems, and migrations.
• Worked cross functionality across teams and with testers and DevOps on requirement gathering, design sessions, implementations, and deployments.
• 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, NoSQL in high security Azure Government environment.

Senior Business Intelligence Architect/Developer

Confidential

Responsibilities:

• Developed new cloud architecture for higher reliability, more automation, and lower cost.
• Architected modular architecture and conversion while maintaining production online 24x7.
• Designed and developed new BI and C# components, automation, utility programs, and tools.
• Microsoft BI Stack, SQL Server 2014, SSIS, SSRS, custom ASP.NET MVC web GUI interface, and custom ETL Windows services and data collection programs on AWS and private cloud.

Senior Engineer/Developer/Architect

Confidential

Responsibilities:

• Data Science Certificate - Coursera.org and John Hopkins University.
• Responsible for the Cricket national OLAP cube serving reports to all Confidential &T Cricket stores and sales managers and executives (3+ TB of data).
• Developed LTE SPG/SPW OLAP production cube with ETL in six weeks.
• Developed OLAP Cube learning videos for Confidential &T University & provided training & mentoring.
• Architected and developed ASP.NET ERD Budget Tool and Aspire Framework.
• 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 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

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.

Senior BI Consultant/Data Warehouse OLAP Cube Developer

Confidential

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

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.