Power Bi Data Analyst

Avinash Kumar

Data Analyst Data Specialist

+91-870******* ************@*****.*** https://www.linkedin.com/in/avinash-kumar-983a16151/ Pune, India Skills

• Data Analytics: Identified trends and insights for strategic decision-making; created dashboards and visualizations with Power BI.

• Database Administration: Managed SQL Server, Oracle, and MySQL databases; ensured security, performance, and recovery.

• Data Modelling: Designed OLTP and OLAP data models; applied normalization techniques.

• Data Warehouse: Implemented ETL processes; developed BI solutions.

• Power BI Report Builder (SSRS): Developed reports and dashboards; integrated various data sources.

• DAX Queries: Wrote and optimized complex DAX queries. Certifications

• SQL Advance, HackerRank (Credential)

• PwC Switzerland - Power BI Job Simulation (Credential) Work Experience

IDS OMNI SOLUTIONS Pune, India

Data Analyst Sep 2023 – Present

Key Responsibilities:

• Developed and maintained interactive Power BI dashboards to visualize monthly, quarterly, and yearly financial performance, enabling timely decision-making for key stakeholders.

• Created Power BI reports, scorecards, and KPIs to measure business performance.

• Configured databases and queries for optimal performance in the BI environment.

• Conducted data analysis to identify trends and insights from large datasets.

• Optimized SQL queries for improved performance with large datasets.

• Ensured data quality and governance by performing regular audits and validation checks on financial data extracted from multiple systems.

• Implemented technical support for users experiencing issues with the Bl platform.

• Created complex SQL and DAX queries for data management. Technologies Used: Power BI, MySQL, Advance Excel, eVestment, Citrix Cloud IDS OMNI SOLUTIONS Pune, India

Data Specialist Sep 2021 – Sep 2023

• Collected, cleaned, and structured raw data from multiple sources to ensure data accuracy, completeness, and consistency.

• Developed and maintained standard operating procedures (SOPs) for data entry, validation, and quality checks.

• Worked closely with analysts and business teams to understand data needs and deliver accurate datasets for reporting and analysis.

Achievements & Awards

• Received client appreciation for delivering high-quality work on the Holdings project and for creating impactful KPI reports that supported business insights and decision-making.

• Analysed historical financial trends to identify operational inefficiencies, resulting in actionable insights and cost- saving opportunities exceeding $8 million annually.

• Individual QUATERLY SPOT AWARD (Quick restoring data of 10000 users post a major failure of data server) – Year 2024.

Education

Magadh University Patna, Bihar

Bachelor’s of Science 2017-2020

Languages

English Advanced

Hindi Native

Contact this candidate