Data Analyst Science

Lavanya Telapudi

+1-660-***-**** *******************@*****.*** linkedin/Lavanya T github/Lavanya Telapudi EDUCATION

University of Maryland Baltimore County Baltimore County, MD Master’s of Professional Studies in Data Science; GPA: 3.96 January, 2022 - December, 2023 Chaitanya Bharathi Institute of Technology Hyderabad, India Bachelor of Engineering in Electrical and Electronics Engineering; GPA: 4.0 May, 2017 – May, 2021 PROGRAMMING SKILLS

Programming Languages: Python (OOPS, Pandas, NumPy, SOAP, REST, Matplotlib, SciPy, Scikit Learn, Seaborn, Stats model), R, HTML, CSS, MATLAB, SAS

Databases: MySQL, Oracle, MongoDB

Machine Learning: Scikit Learn, Regression (Linear, Logistic), Decision Trees, KNN, SVM, Random Forest, K-means Clustering, Neural Networks, Deep Learning, NLP, PyTorch, TensorFlow Big Data Technologies: AWS(S3, EC2, Glue, RDS), Hadoop, HDFS, PySpark, Apache AVRO, Hive, Databricks Data Visualization Tools: Tableau, PowerBI, SAS, Advanced Excel(VLOOKUP, pivot table, sorting) other Technologies: Git, Jenkins

PROFESSIONAL EXPERIENCE

Accenture Hyderabad, India

Data Analyst December, 2020 - January, 2022

• Collaborates directly with cross functional stakeholders [data engineers] to gather data, clean, transform and load metadata. Design and develop ETL process, transforms raw data, flat files, xl spreadsheets into SQL databases.

• Conducted time series analysis on historical financial data, utilizing advanced SQL queries and Python, to identify trends and seasonality patterns that informed marketing campaigns for targeted customers

• Created and maintained data visualizations and dashboards using tools like Excel and Power BI, allowing the team to track KPIs and identify trends

Aurora Solutions Hyderabad, India

Summer Intern April, 2019 - June, 2019

• Orchestrated collaborative efforts within the team to ensure precise data collection and meticulous analysis.

• Leveraged Excel with VBA to streamline data management and analysis. Applied macros to extract critical insights from extensive datasets, producing insightful reports for informed decision-making. ACADEMIC PROJECTS

Housing Market Data Analysis

• To give information about how the house prices have risen at record levels because of Covid-19 pandemic

• Designed and implemented a MySQL database, executed seamless data migration to Amazon RDS via AWS S3 leveraging AWS Glue pipelines.

• Created interactive data visualizations and dashboards using Tableau and communicated the results to the class and published a blog post on the project

Retention of players in the NBA Team for the upcoming year

• Presented findings and recommendations to improve player retention to a Basketball team

• Attained concepts like statistical learning, visualizing the variables in scatterplot matrix, familiarized with training and test data and overfitting.

• Achieved 92 percent accuracy using the Gradient Boosting Regressor with the given features Analysis on motor vehicles collision in NYC

• Big Data project loading over 2GB data using HDFS into cluster after converting data into parquet format

• Performed EDA using Spark, scikit-learn, Dask to generate insights by using UDF’s

• Predicted that Specific locations, such as intersections or zones, emerge as consistent collision hotspots. Song Lyric Generation using GPT-2 and LSTM

• Developed a chatbot that generates lyrics given an input genre

• Used GPT-2 and LSTM models for generating lyrics

• Converted the generated text to music

Contact this candidate