Summary
Overview
Work History
Education
Skills
Projects
References
Timeline
Generic

Ajay Pinisetty

Campbelltown,SA

Summary

Results-driven and detail-oriented Business Data Analyst with a strong background in data analysis and business intelligence. Proficient in utilizing advanced analytical tools and techniques to extract valuable insights from complex datasets. Demonstrated expertise in translating data into actionable business strategies and recommendations. Skilled in creating interactive dashboards and reports to facilitate data-driven decision-making. Strong collaboration and communication skills, enabling effective partnerships with cross-functional teams to drive organizational growth and optimize operational processes. Committed to delivering high-quality analysis and maintaining data integrity to support business objectives and enhance overall performance.

Overview

Work History

Junior Data Analyst

Channelsoft
  • Conducted data cleaning and validation processes to ensure data accuracy and integrity, contributing to reliable analysis outcomes.
  • Assisted senior analysts in data collection and data mining activities to identify trends and patterns in large datasets.
  • Utilized Microsoft Excel, SQL, and Python to perform data analysis, generating reports and visualizations for management review.
  • Participated in team meetings and contributed to discussions on data-driven insights and actionable recommendations.
  • Supported the development of interactive dashboards using Tableau and Power BI, facilitating efficient data visualization.
  • Collaborated with stakeholders to understand data requirements and provided timely ad-hoc analysis to address business queries.
  • Assisted in creating predictive models and statistical analyses using R, contributing to the optimization of key business processes.
  • Documented data analysis procedures and findings, enhancing knowledge sharing and maintaining project documentation.
  • Assisted in the implementation of data quality measures, contributing to enhanced data accuracy and reliability.
  • Stayed abreast of emerging data analytics trends and tools, actively engaging in continuous learning and professional development opportunities.

Education

Master's - Data Science

University of South Australia

Bachelor's - Computer Science

Sathyabama University

Skills

  • Utilized advanced Excel functionalities and Power BI to perform data analysis and create interactive dashboards, enabling data-driven decision-making by management
  • Developed VBA scripts to automate repetitive data tasks, resulting in improved efficiency and reduced manual errors
  • Actively participated in and successfully completed End-Of-Month process cycles, ensuring accurate financial reporting and meeting deadlines
  • Collaborated with cross-functional teams and used Git for code version control, ensuring efficient collaboration and effective code management
  • Designed and maintained SharePoint and Microsoft Teams groups, promoting seamless collaboration and document sharing among team members - Created automated Flows in Microsoft Power Automate, streamlining workflow processes and increasing overall productivity -
  • Utilized industrial software and operational technology, including Pi Historian used in project, to optimize operational processes and enhance performance

Projects

Water & Waste Management Analysis and Route Optimization Predicting Students Performance for UniSA Online

 

City Council | City, State

  • Worked with the City Council on three different scenarios: Water usage analysis, Waste management analysis, and Route optimization.
  • Organized weekly meetings with the stakeholders to discuss project progress.
  • Applied machine learning models on water data to predict water usage in different areas to cut down water usage.
  • Used time series analysis on waste data to forecast the volume of waste in different areas for the coming years.
  • Implemented Clustering techniques on X, Y coordinates of the different locations and came up with the shortest route to take water meter readings.
  • Visualized all the data and solutions using tools like Tableau, Power BI, and in R, Python.

UniSA Online | City, State

  • Combined and Converted all the Raw data files into yearly data using Data transformation techniques.
  • Conducted extensive research on previous solutions to the problem and came up with a desirable solution.
  • Used methods like Chi-square statistics and correlation matrix to find the factors affecting students' performance.
  • Applied different machine learning models to predict students' performance based on their previous semester Grades.

References

 Available upon request.
 

Timeline

Junior Data Analyst

Channelsoft

Master's - Data Science

University of South Australia

Bachelor's - Computer Science

Sathyabama University
Ajay Pinisetty