Deepak Prasad Email & Phone Number

Bengaluru, KA, IN

Chennai, Tamil Nadu, India

• Imported and transformed over 15,000 rows of raw data from Excel sheets using advanced techniques like pivot tables and complex formulas; prepared datasets for Power BI analysis resulting in faster reporting times by.
• Designed and launched advanced Power BI dashboards that integrated real-time sales data, stock levels, and seasonal trends, enabling inventory management decisions that improved stock turnover rate by 25% within three.
• Built advanced analytical reports leveraging DAX functions, merging data from MySQL and Excel; this initiative resulted in a 30% reduction in time spent on data wrangling, enabling quicker access to critical business.
• Engineered data visualization by implementing measures and calculated columns to generate insights on customer preferences, popular product categories, and profitability across different seasons.
• Partnered with the sales team to evaluate historical purchasing trends; refined reorder point accuracy leading to a significant decrease of 20% in both stockouts and excess inventory within three months.
• Spearheaded seasonal sales forecasting initiatives that analyzed over 2 years of historical data and occasion-specific insights, optimizing inventory levels for peak periods such as holidays and product launches to.

Chennai, Tamil Nadu, India

• Developed SQL scripts for five databases, driving a 25% rise in operational efficiency through actionable reporting and optimized resource allocation. Leveraged Window Functions and Joins for fast, accurate data.
• Automated business processes with stored procedures, cutting manual data entry by 70% and improving efficiency by 25%. Enhanced workflow automation and consistency.
• Mastered T-SQL, Views, Triggers, Indexes, and Window Functions. Improved data processing by 40% through optimized query performance and faster reporting.
• Partnered with teams to translate business needs into efficient SQL solutions, reducing processing time with advanced optimization techniques.
• Expertise in Power BI Suite, including Power Query, DAX, and KPI dashboards, delivering clear insights and enabling data-driven decision-making.
• Proficient in data modeling and ETL processes, transforming raw data into structured formats. Improved dashboard usability by 40% with Power Query and DAX.

Master Of Business Administration - Mba, Human Resources Management

Bachelor Of Technology - Btech, Information Technology