Data Analyst Power Bi

Abhijeet Baviskar

************@*****.*** +1-315-***-**** in/abhijeet-baviskar New York Portfolio SUMMARY

Business Data Analyst with proven expertise in data validation, dashboard development, and stakeholder engagement across financial and IT domains. Delivered impactful insights at Freddie Mac, British Telecom, Mahindra Finance, and HDFC Bank using SQL, Python, Power BI, and Tableau. I am skilled in transforming raw data into actionable intelligence to improve fraud detection, streamline processes, and enhance reporting accuracy. Experienced in Agile environments, requirement gathering, UAT support, and cross-functional collaboration and simplifying complex data problems and driving data-informed decisions. SKILLS

Data Analysis & Data Visualization: Python, SQL (MySQL, SQL Server), Excel (Pivot Tables, VLOOKUP), Power BI, Tableau ETL / Data Handling: SSIS, Alteryx, Databricks, Spark SQL, AWS (S3, Redshift), Snowflake, Data Modeling, Data Warehouse Documentation: BRD, FRD, SOPs, RTM, User Stories, JIRA, Confluence, Microsoft Office Suite (Word, PowerPoint) Testing & QA: UAT, Test Case Design, Data Validation Project Methodologies: Agile, Scrum, JAD Sessions, Sprint Planning & Retrospectives Business Intelligence Analysis: Requirement Gathering, Stakeholder Communication, Process Mapping, Business Process Analysis, Process Improvement, Project Management, ETL, Cross-Functional Collaboration, Presentation EXPERIENCE

Business Data Analyst, Freddie Mac, USA February 2025 – Present

• Analyzed large loan datasets using SQL and Excel to uncover process bottlenecks like late-stage rejections and identified patterns that caused revenue leakage, informing management decisions to tighten the loan review process

• Designed and validated Power BI dashboards to track KPIs such as loan approval delays, fraud trends, and lender performance, reducing decision turnaround time by 25% and improving reporting accuracy by 18%.

• Partnered with finance and IT teams to gather business requirements and authored BRDs/FRDs, directly shaping the design of a cross-platform loan validation system.

• Proactively participated in daily Agile stand-ups, sprint planning, and retrospectives, identifying blockers early, refining backlog items, and ensuring technical deliverables aligned with business goals.

• Conducted in-depth data validation across Streaming Data Platform (SDP), AWS S3, and Snowflake to eliminate discrepancies and improve trust in data reporting.

• Collaborated with data engineers to integrate real-time dashboards with Databricks/Spark streaming pipelines, ensuring data was always up-to-date and accurate.

• Built Python-based models using Pandas and NumPy to detect risky borrower behavior and recurring default patterns, leading to an 18% boost in fraud detection accuracy.

• Led SWOT and gap analyses of the loan lifecycle to pinpoint inefficiencies like weak document validation, ultimately reducing processing delays by 20%.

Business Data Analyst, Hexaware Technologies, India June 2019 – December 2022

• Conducted stakeholder interviews and workshops across telecom, finance, and banking clients to gather business requirements and translate them into actionable user stories and FRDs.

• Collaborated with BI developers to build interactive Tableau and Power BI dashboards tracking key metrics (system uptime, revenue vs target, loan processing delays, technician productivity), enabling clients to monitor operations in real time.

• Queried and cleaned data from multiple sources such as MySQL, SQL Server databases and Alteryx workflows, applying custom logic to transform raw data into insights for senior leadership.

• Applied advanced analytics like Random Forest models and clustering in Python to pinpoint areas prone to IT outages and identify risky lending patterns, informing strategic investment decisions.

• Facilitated Joint Application Development (JAD) sessions and sprint demos to align client expectations with development output, resulting in higher post-launch adoption and greater stakeholder satisfaction.

• Owned the entire UAT process across multiple clients writing test cases, validating visual reports, coordinating bug fixes, and ultimately signing off on dashboards to ensure defect-free launches.

• Automated financial reporting processes using Power BI and SSIS pipelines, replacing time-consuming Excel models and saving 10+ hours of reporting work weekly across teams.

• Delivered data-backed recommendations based on gap analysis and root cause findings. For example, proposed automated document checks that cut loan processing rework by 30% in rural branches. EDUCATION

Master’s in Management Information Systems (MIS), Syracuse University, Syracuse, USA January 2023 – December 2024 Bachelor’s in Computer Engineering, Vidyalankar Institute of Technology, Mumbai, India July 2015 – May 2019 CERTIFICATIONS

Certified Scrum Master (CSM)

Google Project Management Certified

Microsoft Power BI Data Analyst Specialization

Fundamentals of Visualization with Tableau

PROJECTS

Uber Power BI Project

Bank Loan Analysis

Sales Overview

Contact this candidate