Business Analyst Data Analytics

Namrata Hiwale

+91-992******* **************@*****.*** http://www.linkedin.com/in/namrata-hiwale Profile Summary

Experienced data analytics professional with 1.9 + years of expertise in delivering end-to-end analytics solutions. Skilled in SQL, Python, and Excel, Dashboarding tool with a proven track record of analyzing large datasets, building real-time dashboards, and maintaining optimized data warehouses. Proficient in ETL pipelines, web scraping, and data transformation, ensuring high-quality, actionable insights to solve complex business challenges. Work Experience

BUSINESS ANALYST E-MECH SOLUTIONS PVT LTD SEPTEMBER 2023 – PRESENT

Improved Purchase Margins: Delivered recurring savings of ~ 3 crore/month by optimizing purchasing strategies, improving purchase margins by +1.5%.

SWOT Dashboard for Vendor Bids: Designed a comprehensive dashboard to assess vendor bid performance

(strengths, weaknesses, opportunities, and threats), aiding vendors in making data-driven bidding decisions.

Purchasing Optimization: Enhanced purchasing decisions by analyzing top bids for high-selling products across cities, ensuring optimal pricing for top performing items.

Vendor Data Model: Built a robust data model to evaluate vendor performance across four granular levels, providing actionable insights for vendor management

Purchase KPI Tracking: Created dashboards to monitor purchase channel KPIs and margin movements across categories, enabling data-driven strategies to enhance profitability

Vendor Dashboards: Classification Dashboard: Categorized vendors into performance tiers (A-D) based on margin and contribution.

Rewards Dashboard: Recognized top-performing vendors city-wise to incentivize excellence.

Weekly Purchase Order Tracker: Developed a dashboard to monitor weekly order metrics, including vendor accuracy, purchase margins, fill rates, and EDD adherence

Scheme Alert System: Designed alert mechanisms to identify mismatches in purchase, sales, and manufacturer schemes, minimizing operational discrepancies.

Tech Stack : SQL, Power BI, Redshift, AWS Buckets, Python, Airflow, Google Sheets, HTML, Hive Academic Details

B.E IN COMPUTER SCIENCE AND ENGINEERING JUNE 2023 SHRI SANT GAJANAN MAHARAJ COLLEGE OF ENGINEERING, SHEGAON CGPA (6.2) HSC (12TH) FEBRUARY 2018 MAHARASHTRA STATE BOARD 74 % SSC (10TH) MARCH 2016 MAHARASHTRA STATE BOARD 88.60 % Technical Skills

Languages and Tools: MS Excel, Python, Data Analysis, Google Sheets, Google Data Studio, AWS quick sight, Tableau,

MicroStrategy, GitHub .,Metabase

Databases: MySQL, PostgreSQL

Core Competencies

Personal Details

Date of Birth: 20 May 2000

Languages Known: English, Hindi, and Marathi

Address: Pune Maharashtra- 412115

Page 2

Communicator Collaborative Learner Team Player Career Focused

Contact this candidate