Summary
Overview
Work History
Education
Skills
Timeline
Generic

Anvesh Chamakuri

Toronto,Canada

Summary

Results-driven Power BI Developer with 4+ years of experience designing and delivering dashboards, reports, and data models to support decision-making. Skilled in Power BI (DAX, Power Query, Power BI Service) and experienced in SQL development and cloud analytics with Azure (Data Factory, Synapse, SQL Database). Hands-on with Python, ETL automation (SSIS, Power Automate), and Excel to streamline workflows. Proficient in data modeling methodologies (star schema, snowflake schema, dimensional modeling) and versed in Agile/Scrum delivery methods to ensure efficient, collaborative analytics solutions.

Technical Skills

  • Business Intelligence & Visualization: Power BI, DAX, Power Query, Power BI Service
  • Languages: SQL, Python
  • Databases: SQL Server, Azure SQL Database, Oracle, MySQL
  • ETL & Automation: Azure Data Factory, SSIS, Power Automate
  • Cloud Platforms: Microsoft Azure (Synapse, Data Factory, SQL Database)
  • Data Modeling Tools & Methodologies: ERwin, Microsoft Visio, dbt, Star Schema, Snowflake Schema, Dimensional Modeling, Kimball Methodology
  • Development Methodologies: Agile, Scrum, Waterfall (basic)
  • Other Tools: Excel, PowerShell (basic), Git

Overview

7
7
years of professional experience

Work History

Azure/Power BI Developer

Jay Analytix Inc
, Canada
08.2022 - 04.2024
  • Developed Pipelines in Data Factory to copy the files from on Premises to Data Lake, to enable the archival of processed files, to Process multiple files at the Same Time.
  • Migrated on-premises environment to Azure cloud.
  • Requirement gathering from Product Owner and design discussion with architect.
  • Created Linked Services, Datasets, Key Vault Secrets, Schedule based triggers.
  • Ingested data from different sources like SQL Server, Oracle, Rest API to Azure data lake store using Azure Data Factory and Azure Data bricks.
  • Developed Notebooks in Databricks using Pyspark to ingest the data from Data Lake to the Staging table after performing data quality checks and transformations.
  • Integrated all the notebook and stored procedure activities in the Pipeline.
  • Collaborated with stakeholders to gather requirements and providing solutions to them.
  • Created Azure Data Factory (ADF) Pipleline ETL Process to Migrate data from on Premises to Azure Cloud.
  • Developed Maintained and Managed Power BI Reports and Dashboards.
  • Created different Dashboards and charts using Power BI that were published on Power BI Server to use business stake holders for analysis and customization using filters and actions.
  • Worked on Power BI Desktop and Power BI Server to Develop and Manage Power BI Reports.
  • Experience with Developing Bar Chart, Pie Charts, Tree Map, Scatter Plot, Bubble Chart, Line Chart etc. using Power BI Desktop.
  • Configured and implemented the Azure Data Factory Triggers and scheduled the Pipelines; monitored the scheduled Azure Data Factory pipelines and configured the alerts to get notification of failure pipelines.
  • Created Pipeline’s to extract data from on premises source systems to azure cloud data lake storage; Extensively worked on copy activities and implemented the copy behaviour’s such as flatten hierarchy, preserve hierarchy and Merge hierarchy; Implemented Error Handling concept through copy activity.
  • Developed interactive dashboards using Power BI for data visualization.
  • Integrated various data sources into Power BI for comprehensive insights.
  • Optimized performance of existing reports and dashboards for efficiency.
  • Created data models to streamline data integration from multiple sources.
  • Developed interactive dashboards using Power BI for client data visualization.

Power BI Developer (Contract)

CIBC
, Canada
02.2022 - 07.2022
  • Experienced in all stages of BI project & support work (requirements and logical design, physical design, implementation, maintenance & support).
  • Expertise in data gathering, research and analytical abilities to develop insightful conclusions and generate solutions to address user needs.
  • Solid experience in database design or integration experience with SQL Server databases.
  • Develop, implement, and optimize stored procedures and functions using T-SQL.
  • Involved in Migration Reporting Databases from SQL Server to Azure DataLake and Azure SQL Database.
  • Designing databases and ensuring their stability, reliability, and performance using T-SQL.
  • Design, create, and implement database systems based on the end user's requirements using T-SQL.
  • Memory management for database systems.
  • Hand on experience in writing SSIS packages & exposure to SSRS and SSAS.
  • Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
  • Created many calculated columns and measures using DAX in Power BI based on report requirements.
  • Possess knowledge of Data Warehousing and Business Intelligence concepts, Dimensional Modeling.
  • Worked in Relational modeling constructs (model, tables, columns) and OLAP modeling constructs (cubes, dimensions, measures).
  • Performance tuning of the SQL Server.
  • Used Jira for creating Use cases and bug tracking for agile board and github for real time bug tracking and issue management.
  • Used ServiceNow for resolving incident tickets and creating change management tickets for production changes.
  • Create Power BI dashboard reports as per the business requirements from the legacy reports.
  • Creating Azure Data Factory for moving and transforming the data.
  • Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations.
  • Worked on Data visualization and Data analyzation using Power BI.
  • Back-end Experience in MS SQL Server development, writing T-SQL stored processing , views, triggers, cursors, UDFs.
  • Collaborated with stakeholders to gather reporting requirements and insights.
  • Designed custom reports to meet specific business unit requirements.

Data Analyst (Contract)

Moneris
GTA, Canada
06.2021 - 02.2022
  • Monitored performance of SQL Server, diagnosed the causes of poor queries, solved them by optimizing or tuning SQL.
  • Created new columns, new measures and conditional columns using DAX functions.
  • Developed Performance tuned SSIS codes that decreased a considerable amount of the code run time using.
  • Utilized R and Python for developing visualizations in Power BI.
  • Optimized packages by avoiding use of non-blocking transformation, executing tasks in parallel and optimizing code at source.
  • Created Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks.
  • Created new reports from Datasets using Power BI Cloud Worked with Edit Interactions.
  • Working with Microsoft R Visuals for Data Automation and Forecasts and Running R Scripts.
  • Analyzed large datasets to identify trends and patterns for business insights.
  • Maintained databases, ensuring data integrity and accuracy for reporting purposes.
  • Generated reports and obtained data to develop analytics on key performance and operational metrics.

Business Analyst

ICodex Publishing Solutions
Pune, India
10.2017 - 11.2019
  • Created Power BI Dashboards with Tiles and Pins from Reports, Insights and Workbooks.
  • Develop project strategy plans based on logical framework approaches.
  • Maintain project timeframes, objectives, and communications.
  • Create and manage documentation and reports for projects.
  • Identify the goals and requirements of each project.
  • Verify data and information and analyze it to suit the direction of a project.
  • Track, forecast and report on project progress including metrics and challenges.
  • Collect the necessary information required to start projects.
  • Collaborate with project managers and client relationship managers to develop actionable insights regarding project goals, progress, and implementation.
  • Coordinate project schedules and prepare regular progress reports.
  • Oversee data entry and analyses, choosing appropriate analysis methodologies per situation.
  • Collaborated with cross-functional teams to gather and document business requirements.
  • Prepared detailed reports on project status and presented findings to management teams.

Education

Data Analytics - OGC

St. Clair College

Bachelor’s - Business Management, Specialized in Finance

Osmania University

Skills

  • SQL
  • PL/SQL
  • Power BI
  • Business Intelligence Development Studio
  • MS SQL Server
  • Server Integration Services
  • Data Transformation Services
  • SQL Server Reporting Services
  • Azure
  • MS Office
  • SQL Developer Data Modeler
  • Logical Database Design
  • Physical Database Design
  • Data Modeling
  • Azure Data Factory
  • DAX functions
  • Data analysis
  • Database design
  • Requirement gathering
  • Virtualization
  • Power BI development
  • DAX calculations
  • Data visualization
  • Data modeling
  • Business intelligence
  • ETL processes
  • SQL database optimization

Timeline

Azure/Power BI Developer

Jay Analytix Inc
08.2022 - 04.2024

Power BI Developer (Contract)

CIBC
02.2022 - 07.2022

Data Analyst (Contract)

Moneris
06.2021 - 02.2022

Business Analyst

ICodex Publishing Solutions
10.2017 - 11.2019

Data Analytics - OGC

St. Clair College

Bachelor’s - Business Management, Specialized in Finance

Osmania University
Anvesh Chamakuri