Sep 25, 2023

Sarthi Chitroda

  • Data Analyst
  • Boston, MA, USA
Full time Business Development Consultant Information Technology

Personal Summary

I am a highly skilled and dedicated Data Analyst with a Master's Degree in Business Analytics. I have a strong background in using various tools and programming languages, such as SQL, Python, and Tableau, to analyze data and provide actionable insights. With a proven track record in creating financial reports, conducting market trend analysis, and implementing data-driven decisions, I am confident in my ability to contribute to the success of any organization. I am detail-oriented, analytical, and possess excellent problem-solving skills. I am eager to leverage my expertise and contribute to the growth of a company as a Data Analyst.

Skills

  • Programming: Python (Pandas, Numpy, Scikit-learn, Matplotlib, Seaborn), SQL, T-SQL, Java, VBA.
  • Database Systems: Microsoft SQL Server, Oracle Database, MySQL, NoSQL, MongoDB.
  • Business Intelligence Tools: SAS, Tableau, Microsoft Power BI, SPSS.
  • MS Office: MS Access, MS PowerPoint, MS Excel, MS Word, MS Project.
  • Cloud Services: Google Cloud Platform, Microsoft Azure, Snowflake.

Licenses and certifications

  • Azure Data Fundamentals by Microsoft
  • Foundations of Project Management by Google

Work Experience

Data Analyst
Jan 2019 - Apr 2022 SMR Realty
  • Employed SQL, Tableau, and Python to create 20+ financial reports and analyses, aiding informed decisions.
  • Programmed financial planning accuracy for sales by 10% through complex modeling and forecasting.
  • Tracked market trends utilizing machine learning libraries on Python, offering actionable insights to senior management.
  • Monitored solution adoption using Tableau dashboards and conducted SQL-based analysis, leading to a 25% increase in process efficiency and a 15% improvement in overall outcomes.
  • Adapted strategies and solutions, incorporating Tableau for data insights resulting in a 15% improvement in overall project success rates.
  • Collaborated with the machine learning team to conduct analyses on Python using ML libraries, aiding in strategic decision-making.
  • Led 3 segment projects leveraging Jira, boosting project co-ordination by 20% and improving internal dataset usability.
  • Collaborated cross-functionally, leveraging Snowflake and GCP to build pipelines, resulting in a 15% rise in data processing.
  • Seamlessly integrated 4 external data sources via BigQuery, driving a 30% growth in qualified leads.
  • Translated complex data into actionable Tableau visuals, accelerating decisions by 25% for key stakeholders.
  • Successfully led requirement gathering sessions for multiple projects, resulting in a 20% reduction in project development time.
  • Translated data-driven insights into actionable sales strategies, resulting in a 30% revenue increase through alignment with business needs.
  • Led ETL processes using Apache Spark and Python to efficiently integrate large-scale datasets from multiple sources into a centralized database for analysis.
  • Demonstrated proficiency in Salesforce applications and reporting, effectively utilizing the platform to streamline processes.
  • Developed Excel macros to automate repetitive tasks, resulting in a 30% reduction in data entry time.
  • Led cross-functional sales teams, achieving a 15% improvement in project success rates and earning recognition as a subject matter expert in sales operations.
  • Automated weekly, monthly, and quarterly reports using SQL, and Python, boosting speed by 15%.
  • Enhanced quarterly forecasting accuracy by 10%, leveraging SQL, Tableau, and Python.
  • Collaborated with the marketing team to implement data-driven decisions, resulting in a 15% rise in campaign effectiveness.
  • Conducted web analytics for e-commerce using Google Analytics and Google Tag Manager, contributing to increased online sales and revenue.
  • Created informative Power BI visualizations based on Google Analytics data to facilitate cross-functional decision-making and improve overall website performance.
  • Led A/B tests on sales strategies, translating results into data-driven recommendations.
  • Successfully conducted ad hoc analysis using SQL queries that resulted in a 20% reduction in customer churn rate.

Education

Master’s Degree
Aug 2022 - Jun 2023 University at Buffalo, The State University of New York