Professional Summary
Results-driven Data Analyst / BI Developer / Data Engineer with 8+ years of experience designing and implementing Business Intelligence (BI) solutions across Healthcare, Finance, Insurance, and Logistics. Skilled in SQL Server, Power BI, SSRS, Azure Data Factory (ADF), Blob Storage, and Python for building scalable, data-driven solutions. Expertise in ETL design, data modeling, and interactive reporting that enable informed business decisions. Adept at working in Agile environments, collaborating with stakeholders, and delivering enterprise-grade data solutions that meet business and compliance requirements.
Technical Skills
Databases: SQL Server (2012–2022), MS Access, Azure SQL Database
ETL & Data Integration: SSIS, Azure Data Factory (ADF), SQL Server Data Tools, OLAP/OLTP
Reporting & Visualization: Power BI (Dataflows, DAX, Power Query, Power Pivot), SSRS, Report Builder, Tableau, Excel
Programming & Scripting: T-SQL, Python, XML, HTML
Cloud & Storage: Azure Blob Storage, Azure Data Factory, Azure DevOps
Version Control: Git, GitHub, TFS, Azure DevOps
Modeling Tools: Erwin, MS Visio
Other Tools: MS Office Suite, SharePoint, Confluence
Professional Experience
Trinity Health – Remote/MI
BI Developer / Data Engineer Dec 2022 – Present
Designed and implemented ETL pipelines using SSIS and Azure Data Factory to extract, transform, and load data from RDBMS, XML, and flat file sources.
Built Power BI dashboards and SSRS reports delivering actionable insights to clinical and business teams.
Optimized T-SQL queries and stored procedures using SQL Profiler and tuning tools, improving performance by 40%.
Automated data workflows with scheduled SSIS jobs for weekly/monthly reporting feeds.
Implemented dimensional modeling for data warehouse solutions (fact/dimension tables, star schema).
Partnered with SMEs to translate business requirements into BI solutions.
Managed backups, restorations, and performance tuning ensuring high database availability.
Tools & Tech: SQL Server 2019, SSMS, SSIS, SSRS, Power BI, ADF, Azure Blob Storage, GitHub, Python
Estes Express Lines, VA
SQL/BI Developer Jan 2019 – Nov 2022
Built Power BI dataflows, dashboards, and reports with advanced DAX measures for operational analytics.
Integrated Power BI with multiple enterprise systems for end-to-end reporting.
Designed SSRS reports with drill-down and parameterized features.
Migrated legacy data sources (Access, Excel, CSV) into centralized SQL Server databases via SSIS.
Collaborated with business units to deliver KPI dashboards for logistics performance monitoring.
Automated ETL jobs and data refresh schedules in ADF and SSIS.
Tools & Tech: SQL Server, SSIS, SSRS, Power BI, ADF, SharePoint, Teradata, Oracle, TFS DevOps
PNC Bank, TX
MSBI Developer Jun 2017 – Dec 2018
Designed and optimized stored procedures, functions, and indexes for data warehouse solutions.
Developed SSIS packages to load financial and compliance data from multiple systems.
Delivered SSRS reports for regulatory and executive reporting (daily/weekly/monthly).
Implemented Type 1 & 2 Slowly Changing Dimensions (SCD) in warehouse design.
Collaborated with stakeholders to develop star schema-based models and ODS.
Tools & Tech: SQL Server 2014/2012, SSIS, SSRS, SSAS, T-SQL, Visual Studio
GAVS
SQL Server SSIS/SSRS Developer May 2016 – May 2017
Designed and developed ETL packages using SSIS for data integration and transformation.
Identify and resolve problems encountered during both development and release of the SSIS code
Built and deployed SSIS packages to integrate and transform data into staging/production systems.
Maintained historical data in the warehouse using Slowly Changing Dimensions.
Created complex SSRS reports (matrix, drill-down, drill-through, tabular) for business intelligence.
Performed SQL tuning and troubleshooting for high-volume ETL jobs.
Tools & Tech: SQL Server 2014/2012, SSIS, SSRS, DTS, SharePoint, Visual Studio, XML, C#
Education
Bachelor’s Degree in Computer Science / Information Systems