Yaswanth Srinivas Chowdary Gottipati

469-***-**** • ad4gox@r.postjobfree.com •

SUMMARY : Success driven analyst with a track record of providing analytical support for diverse business and data projects seeking a position at a reputable company. 5 years of diverse experience in different technologies including developing data pipelines, visualization(tableau), Big data.

EDUCATION:

The University of Texas at Dallas 2021-2022

Richardson, Texas

Master of science in Information Technology and Management CGPA: 3.6

R.V.R & J.C college of Engineering 2014-2018

Guntur, Andhra Pradesh, India

Bachelor of Engineering in Electronics and Communication engineering GPA:3.7

TECHNICAL SKILLS :

Programming Languages : Python, SQL, HTML, CSS.

Web Technologies : HTML5, CSS3

Databases : MySQL (Advance) and NoSQL, MongoDB, Hadoop, Oracle 11g, GTECH

Tools : Power BI, Tableau, MS Excel programming, MS Office, Visual Studio, UiPath, MS Visio, Visual Paradigm, SAP LOGAN, Apache Hadoop, Apache Spark, Hive,Impala, WKafka.

Environment : AWS (EC2, Lambda, S3, SNS, Elasticsearch)

VensaTek LLC, Prosper Mar 2023 -Present

Data Analyst

Prepare and present detailed reports and visualizations to communicate findings to non-technical stakeholders.

Develop data-driven initiatives with cross-functional teams to enhance business operations.

Identify patterns, and anomalies by doing in-depth analysis on huge datasets.

Collaborated with team members to improve data quality and accuracy.

Completed the given tasks within the time and submitted as per the client requirements.

Experienced the creating visualizations using tools like Tableau and became Familiar with database systems, including MySQL.

Develop and maintain database objects and ETL to support data preparation for Tableau reports, dashboards, scorecards, and Self-Serve analytic capabilities.

Accenture, Chennai Dec 2017 – Sep 2020

Associate Software Engineer

Automated SQL queries for GIS and GTECH reports, resulting in a 50% reduction in report generation time. Conducted thorough unit testing to verify enhancements prior to production deployment.

Designed and developed two applications using Java and conducted system analysis using SQL.

Developed GIS and GTECH reports using Oracle SQL developer, providing accurate and timely information for tracking the details of damaged server boxes.

Excels in requirement gathering, Analysis, Configurations, Functional and Technical specifications documentation in addition to planning and developing creative ideas according to client requirements.

Client: Itline24 Technologies, India Mar 2017 – Aug 2017

Data Analyst Intern

Developed an application using SQL to automate the comparison of the files from production and development environment to populate the differences.

Managed database connectivity for querying, inserting, and data management, including triggers and stored procedures, resulting in improved application performance.

Developed a web application using HTML, CSS and implemented create, update and delete operations using SQL.

Worked closely with the development team to identify and resolve issues, contribute to the successful deployment of the application.

Designed the Database of the E-commerce website using SQL: Jan 2021

•Developed an Entity Relationship Diagram (ERD), a Relational model, and normalized to the third normal form (3NF).

•Designed and utilized stored procedures to search for a given product in the database, enhancing search efficiency.

Employee Management System Using Python: Jan 2021

•Constructed an employee database and an application using Object-Oriented Programming (OOP) concepts to allow users to manipulate employee data easily.

•Utilized Python libraries such as SQLAlchemy to interact with the database.

Designed a Diet Plan Website: Aug 2021

•Developed an integrated application called "Smart Diet" that uses a database to allow users to record their daily food intake and provide recommendations on the amount and category of food they should consume to reach a particular weight category.

•Created the backend using Python, SQL, and Flask web framework.

Analysis on Tableau Stories: Aug 2021

•Designed a story on Tableau analyzing the impact of COVID-19 and vaccination in the G20 countries.

•Utilized Tableau's data visualization features to provide insights into the pandemic's spread, vaccination rates, and the impact of these on the economy.

Online Doctor Appointment – HTML5, CSS3, SQL: Jan 2022

•Developed a web application that allows patients to book appointments, view their medical records, and make changes to their appointments.

•Implemented user authentication, the ability to add and delete doctors, and view weekly schedules.

•Utilized SQL for data storage and retrieval.

Analyzing Twitter Sentiment Using Apache Hadoop and Apache Spark: Jan 2022

•Built a data pipeline using Apache Hadoop and Apache Spark to collect tweets related to a specific topic using the Twitter API and store them in Hadoop Distributed File System (HDFS).

•Analyzed the sentiment of the tweets using Apache Spark's Machine Learning Library.

Risk Analysis of ANT Truck Company (Big Data Project Hadoop Hive/Impala PySpark Tableau): Aug 2022

•Loaded data into Hadoop Distributed File System (HDFS) and created tables using Hive/Impala and pig script.

•Developed an interactive and efficient dashboard in Tableau, capturing all statistical parameters of drivers and trucks.

•Utilized PySpark to implement Logistic Regression for multiclass classification to predict the accident type with 96% accuracy.

•Built Lasso and Linear Regression models to determine the risk factor of drivers with R-squared scores close to 88%.

Business Intelligence and Analytics using Tableau: Aug 2022

Generated advanced Tableau dashboards with quick/context/global filters, parameters and calculated fields that allowed to understand the amount of Greenhouse gases emitted globally.

Created vivid visuals to understand the countries responsible for emissions on a large scale.

COURSEWORK:

Data management, Statistic and data Analysis, Object Oriented programming in Python, System analysis and project management, Data Visualization, Spreadsheet Modelling, cloud computing, Programming for Data Science.

Eligibility:

Eligible to work in the US for internships and full-time for up to 36 months without sponsorship and can work currently under OPT for 40 hours.

PROFESSIONAL EXPERIENCE:

ACADEMIC PROJECTS:

Contact this candidate