Available to hire
Business Intelligence Developer and SQL Server Developer with 5+ years of experience designing, developing, and supporting Business Intelligence, Reporting, and Data Warehouse solutions. Strong expertise in SQL Server, SSIS/SSRS/SSAS, Power BI, and data modeling to deliver enterprise reporting and analytics.
Skilled in building ETL pipelines, writing complex T-SQL for performance and reliability, and creating interactive dashboards with DAX/Power Query (including RLS). Experienced in cloud-aware solutions using Azure Data Factory and Azure SQL Database, and in collaborating with stakeholders to translate requirements into impactful BI deliverables.
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Work Experience
Senior SQL Server BI Developer (SSIS/SSRS/Power BI/Azure) at Morgan Stanley, New York, NY
February 1, 2024 - PresentDesigned, developed, and maintained SSIS ETL processes to extract, transform, and load data from multiple sources (Oracle, SQL Server, MS Access, Excel, and flat files) into data warehouse and data mart environments. Built and optimized complex T-SQL objects (queries, stored procedures, views, functions, triggers, CTEs, and indexes) to support reporting and business applications. Developed Power BI dashboards and KPI reports using DAX/Power Query/Power Pivot with data modeling, hierarchies, and Row-Level Security (RLS), and published/managed them in Power BI Service with scheduled refreshes and gateway configuration. Created SSRS reports including tabular, matrix, drill-down/drill-through, parameterized reports, charts/gauges, cascading parameters, and dynamic filtering. Worked on SSAS cubes (dimensions, hierarchies, measures, and aggregations) and performed query/ETL performance tuning using execution plan analysis. Supported and troubleshot SSIS/SSRS/Power BI in development, testing,
Senior SQL Server BI Developer (SSIS/SSRS/Power BI/Azure) at Morgan Stanley
February 1, 2024 - PresentDesigned, developed, and maintained ETL processes using SSIS to extract, transform, and load data from multiple sources (Oracle, SQL Server, MS Access, Excel, flat files) into data warehouse and data mart environments. Developed and optimized complex T-SQL (stored procedures, views, functions, triggers, CTEs, indexes) to support reporting and business applications. Built Power BI dashboards and KPI reports using DAX, Power Query, and data modeling with relationships and Row-Level Security (RLS). Created and maintained SSRS reports (tabular, matrix, drill-down/drill-through, charts, parameters with cascading filters). Worked on SSAS cubes, dimensions, hierarchies, measures, and aggregations. Performed performance tuning using execution plans and indexing strategies, and supported production issues with unit/integration/UAT testing and monitoring of SSIS/Power BI/SSRS deployments. Used Azure Data Factory and Azure SQL Database for cloud-based integration where applicable.
Business Intelligence Analyst (SQL/SSIS/SSRS/Power BI) at Centene Corporation, Saint Louis, MO
April 1, 2022 - January 31, 2024Gathered business requirements with stakeholders and identified data sources for reporting and analytics. Developed and maintained SSIS ETL solutions to load data from Oracle, SQL Server, Excel, flat files, and other external systems into data warehouse/data mart environments. Wrote complex T-SQL queries and database objects (stored procedures, functions, views, triggers, indexes) for data processing and reporting. Built Power BI dashboards and KPI scorecards with DAX, Power Query, and interactive visuals, including data modeling and Row-Level Security (RLS), then published/manage reports in Power BI Service with workspace security and scheduled refreshes (including gateway configuration). Developed SSRS reports (tabular/matrix/drill-through/drill-down/chart/parameterized) with dynamic and cascading parameters. Built SSAS models including star schema fact/dimension structures and OLAP cubes, dimensions, hierarchies, measures, and aggregations. Performed unit/integration testing and UAT
Business Intelligence Analyst (SQL/SSIS/SSRS/Power BI) at Centene Corporation
April 1, 2022 - January 31, 2024Partnered with business users, stakeholders, and vendors to gather requirements and identify data sources for reporting and analytics. Built SSIS ETL pipelines to load data from Oracle, SQL Server, Excel, and flat files into data warehouse and data marts. Developed T-SQL objects (procedures, functions, views, triggers) and implemented query tuning for ETL/report performance. Created Power BI dashboards, KPI scorecards, and drill-down/analytical reports using DAX and Power Query; implemented RLS and published reports to Power BI Service with scheduled refresh and gateway configuration. Designed SSRS reports with dynamic filtering, cascading parameters, and interactive features. Developed SSAS models including fact/dimension star schemas, cubes, hierarchies, measures, and aggregations. Supported production operations, troubleshooting, maintenance, and testing activities (unit/integration/UAT). Used Azure Data Factory and Azure SQL Database for cloud integration and followed Agile/Waterfa
SQL/SSRS/SSIS/SSAS Developer at IBM, New York, NY
January 1, 2021 - March 31, 2022Collected and documented reporting and data integration requirements with business users, analysts, and stakeholders. Designed and implemented SSIS ETL packages to extract, transform, and load data from heterogeneous data sources. Developed SSRS reports (drill-down/drill-through, matrix, tabular, parameterized, dashboard) including charts, gauges, and KPI visuals, and created reusable datasets/report models to improve scalability and maintainability. Built Power BI dashboards and reports with interactive filtering and drill-through. Developed SSAS cubes, dimensions, measures, and KPIs for analytical reporting. Implemented incremental loads, data cleansing/validation, and SQL Server Agent scheduling for automated SSIS executions. Added SSIS exception handling, logging, checkpoints, and event handlers for reliability and monitoring. Improved report and query performance using dataset optimization, indexes, execution plan review, and stored procedure tuning. Supported deployment/migration
SQL/SSRS/SSIS/SSAS Developer at IBM
January 1, 2021 - March 31, 2022Collaborated with business analysts and stakeholders to document reporting and data integration requirements and deliver SSIS-based ETL solutions across heterogeneous data sources. Developed SSRS reports including drill-down/drill-through, matrix, tabular, parameterized, and dashboard-style reports with charts, gauges, and KPIs. Built and optimized T-SQL (procedures, functions, views) and implemented reusable datasets/report models to improve performance and scalability. Created Power BI dashboards with interactive visuals, filters, and drill-through. Developed SSAS cubes, dimensions, measures, and KPIs for analytical reporting. Implemented incremental loads, data cleansing/validation, exception handling, logging, checkpoints, and event handlers in SSIS; scheduled jobs using SQL Server Agent. Tuned indexes and execution plans to improve query/report performance, supported deployments across Dev/QA/UAT/Prod, migrated legacy Crystal/older SSRS reports, and ensured data accuracy via recon
Education
Master’s in Computer Science at University of Houston Clear lake
January 11, 2030 - July 23, 2026Master’s in Computer Science at University of Houston Clear lake
January 11, 2030 - July 23, 2026Qualifications
Industry Experience
Financial Services, Professional Services, Software & Internet, Computers & Electronics
Skills
Experience Level
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Hire a Database Developer
We have the best database developer experts on Twine. Hire a database developer in New York today.