Looking for a job

Prashant User

@prashantuser10

Message

Data Analyst at Infosys who automated ETL reporting, improving data accuracy from 65% to 95% across 15+ dashboards.

India

Message

At Infosys Limited, I architect automated ETL pipelines with Python and MS SQL Server, reducing manual reporting workflows by 40% and raising data accuracy from 65% to 95% across 15+ enterprise dashboards. I also transformed Power BI reporting with Star Schema models and DAX, reducing refresh times by 25%.

On my E-Commerce Profitability Intelligence System project, I used a Power BI dashboard and statistical analysis to uncover a discount strategy behind $64K in annual losses. My analysis informed budget recommendations that protected more than $64K in annual revenue.

Experience

Work history, roles, and key accomplishments

Current

Senior Systems Engineer (Data Analyst)

Current

Infosys Limited

Mar 2024 - Present (2 years 8 months)

Architected automated ETL pipelines using Python and MS SQL Server, eliminating 40% of manual reporting workflows and boosting data accuracy from 65% to 95% across 15+ enterprise dashboards. Spearheaded Power BI transformation initiative by implementing Star Schema data models and advanced DAX calculations, reducing report refresh times by 25%.

Python Pandas NumPy MS SQL Server ETL Power BI DAX Star Schemas VBA XLOOKUP Index Match SQL CTEs Window Functions API Integration

Systems Engineer (Developer)

Infosys Limited

Mar 2021 - Jan 2024 (2 years 10 months)

Developed enterprise-grade backend admin panels with optimized SQL database schemas, improving data retrieval speeds by 40% and enhancing operational productivity by 22% for 500+ daily active users. Built Python-based analytics applications supporting real-time user interaction tracking, contributing to a 55% improvement in search rankings.

Python SQL Database Design Backend Development Analytics Data Collection

Education

Degrees, certifications, and relevant coursework

Ambalika Institute of Management and Technology

Bachelor of Engineering, Mechanical Engineering

2016 - 2020

Bachelor of Engineering in Mechanical Engineering from 2016 to 2020.

Microsoft

Microsoft Azure Certifications, Cloud Computing

Earned Microsoft Azure certifications including Power BI Data Analyst Associate (PL-300), Azure Administrator (AZ-104), Azure Fundamentals (AZ-900), Azure AI Fundamentals (AI-900), and Azure Data Fundamentals (DP-900).