ROHIT DODTI
Mumbai
Summary
Results-driven Data Analyst/Engineer with 4 years of experience at TCS, specializing in impactful Power BI dashboards and efficient ETL processes. Proficient in SQL and Python, leveraging data analysis to identify trends that enhance operational efficiency. Collaborative problem-solver delivering customized BI solutions that improve decision-making.
Overview
4
4
years of professional experience
Work History
Data Analyst/Engineer
TCS
Mumbai
04.2021 - Current
- Developed interactive dashboards and reports in Power BI, enabling actionable insights.
- Executed ETL processes for efficient data integration into centralized warehouse.
- Collaborated with stakeholders to gather requirements for customized BI solutions.
- Optimized SQL queries and stored procedures, enhancing performance and accuracy.
- Conducted data analysis to identify trends that improved operational efficiency.
- Utilized Pandas library for effective data cleaning and manipulation.
- Analyzed large datasets to uncover trends and patterns for strategic decisions.
- Provided technical support for existing reports and dashboards.
Support Engineer
Credence Analytics (Intern)
Mumbai
01.2021 - 03.2021
- Conducted debugging activities to identify errors in SQL code.
- Coordinated testing and validation procedures through software development lifecycle.
Education
BE - Information & Technology
Fr. Conceicao Rodrigues College of Engineering
Mumbai, India10.2020
Skills
- Power BI and Excel
- SQL and PLSQL
- Python programming
- R programming
- Data analysis with Pandas
- Numerical computing with NumPy
- Scientific computing with SciPy
- Web scraping
- DAX for modeling
- ETL processes
- JSON
- AWS cloud services
- Machine learning techniques
- Java development
Accomplishments
- Star of the Quarter Award - TCS, for displaying initiative, exceptional communication skills, and persistence towards timely delivery
- IEEE Publication, published in the International Journal of Advanced Science and Technology (IJAST 2020)
Projects
- Phishing site detection: Developed a machine learning-based system to detect phishing websites by analyzing URL structure, content, and behavior
- Liquid Level Monitoring System: Designed and developed a system to monitor liquid levels in tanks using sensors and microcontrollers, implemented a user-friendly interface to display liquid levels, and send alerts when levels reach critical points
Languages
- English
- Hindi
- Marathi
Hobbies and Interests
- Sports and fitness
- Volunteering: Community service, charity work, or environmental activities
Timeline
Data Analyst/Engineer
TCS
04.2021 - Current
Support Engineer
Credence Analytics (Intern)
01.2021 - 03.2021
BE - Information & Technology
Fr. Conceicao Rodrigues College of Engineering
Similar Profiles
Avinash GawliAvinash Gawli
Scrum Master at TCSScrum Master at TCS
Krishna Kiran VelamakanniKrishna Kiran Velamakanni
Nutanix and VMWare Administrator at TCSNutanix and VMWare Administrator at TCS
Nidhi NarenNidhi Naren
Technical Program Manager at TCSTechnical Program Manager at TCS
TAMILSELVI NTAMILSELVI N
MIS & PMO Team Lead at TCSMIS & PMO Team Lead at TCS
Karuna GokarnKaruna Gokarn
In-Charge Principal at St. Xavier’s College, Mumbai (Empowered Autonomous Institute)In-Charge Principal at St. Xavier’s College, Mumbai (Empowered Autonomous Institute)