Certified Microsoft/Microstrategy Software Engineer who strengthens a business’ competitive advantage by leading teams to align web communications and IT systems with business goals.
• Architected, designed, and drove development of an enterprise data warehouse consisting of all U.S. Army accident data and multiple DoD sources. Responsible for all phases of development including source analysis, ETL scripting and package development, data modeling (ErWin Data Modeler), report/dashboard creation, documentation and training. The solution utilized Microsoft BI stack including SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS).
• Microstrategy 10.x (SME) responsible for managing and maintaining development, test, and production environments. Administering and training users. Responsible for report, document, and dashboard development. Responsible for troubleshooting development, UAT and production environments, object migrations, user and permission administration, creating and duplicating new projects using development lifecycle. Created dashboards with parameter driven forecasting models (R) and performed user acceptance testing (UAT). Integrated MDX cube development with Microstrategy environment. Responsible for installing, upgrading and patching to newest versions of Microstrategy.
• Architected, developed and documented a SSIS data processing model for nightly loading of staging and data warehouse database structures. This included the development of a standard SSIS ETL framework utilizing error/execution logging, record outlying, and standard configurations to maximize efficiency and reusability.
• Developed SSIS ETL projects/packages for 30+ external data sources and integrated into EDW
• Developed data architecture for OLAP cubes and data marts using star schema and snowflake schema based data models.
• Implemented Data Quality Control by testing and implementing database constraints.
• Developed SSIS ETL and migrated data from legacy systems into new database structures.
• Developed testing procedures and workbooks to compare counts between source and destination for data
Work Terms
20+ hours a week, email or phone preferred communication