Summary
Overview
Work History
Education
Skills
Certification
Projects
Timeline
Generic
Ashitha S

Ashitha S

Toronto,Canada

Summary

  • Results-driven MSBI/Power BI Developer with a proven track record at Siemens, adept at transforming complex data into actionable insights.
  • Expert in Power BI and DAX, I enhanced reporting efficiency by automating processes and led successful migrations to Azure, showcasing strong leadership and collaboration skills.

Overview

5
5
years of professional experience
1
1
Certification

Work History

MSBI/Power BI Developer

Siemens
Toronto, Canada
08.2023 - Current
  • Collaborated with stakeholders to translate business requirements into interactive Power BI dashboards and reports.
  • Implemented Power BI data models, ensuring efficient DAX queries and relationships for precise insights.
  • Managed Power BI environments, including setting up data gateways and user access.
  • Automated data refreshes, reducing manual reporting effort by 20%.
  • Utilized Azure Synapse Analytics and Azure Data Lake for advanced data analysis and reporting, enhancing data accessibility.
  • Led the migration of on-premise SQL Server databases to Azure SQL Database, increasing system scalability by 40%.
  • Provided training to 10+ users on Power BI functionalities, improving user adoption across departments.

BI Developer

Fidelity Investments
Toronto, Canada
02.2023 - 08.2023
  • Developed and deployed SSRS and Power BI reports tailored to business needs, reducing report generation time by 25%.
  • Created matrix, tabular, and drill-down reports in Power BI, improving data visualization for key stakeholders.
  • Developed SSIS packages to integrate data from various sources, improving ETL process efficiency by 30%.
  • Configured data models in Power BI and created advanced DAX formulas for custom calculations.
  • Optimized query performance, reducing report processing time by 15%.

SQL BI Developer

EduRun Group
India, India
07.2020 - 12.2022
  • Created and optimized complex T-SQL queries and ETL packages using SSIS for data integration between SQL Server and Oracle databases.
  • Designed and implemented star and snowflake schemas for reporting purposes, improving data accuracy by 20%.
  • Collaborated with business analysts to define database architecture and ensured scalability.
  • Led a team of 3 developers to implement data models and reporting solutions, improving team efficiency.
  • Documented all data processes and workflows for future reference, reducing onboarding time for new developers by 25%.

Education

Bachelor of Technology - Information Technology

Sreenidhi Institute of Science and Technology
Hyderabad, India
01.2020

Skills

  • Power BI
  • SQL Server Reporting Services (SSRS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • MS SQL Server
  • MySQL
  • Oracle 11g
  • MS Access
  • Azure Data Factory
  • Tableau
  • Crystal Reports
  • T-SQL
  • DAX
  • MDX
  • Python
  • M Language
  • Azure Data Lake
  • Azure Synapse Analytics
  • AWS Redshift
  • Star Schema
  • Snowflake Schema
  • Erwin Tool
  • Windows Server
  • Windows 10
  • Linux
  • Agile
  • Scrum
  • DevOps
  • CI/CD
  • Git
  • Azure DevOps

Certification

  • Microsoft Certified: Data Analyst Associate (Power BI)
  • Azure Fundamentals (AZ-900)
  • SQL Server 2016 Database Development Certification

Projects

  • Azure Data Migration Project, Migrated an on-premise SQL Server database to Azure SQL Database with zero downtime, improving system scalability by 40% and reducing operational costs by 15%.
  • Power BI Dashboard for Financial Reporting, Developed a comprehensive Power BI dashboard for financial reporting, enabling real-time insights and reducing report generation time by 30%.
  • The dashboard was adopted by senior management, resulting in improved decision-making processes.

Timeline

MSBI/Power BI Developer

Siemens
08.2023 - Current

BI Developer

Fidelity Investments
02.2023 - 08.2023

SQL BI Developer

EduRun Group
07.2020 - 12.2022

Bachelor of Technology - Information Technology

Sreenidhi Institute of Science and Technology

Similar Profiles

CREATE PROFILE
Ashitha S