Summary
Overview
Work History
Education
Skills
Timeline
Generic

Pragati Jagdale

Data Analyst/Power bi Developer
Pune

Summary

Having 6+ years of IT experience as Microsoft SQL Server developer implementing SSIS using Microsoft Business Intelligence development studio SQL Server data and Power BI. • Developed SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from SQL Server. • Strong Knowledge on Tableau and Power BI to import data from various sources such as SQL Server, Azure SQL DB, MS Excel ,High-rise etc. •

Extensive hands-on experience in Querying in DAX, Power Pivot , Power Query Editor and SQL. • Prepared dashboards using calculations, parameters in Tableau and created calculated fields, groups, sets and hierarchies etc.

Overview

6
6
years of professional experience

Work History

Data Analyst

Tessrac Innovations
09.2022 - Current
  • Used on-premise SQL Server Reporting Services and Azure Data Studio to extract,transform and manipulate data for meaningful analysis.
  • Transforming data into a new format to make it more appropriate analysis using Azure SQL and Power Bi.
  • Conduct complex analysis of business performance, interpret the result and summarize opportunities for improvement.
  • Integrated Python scripts within Power BI to perform advanced data preprocessing,statistical analysis, and predictive modeling, enhancing the depth of insights delivered to clients.
  • Engineered ETL pipelines using Python and SQL Server Integration Services (SSIS) to extract, transform, and load data from disparate sources into Power BI data models, ensuring data accuracy and freshness.
  • Stayed abreast of industry trends and emerging technologies in data analytics, continuously enhancing skills in Power BI, Python, and machine learning through self-study and professional development activities.
  • Power BI Dashboards available in Web clients and mobile apps.


Data Analyst

Rohan Builders And Developers
06.2021 - 09.2022
  • Analyze raw data ,draw conclusion & developed recommendations writing SQL Scripts to manipulate data for data loads and extracts.
  • Involved in data mining,transformation and loading from source systems to target systems.
  • Conducted data cleansing and transformation tasks using Python pandas library, improving data quality and reliability for analytics initiatives.
  • Supported the integration of external data sources into the company's data warehouse, writing SQL queries to extract, transform, and load data from cloud-based APIs and relational databases.
  • Create insightful reports to monitor and highlight contributing factors to financial and operational variances.
  • Used Power BI Gateways to keep the dashboards and reports up to date. Prepare Dashboards using calculations,parameters in tableau.
  • Created Dax Queries to generated computed columns in Power BI.

Data Analyst

Starsun Technology
07.2020 - 05.2021
  • Analyze and find the business data to identify patterns and correlations among the various data.
  • Cleaning and transforming massive data into useful specific teams and insight.
  • Write data definition language or data manipulation language SQL commands. Manipulating, Cleaning, &processing data using excel and SQL.
  • Identify relevant trends, do follow-up analysis, prepare visualizations in form of charts’, graphs, and tables.
  • Work with Tableau to create interactive dashboards and reports for teams within the organization.
  • Preparing reports based on analysis and presenting to management.

Junior Associate

Global Advertisement Services Pvt. Ltd.
02.2019 - 07.2020
  • Identifying data issues and provide recommendation for resolution to insure optimal database performance.
  • Building and maintaining SQL, INDEXES and Complex Queries for data analysis using Power Bi.
  • Generated computed tables in Power BI by using Dax.
  • Analyzing data and produce reports to assist in analysis and decision making to prioritize workload and ensure development and business requirement are met.
  • Used advanced Microsoft excel to create pivot tables and pivot reporting, as well as use VLOOKUP function.

Data Analyst

QualSquad Pvt.Ltd
11.2017 - 12.2018
  • Designing database schema, create tables to store data, and perform data manipulation. Wrote SQL Statements to extract Data from SQL server Database.
  • Developed Monthly reports and presented to Board of directors.
  • Analyzed reports for errors and craft the database solutions to fix the deficiencies and reduce the chance of errors.
  • Designing database schema, create tables to store data and perform data manipulation.
  • Prepare Dashboards using calculations,parameters in tableau.

Education

BE - Computer Science

Savitribai Phule Pune University
Pune
05.2001 -

Skills

  • SQL Server

    • undefined

    Timeline

    Data Analyst

    Tessrac Innovations
    09.2022 - Current

    Data Analyst

    Rohan Builders And Developers
    06.2021 - 09.2022

    Data Analyst

    Starsun Technology
    07.2020 - 05.2021

    Junior Associate

    Global Advertisement Services Pvt. Ltd.
    02.2019 - 07.2020

    Data Analyst

    QualSquad Pvt.Ltd
    11.2017 - 12.2018

    BE - Computer Science

    Savitribai Phule Pune University
    05.2001 -

    Similar Profiles

    CREATE PROFILE
    Pragati JagdaleData Analyst/Power bi Developer