We provide IT Staff Augmentation Services!

Application Architect (principal Architect) Resume

4.00/5 (Submit Your Rating)

SUMMARY

Experienced technical leader with a demonstrated history delivering quality solutions for business problems using Microsoft technologies.

PROFESSIONAL EXPERIENCE

Confidential

Application Architect (Principal Architect)

Technologies: SQL Server, SSIS, Data Warehouse, Kimball Modeling, SSAS, MDX, C#, MVC, Web API, WCF, Kendo, J - Query, Backbone, Bootstrap, Microservice, WCF, TFS, Git

Responsibilities:

  • Principle back-end architect and engineer for our hospital suite of products.
  • Redesigned the entire back-end and created a stable, scalable, and highly performant solution.
  • Accepts multiple data inputs (HL7, 835's, 837's, flat files).
  • SSIS and Microservices.
  • Designed integrations with other product teams via API's.
  • Worked with the Data Science team to deliver the next generation predictive analytics solution.
  • Designed and implemented a data warehouse to support our advanced analytics solution.
  • Worked as a full-stack engineer as needed to create WCF services, Web API, MVC applications.
  • Architected and engineered a highly performant rules engine.

Confidential

Lead Software Engineer

Technologies: SQL Server, DBA, C#, Scrum & Kanban, Rally, MDM, AWS, Tibco, DQS

Responsibilities:

  • Designed and developed a highly scalable solution to collect, match, and master product SKUs across the internet.
  • Resolved performance issues with the core product.

Confidential

Data Warehouse Architect & Manager

Skills used: SQL Server (SSAS, SSIS, SSRS), MicroStrategy, Kimball Methodology, Dimensional Data Modeling, ETL Design, Data Integration, Data Migration, DBA, VB.NET, C#, MySQL, Oracle, Rally, Project Management (Agile, Scrum)

Responsibilities:

  • Designed and built the data warehouse.
  • Data profiling, business interviews & requirements gatherings, data modeling, ETL development, testing, MicroStrategy architecture/metadata, front-end report development, and training.
  • Strategically hired and managed consulting resources to augment my efforts as needed while staying on budget.
  • Performed all DBA tasks for the data warehouse including upgrades, patching, backups, and performance tuning.
  • Executed a complex data migration from the internal billing system to an external biller.

Confidential

Data Applications Engineering Manager

Technologies: SQL Server (SSAS, SSIS, SSRS), Kimball Methodology, Data Modeling, ETL Design, Data Integration, ProClarity, Sybase, MySQL, DBA, High Availability, High Scalability, multi-terabyte datasets, C#, Jira

Responsibilities:

  • Managed and mentored a team of DBA’s and BI Developers.
  • Our team supported 25+ application developers.
  • Created coding conventions, naming standards, data retention policies, change management procedures, audit processes, best practices, DBA checklists, security models, technical documentation, DDL auditing via triggers, backups, update statistics, server patching, maintenance, performance monitoring, query & index tuning and optimization, rebuilding & defragmenting indexes, event monitoring, SQL Profiler, Performance Monitor (perfmon).
  • Designed, implemented, and maintained multiple datamarts.
  • Extracted data from 6000+ survey databases.
  • Worked with the application developers to deliver several internal and external tools including a data-driven panel management system.

We'd love your feedback!