Sowjanya M Nimmagadda
+1-224-***-**** ********@***.*** www.linkedin.com/in/sowjanyanimmagadda
Result driven Analytics professional with experience in retail, banking and manufacturing sectors seeking a position where background in data analytics can drive innovative decision making and performance optimization.
Education
M.S. in Business Analytics, W. P. Carey School of Business, Arizona State University GPA 4.0/4.0 May 2018
MBA (Operations and Finance), IPE, Osmania University, India GPA 3.8/4.0 May 2013
B. Tech in Computer Science & Engineering, Acharya Nagarjuna University, India GPA 3.8/4.0 April 2011
Professional Qualifications
Statistical Modeling
Data Mining
Data Visualization
Data driven Quality Mgmt.
Marketing Analytics
Enterprise Data Modeling
Optimization Modeling
Agile Methodology
Machine Learning
Business Intelligence
Software: SAS, R, Python, SQL, Tableau8, SPSS, Hadoop (Pig/Hive/Storm/Kafka(intermediate)), MapReduce, Java, C, C ++.
Microsoft Office: Advanced Excel, VBA, PowerPoint.
Statistical Modeling, Financial Analysis, Forecasting.
Professional Experience
Intern – Advanced Analytics, PetSmart, Phoenix, AZ Jan’2018-Present
Analyzed the store level data from 1500 stores all over the United States, Canada and Puerto Rico to recommend business solutions from the trends and events related to sales of categorical products.
Developed the Key Performance Indicators for store level performance.
Performed Exploratory data analysis to understand the dimensions of the acquired data using Excel, Tableau, Power BI.
Clustered the stores based on % comp sales and % comp sales using SAS and R.
Built linear regression model to identify the drivers of store performance in SAS and R.
Used statistical techniques for hypothesis testing to validate data and interpretations.
Scale II Officer- Business Analyst, Karur Vysya bank, Chennai, India Apr’2013-Sep’2014
Spearheaded Project Appraisal to analyze the feasibility of a project by assessing market, technical, financial, promoters and risk aspects involved in the project and approved 27 successful projects worth 2.5 M.
Performed Regression Analysis on the log data of CDM machines and provided recommendations which improved the performance by 54%.
Worked with digital technology team to extract and clean the data using SQL to support dual testing with real-time customer information & credit report data from current product user database for a new product launch.
Developed regular business reports and summaries on Non-Performing Assets to the senior management using Data visualization tool Tableau.
Management Trainee, National Thermal Power Corporation, Ramagundam, India Aug’ 2012 – Feb’2013
Analyzed inventory and waste which resulted in cost cutting on future orders by 25%.
Developed quarterly inventory dashboards to present to the senior management using Excel.
Intern, Analyst, State Bank of Hyderabad, India Jan’2012-Jun’2012
Prepared reports based on the findings from analyzing credit data to make decisions on lending to reduce risk of the bank.
Automated all the daily and monthly report generations using a combination of Macros, Excel, MS Query and SQL; saved 2 – 4 hours of daily manual work.
Academic Projects
Developed predictive models for fraud detection, target marketing, customer churn prediction and employee attrition using Decision Trees, Regression analysis including feature engineering and data preprocessing with Python,R and SAS.
Generated clusters for finding grocery items consumption across different regions & channels to find out consumer’s annual spending pattern using K-Means & Kohonen Nets on SPSS.
Created relational model & ER diagrams for processes, used them for database handling and implementing with MySQL
Visual stories through interactive dashboard using Tableau and SQL, logistic regression models using Python and SAS
Designed optimization models and other analytical decision models using Excel Solver Table, StatTools, Precision Tree.
Built recommendation system on amazon metadata using social network analysis & Sentiment analysis on twitter data.
Process Improvement-Chess Emporium, Scottsdale, AZ Aug’2017-Dec’2017
Developed and implemented process improvement plan (DMAIC) which increased customer retention by 60%.
Developed standard communication procedure which improved the employee communication log by 70%.
Community Involvement
Founder and President of ‘SAMSTHAPANA’, a non-profit organization focused on helping students in schools in villages in Andhra Pradesh, India.
Ran crowdfunding campaigns and collected INR 600,000 for the cause of the organization.
Volunteered in Feed My Starving Children-NGO in Mesa, Arizona for packaging 19,224 meals costing to $4,229