Dan Johnson Email & Phone Number

Washington, Dc, Us

Baltimore, Md, Us

Manage team of 3 developers responsible for design, configuration, and implementation of all aspects of the data integration framework. This includes all aspects of data integration and warehousing that include data infrastructure, data security, and data access patterns.Developed environment modernization roadmap to move core data products from SQL Server to cloud native tools (ex: Databricks & Microsoft Fabric).Manage the delivery of long-term data initiatives and ad-hoc activities while balancing multiple high-priority value streams through a dynamic environment.

Baltimore, Md, Us

Formerly University of Maryland Medical Systems Health Plans prior to acquisition by CareFirst in October 2020.Provide Architecture and Data Strategy Roadmap for enterprise data warehouse expansion into Snowflake and cloud migration to Microsoft Azure. Manage team of 3 developers responsible for design, configuration, and implementation of all aspects of the data integration framework. This includes all aspects of data integration and warehousing that include data infrastructure, data security, and data access patterns. Responsible for planning and execution of migration to new Azure environment as part of Data Center decommissioning including mapping existing services into Azure services and then planning upgrade to more cloud native technologies (Data Factory/Azure SQL Managed Instance/Azure Virtual Machines).Created environment and development best practices that were documented and proactively revised through code review to ensure that all policies are adding value for the team and providing a standardized process that reduces turnaround time. Manage the delivery of long-term data initiatives and ad-hoc activities while balancing multiple high-priority value streams through a dynamic environment.

Responsible for cloud architecture and administration utilizing Azure and AWS cloud platforms to migrate or rearchitect existing infrastructure or processes. Onboarded new customers into the Azure environment for new Atlassian implementations providing technical sales support as well as architecture guidance for technical implementation of the Azure resources including storage, networking and virtual machines.Built governance models around both data and cloud infrastructure deployments.Planned and implemented Office 365 for small business.

Hanover, Maryland, Us

Led an agile development team responsible for web analytics reporting. The solution was developed from the ground up to consume existing web analytic data and generate insights into how the web properties were driving business. Provided Data Engineering solutions for Data Science, Customer Analytics, and Service Desk Metrics project teams within both Oracle and Hadoop environments. Data solutions implemented using Agile methodologies with a range of technologies from PL/SQL, HQL, Sqoop, Shell Scripting, Cisco Information Server, Informatica, and Tableau to deliver the desired result to our product owners. Developed data models for Hadoop platform that can effectively be consumed for end user reporting via Tableau. These models span internal and external data to allow for consumption of previously structured data with newly ingested statistical data. Collaborated extensively with both on-shore and off-shore resources operating in multiple time zones to both develop and execute complex ETL logic utilizing both RDBMS and Hadoop. Drove the adoption of best practices and methodologies for new technologies to reduce technical debt when providing new solutions to product owners.

Baltimore, Md, Us

Inclusive of all previous job responsibilitiesWorked directly with executive leadership to provide insight into the data warehouse environment and accommodate Agile changes into the Data Strategy Roadmap.Principal Architect for CareFirst Business Intelligence Environment encompassing 145 virtual and physical Windows servers including load balanced production SQL Server Reporting environment instances. Managed two engineers encompassing the Business Intelligence Infrastructure Team that provided oversight and support for Development and End User communities.Built and maintained complex ETL logic for the Business Intelligence data warehouse that utilized multiple sources to create a consolidated repository for both reporting and analytics. Established governance for highly sensitive data to include data security and access patterns.

Baltimore, Md, Us

Managed and Administered 100+ Windows server environment. Coordinated SAN migration for SQL and Business Intelligence environment.Coordinated server expansion to accommodate environment growth.Managed backup and disaster recovery plan for SQL and Business Intelligence Environment. Implemented third-party reporting applications for both Internal and External customers. Maintained infrastructure for Reporting and Analytics platforms utilizing SQL Server.Designed SQL Server Database Security and Windows Server access model. Responsible for Data Integrity of Relational and Analytic databases.Coordinated Monthly data releases including development, testing, and production release phases. Worked with both internal contractors and external vendors to develop project solutions.

Baltimore, Md, Us

Lead Developer on numerous projects; responsible for project planning as well as delivering the technical solution. Optimized Monthly Processing through use of SQL Server Integration Services. Responsible for monthly processing of enterprise reporting environment.Coordinated Monthly data releases including development, testing, and production release phases.

Baltimore, Md, Us

Member of 4 person team that developed and implemented a SQL Server load balanced, enterprise reporting solution.Developed cross-platform solutions utilizing Informatica and SQL Server Integration Services ETL integrated with SQL Server 2008 databases using table triggers and SQL Agent to deliver a comprehensive end to end solution.Responsible for monthly processing of enterprise reporting environment.Worked with Project Management Office to schedule projects from the planning to delivery stages.

Master'S Degree, Advanced Information Technologies

Bachelor'S Degree, Computer Information Systems