Back to Developers
umang prasoon

umang prasoon

Data Analyst

Delhi, India 1+ yrs exp 84 ยท Excellent

About

Data Analyst skilled in SQL and Power BI with experience in vendor and distribution analytics. Built a profitability dashboard used by finance and operations and drove a 20% gain in distribution efficiency through data backed reallocation. Experienced in vendor performance analysis, distribution profitability optimization, and cross-functional reporting for operations and finance teams.

Skills & Expertise (19)

Power BI Advanced
8.0/10
1
Years Exp
Data Visualization Advanced
8.0/10
1
Years Exp
Dashboards Advanced
8.0/10
1
Years Exp
Problem Solving Advanced
8.0/10
2
Years Exp
Analytical Thinking Advanced
8.0/10
2
Years Exp
SQL Intermediate
7.5/10
2
Years Exp
MS Excel Advanced
7.5/10
2
Years Exp
Data Modeling Intermediate
7.0/10
1
Years Exp
Communication Intermediate
7.0/10
2
Years Exp
Power Query Intermediate
6.5/10
1
Years Exp
Stored Procedures Intermediate
6.0/10
2
Years Exp
Google Sheets Intermediate
6.0/10
2
Years Exp
DAX Intermediate
6.0/10
1
Years Exp
Angular Intermediate
5.5/10
1
Years Exp
JavaScript Intermediate
5.5/10
1
Years Exp
HTML Intermediate
5.5/10
1
Years Exp
CSS Intermediate
5.5/10
1
Years Exp
ASP.NET Web API Intermediate
5.0/10
1
Years Exp
AWS Intermediate
5.0/10
1
Years Exp

Work Experience

Data Analyst

Peripheral Engineers Pvt. Ltd.

Jun 2023 - Jun 2024

Collected and consolidated vendor-submitted data from standardized forms across 50+ vendors; performed data validation and cleansing in SQL to ensure accuracy before downstream analysis. Analysed regional sales and demand data to identify high-performing vs. underperforming distribution zones; recommended product quantity reallocation that improved distribution efficiency by 20%. Built a Power BI dashboard tracking revenue, cost of goods, margins, and net profit by product category, vendor, and region, enabling finance and operations teams to monitor profitability with ease. Created SQL queries to calculate vendor-wise contribution margins and cross-referenced with distribution costs to surface the most and least profitable vendor-region combinations. Maintained weekly and monthly reports on inventory movement, vendor fill rates, and regional sell-through rates for operations and senior management planning decisions.

.NET Developer

ISMEDU Software Sol Pvt. Ltd.

Apr 2023 - May 2023

Built hospital management web pages using Angular with full CRUD operations and developed reusable form validation library functions used across multiple project pages. Debugged and resolved code issues, improving overall code efficiency and reducing system crashes.

Associate Software Engineer

Bizframe Technologies Pvt. Ltd.

Mar 2022 - Oct 2022

Developed Web APIs for Employee Data and Document CRUD using repository pattern and wrote database SQL scripts to support the APIs. Contributed to a cloud-native solution (AWS) for storing employee data and documents for a leading consultancy client.

Software Engineer Intern

Bizframe Technologies Pvt. Ltd.

Nov 2021 - Feb 2022

Developed website login and management pages and wrote Web APIs using CRUD operations; built Angular UI with MySQL Stored Procedures for structured data storage. Built AngularJS data entry forms with form validation and integrated multi-language support across survey forms to serve diverse regional users. Gained hands-on experience in AngularJS, JavaScript, HTML, CSS, and ASP.NET Web API development, including token/claims-based API authorization.

Education

B.Tech in Computer Science Engineering - Bengal Institute of Technology and Management, MAKAUT

2017 - 2021 ยท Afghanistan

Certifications

No certifications added yet

Interested in this developer?

Profile Score Breakdown

๐Ÿ“ท Photo 10/10
๐Ÿ“„ Resume 10/10
๐Ÿ’ผ Job Title 10/10
โœ๏ธ Bio 10/10
๐Ÿ› ๏ธ Skills 20/20
๐ŸŽ“ Education 10/10
โฑ๏ธ Experience 9/15
๐Ÿ’ฐ Rate 0/5
๐Ÿ† Certs 0/5
โœ… Verified 5/5
Total Score 84/100

Profile Overview

Member sinceOct 2026