Abhijit Sathe
Pune
Summary
Detail-focused Data Analyst and BI Developer with 6+ years with knowledge in data warehousing, process validation and business needs analysis. Proven to understand customer requirements and translate into actionable project plans. Dedicated and hard-working with passion for Big Data.
Experience delivering impactful insights through data modeling, dashboard development, and automation.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Data Analyst
Equifax
01.2025 - 06.2025
- Managed end-to-end data analysis tasks including writing and modifying SQL queries.
- Developed advanced DAX measures including YoY growth, running totals, rolling metrics, and dynamic parameters.
- Designed star schema data models, optimizing performance and reducing refresh time by 40%.
- Implemented dynamic row-level security (RLS) to enforce access control based on user roles.
- Partnered with cross-functional stakeholders to identify KPIs and translate business rules into analytical models.
- Generated insightful business reports using Looker and Power BI to support decision-making.
- Led Quality Control (QC) efforts by validating data accuracy and consistency in Python-generated reports.
- Handled custom reporting by modifying Python scripts as per client requirements, executing them, and delivering results to stakeholders.
Consultant
Atos-Syntel
09.2021 - 12.2024
- Designed and developed end-to-end Power BI dashboards for ServiceNow Incidents, Service Requests, and Change Requests, enabling IT leadership to track SLA compliance, backlog trends, resolution time, and priority-wise performance.
- Successfully delivered a Proof of Concept (PoC) for new business requirements, validating feasibility and gaining stakeholder approval for production implementation.
- Automated manual Excel-based reporting into Power BI dashboards, reducing manual effort and improving data accuracy, refresh efficiency, and reporting turnaround time.
- Built domain-specific KPIs such as Incident Aging, Mean Time to Resolve (MTTR), SLA Breach %, First Call Resolution, Change Success Rate, and Request Fulfillment Trends.
- Automated manual Excel-based operational reports by migrating them into Power BI, reducing manual effort and enabling near real-time insights through scheduled refreshes.
- Implemented a successful Proof of Concept (POC) for ingesting data into Power BI using REST POST APIs, validating secure authentication, payload handling, and incremental data loads.
- Optimized data ingestion using Power Query query folding techniques, significantly reducing dataset refresh duration and improving overall report performance.
- Enhanced user experience through bookmarks, hidden slicers, and conditional visuals, allowing dynamic filtering and guided analytics without cluttering the UI.
- Applied row-level security (RLS) to restrict data access based on assignment groups, support teams, or regions.
- Leveraged tooltips, drill-through pages, and custom interactions to enable deeper analysis without overwhelming the main dashboard.
- Used Power BI Service for publishing, scheduling refreshes, managing workspaces, and controlling access via appropriate permission levels.
Power BI Developer
Hexaware Technologies Pvt Ltd
09.2018 - 08.2021
- Designed and developed end to end Power BI dashboards to track resource scanning status at granular levels, PI Data Reports etc.
- Defined KPIs and wireframes for new reports.
- Collaborated with senior stakeholders for enhanced data visibility.
- Automated report generation to reduce manual work using Query Folding, RLS, Breadcrumbs, and other Power Query features.
- Delivered successful PoCs for new reporting needs.
- Developed and managed dashboards using Power BI Desktop.
- Designed PowerBI Model for reporting dashboards of ServiceNow, SAP MM, SAP PM, IT Procurement, IT Spend Analysis, SharePoint, Research and Development Chemistry lab.
- Daily Review call with the client to discuss on the requirements in pipeline and discuss on all ongoing Projects
- Weekly call with the functional leads to discuss on inputs required on specific project.
- Enhancement in dashboard in case there is change in logic or visual/report.
- Created visuals with toggle switch, Bookmarking, Drill Through, Drill Down reports, sync slicers, pie charts, waterfall chart etc
- Designing wireframe for the new projects where we consult user explaining the suitable chart for particular data or do as per users demands
- Prioritize the work by setting up the call with SLTs & ITLTs and the requirement requestor to set the timelines in case there is bottleneck with workload
- As admin at client, included in a call with business Excellence team to discuss if particular requirement can be taken up globally.
- Working with ServiceNow Business Analyst for all the functional inputs and for the new requirements related to ServiceNow.
- Worked on creating pipelines in Azure Data Factory cloud ETL tool for moving and transforming the data in case there is mismatched, or new table/Column is to be added.
- Working with Insertion, Deletion, update queries, Stored Procedures in SQL, creation of Development environment in order to test data at SQL
- Experienced in all facets of Software Development Life Cycle (Analysis, Design, Development, Testing and maintenance). Would Raise Change Request for this and work according to every stage of it.
- Gathering Requirements, creating Business Requirement Specification document explaining all the requirements and would go ahead with development once business user sign off & gives go ahead
- Creation of Technical document explaining the Data sources, required Data Modelling, Relationships, Measures & Calculated columns. If required created functional document explaining technical logics into functional words for Functional & End users to understand the logics applied.
- Involved in Performance Planning of the dashboards for better tuning i.e. Refresh time, monitoring each dashboard refreshes, its dataset size
- Setting up the gateway, scheduled refresh, providing access of specific reports to Business users
- Helping & Working with other Power BI developers of client.
- Managing the Projects dashboard including ITDPM, MSP & Minor Projects.
Education
Bachelor in Enggineering - Electrical, Electronics And Communications Engineering
Ashokrao Mane Group Of Institutions
Kolhapur, India03-2015
Skills
- Power BI, Query Folding, RLS, Performance Tuning
- SQL
- Python
- Azure Data Factory
- Defect tracking
- Data filtering
- Gap analysis
- Visual data representation
Certification
- SnowPro Core Certification
- Data Science Pro Degree – Imarticus Learning, Pune
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Accomplishments
- Improved relationship with client by developing a unique business intelligence solution to meet complex requirements.
Timeline
Data Analyst
Equifax
01.2025 - 06.2025
Consultant
Atos-Syntel
09.2021 - 12.2024
Power BI Developer
Hexaware Technologies Pvt Ltd
09.2018 - 08.2021
Bachelor in Enggineering - Electrical, Electronics And Communications Engineering
Ashokrao Mane Group Of Institutions