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