Power Bi Data Analyst

Prathima Chekuri ****************@*****.*** 515-***-****

https://www.linkedin.com/in/prathima-ch-08418b36a/

Summary

•Extensive IT experience as a Business Intelligence (BI) Analyst/Data Analyst specializing in building and optimizing enterprise data pipelines and ETL workflows using SQL, SSIS, Azure Data Factory, and Python. I am skilled in developing scalable data integration solutions and supporting analytics platforms with Power BI.

•Proficient in building ETL pipelines using SSIS and Azure Data Factory to extract, transform, and load large volumes of structured and semi-structured data from diverse sources including Oracle, SQL Server, and cloud environments.

•Developed and deployed Power BI dashboards and reports using DAX and Power Query to provide actionable business intelligence insights across domains such Banking and Finance.

•Executed complex SQL queries, stored procedures, and performance optimization on large-scale data systems for data validation, transformation, and back-end testing.

•Migrated data and analytics solutions from on-premises to Azure SQL, enabling cloud scalability and seamless data integration with existing systems.

•Leveraged Python (Pandas, NumPy, Matplotlib) for data wrangling, automating data validation workflows, and generating reports to streamline data processing pipelines.

Collaborated with cross-functional teams using Agile/Scrum methodologies to deliver data warehouse solutions, BI reports, and analytics products aligned with business KPIs.

•Designed dimensional data models (Star/Snowflake schemas), implemented OLAP cubes, and enabled self- service analytics through governed Power BI datasets.

•Conducted data cleansing, and validation using SQL, ensuring high-quality data delivery for downstream analytics and regulatory compliance.

•Created impactful data visualizations and KPIs using Power BI and Python visualization libraries (Matplotlib, Plotly) to support strategic decisions for stakeholders.

Technical Skills:

●Data Science Tools: Python (Pandas, NumPy), Jupiter Notebook.

●Data Visualization: Matplotlib, Seaborn, Excel, PowerBI.

●Database Languages: SQL

●Cloud Services: Azure Data Factory, Snowflake

●Programming & Scripting: Python, HTML.

●Office & Documentation Tools: MS Office Suite (Excel, Word, PowerPoint, Project, Visio), Get Pivot, VLOOKUP in Excel.

●Version Tools: GitHub, Tortoise SVN

Certification:

Microsoft Certified: Azure Data Fundamentals (DP-900,Certification number: 8CFAT5-40E8F0

Professional Experience:

Pimco, New York Dec 2024 - Present

Senior BI/Data Analyst

Improved portfolio risk reporting by integrating multi-source financial data into unified ETL pipelines, ensuring regulatory compliance and enabling faster, data-driven investment decisions.

•Performed data profiling and preprocessing using Python (Pandas, NumPy), identifying data quality issues and preparing structured/semi-structured data for ETL pipelines.

•Developed and optimized end-to-end ETL pipelines using SSIS and Azure Data Factory to ingest, cleanse, and transform data from multiple sources including SQL Server, flat files, and cloud APIs.

•Automated data validation and transformation tasks using Python scripts, improving pipeline reliability and reducing manual effort.

•Designed and implemented complex T-SQL queries, stored procedures, and views to support downstream analytics and reporting requirements.

•Participated in data migration projects, moving data from on-prem SQL Server to Azure SQL Database

and Azure Synapse Analytics, ensuring schema alignment and data consistency.

•Built and scheduled Power BI reports with parameterization and role-level security, enabling self-service analytics and operational dashboards.

•Conducted data quality checks, regression testing, and user acceptance testing (UAT) for both ETL outputs and BI dashboards to ensure accuracy and performance.

•Collaborated with BI developers and analysts to create dimensional models (star and snowflake schema) with well-defined fact and dimension tables.

•Developed reusable and modular SSIS packages, implementing logging, error handling, and performance tuning best practices for production deployment.

•Leveraged DAX and Power Query in Power BI to build interactive dashboards that support decision- making and real-time performance tracking.

Tools & Technologies: SQL, Azure Data Factory, Python, Power BI, SSIS, T-SQL, Azure Synapse Analytics, Azure SQL Database

TD Bank, Cherry Hill NJ Jul 2022 - Nov 2024

Senior BI/Data Analyst

Delivered timely market performance metrics by automating data ingestion and analytics workflows, reducing reporting delays and enabling compliance teams to respond to regulatory changes more efficiently.

•Developed and optimized complex SQL queries to extract, transform, and analyze large datasets from enterprise data warehouses for reporting and analytics.

•Pythontained Power BI dashboards and visual reports using advanced DAX calculations and Power Query, enabling stakeholders to monitor KPIs and trends in real time.

Designed and implemented ETL workflows using SSIS and Azure Data Factory to automate data ingestion, cleansing, and transformation across multiple data sources.

Applied Python (Pandas, NumPy, Matplotlib) for statistical data analysis, automation of data validation processes, and generating visual insights from raw datasets.

•Created and maintained dimensional data models (Star/Snowflake schemas) to support scalable analytics and business intelligence applications.

•Conducted data validation, root cause analysis, and quality assurance testing to ensure accuracy and integrity in data-driven reporting systems.

Migrated and integrated datasets from legacy systems into Azure SQL Database and Azure Synapse Analytics, improving performance, accessibility, and scalability.

•Automated repetitive data processing tasks and report generation using Python scripts, significantly reducing manual effort and improving turnaround times.

•Participated in the documentation of data architecture, ETL workflows, and system integrations using tools like Microsoft Visio and Excel.

•Collaborated with cross-functional technical teams to streamline data pipelines, optimize query performance, and ensure alignment with BI development best practices.

Tools & Technologies: SQL, Power BI, DAX, Python, SSIS, Azure Data Factory, Azure SQL Database.

M&T BANK Buffalo NYC Oct 2020 - Jun 2022

Senior BI/Data Analyst

Streamlined operational and regulatory reporting processes by optimizing data preparation and ensuring high data accuracy, enabling business and compliance teams to act on insights with greater confidence.

•Developed and deployed interactive dashboards and ad-hoc reports using Power BI integrating data from SQL databases, flat files, and APIs to meet dynamic business needs.

•Designed and maintained relational database schemas, tables, views, indexes, and stored procedures using

T-SQL and PL/SQL, improving data structure efficiency and accessibility.

•Created and optimized complex SQL queries to extract actionable insights from large datasets, supporting data analysis and reporting activities across departments.

•Built and scheduled SSIS packages for data extraction, transformation, and loading (ETL) from various sources into centralized data warehouses.

Implemented SQL Server Agent jobs and alerts to automate routine maintenance tasks and monitor ETL workflows and databases

•Developed Power BI reports backed by Azure SQL Databases, implementing row-level security, custom connectors, and DAX measures for controlled access and advanced analytics.

•Performed query tuning and database optimization to improve performance and resolve execution bottlenecks in SQL Server environments.

Designed and maintained SSRS reports for operational and executive reporting, ensuring consistency and scalability across report layers.

•Utilized Power Automate to automate report refreshes, email distribution, and notification workflows, integrating with Power BI for enhanced efficiency.

•Collaborated in version-controlled development using Git, contributing to centralized repository maintenance and ensuring seamless team collaboration and rollback capabilities.

Tools & Technologies: Power BI, Tableau, SQL Server, T-SQL, PL/SQL, SSIS, SSRS, Power Automate, Git

American Express New York Jul 2018 - Sep 2020

Senior BI/Data Analyst

Modernized global reporting infrastructure by migrating on-premise data pipelines to scalable cloud environments, improving report turnaround time and enhancing accessibility for finance teams across regions.

•Designed and developed end-to-end data pipelines using Azure Data Factory and Python, covering data ingestion, transformation, validation, and publishing to support scalable reporting systems.

•Created and optimized SQL queries for advanced data extraction, transformation, and analysis, significantly improving query execution times and reporting accuracy.

•Engineered automated ETL workflows using SSIS and integrated with cloud services, improving data reliability and reducing manual intervention.

•Built interactive dashboards and automated reports in Power BI, using DAX, custom connectors, and row- level security to support dynamic data exploration across user roles.

•Conducted data quality assessments and implemented validation rules using Python, improving data consistency across structured and semi-structured sources.

•Migrated large-scale datasets from on-prem SQL Server to Azure Synapse and Snowflake, implementing

SQL scripts and Python-based orchestration for seamless transition.

Integrated API and streaming data (JSON) into relational and cloud systems, applying Python flattening logic and transformation scripts to ensure schema conformity.

•Utilized Power Automate and Azure-native tools to create event-driven workflows for data refresh, alerting, and business rule automation in Power BI ecosystems.

•Configured cloud-based data monitoring solutions using Azure Monitor and SQL Server Agent, enabling proactive alerts and improved system performance oversight.

•Collaborated with cross-functional teams in Agile environments, using version control tools like Git to manage analytics development and deploy BI solutions reliably.

Tools & Technologies: Python, Power BI, DAX, Power Query, SSIS, Azure Data Factory, T-SQL, Azure SQL Database

Deutsche Bank, New York Feb 2016 - Jun 2018

Data Analyst

Ensured enterprise-wide data accuracy and compliance by optimizing SQL-based reporting processes, enhancing query performance, and maintaining audit readiness for financial and regulatory reporting.

Responsibilities:

●Developed SQL queries to retrieve, filter, and manipulate data from relational databases.

●Created and optimized stored procedures, views, and functions to support reporting needs.

●Performed data validation and testing to maintain accuracy and consistency in reports and dashboards.

●Debugged and optimized SQL queries to improve performance.

●Utilized SSMS for database exploration, query execution, and schema analysis.

●Assisted in ETL workflows for data loading and transformation.

Tools & Technologies : SQL, SSMS, ETL

Education

Master of Technology (M. Tech) – Computer Science & Engineering

Sagi Rama Krishnam Raju Engineering College, Andhra University – 2011

Contact this candidate