Data Analyst
Resume:
Ravali Maryala
******.*******@*****.***
Austin, TX
LinkedIn Github
Education
Master of Science in Data Analytics and Information Systems Spring 2019 – Fall 2020
Texas State University – San Marcos, TX, USA GPA : 4.0
Bachelor’s in Information Technology Fall 2009 – Spring 2013
JNTU, India GPA : 3.65
Skillset and tools
Data Mining, Cleaning and Visualization using Python/R libraries- NumPy, pandas, Matplotlib, Seaborn and MongoDB, NLP, NLTK
Data reporting and Visualization dashboards using PowerBI, Tableau, SAP Lumira and Excel – Pivot tables, VLOOKUP
Data-warehousing and database management using Microsoft Access, SAS and MYSQL
Predictive/Statistical Modeling and Machine Learning – Classification, Regression, Clustering etc
Deep Learning and computer vision using OpenCV, TensorFlow, Keras and Scikit-Learn
WebScraping using Beautiful Soup and requests library from Python
IDE’s like Jupyter Notebook, Terminal, Visual Studio Code
Expertise in PySpark, Text Analysis and Sampling. Simulation using Simio and Statfit.
Tableau Data Analyst certification
Data modelling work using Python, R, Hadoop, Scala, Spark
AWS trained cloud practitioner.
Academic Projects
Accidents in Austin Analysis (08/2019 – 12/2019)
-Analyze the road traffic patterns and the accident zones in Austin. Achieved this in the order of cleaning the datasets and used several approaches to analyze the datasets.
-Located the accident-prone areas in Austin using maps for descriptive analytics.
-Performed multiple regression to find the factors influencing the accidents for predictive analysis.
-And for the prescriptive analytics, used decision tree to find the 2 major factors contributing to accidents.
-We used several python libraries and tools to perform the analysis and visualize them.
Built a website (01/2019 – 05/2019)
-Designed and implemented the data modeling required to build the database for the website getrocketbook.com using MySQL.
-Also worked on creating a suitable UI using HTML.
2018 Movie Analysis (08/2019 – 12/2019)
-Analyzed the movies datasets to show the trends of budget, genre and the top grossed movies in the year 2018.
-We scraped the movies using beautifulsoup from imdb and performed the cleaning needed on the datasets to analyze the data.
-Create visualizations to get reasonable insights into the trends of the movies in 2018
Professional Experience
Texas State University, San Marcos, USA Jan 2019 – Dec 2020
Graduate Research Assistant
Conducted complex data analysis in support of management and customer requests. Involved in reporting statistical findings to work colleagues and senior managers using dashboards developed in Tableau.
Conglomerate IT – Hyderabad, India Aug 2015 – Nov 2018
Data Analyst
Gathered user requirements, analyzed, and designed solution based on the requirements.
Interacted with Subject Matter Experts, Business Analysts, and Data modelers to define requirement document and design processes for various data sources and reporting needs.
Worked on development of data warehouse, Data Lake and ETL systems using relational and non-relational tools like SQL, No SQL. Built and analyzed datasets using Python.
Built and published customized Interactive reports and dashboards along with data refresh and user level security by using Tableau Desktop.
Developed KPIs and Dashboards based on reports, spreadsheets, and charts.
Created and modified some of the existing reports and dashboards and implemented Tableau features like Filters, Groups, and Sets
Implemented ad-hoc analysis to create dashboards for timed reports like weekly, monthly, and daily basis.
Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
Developed key indicators and the appropriate tracking reports with graphical and written summations to assist in the quality improvement initiatives.
Created extracts, consolidated data and published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.
Implemented data mining, data cleaning, data collection, developing models, validation, visualization with the python using python libraries like NumPy, Pandas, Matplotlib.
Designed effective visualizations using Lines, Pies, Bars, Scatter plots, Heat Maps, Bubble charts, Bullets, Histograms, and highlight tables in python.
Used different Mark types and Mark properties in views to provide better insights into large data sets.
Used Data Blending, Groups, combine fields and aggregated fields, spotlight into compare and analyze data in different perspectives.
Experience in Creating, publishing, modifying, and managing tasks, utility, and performance on server.
Troubleshoot and fix user issues related to Tableau reports (underlying data or performance) by generating the dashboards and sheets.
Assisted in data modeling and design. Performed data cleansing and visualization on highly complex dataset in different formats and forms. Developed and implemented various analytics models including predictive model, clustering, and decision trees to evaluate marketing tactics impact.
Associate Data Analyst – Wipro, India Dec 2013 – July 2015
Performed ad-hoc reporting analysis as well as manipulate complex data on MS SQL server
Wrote complex SQL queries to retrieve data from disparate tables utilizing Joins, Sub-queries and used concepts like Explain, Stats, Cast and volatile tables on SQL server
Analyzed duplicate data or errors in data to provide appropriate inter-departmental communication and monthly reports.
Implemented data mining, data cleaning, data collection, developing models, validation, visualization with the python using python libraries like NumPy, Pandas, Matplotlib.
Used SQL and PROC SQL (SAS) for ad-hoc report programming and creation of the ad-hoc reports for marketing research data
Worked on development of SQL and stored procedures, triggers and functions on MySQL.
Created numerous Permanent tables, Volatile tables and Global Temporary tables
Wrote standard SQL Queries to perform data validation and created excel summary reports (Pivot tables and Charts)
Ensured that data warehousing design was scalable and maintainable.
Generated the weekly and Tableau reports and presented reports for Category Growth and P&L reports.
Contact this candidate