Power Bi Sql Server

Talha Bin Abdur Raheem Fremont, California, *****

SQL/ MSBI/ Power BI Developer

Mobile: 510-***-**** Email: **************@*****.***

Experience Summary:

I develop solutions that help businesses understand their data better and work more efficiently. My aim is to make data easier to access and visualize, so companies can make smarter decisions.

Experience: Over 8 years in IT, focusing on building systems that move, clean, and organize data, plus making reports and dashboards that tell clear stories.

Technical Skills: Skilled in tools like SQL Server, Power BI, Tableau, ETL process, Dashboard developing, Azure Data Factory, Snowflake, AWS and Databricks.

Business Intelligence: I design dashboards and reports that help people see trends and measure success, using tools like Power BI, Tableau, and SSRS.

Database Design: I create smart structures for databases that store data efficiently and are easy to use.

ETL Processes: I have lots of experience building workflows that move data between different systems using tools like SSIS, Azure Data Factory, and Python.

Cloud Platforms: I know how to use modern tools like Azure Synapse Analytics and Delta Lake to process big data quickly.

Methodologies: I work well in teams and projects that use Agile, Kanban, or Waterfall approaches to get work done.

Technical Work: I write complex SQL queries and build pipelines for deploying reports and workflows smoothly.

Personal Strengths:

Great at solving problems and thinking critically.

Work well alone or with others, always communicating clearly.

Always eager to improve systems and deliver results that make a difference.

Education Details:

Master’s degree in engineering management, Trine University, Detroit, MI, USA – Graduated May 2022

Technical Skills:

Relational and Database Management Systems (RDBMS/DBMS):

MS SQL Server (2022, 2019, 2017)

Azure SQL Database

MySQL 8.0, IBM Db2 (12)

Teradata Vantage, Oracle (21c/19c)

PostgreSQL (15), MS Access.

Database Technologies & Tools:

SQL Server Management Studio (SSMS), Azure Data Studio

T-SQL, Data Transformation Services (DTS), OLTP/OLAP, BCP

SSIS, Azure Data Factory, Azure Synapse Analytics, Azure Data Lake

Snowflake, Google BigQuery, Amazon Redshift

ER/Studio, DBT (Data Build Tool), MS Visio

Reporting Tools:

Power BI, SQL Server Reporting Services (SSRS), Tableau

Looker, SAP Crystal Reports, MicroStrategy

Excel with Power Query, Power Apps, and Power

Automat

Operating Systems:

Windows 11, Windows Server 2022

Linux (Ubuntu 22.04 LTS, Red Hat Enterprise Linux 9, CentOS Stream)

macOS Ventura, ChromeOS

Programming Languages:

T-SQL, DAX, PL/SQL, Python (3.11), R

Java (17), JavaScript (ES2023), TypeScript, C#/.NET (7), C++

HTML5/CSS3, Windows PowerShell, Go

Design & Modeling Tools:

MS Visio, Erwin Data Modeler, Rational Rose

Figma, Lucidchart

Data Warehousing & Business Intelligence Tools:

SQL Server Reporting Services (SSRS) and Integration Services (SSIS)

SSAS, Azure Synapse Analytics, Snowflake

Google BigQuery, Amazon Redshift, dbt (Data Build Tool)

Visual Studio (2022/2019)

Professional Experience:

Client: Lurie Children's Hospital of Chicago, Chicago, Illinois Feb 2023– Present Role: SQL/MSBI/Power Apps Developer

Description:

Lurie Children's Hospital provides exceptional pediatric care and fostering innovation in healthcare services. As a SQL/MSBI/Power Apps Developer, I collaborated with Town & Country Pediatrics—a trusted affiliate of Lurie Children’s Hospital, renowned for offering comprehensive primary care services for children. The hospital’s commitment to delivering the highest-quality care at the right time and place resonates with its mission to ensure healthier futures for every child and family it serves. At Town & Country Pediatrics, we strive to provide the most convenient scheduling options for your family, while providing the highest-quality care in the right place at the right time.

Responsibilities and Contributions:

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources. Created drill down and drill through report to go to detail and child report within power bi based on hierarchy.

Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.

Secured the Power BI reports using Row Level Security (RLS) and DAX filters

Integrate Power App with Power BI to enable the write back feature from Power BI.

Sharing of Power BI reports and managing workspaces in Power BI service.

Implemented Power Apps Role Based Security using SharePoint Group Flow.

Automated Contract Expiration System using Microsoft Power Automate

Analysis of Business Requirements & Design Specification Document to determine the functionality of the ETL Processes.

Set up and ran Power BI Environment, creating app workspaces, publishing apps, and setting up Power BI Gateway.

Published Power BI Reports in the required originations and made Power BI Dashboards available to web clients.

Developing visual reports, dashboards and KPI scorecards using Power BI desktop

Integrate Power App with Power BI to enable the write back feature from Power BI.

Achievements:

Enhanced Reporting and Visualization: Created interactive Power BI dashboards and reports, enabling data-driven decision-making and actionable insights.

Optimized Workflow Efficiency: Streamlined business processes by automating workflows using Power Apps and Power Automate, achieving significant time savings.

Executed Scalable Data Migration: Successfully migrated large-scale data from SQL Server to Snowflake, improving system performance and accessibility.

Implemented Advanced Analytics: Leveraged Azure Databricks and Spark for predictive analytics and machine learning, driving business innovation.

Environment:

Databases: SQL Server 2019, SQL Server 2022, Sybase

Integration & ETL: SQL Server Integration Services (SSIS), SQL Server DTS

Data Analysis & Reporting: SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Power BI, MDX

Languages: T-SQL, PL/SQL

Application Development: Power Apps

Tools: SQL Server Management Studio (SSMS), Enterprise Manager, Profiler, Query Analyzer, MS Visio, Erwin, Visual Studio

Cloud Platforms: Azure.

Client: John Hancock, Boston, MA, USA Duration: Sept 2021 – Jan 2023

Role: SQL/MSBI/ Power BI Developer

Description:

John Hancock is a Boston-based financial services company with a rich history dating back to 1862. Named after the famous American patriot, the company specializes in life insurance, mutual funds, retirement planning, and other financial solutions. It operates as a subsidiary of Manulife Financial, a Canadian multinational insurance company.

John Hancock is committed to helping individuals and families achieve financial security and live healthier lives. The company emphasizes innovation, community investment, and diversity, equity, and inclusion in its operations we have remained true to the ideals on which our company was built, while also encouraging fresh insights and new ways of thinking. Whether it’s helping our clients plan for their financial future, and helping local communities grow stronger.

Responsibilities and Contributions:

Created interactive Power BI dashboards and reports using advanced visualizations like bar charts, clustered column charts, waterfall charts, and tree maps to deliver actionable insights.

Integrated Power BI reports with Power Apps, designing user-friendly workflows for financial planners and other stakeholders.

Implemented ETL processes using SSIS to extract, transform, and load data from diverse sources, ensuring reliability and scalability.

Developed and optimized SQL queries, stored procedures, triggers, views, and functions for business logic implementation.

Leveraged cloud solutions like Azure Synapse Analytics, Azure SQL Database, and Snowflake for scalable data storage and analytics.

Tools and Technologies:

Data Integration and Warehousing: SSIS, Azure Data Factory, Snowflake, BigQuery, Teradata, SAP BW/BI

Reporting and Analytics: Power BI, SSRS, SSAS, Tableau, Excel Power Query

Programming and Scripting: SQL, DAX, PL/SQL, Python, R, JSON, PowerShell

Cloud Platforms: Azure Synapse Analytics, Azure Data Lake, Azure SQL

Database Management: SQL Server (2012-2022), IBM Db2, MySQL, PostgreSQL, dbt

Workflow Automation: Power Automate, Microsoft Flow, Power Apps

Project Management: Agile Scrum using Jira

Achievements:

Reduced data processing time by 30% through query optimization and performance tuning.

Successfully delivered over 25 high-impact dashboards and reports, empowering the client with improved financial planning insights.

Implemented automated workflows using Power Apps, reducing manual effort by 40%.

Client: GameStop, Grapevine, Texas, USA Duration: Mar 2020 – Aug 2021

SQL, Power BI /MSBI Developer

Description:

GameStop offers games, entertainment products and technology through its e-commerce properties and stores.

GameStop is a global retailer offering games, entertainment products, and technology through its e-commerce properties and stores. The company focuses on delivering innovative and engaging solutions to its customers while maintaining a robust technological framework to support its operations.

Responsibilities:

Generated a variety of reports (Tabular, Matrix, Chart, Graphs, Ad-Hoc) using SQL Server Reporting Services (SSRS), extracting valuable insights for stakeholders.

Configured and scheduled pipelines in Azure Data Factory, ensuring seamless data workflows and integration.

Migrated the SSAS Model to Azure Analysis Services for enhanced compatibility with Power BI dashboards.

Facilitated data migration projects using tools like SQL, SQL Azure, Azure Storage, Azure Data Factory, SSIS, and PowerShell, ensuring data accuracy and completeness.

Achievements:

Enhanced data processing efficiency by 35% through optimization of ETL jobs and UNIX-based workflows.

Delivered over 15 custom SSRS reports, providing actionable insights into sales and operational data.

Migrated critical business intelligence solutions to Azure Cloud, improving scalability and reducing operational costs.

Streamlined reporting processes by consolidating data pipelines into Azure Data Factory, reducing manual overhead by 40%.

Successfully transitioned SSAS models to Azure Analysis Services, allowing for real-time analytics integration with Power BI dashboards.

Environment:

Databases: SQL Server 2012/2014/2016, SQL Azure

ETL Tools: DataStage (8.5), SSIS, Azure Data Factory

Reporting & Analytics: SSRS, Power BI, Azure Analysis Services, SSAS

Languages: T-SQL, PowerShell, UNIX Shell Scripting

Cloud Technologies: Azure Storage, Azure Data Factory, SQL Azure

Version Control: Team Foundation Server (TFS)

Operating Systems: UNIX/Linux

Client: Apollo, Hyderabad, India Duration: Aug 2016 – Dec 2019

Role: SQL/MSBI Developer

Description: Over the last 25 years Apollo Hospitals has become the largest integrated private hospital group in Asia with expertise in managing hospitals, clinics, health insurance, healthcare IT, Telemedicine, Education, Pharmacy retail & Medical business process outsourcing.

Responsibilities:

Gathered user requirements to develop the business logic and analyzed and designed the packages and database solutions.

Set up ETL Jobs to run on a nightly basis in the Data Marts using SQL Server Agent.

Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tune the existing packages.

Responsible for regression testing ETL jobs before testing production migration.

Used Team Foundation Server for storing and moving the developed scripts to other environments.

Developed unit test plans for SSIS packages and created technical documentation.

Wrote complex DAX functions in Power BI and Power Pivot. Used various sources to pull data into Power BI such as SQL

Client: Genpact, Hyderabad, India Duration: Sept 2015 – Aug 2016

Role: SQL Server/ MSBI Developer

Description:

Genpact is a global professional services firm delivering digital transformation by putting digital and data to work to create competitive advantage.

Responsibilities:

SQL Development:

Designed and implemented complex SQL database solutions to meet business requirements.

Developed and optimized advanced T-SQL stored procedures and queries for data retrieval and processing.

Tuned SQL queries for enhanced performance and reduced execution times.

MSBI Development:

Designed and developed dynamic SSIS packages for data integration, transformation, and migration across multiple platforms.

Leveraged SQL Server Agent to schedule and automate ETL workflows in the data mart.

Created and maintained SSRS reports to deliver actionable insights through visually appealing dashboards.

ETL Management:

Extracted, transformed, and loaded data from multiple sources, including flat files, CSV, Excel, and XML.

Utilized configuration files to ensure seamless deployment of SSIS packages across development, testing, and production environments.

Developed stored procedures using T-SQL programming to meet the business requirements.

Contact this candidate