Data Python

Sushmitha Kallur Raju

***************@*******.*** 469-***-**** https://www.linkedin.com/in/sushmithakallur/ EDUCATION p

The University of Texas Dallas, M.S, Business Analytics August 2018 - May 2020 BMS College of Engineering, India, B.E, Telecommunications August 2012 - May2016 SKILLS

Database Technologies- MSSQL, MySQL, PL/SQL, Oracle, SAP

Programming- R, SAS, Python, HTML, CSS, Java

Visual Analytics- Tableau, Alteryx, Power BI, QlikView, ArcGIS

Advanced Excel- VBA Macros, VLOOKUP, Pivot tables

Statistical Techniques- Hypothesis Testing, Regression Analysis, Time Series Analysis, A/B Testing

Machine Learning Algorithms- Linear Models, Decision Tree, SVM, PCA, Clustering, Random Forest G

PROFESSIONAL EXPERIENCE

Volvo Group, Macungie, PA- Material Handling Analyst Intern January 2020 - Present

Collaborated with data engineers to implement robust floor operations analyzing SQL data affecting 20% production

Improved lead data tool used for locating materials of 100+trucks daily through ETL process of backend databases

Communicated yearly trends of missing parts to leadership on PowerBI KPI dashboard defining long term solutions The Walt Disney, Florida- Trade Compliance Analyst Intern September 2019 - December 2019

Facilitated system automation for predicting duty rates via Java backend framework improving sourcing plan by 5%

Designed real time Tableau dashboard using SQL server to improve technical capabilities across 5 business divisions

Auto populated spreadsheet dropdown stakeholder list using VBA macros reducing manual activity by 2 hours daily

Developed drawback duty app to debug complex system integrations using Python accounting for over $0.5M/year Motorola Solutions, Chicago-IT Supply Chain Analyst Intern May 2019 - August 2019

Validated weakness of proposed metric using R hypothesis testing contributing to 7% of false failures cancellations

Implemented scalable data pipeline using SQL database to tackle stakeholders missed monthly promise dates

Optimized On Time Delivery metric using Python reducing 3 days of labor hours and expedited through large data

Performed descriptive analytics to eliminate 9% of redundant data to support decision making across different teams Accenture, India-SAP Consultant November 2016 - June 2018

Aggregated data from SAP modules supporting ad-hoc use for client and address stakeholder due diligence

Optimized client invoice layout by altering currency using Open SQL reducing client exchange rate by 7%

Collaborated with different teams to develop SOPs for client ticketing system resulting 10% workflow efficiency

Improvised operational quality by 5% using SAP Ariba making strategic sourcing decisions for the client ACADEMIC PROJECT

Database Management using SQL server- Customer Sales for diverse coat brands

Normalized database and performed SQL server analysis on coat brands to forecast sales using Excel and R Data Visualization Using Tableau- Suicide rates in India

Web scrapped data using Python and integrated R with Tableau to get insights on suicide patterns and its causes Business Analytics with R-Analysis on Olympics History

Visualized data by performing data wrangling using R and predicted results of Olympics using logistic regression Predictive Analytics using SAS - Statistical Analysis on Consumer Goods

Merged panel datasets to perform hypothesis test and regression to predict market shares of top diaper companies Machine Learning - Prediction of Fraudulent firm

Preprocessed audit dataset and analyzed regression/classification models to help audit firm predict possible frauds

Contact this candidate