Summary
Overview
Work History
Education
Skills
Certification
Project
Timeline
Generic

Irfana Shikalgar

Pune

Summary

Results-driven Data Analyst with a proven track record at Lean Quality Solutions Pvt Ltd, excelling in stakeholder management and data analysis. Expert in SQL and Power BI, I have successfully optimized processes and implemented data models, enhancing operational efficiency and driving data-driven decision-making.

Overview

7
7
years of professional experience
1
1
Certification

Work History

Data Analyst

Lean Quality Solutions Pvt Ltd
Pune
05.2024 - Current
  • Bridging business needs with technical solutions, specializing in requirement gathering, process optimization, and data-driven decision making.
  • Proven track record of collaborating with stakeholders (business users, IT teams) to translate requirements into actionable BI solutions (Power BI, SQL, DAX).
  • Strong expertise in analyzing business processes, identifying inefficiencies, and implementing data models/automation to improve operational efficiency.
  • Hands-on experience in documenting business requirements (BRD), functional specifications, and user stories for BI and reporting projects.
  • Skilled in facilitating workshops and meetings to align technical solutions (Power BI dashboards, data pipelines).
  • Technical proficiency in Power BI, SQL, DAX, and the ETL process, leveraged to solve business problems like data accessibility and KPI tracking.
  • We used the AIMS Grid Project management tool.

Data Analyst Intern

Lean Quality Solutions Pvt Ltd
Pune
12.2023 - 05.2024

Digital Marketing Associate

Machbizz Marketers Pvt Ltd
Pune
10.2020 - 05.2023

Senior Data Research Analyst

LPC Advisors Pvt Ltd
Pune
05.2019 - 09.2020

Data Research Analyst

XDBS Corporation
Pune
03.2018 - 03.2019

Education

Master of Computer Applications -

Sinhgad Institute of Management,Pune
04-2016

Bachleor of Computer Science -

Sinhgad College of Science,Pune
04-2014

Skills

  • Primary skills - Stakeholder Management, Data Analysis, Create BRD, Data Cleansing, Modeling, Migration, SQL Server, Power BI, Power BI Report Builder, DAX, M code
  • Database: SQL Server 2012, MS Access, Teradata, Azure Data Factory
  • E Tool - Power Query Editor
  • Reporting tools: Excel, Power BI Desktop, Power BI Report Builder
  • Analysis tool - Power Pivot
  • Programming language - SQL, T-SQL, DAX, M-Query
  • Business analysis - requirement gathering, process mapping, gap analysis, user stories, use cases
  • Documentation - BRD, FRD, user stories, process flows
  • Methodology - Agile, Waterfall, SDLC

Certification

  • Pursuing Data Analytics and Science Certification By CLODYML

Project

Domain - banking

Environment - Power BI, Excel, SQL Server 2012, SQL Server 2016, GCP, Azure

Role - Power BI developer

Roles and responsibilities

  • Involved in requirements gathering and preparing technical documents
  • Connect, import, shape, and transform data for business intelligence (BI)
  • Experience in developing visualization reports and dashboards using Power BI
  • Visualize data, author reports, and schedule automated refresh of reports
  • Implemented visual level, page level, report level filters, and pinning in dashboards
  • Written a simple DAX calculation as per the requirements to maintain a business measure
  • We create relationships between relevant tables based on common fields (e.g., customer)
  • Used quick insights to get various types of visuals to match the requirements

Timeline

Data Analyst

Lean Quality Solutions Pvt Ltd
05.2024 - Current

Data Analyst Intern

Lean Quality Solutions Pvt Ltd
12.2023 - 05.2024

Digital Marketing Associate

Machbizz Marketers Pvt Ltd
10.2020 - 05.2023

Senior Data Research Analyst

LPC Advisors Pvt Ltd
05.2019 - 09.2020

Data Research Analyst

XDBS Corporation
03.2018 - 03.2019

Master of Computer Applications -

Sinhgad Institute of Management,Pune

Bachleor of Computer Science -

Sinhgad College of Science,Pune

Similar Profiles

CREATE PROFILE
Irfana Shikalgar