Data Analytics Professional with BI Expertise

Shrutika Kole

Pune, India +91-954******* **************@*****.*** Linkedin

Summary:

To leverage my strong Analytical, Business Strategy, and Visualization skills to contribute to an organization’s success by driving innovation and fostering a collaborative environment, seeking to make a meaningful impact while growing both professionally and personally.

Skills:

• Technical: Python (Pandas, NumPy, Matplotlib, Seaborn), SQL, MySQL, Power BI, DAX, Power Query, Excel, Azure DevOps, Machine Learning and Artificial Intelligence (Learning).

• Analytics: ETL, Data Cleaning, EDA, Data Transformation, Forecasting, Statistical Modelling, KPI Reporting.

• Visualization: Dashboard Design, Business Intelligence, Data Storytelling, Performance Tracking

• Soft Skills: Collaboration, Communication, Problem Solving, Agile Delivery. Experience:

Assistant System Engineer Tata Consultancy Services Feb 2024 – Present

• Developed Power BI dashboards integrating SQL, Power Query & DAX, enhancing reporting efficiency by 30%.

• Ensured 100% data accuracy through ETL, validation, and governance processes.

• Created KPI-based reports & automated Power BI refresh, improving real-time visibility.

• Delivered analytics in Agile sprints using Azure DevOps for tracking user stories. Data Analyst (Intern/Assistant) Guru Tours and Travels, Kolhapur July 2023 – Dec 2023

• Analyzed Excel & SQL data to identify sales trends and customer demand, increasing forecast accuracy by 25%.

• Built Power BI dashboards for bookings & revenue, optimizing business planning.

• Performed EDA in Python to derive actionable marketing insights. Projects:

Blinkit Sales Performance Dashboard, Project Domain: Business Intelligence & Data Visualization:

• Objective: To analyze Blinkit’s grocery sales and identify factors driving revenue and outlet performance.

• Built a BI dashboard with ETL & KPI tracking to analyse sales, ratings, and outlet performance, found Regular-fat items (~65%) and Tier-3 outlets drove major revenue. Ride Booking Analysis, Project Domain: Data Analytics (Python) :

• Objective: To analyze ride booking data and identify customer, cancellation, and operational patterns.

• Conducted EDA on 150K+ rides to reveal booking, cancellation, and demand trends, identified auto rides as the most frequent and peak hours at 10 AM & 6 PM. Education:

B.Tech in Computer Science DKTE'S Textile and Engineering Institute, Ichalkaranji 2019–2023 CGPA: 8.5 Certifications:

• Python

• SQL

• Probability and statistics

• Advanced Excel

• Power BI

• Data Science using Python

Contact this candidate