Diwakar Putha
BI Data Analyst
Hire this person
Send a job offer directly to this candidate
About
Detailed oriented BI data analyst with over 4.5+ years of experience in data analysis, visualization, and reporting. Proficient in data warehousing, ETL process, and BI tools such as Power BI, SQL and transforming complex data into actionable insights. I am good at creating dashboards and reports that provides clear and concise information to stakeholders for data-driven decision-making and improve operational efficiency.
I am passionate about leveraging data to solve complex problems and driven business growth.
Experience
Data Analyst at HEPL (Cavinkare Pvt Ltd group company) (2022-12 – Present)
- Project Name: FMCG Sales analysis Report (Sales dashboard)
- Client: Cavinkare
- Tools: Power BI & SQL
- Automated sales dashboard in Power BI with SQL database.
- The analysis involves evaluating both primary and secondary data across different brands.
- Developing key performance indicators (KPIs) such as sales, units sold, profit, and growth trends over previous years.
- Presenting brand performance on a Month-over-Month (MoM) basis by zone, state, Area Sales Manager (ASM), distributor, and salesmen productivity.
- Using these metrics, a Brand Manager can make informed decisions on key business impact areas, while identifying opportunities for improvement and potential new initiatives
- By analyzing brand performance, they can take strategic actions to enhance both Existing Product Development (EPD) and New Product Development (NPD).
- Project Name: Elixify Dashboard
- Client: Elixify Skin & Hair Clinic
- Automated Dashboard in Power BI with SQL Database and Windsor
- A comprehensive analysis of sales generated from each service provided by the clinic in comparison to the desired targets.
Data Analyst at Garudaastra Aeroinventive Solutions private limited (HYD) (2022-01 – 2022-12)
- Project Name: Drone Eco System Dashboard
- Client: Garudaastra Aero inventive Solutions
- Tools: Power BI & Excel
- Automated dashboard on PBI with one drive data
- Comparing different types of drones available in the market and categorizing them by specifications, services, payloads, and their applications in various sectors.
- The dashboard is used in R&D to develop prototypes by comparing different combinations available in the market that meet DGCA standards.
- Developing key performance indicators (KPIs) such as Month-over-Month (MoM) customer trends, customer retention, and service growth.
- Connecting through windsor ai (AI-Powered Marketing Attribution Software) to analyze digital marketing data across various social media platforms.
- Assessing digital marketing expenditures across each service by social media platform and analyzing the number of customers visiting the clinic.
- Project Name: ECOM Primary &Offtake Dashboard
- Client: Cavinkare
- Tools: Power BI & SQL
- Automated dashboard in power bi with sql database and windsor
- In-depth analysis of product sales and brand performance across various e-commerce platforms.
- developed PO tracker visual to monitor total purchase orders received, delivered, and closed, while managing depot stock to ensure fulfillment of PO orders.
- Developed a Depo Tracker to maintain minimum stock levels for each SKU in the depot, based on the average run rate of each SKU.
- Through Digital marketing data Analysis of spends, Cost Per Click (CPC), clicks, and views of each SKU across different e-commerce platforms.
- Key account managers (KAMs) can make informed decisions on key business impact areas by setting budgets for SKU advertising, discounts, and offers to drive sales.
Education
Bachelor of technology (B.Tech) in civil engineering – Annamacharya Institute of technology & sciences (2015 – 2019)
