OMKAR GUPTA

Results-driven Data Analyst
301707, Tapukara, IN.

About

Results-driven Data Analyst with 3+ years of experience, specializing in transforming complex data into actionable insights and optimizing reporting processes. Proficient in Power BI, SQL, and advanced data visualization, I excel at developing robust BI solutions that enhance decision-making and drive significant improvements in reporting efficiency and data accuracy.

Work

Infosys Limited
|

Systems Engineer

Gurugram, Haryana, India

Summary

Led end-to-end business intelligence initiatives, from data extraction and transformation to dashboard deployment and user training, significantly enhancing reporting efficiency and data accuracy.

Highlights

Designed and deployed over 10 Power BI dashboards, accelerating reporting speed by 40% and providing critical business insights.

Optimized complex SQL queries, enhancing data retrieval efficiency by 50% and improving database performance.

Implemented a robust data validation framework, increasing data accuracy by 30% and ensuring reliable reporting.

Integrated and transformed diverse datasets from multiple sources, enabling comprehensive analytical capabilities.

Developed and delivered comprehensive training programs and documentation to facilitate Power BI adoption across user teams.

Revature
|

Power BI Trainee

Remote, US

Summary

Completed intensive training in Business Intelligence, gaining foundational expertise in Power BI, SQL, and data modeling to prepare for real-world data analysis challenges.

Highlights

Completed intensive 4-month training program focused on Power BI, SQL, and advanced data modeling principles.

Developed and presented multiple dashboards and reports using diverse mock datasets, demonstrating proficiency in BI use cases.

Applied Power Query and DAX extensively for efficient data transformation and complex analytical calculations.

Gained practical expertise in designing intuitive KPIs and effective data visualization techniques for actionable insights.

Certificates

Others

Issued By

Infosys

Advanced SQL Programming Certification

Issued By

Infosys

Data Science Machine Learning Fundamentals

Issued By

Infosys

Microsoft Certified: Power BI Data Analyst

Issued By

Microsoft

Education

Institute of Engineering and Technology
Alwar, Rajasthan, India

B.Tech

Computer Science and Engineering

Grade: 7

Courses

Computer science

Skills

Programming Languages

SQL, DAX.

BI & Data Tools

Power BI, Power Query, MySQL, SSRS, SSIS, SSAS, Azure, ETL Processes, Microsoft Office Suite.

Data Management & Analysis

Data Modelling, Dashboarding, Reporting Automation, KPI Design, Data Visualization, Data Transformation, Data Validation.