Kiran Rajkumar Bhillare

KIRAN BHILLARE CONTACT Pune, India-- TECHNICAL SKILLS • Power BI, query, DAX • SQL • • • • Microsoft Excel Reporting Analytical Profit and Loss Analysis SOFT SKILLS • Team management • Communication • Ownership A data professional with almost 6 years of year on year success in Data analysis, fetching, cleaning the data and delivering data driven outputs to improve the business performance. Successfully mined and analyzed data from multiple sources and presented as interactive dashboards to achieve improvements and optimization. EXPERIENCE November 2022 – October 2024 (1y 11 months) Team Lead - Eatsure D2C & Offline Rebel Foods private limited, Mumbai • Managed a team in growth department for Eatsure D2C and Eatsure Offline, primarily responsible for all the data fetching, cleaning, update, assisting data science team for data fetching, cleaning and dashboard making. Worked on MySQL & Azure. • Worked with various stakeholders such as brand managers, data science team, analysts, marketing team, etc. to understand their requirements in terms of data, reporting and provide inputs based on data analysis. • Assist data science and database admin team make efficient and data models using Power BI desktop & services. • Worked on data integration from various sources such as third party campaign portals, Azure, etc. • Help on optimization of existing dashboards, queries used by organization for speed, efficiency with large data sets, making it more inclusive as well as for additional business needs. • Identify and resolve the data issues, report and quick resolution of data discrepancies to have reliability of insights. • Train the colleagues and end users on dashboard handling and effective interaction with it. • Conducted regular performance review of the reportees, calibrate their performance based on KRAs. • Looked after the offline category of the business, managed the entire catalog of all 7 offline stores across 4 cities, look after entire process of onboarding the new outlets in the database, curated its customer facing, monitored its sales data on own as well as the third party platforms, etc. September 2020 - November 2022 (2y 2m) Senior Executive - Eatsure Category Data management Rebel Foods private limited, Mumbai • Worked in a team in business growth department for the Eatsure food ordering application data handling and execution of a range of tasks including menu and data modification, database updates, new table additions, weekly, monthly and quarterly performance reports and visual demonstration creation using power BI, daily campaign executions, keep application front appearance clean and correct, etc. • Fetched various data sets from MySQL database for various cross-functional teams such as campaign performance data for digital marketing team fetched with the help of third party API, KPI performance data of past week/month/quarter, etc. • Created dashboards for monthly business review presentations displaying various company KPIs such as sales, no. of orders, net revenue, gross revenue, citiwise sale, kitchen wise sale, etc. • Managed offline store catalog data, managing the menus, maintaining the data, making sure its correct and updated, constant checks on parity, etc. February 2019 - September 2020 (1.7 years) Executive - Brand Data Management Rebel Foods private limited, Pune • Responsible for execution of changes in brand catalogs according to the requirements from brand managers • Co-ordinated with brand managers & other stake holders to keep brand data updated and correct, data readiness for upcoming initiatives and campaigns. • Fetched data using SQL queries from multiple sources and provided the reports to various teams such as brand managers, channel managers, growth team, etc. • Modified the data according to the needs of stakeholders in the database such as price change for certain period during offers, products name changes, • Did fetching and cleaning of data sets and provided to brand managers for analysis to help them plan marketing campaigns. • Conduct regular data validation checks and perform data cleansing activities of brand data such as removal of permanently closed stores, transferred store co-ordinate update, etc. • Look over the data updation and table addition of new onboarded store on own as well as third party channels, data such as fssai number, store co-ordinates, etc. EDUCATION 08/2016 Bachelor of Engineering Electronics and Communication Engineering GPA: 73% 01/2012 Higher Secondary School Mathematics and Science GPA: 72%