Summary
Overview
Work History
Education
Skills
Affiliations
Accomplishments
Certification
Websites
VOLUNTEER EXPERIENCE
ACADEMIC EXPERIENCE
OTHER PROJECTS
Timeline
Generic

Manoj Renu Kumar

Murrumbeena

Summary

Results-oriented Data Analyst with experience in data analysis & visualization, business intelligence, and machine learning with demonstrated results in maximizing operational efficiencies and customer satisfaction. Hands-on experience in Python, Databricks, Oracle Database,reporting tools like Power BI and CRM-A, cloud technologies like AWS and producing data-driven actionable insights to optimize decision making and deliver value efficiently.

Overview

3
3
years of professional experience
1
1
Certification

Work History

Data Analyst

University of Melbourne
Melbourne
03.2023 - Current
  • Analyzed large datasets to identify trends, patterns and correlations for business insights.
  • Provided data-driven solutions to support decision making.
  • Gathered requirements from stakeholders to design data models and reports.
  • Collaborated with stakeholders across the organization to understand their needs from a data perspective.
  • Worked closely with the Data Migration team to analyze the data for quality purpose and also helped them to transform the data based on the Salesforce standards.
  • Built a python script to automate the loading process of data from the AWS oracle relational database to salesforce.
  • Used CRM-A to visualize the salesforce data based on stakeholder's requirements.
  • Helped the business service team with creating reports summarizing business , financial or economic data and students records.
  • Also helped with the database admin tasks such as Configuring user accounts, privileges, roles, profiles in the database servers.
  • Helped the data Remediation team to analyze the data issues and helped them to solve in an efficient way.
  • Built a sql script to extract the data from various sources and automated the refresh process through AWS lambda service.

Data Engineer

Intelematics
Melbourne
10.2021 - 03.2023
  • Experienced data engineer with expertise in analyzing data from various sources using programming languages such as python, SQL, Pyspark on Databricks Platforms and power Bi to create reports .
  • Skilled in managing and Controlling the integration and linkage of datasets through data and content processing and delivering pipelines, including data from IOT devices, geospatial, temporal/time series, demographics, GPS etc.
  • Proficient in conducting investigative analysis such as predictive analytics, scenario analysis and developing statistical metrics to track the performance of machine learning models on productions.
  • Skilled at ensuring continuous data flow by effectively linking systems and components, maintaining quality management documents, and working with stakeholders to deploy production data changes.
  • Developed Python scripts for extracting data from web services API's and loading into databases.
  • Integrated multiple sources of structured and unstructured datasets into a single platform.
  • Identified, protected and leveraged existing data.
  • helped the failsafe team to merge the data from various sources, clean them and build machine learning models to predict the battery status of the vehicles.

Data Processor

Maple Plan
Melbourne
03.2021 - 10.2021
  • Reviewed and analyzed data from various sources to identify discrepancies or errors.
  • Compiled, sorted, and verified accuracy of data entered into database.
  • Reviewed and analyzed staff data and calculated weekly KPI's and developed a visual dashboard using Microsoft Excel and Tableau to present performance, trends and insights to senior management team. This was recognized for improving management decision making.
  • Produced detailed SOP's, user manuals and other documentation to report findings, new ways of working which helped to minimize reprocessing whilst improving knowledge sharing capability.
  • Conducted comprehensive quality checks on data sources and introduced data validation, standardization and cleansing processes which improved overall data accuracy.
  • Prepared presentations on collected data for management review.
  • Generated dashboards in Power BI to provide detailed views of the KPI of the employees and also created reports to support the business timesheets.

Data Analyst Intern

Stomble
Melbourne
01.2021 - 03.2021
  • Coordinated with external service providers to implement AWS whilst updating the schema to support future developments of the company. The migration led to a saving of 8% of maintenance costs.
  • Conducted comprehensive competitor analysis, factoring other attributes such as customer behavior, industry trends and developed reports which helped to improve technical efficiencies and identify new business opportunities.
  • Performed exploratory data analysis on large datasets to identify trends and outliers.
  • Conducted research into industry best practices for data management processes and procedures.
  • Created SQL queries to extract relevant information from relational databases for various projects.
  • Assisted in developing strategies for collecting, organizing, and storing large amounts of data efficiently.
  • Implemented Confluence as a collaboration tool completely integrated with JIRA and other platforms which helped to identify risks, issues and dependencies of each sprint that led to improve mean time to resolve issues by 8%.
  • Assisted with development of dashboards and reports using spreadsheet and Power BI.

Business Consultant

Study Melbourne Internship
Melbourne
07.2020 - 08.2020
  • Conducted a detailed analysis of ASPL’s social media platforms using Tableau and R programming and produced actionable insights using Python, Google Analytics which was recognized for delivering accurate outcomes.
  • Utilized Keyhole to collect complex sets of data from various sources and performed cleaning, whilst implementing validation techniques to improve future tasks.
  • Implemented an audit report to present the findings on ASPL's social media reach and B2C interactions to optimize management decision making.
  • Created financial projections based on market research data and industry trends.
  • Conducted surveys of customer satisfaction to identify areas of improvement.
  • Analyzed financial records, including income statements and balance sheets, to assess performance of businesses.

Education

Master of Science - Data Science

Monash University
Melbourne, Australia
12.2020

Bachelor of Science - Bachelor’s in Information Technology

Don Bosco Institute of Technology
Bangalore, India
06.2018

Skills

  • Data Validation
  • Database Maintenance
  • Data Modeling
  • Data Warehousing
  • Statistical Analysis
  • Data Mining
  • Data Visualization and Presentations
  • SQL
  • Data Analysis
  • Power BI
  • Big Data
  • Data Wrangling
  • ETL
  • Problem Solving
  • Agile Methodologies
  • Adaptability
  • Relationship Building
  • Communication
  • Git

Affiliations

  • Love playing outdoor sports mainly cricket and i represented my state back in India in it.
  • Good at singing and dancing
  • love to code.

Accomplishments

  • Top 20 Ranking in Kaggle Competitions : Machine leaning predictions for Titanic dataset.
  • Top 10 Ranking in University machine learning Compitation: Recommendation system using ALS algorithm and an analysis on an Earthquake dataset to inspect and predict future damage rate for a particular building.

Certification

  • SQL Certification by Udemy.
  • Python Basics by University of Michigan.
  • AWS Cloud Cloud practitioner.

VOLUNTEER EXPERIENCE

Coordinated various Volunteer programs through Monash Student Association as well as spearheaded various the campus tour team and Information booth handler during summer events.

ACADEMIC EXPERIENCE

Industrial Experience Project

Monash University

  • Developed a comprehensive mobile-responsive website using WordPress with custom HTML and CSS for styling. This resulted in improving user engagement by 15% and organic rankings.
  • customizedomised integrations and functions to allow children aged 14 years to have better access to My Health record which was praised for enhancing user experience.
  • Deployed web application in AWS and used RDBMS which led to improving loading time as well as overall security and performance.
  • Worked as a part of multi-cultural team with a diverse level of skills, whilst brainstorming innovative ideas to create cultures of creativity.

Study Melbourne Project

ASPL Social Media Analysis

  • Conducted a detailed analysis of ASPL’s social media platforms using Tableau and R programming and produced actionable insights using Python, Google Analytics which was recognized for delivering accurate outcomes.
  • Utilized Keyhole to collect complex sets of data from various sources and performed cleaning, whilst implementing validation techniques to improve future tasks.
  • Competitive exploration on leading organizations in leadership training sector and develop a list of recommendations on social media activities and practices.
  • Implemented an audit report to present the findings on ASPL's social media reach and B2C interactions to optimize management decision making.

OTHER PROJECTS

Analysis of UK Accidents

  • Built an advanced R-shiny based application that allows the users to explore accidents based locations with information pertaining to the causes.
  • Performed cleaning of data beforehand to establish an environment to conduct analysis.
  • Conducted advanced data analysis to evaluate and compare the causes of the accidents and produced evidence-based solutions through interactive dashboards to prevent them in future.
  • Technologies Used: Python, classification algorithms, NLP, NLTK.

Authorship Profiling using Prediction Analysis :

  • Analyzed the social media behavior of the users based on author’s books whilst conducting comprehensive cleaning to develop classifications on gender and text using NLP.
  • Used various types of algorithms to generate predictions on the analysis. Technologies - Python, classification algorithms, NLP, NLTK.

Rain Prediction in Melbourne:

  • Gathered data on historical weather reports generated by Meteorology Bureau in Melbourne and conducted analysis on big data by removing anomalies and applying machine learning algorithms to predict forecast for next day.
  • Conducted tests to verify the accuracy of prediction. Technologies Used: PySpark, Machine Learning Algorithms: Decision Tree, Random Forest, Support Vector Machine (SVM), Naive Bayes, Logistic Regression.

Design of Monash Hospital

  • Designed Monash Hospital using a conceptual model, and
  • conducted normalization and logical modelling, SQL was utlized to insert data into logical model.
  • I deployed “Time Complexity” as well other essential components that is crucial to be factored in to data analysis and algorithms.
  • Database: SQL, Lucid Chart (Conceptual Model), Oracle (Logical Model).

Timeline

Data Analyst

University of Melbourne
03.2023 - Current

Data Engineer

Intelematics
10.2021 - 03.2023

Data Processor

Maple Plan
03.2021 - 10.2021

Data Analyst Intern

Stomble
01.2021 - 03.2021

Business Consultant

Study Melbourne Internship
07.2020 - 08.2020

Master of Science - Data Science

Monash University

Bachelor of Science - Bachelor’s in Information Technology

Don Bosco Institute of Technology
Manoj Renu Kumar