Database Developer/architect Resume
3.00/5 (Submit Your Rating)
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.