SruthaKeerthi Mylavarapu

ad4zpr@r.postjobfree.com 405-***-****

https://www.linkedin.com/in/sruthakeerthi-mylavarapu/ EDUCATION

Oklahoma State University, Stillwater, OK May 2024 Master of Science in Management Information Systems GPA: 4.0 Relevant Coursework: Programming for Data Science, Descriptive Analytics, Data Warehousing, Predictive Analytics, Health Care Analytics, Statistics, Risk Management.

Chaitanya Bharathi Institute Technology, Hyderabad, India August 2021 Bachelor of Engineering in Information Technology GPA: 3.5 TECHNICAL SKILLS

Programming Languages: Python, R, SQL, HTML, CSS, Bash, PowerShell.

Data Visualization Tools & Packages: Tableau, Power BI, Advance Excel, KNIME, Command Line, SAS Viya.

Operating Systems: Windows, Mac OS, Linux.

Data Architecture: MySQL, MS SQL Server (SSMS), SSIS(ETL), NoSQL (MongoDB), Azure AI fundamentals.

Other Skills: Communication Skills, Project Management, Teamwork, Decision making, Problem-solving, Leadership. WORK EXPERIENCE

Oklahoma State University, Stillwater, OK Jan 2023- Present Graduate Research Assistant, Data Analyst

Contributed to the enhancement of the OSU Doctoral Business Administration (DBA) website.

Transformed 20k+ student records into insights using Advance Excel (Pivot Tables, VBA) for academic year reviews

Leveraged SQL querying to extract and manipulate OSU Alumni data for seamless integration with Tableau, enabling interactive visualization. Delivered presentations based on resulting insights, facilitating informed strategic discussions.

Monitored website KPIs from Google Analytics and improved SEO ranking by 18 spots. Cognizant Technology Solutions, Hyderabad, India Aug 2021 – Aug 2022 Business Analyst

Led a real-time data project, analyzing dynamic data streams for immediate, actionable insights using PowerBI.

Validated data flow through data pipelines and designed optimized custom SQL scripts, reducing query time by over 16%

Created dashboards using Tableau for client's Business KPIs that reduced manual reporting work by 8 hours a week

Coordinated with executive leadership to communicate the insights, improving the sales of the client by 14%

Resolved ad hoc requests from businesses and delivered 100% SLA compliance by bringing down priority issues.

Implemented data governance practices and quality assurance measures for a 200K+ records database, utilizing SQL querying, statistical analysis, and Microsoft Excel for data cleaning, preprocessing, and visualization. Ensured data integrity and reliability, facilitating informed decision-making. Cognizant Technology Solutions, Hyderabad, India Mar 2021- Jul 2021 Business Analyst Intern

Utilized Tableau and Power BI to create interactive dashboards and reports, facilitating effective data visualizations.

Collaborated across teams to translate business needs into actionable data strategies. Utilized SQL, Python, and R to analyze large datasets, driving data-driven decisions.

PROJECTS

Global Energy Trends: A Comprehensive Analysis of Consumption and Production: Nov 2023

Analyzed and visualized global energy production and consumption patterns, emphasizing key sources like coal, solar & gas.

Created Tableau dashboards showcasing energy sustainability and consumption trends. Injury Severity Prediction- CRSS data by NHTSA April 2023

Joined and wrangled data of 200 columns and 0.5M+ records using KNIME

Evaluated Decision Tree, Random Forest, XGB, and ANN models to predict the injury severity with 78% accuracy. HealthCare Data Analysis for Patient Outcomes April 2023

Led analysis of patient demographic and treatment data using Python and SQL. Developed impactful Tableau visualizations to optimize patient outcomes and inform resource allocation strategies. Sentiment Analysis on House of the Dragon Show. Nov 2022

Led sentiment analysis project on audience reviews for HBO Max's 'House of the Dragon', influencing script enhancements for series success and potential multi-season extension. Analyzed viewer sentiments from social networks and media reviews. CERTIFICATIONS

Tableau Desktop Specialist Issued by Tableau, Python for Data Science, AI & Development Issued by IBM Data Analysis with R Programming Issued by Google, Advanced Excel Essentials for Data Analytics Issued by Coursera