Rohit Utekar Email & Phone Number

hello I am Rohit and I'm passionate about making sense of data to help businesses grow smarter. With a knack for numbers and a love for problem-solving, I specialize in turning complex data into actionable insights. Whether it's crunching numbers, creating visualizations, or building predictive models, I thrive on uncovering valuable information that drives strategic decision-making. Let's connect and explore how we can leverage data to drive success together!" My educational background in commerce has provided me with a strong foundation in business and financial principles. This, combined with my technical skills, allows me to analyze data effectively and provide actionable insights. During my certification program in data analysis, I honed my abilities in data collection, cleaning, and visualization, as well as statistical analysis and predictive modeling.1) SQL: Efficient in writing complex queries to extract, manipulate, and analyze data from large databases.2) Power BI and Tableau: Experienced in creating interactive dashboards and visualizations to present data insights clearly and effectively.3) Excel: Proficient in advanced Excel functions, including pivot tables, VLOOKUP, and data analysis tools.4) Python: Competent in using Python for data analysis, including libraries such as pandas, NumPy, and Matplotlib* Here are a few highlights of my relevant experience : 1) Developed and maintained comprehensive dashboards in Power BI to monitor key performance indicators (KPIs) and track business performance.2)Utilized SQL to query large datasets, performing detailed data analysis that supported decision-making processes.* Key Skills : Data Analysis, Data Visualization, Problem Solving, Data Modelling* Languages : SQL, Python* Database : SQL Server, My SQL

• 

  Data Analyst

  Tricity Realty Llp

  Sep 2024 - Present - Vashi, Thane, Maharashtra, India

  1) Spearheaded daily data transformation and cleaning processes for unstructured real estate data using Enrich 360 software, ensuring accuracy and consistency in all datasets.2)Analyzed key performance metrics, including the performance of sourcing managers, tracking proposed visits, visits done, and visits confirmed.Applied Excel formulas for target tracking, calculating achievements, and identifying deficits to improve project monitoring and decision-making.3)Managed missing data, duplicate entries, and irrelevant fields to enhance data quality, ensuring reliable insights for report generation.4)Generated and presented MIS reports for different departments (Direct Marketing, Indirect Marketing, Closing Department) to support strategic decision-making.Collaborated with cross-functional teams to deliver actionable insights from data, directly contributing to real estate project performance improvement.

• 

  Mumbai University Mumbai

  Bachelor Of Commerce - Bcom