Senior SQL Server & Analytics Specialist

Cedric T. Britt

301-***-**** ********@*****.*** Ellicott City, Maryland

SENIOR SQL SOLUTIONS & ANALYTICS SPECIALIST

Summary

Senior Data and Analytics Professional with over 25 years of experience designing, developing, and optimizing SQL Server solutions across healthcare, finance, government, and retail industries. Expert in advanced T-SQL development, data modeling, database performance tuning, ETL development, and analytics reporting. Proven ability to analyze complex business requirements, transform large datasets into actionable insights, and communicate technical solutions effectively to business stakeholders and executive leadership. Extensive experience supporting mission-critical data environments with a focus on accuracy, scalability, compliance, and operational excellence. Skills

• SQL Server

• Microsoft Fabric

• SSIS/Azure Data Factory

• PowerShell

• High Availability/Disaster Recovery/Replication

• Python/C#

• SSRS/POWER BI

• Data Visualization

• Data Modeling

• REST

• GraphQL

• API Integration

• Visual Studio

Experience

Northern Regional Pennsylvania College

Data Analyst 01/2026 – Present

• Serve as lead Data and Analytics Analyst, driving enterprise-wide data-informed decision making through the Ellucian Colleague Insights cloud data warehouse and Microsoft analytics platforms.

• Design, develop, and maintain Power BI semantic models, datasets, and interactive dashboards that deliver actionable insights for executive leadership, academic departments, and operational stakeholders.

• Build and automate Azure-based data integration pipelines that consolidate and transform data from Ellucian SaaS applications, enterprise systems, and third-party platforms.

• Develop complex T-SQL solutions, data models, and reporting architectures to improve data accessibility, integrity, and performance across the organization.

• Implement data governance, documentation, and automated workflows to enhance data quality, reporting consistency, and self-service analytics capabilities.

• Apply prompt-engineering techniques to build AI-enabled predictive models to forecast future enrollment, financial need assessments, future workforce development programs requirements, and generating draft grant proposals. Senior Consultant 11/2019 - 10/2025

Guidehouse

• Led enterprise data architecture, Azure data platform modernization, and data governance initiatives, enabling scalable analytics and cloud-based reporting solutions.

• Designed and developed advanced Azure SQL, T-SQL, stored procedures, functions, and views supporting enterprise reporting, business intelligence, and operational analytics.

• Architected and optimized Azure Data Factory and SSIS data pipelines, delivering reliable ETL/ELT solutions for large-scale data integration and transformation workloads.

• Implemented cloud-based analytics solutions using Power BI, Azure Data Services, and Microsoft Power Platform, providing executive dashboards and KPI reporting across business units.

• Analyzed and optimized multi-million-row datasets, improving query performance, report delivery times, and overall platform scalability.

• Collaborated with business and technical stakeholders to translate requirements into data products, semantic models, dashboards, and self-service analytics solutions.

• Performed root cause analysis on complex data quality issues, implementing automated monitoring and remediation processes that improved data reliability and governance compliance.

• Developed automated validation, reconciliation, and master data management processes across multiple enterprise systems.

• Authored enterprise data architecture documentation, data dictionaries, technical specifications, and governance standards supporting operational excellence and knowledge transfer.

• Partnered with cross-functional teams to deliver Power Platform solutions, leveraging Power BI and workflow automation to streamline reporting and business processes.

Senior Data Architect 11/2018 - 11/2019

Baltimore City Information Technology

• Led data systems management and architecture development including on-prem and cloud database development and data governance frameworks.

• Developed data integration pipelines orchestration and data ingestion leading to 70% decrease in accounts receivable processing time.

• Reviewed and optimized existing data platforms, enhancing data quality and operational efficiency.

• Contributed to strategic planning for migration of legacy systems to cloud, enhancing integration with third-party SaaS products.

• Directed enterprise architecture, systems planning, and governance initiatives, aligning municipal IT systems with organizational goals.

• Provided expertise on Microsoft Dynamics GP, facilitating database administration, reporting, and data integration to support operational needs.

Senior Data Architect/Developer 10/2015 - 08/2018 Johns Hopkins Health Plans

• Led data migration and data warehouse development for healthcare claims systems, improving data integration and reporting capabilities.

• Developed data mapping and business rules to streamline payer systems migration and consolidation.

• Built and maintained SQL Server Integration Services packages and SQL scripts, enhancing data transformation processes.

• Supported post-migration validation and reporting, optimizing system performance and ensuring data accuracy. Senior Data Architect/DBA 10/2012 - 09/2015

FEI Systems, Inc.

• Designed and implemented data warehouse architecture and ETL processes for state health agencies.

• Managed database design, development, implementation for large-scale health IT projects, enhancing data quality and supporting robust reporting infrastructure.

• Led database performance tuning, backup/recovery, and high availability planning.

• Collaborated with analysts to create BI solutions using Microsoft BI Stack, improving data accessibility and decision-making for stakeholders.

Associate 03/2008 - 10/2012

Booz-Allen-Hamilton

• Designed and optimized SQL Server and SharePoint architectures for enterprise applications.

• Guided clients on best practices for database security and ensured high availability and performance.

• Delivered database architecture and optimized performance to enhance business intelligence solutions for government clients.

• Led data migration and integration projects, including legacy systems modernization initiatives. Solutions Architect 09/2006 - 03/2008

EMC Corporation

• Facilitated pre-sales and delivery of Microsoft data solutions, including SQL Server, SharePoint, and data warehousing, enhancing client engagement and satisfaction.

• Delivered pre-sales technical support and executed post-sales delivery of Microsoft SQL Server data and architecture projects, ensuring alignment with client requirements.

• Oversaw deployment and adoption of Microsoft BI and SharePoint solutions, driving user engagement and maximizing project value.

• Conducted architecture assessments and performance analyses for client databases.

• Developed and presented technical proposals and statements of work. Education

MIT - Professional Applied Data Science Program

Leveraging AI for Effective Decision Making

Machine Learning and Advanced Analytics

George Washington University - Washington, D.C. Master of Science Operations Research

Morehouse College - Atlanta, Georgia Bachelor of Science Mathematics

Contact this candidate