Data Analyst

SRUTI BOTADRA

South Plainfield, New Jersey 848-***-**** *****.*******@*****.*** www.linkedin.com/in/srutibotadra EDUCATION

Rutgers University, Master of Information Technology and Analytics (Dec 2019 / GPA:3.8) A lifetime member & Honoree of Beta Gamma Sigma (BGS), for being recognized as one in Top 20% of graduate students at Rutgers University.

New Brunswick, NJ

University of Nottingham, Master of Science in Information Technology (Sept 2013 / GPA: 3.6) Nottingham, UK

University of Mumbai, Bachelor of Science in Information Technology (June 2012 / GPA: 3.6) Mumbai, India

SKILLS

• Analytical Programs: SQL, Python, R, Tableau, Jupyter Notebook, AWS, Microsoft Excel, Google Analytics, Shiny(R), matplotlib/ seaborn (Python), ggplot(R), Plotly, VBA, Microsoft Access, Visio

• Real world experience with: Exploratory Data Analysis, Time Series Analysis, Forecasting, Classification, Regression, Neural Network Models, Decision Trees, Text Analysis, Advanced Predictive & Prescriptive Analysis, Processes in Agile

• Soft Skills: Analytical skills, Problem-Solving, Research-Oriented, Team Player, Management, Consulting, Leadership RELEVANT PROJECTS

Text Mining Yummly Kaggle Competition

• Predicted which country a recipe is from, given a list of ingredients in the form of json files

• Performed data pre-processing methodologies using text mining & Natural Language Processing techniques like WordStemming & DocumentTermMatrix

• Obtained results with 79.8% accuracy by performing text mining algorithms like XGBoost, Naïve Bayes and implementing Keras Embedding Layers

Business Intelligence Projections Coffee Chains of U.S.

• The dataset was a combination of a coffee chain sales data and market research of leading coffee chains as well as consumer sentiments. Task was to analyze the business requirements and target a location where the next franchise can benefit the business

• Created Tableau dashboards to project performance of leading coffee chains in the U.S. thus, answering key business questions for a new outlet

Demand Forecasting Life science Industry

• Performing Ad-hoc analysis and reporting to understand the business revenue and performance of this medical device manufacturing company to re-design the processes and strategizing the resources for operational excellence

• Analyzed sales reports and asset allocation reports to suggest business enhancements

• Translated trends & seasonality using statistical models like ARIMA, Naïve Bayes, Holt’s Winter models for better forecasts to achieve up to 98% accuracy in forecasts driving production operations & inventory management Credit Risk Analysis Lending Club

• In case of Peer-2-Peer lending, it is very important for the investors to understand the risk categories of customers that they are investing in, the potential of defaulters and pre-payment risk. This analysis helps the investors in decision making for granting loans

• Predicted the rate of defaulters using the data from 2007-2019 classifying borrowers using Random Forest & Decision Tree algorithms

• Implemented an industry specific keystone analysis to help the investors identify Pre-Payment risks from the types of borrowing applications

Predictive Analysis Commodity Market Demand

• Estimated the flow of commodity over different regions in the U.S by executing data wrangling from a pool of information

• Conducted Logistic Regression, Tree Classification & Random Forest methods using Python & R to predict associated market demand WORK EXPERIENCE

Data Scientist Intern NJTech Inc. New Jersey

• Built ETL pipelines and data transformation tasks, scripting using Python

• Exposure to implementation of feature engineering: discretization, binning, data wrangling, cleaning, transforming, merging and reshaping data frames prior to ML predictions

• Analyzed and tracked KPIs & market trends using visualization dashboards in Tableau and created ad-hoc reports

• Environment: Jupyter Notebook, PySpark, MySQL, AWS, Tableau, MS Excel Solutions Engineer Augnix Technologies Mumbai (India)

• Directed a cross-functional team delivering comprehensive commercial solutions based on client requirements, fostering long-term client relationships

• Spearheaded projects across diverse industry verticals serving as primary liaison between Business, Architecture, Development and Testing teams throughout the project life cycle. Following are some notable project contributions-

• Developed a Procurement & Inventory Management module to integrate with back-end ERP system

o Shadowed end-users in organization to analyze and design processes facilitating sourcing and inventory planning

o Significantly improved performance upto 45% by optimizing the processes and tuning the complex SQL

• Conceptualized systematic design layouts for Fund Investment platform facilitating easy information, fund analytics, assessing fund ratings for one of the largest Financial Services Firm in India

o Closely involved in information architecture and visualization designs to provide engaging statistical charts

• Architected CRM modules to facilitate broadcasters to manage FMCG PRO and other customers on one platform

o Developed user stories and training material for data normalization, data trending and cleaning

o Used Agile Management Methodologies to determine best practices for processes achieving accuracy up to 70%

• Built an Android Application (Java programming) seamlessly connecting 30K+ traders on a Diamond Trading Network

o Coordinated with stakeholders to conduct need finding, creating information architecture schema and developing a marketplace to simplify more than 1million daily diamond listings

• Environment: MySQL, SQL Server, Android Studio, Tableau, MS Excel, MS Visio, Agile/ Scrum Methodologies

April 2020- Present

Oct 2013- Dec 2018

LEADERSHIP

• Established a close focus group along with 25 micro- IT business owners for networking and referrals in Mumbai (India), boosting the revenues upwards by 15% on a yearly basis

• Managed city-level events organized by Headstart Network Foundation helping 50+ early stage startups towards growth & sustainability

Contact this candidate