Power Bi Sql Server

KAZI ZAKIA TRINA

Senior BI Engineer

Dallas, Texas 469-***-**** *****.*****@*****.*** https://www.linkedin.com/in/trina-kazi-264117201/

SUMMARY

●Power BI/SQL Developer with over 6+ years of expertise in designing, developing, and optimizing database solutions, ETL pipelines, complex data, and interactive dashboards to support data-driven decision-making.

●Proficient in AWS, Azure, and ETL tools like Snowflake, SSIS, and Redshift, refining data workflows to reduce query execution time by 30% and improving reporting efficiency.

●Expertise in SQL, T-SQL, and DAX, leveraging MS SQL Server, MySQL, and Oracle for data modeling, analysis, and reporting, ensuring high-performance data retrieval and transformation.

●Knowledgeable in Power BI, SSRS, and Tableau, creating visualizations and analytical reports to track key business metrics and improve operational efficiency.

TECHNICAL SKILLS

Languages: SQL, T-SQL, Python, DAX Data Modeling Tools: Erwin, MS Visio Version Control: Git

Cloud Technologies: AWS, MS Azure Methodologies: SDLC, Agile, Waterfall Visualization Tools: SSRS, Power BI, Tableau

ETL Tools: Redshift, Snowflake, SSIS

Database: MS SQL Server, MySQL, Oracle, Microsoft Azure, OLAP, OLTP

Tools/Utilities: SSDT (SSIS, SSRS, SSAS), DTS, Visual Studio, Query Analyzer, SQL Profiler, SSMS, JIRA

Additional Skills: Data Analytics, Data Warehousing (Snowflake Schema, Star Schema), Data Modeling

PROFESSIONAL EXPERIENCE

EMCARA HEALTH Franklin, TN

Senior BI Engineer Aug 2022 – Jan 2025

●Accelerated data retrieval by decreasing query times from 10 seconds to 7 seconds and improved query efficiency by processing 1500 complex SQL queries, secured procedures, and functions for healthcare analytics.

●Engineered Redshift database performance by configuring 30 clusters and managing 90 nodes, saving 300 GB of storage space while supporting healthcare data warehousing demands.

●Delivered scalable database solutions by managing 60 BI projects across three years using Agile Kanban and Waterfall methodologies, achieving an on-time delivery rate of 57 projects for evolving healthcare needs.

●Elevated data integrity and scalability by designing 45 database schemas with MS SQL Server and Erwin, integrating 12 million patient records and clinical datasets across systems.

●Streamlined ETL workflows by deploying 45 SSIS packages, SSRS reports, and SSAS cubes using SSDT, Visual Studio, and DTS, cutting data processing times by 12 hours monthly for healthcare metrics across three years.

●Empowered healthcare stakeholders with 150 Power BI reports, including parameterized views, drill-downs, and interactive dashboards, minimizing time by 5 hours weekly.

●Reduced report generation time by 10 minutes per report by integrating Power BI with Redshift, delivering 90 near-real-time visualizations of healthcare KPIs like patient readmissions.

●Minimized system downtime by resolving 150 critical database issues and improved performance by shaving 9 seconds off average query execution time across troubleshooting.

●Pioneered a centralized data warehousing strategy, consolidating 300 terabytes of patient and billing data, diminishing data access time by 15 seconds for analytics while ensuring HIPAA compliance.

●Supervised 15 major AWS Redshift migrations with zero data loss, cutting query response times by 6 seconds for clinical reporting across three years of system upgrades.

●Designed 24 multidimensional data models using SSAS and Erwin, analyzing 9 million patient records for population health studies across three years, enhancing predictive modeling accuracy.

Merck Plano, TX

Power BI Developer Nov 2019 – Jul 2022

●Harnessed Azure Data Factory (ADF) to extract and integrate data from 15 unique healthcare sources—such as 5 EHR systems, 6 CSV files, and 4 SQL databases—processing 2 million records daily for operational and analytical use.

●Deployed 5 SQL tables within Azure SQL Database to manage healthcare data (patient outcomes, billing records), reducing retrieval time by 3 seconds on average for reporting.

●Automated 10 ADF pipelines using 5 event-driven triggers and 5 scheduled triggers, processing 500,000 healthcare data rows—like daily patient admissions or claims updates—within 15 minutes for real-time analytics and compliance reporting.

●Engineered a data pipeline handling 1.5 million records, moving healthcare data from 7 source files into a staging layer, then transforming and loading into a reporting layer within 20 minutes, enabling access to insights on 50,000 patient trends annually.

●Developed SQL stored procedures to compute 30 key healthcare metrics (readmission rates, treatment costs), reducing data processing time from 10 minutes to 2 minutes per batch for clinical and financial reports.

●Refined 12 procedures to transform 80,000 rows of raw healthcare data from staging to reporting layers, ensuring reliable data flows for 25 downstream analytics reports and regulatory submissions.

●Delivered 20 interactive Power BI reports with 50 visualizations tailored to healthcare needs—such as dashboards tracking 1,200 patient satisfaction surveys or 300 resource utilization metrics—empowering stakeholders with actionable insights.

●Applied 15 advanced DAX functions across 10 reports to encode complex healthcare logic, enabling calculations for 5,000 patient outcomes and 200 provider performance rankings monthly.

●Leveraged Power Query within Power BI to clean and transform 3 million healthcare data rows—such as normalizing 10,000 diagnosis codes or duplicating 8,000 patient records—across 15 datasets, ensuring high-quality data for analysis.

●Crafted 40 calculated columns and 25 measures aligned with 35 healthcare KPIs (average length of stay for 2,500 patients, cost per procedure for 1,000 cases), providing stakeholders with precise metrics to drive operational improvements.

●Built and deployed 18 custom Power BI reports, each addressing specific healthcare objectives—like tracking 500 hospital bed occupancy records or analyzing 1,500 payer reimbursement trends—reflecting performance across 10 departments.

●Configured and maintained dataset refresh schedules for 15 Power BI reports in Power BI Service, updating 5 gigabytes of healthcare data across 20 datasets every 4 hours, ensuring near-real-time access for 50 users.

●Implemented Snowflake data warehouse to centralize 12 terabytes of healthcare data from 10 disparate sources, enabling 30 concurrent queries with an average response time of 5 seconds, and supporting 25 Power BI reports with scalable, cloud-based analytics.

KPMG Dhaka, Bangladesh

SQL Developer Jan 2016 – Jan 2017

●Developed scripts for automating data tasks and enhanced financial workflows by building 10-15 automation scripts streamlining processes like data cleansing or calculations integrating Python with SQL for data handling.

●Knowledgeable in deploying and managing cloud-based database solutions for financial applications. Configured 5-7 AWS instances or services to support secure and scalable data storage. Monitors cloud performance for cost-efficiency.

●Proficiency in designing ETL processes to integrate and transform financial data across systems. In one year, capable of building 8-10 SSIS packages to handle data migration or daily updates. Ensures data consistency for downstream financial reporting.

●Streamlined Oracle databases to manage high-volume financial transactions and reporting executing 3-10 schema designs or performance tuning tasks for critical financial databases. Supported scalability and reliability in production environments.

●Analyzed and resolved 10-15 performance in monitoring and debugging database for financial operation, improving query execution.

●Expertise in building visualizations to present financial insights to stakeholders. Created 7-12 interactive dashboards annually, each supporting 3-5 key financial metrics. Enhanced decision-making with clear, data-driven visuals.

EDUCATION

American International University Bangladesh

Masters in Finance Sep 2014 – Apr 2016

American International University Bangladesh

Bachelors in Computer Science Jan 2009 – Apr 2014

CERTIFICATION

Data Analytics Bootcamp

Contact this candidate