SRI VYSHNAVI GOPALAM
Summary
Data Enthusiast with years of industry and freelancing experience as a Data Analyst, worked with various clients operating in Telecom, Finance and Technology domains. Acquired proven experience in SQL, Python and Tableau and major experience includes problem scoping, insights generation, data scripting, data modelling and monitoring data.
Overview
3
3
years of professional experience
1
1
Certification
Work History
Freelance Data Analyst
Upwork
(Remote)
09.2023 - Current
- Analyse the metrics incorporated for the KYC approval, to have hassle free services on account
- Designed and constructed ad-hoc queries for data validation and data modelling
- Analysing factors responsible for KYC being approved, not being approved and KYC not being renewed
- Suggested the factors responsible for improvement in processing application time and accounted for 15% improvement in processing time
- Started with Machine Learning algorithms, to automate the whole process of KYC Analysis
- Implemented Random Forest and Decision Tree algorithms for the same.
- Designed and implemented comprehensive frameworks for A/B testing that consider different conversion goals and statistical methodologies.
- Lead the statistical analysis of A/B tests using a variety of methods including t-tests, z-tests, chi-square tests, ANOVA, and others.
- Develop and refine logic for determining when A/B tests are statistically significant, taking into account different types of data and desired outcomes.
- Provide expert guidance on the selection of appropriate statistical tests and data interpretation.
Data Analyst
Infosys
Sydney,NSW
02.2022 - 08.2023
- I gained extensive experience in SQL, Python, and data analytics methodologies, which I applied to various projects aimed at driving business growth and efficiency.
- Developed and executed complex SQL queries in cloud environment such as (Google's BigQuery) to extract, transform, and analyze data from relational databases in a KYC client project. This work involved using joins, CTE's, window functions and aggregations.
- Leveraged advanced Python programming skills to automate various data processing tasks. By scripting workflows and optimizing processes. This automation not only saved time but also reduced the risk of human error, ensuring more accurate and reliable data handling.
- Designed and created interactive dashboards and visualizations using PowerBI, tailored to meet stakeholder needs. The visualizations helped translate complex data sets into understandable formats, facilitating data-driven decision-making and enhancing overall stakeholder understanding.
- PowerBI Reports for Business Performance: Implemented PowerBI reports by integrating real-time data and providing clear visual representations of key metrics, these reports enabled quick and effective decision-making.
- Overall, my professional experience in SQL, Python, PowerBI, Excel and data analytics has equipped me with a robust skill set, enabling me to contribute effectively to business intelligence and performance enhancement initiatives.
- Analyzed complex data sets, identifying trends and patterns crucial for informed decision-making in various projects.
Tutor in Data Science
SuperProf
Sydney NSW
01.2021 - 02.2022
- Provided one-on-one tutoring sessions to students, tailoring instruction to meet specific needs while promoting independent learning skills.
- Assisted students in developing programming skills and strategies, including SQL, Python, and data analytics techniques.
- Conducted review sessions to help students prepare for tests.
Education
Master of Information Technology - Data Science And Engineering
University of New South Wales (UNSW)
Sydney01.2021
Bachelor of Technology - Electronics and Communication Engineering
Gandhi Institute of Technology And Management
01.2017
Skills
- Statistical Methods - Hypothesis Generation, AB Testing, Uni Variate Analysis, Bi Variate Analysis
- Machine Learning -Linear Regression, Logistic Regression, Decision Trees, Random Forest, K- Nearest Neighbours, K-Mean Clustering
- Data Analytics
- Data Visualization
- Database Language: SQL, SQLite, BigQuery
- Cloud & IDE's: Google Cloud, Azure Data Studio
- Tools and Technologies: Python, R, PowerBI, Tableau, Excel, Jupyter Notebook
- Functional Skills: Process Interpretation, Analytical Ability, Team Management, Interpersonal Communication, Problem solving
Certification
Google advanced data analytics Certification
-Python, ML, Tableau, BigQuery, Statistics, EDA
Microsoft POWER BI Data Analyst Professional Certification
-Excel, PowerBI, ETL processes, Data Modelling&Visualisation
Additional Information
Projects Portfolio: https://srivyshnavig.github.io/srivyshnavigopalam.github.io/
Automati Data, TikTok, Waze:
These 3 complete data analysis life cycle projects includes a series of comprehensive case studies, covering essential data analysis techniques such as Exploratory Data Analysis (EDA), Hypothesis Testing(AB), Regression Analysis, Machine Learning Tree based Models, KNN, Bagging, Boosting enhancing model accuracy while mitigating overfitting, and Presentations.
Sales Analysis Using PowerBI:
A comprehensive dashboard for analyzing automotive sales trends which provide a detailed breakdown of (YTD)figures, weekly trends, and sales by dealer/region. Also help's to keep track of important KPI's while empowering users to uncover hidden patterns and opportunities within the automotive sales landscape in a more granular level.
Customer Segmentation using kmeans in Python:
This project uses unsupervised ML model K-means clustering to categorize customers based on shopping patterns. By identifying customer groups, we can tailor targeted marketing campaigns to enhances customer satisfaction and loyalty by delivering personalized experiences aligned with diverse needs.
Timeline
Freelance Data Analyst
Upwork
09.2023 - Current
Data Analyst
Infosys
02.2022 - 08.2023
Tutor in Data Science
SuperProf
01.2021 - 02.2022
Master of Information Technology - Data Science And Engineering
University of New South Wales (UNSW)
Bachelor of Technology - Electronics and Communication Engineering
Gandhi Institute of Technology And Management