Data Analyst Power Bi

ABHISHEK HIRE

+1-313-***-**** ************.***@*****.*** https://www.linkedin.com/in/abhishek-hire

Professional Summary

Data Analyst with 4 years of experience in data analysis, business analytics, and workflow automation across supply chain, healthcare, energy, and IT. Skilled in PL/SQL, Oracle (10g+), SAP (ERP), SQL Server, and Power BI, with expertise in writing complex queries, stored procedures, and ensuring high data quality. Strong track record of partnering with business stakeholders to design solutions, streamline onboarding processes, and deliver actionable insights. Adept in Agile/Scrum environments with excellent communication skills for both technical and executive audiences.

Experience

Data Analyst BASF, USA Aug 2024 – Present

Wrote and optimized complex PL/SQL queries in Oracle Exadata and SAP datasets to support procurement and supplier analysis.

Conducted end-to-end analysis of historical purchasing patterns, delivering insights that resulted in a 9% cost savings in raw material bidding events.

Collected and analyzed procurement data (MOQ, RFQ, lead times, packaging specs), ensuring accurate and complete supplier onboarding.

Designed Power BI dashboards to track supplier portfolio and raw material visibility, enabling faster sourcing decisions.

Automated approval workflows using Power Apps + Excel + Word, reducing manual effort and improving compliance documentation.

Data Analyst Ecojiva LLC, USA Feb 2024 – Jul 2024

Created PL/SQL queries to extract and validate solar energy data, improving accuracy of performance monitoring.

Developed Power BI dashboards to analyze energy generation and consumption, providing executives with KPI tracking.

Automated reporting workflows with Excel VBA & Power Apps, reducing manual effort by 30%.

Data Analyst NorthStar Care, USA May 2023 – Jul 2023

Consolidated duplicate patient IDs through SQL queries, improving accuracy of patient records for onboarding and re-admission tracking.

Identified critical KPIs (PPS scale, shortness of breath, weight loss) and built a predictive model (Hist-GB) achieving 86% accuracy in classifying hospice care readiness.

Enhanced baseline reporting processes and presented results to both clinicians (technical detail) and executives (business summary).

Data Analyst Cisco Systems, India Nov 2021 – Jul 2022

Wrote and optimized SQL/PL-SQL scripts for processing logs from 200+ network devices, improving anomaly detection and performance monitoring.

Leveraged SolarWinds and SQL queries to maintain accurate Layer 2/3 topology data.

Automated extraction of log files using Python, reducing processing time and manual effort.

Jr. Data Analyst Manasavi Tech Solutions, India Nov 2020 – Nov 2021

Designed and developed 50+ Power BI dashboards delivering actionable business insights.

Implemented data management strategies across 5+ client projects, ensuring accuracy and quality of large-scale datasets.

Supported Agile teams by contributing to sprint planning, backlog refinement, and testing deliverables.

Technical Skills

Databases & Querying: PL/SQL, Oracle (10g+ / Exadata), MS SQL Server, SSRS, Data Warehousing

Programming: Python, R, C++, VBA

Visualization & Reporting: Power BI, Tableau, DAX

Cloud Platforms: Microsoft Azure, AWS

Tools & Platforms: SAP (ERP), Jira, Power Apps, Excel (Advanced), Microsoft Access, Visio, SharePoint

Methodologies: Agile/Scrum, Lean Six Sigma (White Belt), Data Analytics, A/B Testing

Certifications

Microsoft Azure Associate Data Engineer

CCNA (Cisco Certified Network Associate)

Lean Six Sigma White Belt

Education

Master’s in Data Science & Business Analytics – Wayne State University, Detroit, MI (Aug 2022 – Dec 2023)

Bachelor’s in Computer Engineering – Pune University, India (Jun 2015 – Jul 2020)

Contact this candidate