Power Bi Business Intelligence
Resume:
Sana Tabassum
Power BI Developer
***************@*****.***
PROFESSIONAL SUMMARY:
•Power BI Developer with over 5 years of experience in business intelligence(BI), data analysis, SQL Tableau, Business Objects, SSRS specializing in transforming complex datasets into interactive dashboards and actionable insights that support executive decision-making and drive business performance.
•Proven expertise in Power BI Desktop, Power BI Service, DAX, Power Query (M Language), and Power BI Report Builder, with a strong ability to create insightful reports from complex datasets.
•Proficient in SQL (T-SQL/PL-SQL) for writing complex queries, stored procedures, views, and performance-tuned database operations across SQL Server, Azure SQL, and Oracle platforms.
•Strong foundation in Business Intelligence and Data Warehousing concepts, including ETL processes, data modeling (star/snowflake schemas), and report automation using SSIS, SSRS, and Azure Data Factory.
•Good Experience with deploying SSRS reports in Report Server and managing user access on report Manager.
Managing tableau project folder, Groups and content as Tableau Site Administrator.
Experience in creating solution driven dashboards by developing different chart types including Crosstabs, Heat/Geo/Tree Maps, Pie/Bar Charts, Circle Views, Line/Area Charts, Scatter Plots, Bullet Graphs, and Histograms in Tableau Desktop.
Worked on different versions of Business Objects 4.1/4.0/XI 3.1/XIR2 (CMS, Info View, Launch Pad 4.0/4.1, Designer, IDT 4.0, Desktop Intelligence, Web Intelligence, Import Wizard, Xcelsius and Dashboard Design.
•Experience in report writing using SQL Server reporting Services (SSRS) and creating several types of reports like Dynamic, Linked, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Document Map and Sub-Reports.
•Experience in gathering business requirements, translating them into technical specifications, and building KPIs, scorecards, and metrics-driven dashboards tailored to stakeholder needs.
•Adept at data transformation and cleansing using Power Query, and integrating data from multiple sources such as Excel, SharePoint, SQL Server, Azure, and APIs.
•Hands-on experience implementing row-level security (RLS), workspace management, and scheduled data refreshes in Power BI Service for secure and scalable reporting solutions.
•Skilled in DAX to perform time intelligence, advanced calculations, and performance optimization in large datasets.
•Experienced in working within Agile/Scrum teams, collaborating with business analysts, data engineers, and stakeholders to deliver analytics solutions on time.
•Proficient in ETL processes using SQL, Power Query, and Azure Data Factory, ensuring clean, structured, and analysis-ready data pipelines.
•Sound knowledge and experience in Excel, PL/SQL, ETL, and Tableau platform.
•Good understanding of Normalization/De-normalization, Normal Form, and database design methodology.
•Experienced in creating interactive dashboards and scorecards utilizing Power BI.
•Hands on experience in MS Power BI desktop and Power BI service.
•Hands on Experience in Data Migration from MS SQL Server to Oracle ERP Systems.
•Strong analytical, problem-solving, and stakeholder management skills.
EDUCATION DETAILS:
Master of Science in Computer Science
Illinois State University - Normal, IL
TECHNICAL SKILLS:
BI & Reporting Tools: Power BI (Desktop, Service, Gateway), SSRS, Tableau 2022.3, Qlik, Power Apps Crystal Reports, Power Query, Power Automate Report Builder, Information Design Tool, Info View, Launch pad, Import Wizard, Promotion Management, Web Intelligence, etc.
ETL & Data Integration: SSIS, Azure Data Factory, Talend, Informatica, TIBCO, BCP, DTS
Databases: MS SQL Server, Oracle, Snowflake, Redshift, DB2, Netezza, Teradata
Cloud Platforms: Microsoft Azure (ADF, Synapse, Data Lake), AWS
Languages & Scripting: T-SQL, DAX, PL/SQL, Python, Shell Scripts, XML, HTML, JavaScript, C#
Power Platform: Power BI, Power Apps, Power Automate
Tools & Dev Environments: Visual Studio, SSMS, SQL Profiler, Tabular Editor, TFS, Git
Data Modeling & Methodologies: Star/Snowflake Schema, Dimensional Modeling, Agile, Scrum, SDLC
CI/CD & Deployment: Azure DevOps, Power BI Deployment Pipelines, Git, GitHub, Version Control SQL Server Agent Jobs
PROFESSIONAL EXPERIENCE:
Cigna Healthcare Nashville, TN
Power BI developer
June 2024 – Present
Responsibilities:
•Designed, configured, and maintained SQL Server databases, ensuring optimal structure, data integrity, and performance for both operational and reporting workloads.
•Developed custom SQL Server Agent jobs for automated data movement, scheduling, and validation across multiple production environments.
•Conducted regular SQL Server health checks and performance tuning to resolve bottlenecks and improve system stability and efficiency.
•Diagnosed and resolved SQL job failures, minimizing downtime for mission-critical systems.
•Created and monitored incremental, idempotent ETL processes using SQL, improving integration of data from disparate operational systems.
•Optimized SQL queries and indexing strategies, improving report performance by 50% and reducing refresh time from 10 minutes to under 5 minutes.
•Designed and developed 25+ Power BI dashboards to visualize business and operational KPIs, Reducing manual reporting by 40% and improving decision-making speed.
•Built optimized Power BI data models, establishing relationships, and applying DAX measures for complex business logic.
•Documented and maintained a comprehensive inventory of SQL jobs, detailing configurations, schedules, and run history.
•Created executive dashboards tracking Revenue Cycle KPIs, Patient Discharge Summaries, and Claim Denials for hospital leadership.
•Integrated Power BI with Azure SQL, Snowflake, and other cloud sources for real-time data access and scheduled refreshes.
•Built and deployed SSIS packages to extract data from OLTP systems, transform it, and load it into the data warehouse with dynamic configuration.
•Configured Row-Level Security (RLS) in Power BI to enforce role-based access control and compliance with data privacy standards.
•Published and shared Power BI reports via Power BI Service, enabling secure collaboration and report access across departments.
•Automated dataset and report refresh schedules in Power BI, ensuring data currency with minimal manual effort.
•Worked closely with business users to gather requirements and deliver custom Power BI visuals that met specific analytical needs.
•Performed Power BI report tuning by optimizing DAX, simplifying visuals, and implementing composite models to improve performance.
•Developed end-to-end KPI tracking solutions using Power BI and SQL, driving better data-informed decision-making.
•Centralized all SQL job scripts in a Git repository for version control and improved collaboration.
•Validated and reconciled data warehouse contents with enterprise systems to ensure data quality and consistency.
Environment: Power BI (Desktop, Service, Gateway), SQL Server, T-SQL, SSIS, SSRS, Azure SQL Database, Snowflake, DAX, Power Query (M), Git, Azure Data Factory, Visual Studio, SQL Server Agent, OLTP Systems, Data Warehouse, Windows Server
HCA Healthcare Terre Haute, IN
Business Intelligence Analyst
Aug 2023 – May 2024
Responsibilities:
Designed and delivered Power BI dashboards to track patient outcomes, hospital performance, and financial KPIs for healthcare administrators and clinical teams.
Analyzed complex clinical, operational, and financial datasets to provide actionable insights that improved care quality, resource utilization, and cost management.
Developed and integrated Power Platform solutions (Power BI, Power Apps, and Power Automate) to streamline reporting workflows and automate manual business processes, reducing turnaround time by 30%.
Integrated data from SQL Server, Amazon Redshift, Excel, SharePoint, and Snowflake into Power BI for real-time and ad-hoc reporting needs.
Developed ETL pipelines using Azure Data Factory and SSIS to extract, clean, and load healthcare data from multiple systems into Snowflake and SQL-based data warehouses.
Worked with big data (1.3 billion records) and implemented incremental refresh for improved performance.
Automated data extraction and reporting using Power Automate and Power Apps.
Created paginated reports and used SFTP automation to export reports to client servers.
Created healthcare-specific dashboards such as Daily Admissions, Bed Utilization, Patient Discharge Summaries, Claims Reports, and Revenue Cycle KPIs.
Applied DAX and Power Query to build complex measures, calculated columns, and data transformations for healthcare-specific analytics.
Implemented row-level security (RLS) in Power BI to ensure HIPAA-compliant access control across roles and departments.
Automated dataset refreshes and report distribution using Power BI Gateway and Power BI Service, improving data availability and reducing manual overhead.
Collaborated with physicians, administrators, and IT teams to gather requirements and translate clinical needs into meaningful visual reports.
Led redesign of 20+ healthcare dashboards, improving load times and usability with enhanced data modeling, KPI visuals, and performance tuning.
Utilized Tabular Editor and SSAS Tabular Models to implement Time Intelligence for trend analysis across months and quarters.
Participated in Agile development cycles, including Sprint Planning, Daily Stand-ups, and Retrospectives, ensuring timely delivery of analytics solutions.
Environment: Power BI Desktop, Power BI Service, Power BI Gateway, Power Apps, Power Automate, Azure Data Factory (ADF), SSIS, SQL Server, Snowflake, Amazon Redshift, SharePoint, Excel, DAX, Power Query, Tabular Editor, SSAS Tabular, SFTP, Agile/Scrum
SQL Developer
Goldman Sachs India – (Remote)
Sep 2019 – May 2022
Responsibilities:
Translated high-level design specifications into scalable ETL mappings using Informatica Power Center, including Source-to-Target Mapping (STM) and business logic implementation.
Designed and maintained data warehouse models supporting real-time data integration from multiple sources.
Developed complex ETL workflows with tasks such as sessions, decision, command, event wait/raise, email, and scheduling.
Implemented SCD Type 1 and Type 2 mappings to manage historical data in dimension tables.
Created, configured, and debugged Informatica mappings, sessions, and workflows to extract, transform, and load data efficiently into target systems.
Utilized SQL Loader and T-SQL/PL-SQL scripts to load and validate data across Oracle, SQL Server, and AWS Redshift.
Experienced in Teradata scripting using Fast Load, Multiload, and BTEQ for batch data integration and key generation.
Built and modified stored procedures, complex joins, and views to support SSRS reports, including drill-through and ad-hoc reporting.
Conducted SQL Server performance tuning using SQL Profiler, optimizing database code and stored procedures.
Created batch scripts and UNIX shell scripts for FTP transfers, backups, and job automation using PMCMD commands.
Developed and tested data migration processes, including data transformation, validation, and reconciliation across environments.
Engaged in full SDLC, including requirement analysis, development, testing, deployment, and documentation.
Performed ETL performance tuning at the source, target, mapping, and session levels for improved efficiency.
Environment: Workflow Manager, Workflow Monitor, PL/SQL, Oracle 11g/10g, Erwin, Teradata, Autosys, Netezza, SQL Server 2019, UNIX AIX, Toad 9.0
Contact this candidate