Rahul Khilare 909-***-**** *****.**********@*****.*** LinkedIn GitHub Portfolio
OBJECTIVE:
Seeking a challenging and rewarding position in a reputed organization where I can apply and expand my skills in data analytics, data insights, machine learning, and data modeling. Eager to enhance my technical knowledge while contributing valuable solutions that drive business impact and support organizational growth.
EXPERIENCE:
Power BI Developer WebRelier Software Solutions Pvt. Ltd, Pune (June 2023–Present) Experienced in analyzing BI requirements, translating business needs into actionable insights through interactive dashboards and reports. Skilled in data analysis, KPI tracking, and data modeling using Star and Snowflake schemas. Proficient in designing and maintaining logical and physical data models to support strategic decision-making.
Pharmaceutical Professional 7+ Years Industry Experience Worked with leading pharma companies including Abbott, Marksans, Glenmark, Cipla, and Teva across roles from Production Officer to Executive. Strong expertise in production operations, documentation, Excel, and SAP.
SKILLS:
POWER BI DATA VISUALIZATION DATA CLEANING DATA CLEANING POWER QUERY DATA ANALYSIS REPORTING AND DASHBOARDING SQL EXCEL PYTHON MATPLOTLIB ETL DATA MODELLING MySQL TABLEU DAX SEABORN PANDAS NUMPY
PROJECT:
Ecommerce Analysis-[MySQL Python] GitHubRepo
●Led a comprehensive analysis of e-commerce sales data, applying SQL for data cleaning, segmentation, and trend analysis across categories, regions, and time periods. Delivered insights that informed inventory planning and targeted marketing.
●Developed automated Python workflows for churn prediction and KPI tracking, integrating SQL queries with visual dashboards to monitor customer lifetime value and purchase frequency—enhancing decision-making speed and accuracy.
Amazon Prime User Analysis -[Python]GitHub Repo
●Conducted the EDA analysis by using Pandas and NumPy with Python. including Device Usage, Purchase history, usage frequency, favorite genres, subscription plan, enhancing decision-making capabilities, and much more
●Engineered customized Python visualization reports by using Matplotlib and Seaborn to enhance decision-making capabilities.
Pizza Sales Analysis-[Excel SQL]GitHubRepo
●The Pizza Company aims to establish its presence in the Indian market and conduct a survey across India to gather insights on its pizza Type.
●Using MySQL, creating insights from the database on the total No. Order the most Common Pizza, Pizza Type, and consumer response, and provide those insights to the Pizza Company
CERTIFICATE:
●Certified Data Science Pro Certificates from “Fingertips”.
EDUCATION:
RITEE College of Pharmacy, Raipur
M.Pharmacy (Master’s In Pharmacy)-First Class
KLE College of Pharmacy, Nipani
B.Pharmacy (Bachelor’s In Pharmacy)-First Class