Madhuram Sharma

Madhuram Sharma Data Analyst / Business Analyst Phone: +91 - Email:-Portfolio: https://github.com/Madhuram6sharma SKILLS LinkedIn: www.linkedin.com/in/madhuramsharma1996 SQL ( SQL Server, Advance Queries) PORTFOLIO PROJECTS Power BI Dashboard Pizza sales for Virtual Client Developed an interactive and dynamic Dashboard for virtual Pizza sales to analyze customer choice and sales trends. Transformed and Cleaned client’s data using SQL & DAX to ensure data validity. Provided technical insights on how client can boost business using Data Trends and Charts. Structured Query Language (SQL) Housing Service Analysis Utilized SQL & Excel to perform Data Analysis on 40,000+ House Owners. Performed ETL techniques to clean, extract & transform data for successful identification of location and date of purchase. Implemented SQL Queries such as CTEs to comb through data points and identify key parameters. Python ( NumPy, Pandas) Advance Excel ( Formulas, Conditional Formatting, Pivot Tables & Charts) Microsoft Power BI ETL & Data Transformation Data Visualization Problem Solving, Statistical Analysis Effective Communication Critical Thinking OLA Monthly Report End-to-End SQL and Power BI Project Extracted data from CSV file to SQL Server and created Database for Monthly report. Data exploration using SQL queries to gather key business pain points. Generated a Power BI Dashboard to identify key reasons for ride cancellation and driver ratings to enhance daily profits. WORK EXPERIENCE MADSA Enterprises Mar 2023 Dec 2024 HPCL-Mittal Energy Ltd (HMEL) Jul 2019 – Mar 2023 Junior Data Analyst Created sales reports, presented performance data and prepared summaries for stakeholders of an e- commerce business. Created sales reports, presented performance data and prepared summaries for stakeholders of the entire e-commerce business. Designed and maintained Dashboard to communicate insights and monitor product performance across various KPI's. Reduced manual work by 70% by creating Queries to gather and clean data and improved sales by 20% by providing key failing products and inflated marketing costs for low performing products. Hands-on experience with operational data, troubleshooting, and decision making in a dynamic environment. Console Operator & Assistant Plant Manager Worked as console operator to maintain real time monitoring for productivity of the Polypropylene Unit of the Plant. Maintained daily log sheets of data from sensors and machines and created work reports. Precision in critical manufacturing decisions to ensure safety and efficiency of the unit EDUCATION- DEENDAYAL UNIVERSITY (GANDHINAGAR) PANDIT ENERGY B.Tech in Petroleum Engineering (Major in Downstream Processes) LANGUAGES English (Fluent) Hindi (Fluent) Gujarati (Basics) Marwari (Intermediate)