Rohan Talekar
Data Analyst / Data Scientist & Process Optimizer
Analytical and data-driven professional with an M.Sc. in IT and over 2 years of experience leveraging SQL, Python, and Excel to analyze complex operational workflows, identify functional bottlenecks, and deliver actionable insights. Transitioning technical support achievements into a Data Analyst / Data Scientist role, applying competencies in exploratory data analysis (EDA), statistical modeling, and machine learning to drive data-backed strategic decisions.
Work Experience
Software Support
Gold Star Jewellery Pvt Ltd Sept 2023 - Dec 2025- Provided Software support to end-users, resolving software application issues through rigorous root-cause analysis.
- Conducted troubleshooting and debugging to identify and resolve system problems efficiently.
- Documented and maintained clear technical documentation for software applications.
- Collaborated with cross-functional teams to ensure smooth operation of IT systems.
- Analyzed complex operational datasets and production system workflows to identify structural bottlenecks, engineering automated workflow efficiency enhancements.
- Executed comprehensive validation testing and User Acceptance Testing (UAT) to evaluate software updates, strictly ensuring data integrity across infrastructure.
- Synthesized data insights and technical investigations into clear operational updates for cross-functional support teams and senior management.
- Developed and implemented automated data validation and reporting processes, enhancing operational efficiency and accuracy.
Skills & Competencies
Languages
Analytics
Tools & Testing
Support & Ops
Technical Projects
Student Management System
Designed and implemented a fully normalized relational database structure to manage records across students, courses, instructors, and enrollments.
- Enforced comprehensive data integrity and domain business logic constraints through precise primary/foreign key indexing.
- Engineered advanced analytical reporting queries leveraging nested JOINs, subqueries, and conditional aggregation techniques (GROUP BY, HAVING).
Employee Salary & Workforce Analytics
Designed and queried a relational employee database in MySQL Workbench, applying data filtering, aggregation, and date-string conversion to analyze hiring trends.
- Built department-level salary analytics using aggregate functions and GROUP BY/HAVING clauses to benchmark against company-wide metrics.
- Implemented window functions (RANK(), DENSE_RANK(), SUM() OVER PARTITION BY) to calculate budget utilization and surface anomalies.
Expense Tracker
Built a robust Python CLI application for tracking and managing daily personal expenses with persistent file storage mechanisms.
- Implemented complete CRUD operations with persistent data storage using JSON formats.
- Applied clean structural file handling, exception safety, and modular list/dictionary structures.
Number Guessing Game
Interactive command-line application built to master algorithmic conditional logic, loop state tracking, and error handling variations.
Rock Paper Scissors Game
Command-line gameplay loop system utilizing Python's random module to simulate predictable and dynamic computer choices.
Education
M.Sc. in Information Technology
University of Mumbai
Graduated 2020
B.Sc. in Computer Science
University of Mumbai
Graduated 2018
Languages Spoken
Certifications
-
Cloud Computing Service Models
Great Learning
-
Python Fundamentals for Beginners
Great Learning
-
Python Programming
Great Learning