We provide IT Staff Augmentation Services!

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.

We'd love your feedback!