SHILPA RANJAN

+1-617-***-**** ada60v@r.postjobfree.com LinkedIn GitHub

EDUCATION

Northeastern University, Boston, MA April ’18 – Dec’19 Master’s in Data Science/Analytics (Concentration: Statistics/Statistical Modeling) Centurion University of Technology & Management, Bhubaneswar, INDIA June ‘09 - May ‘13 Bachelor of Engineering in Electronics and Communication Engineering PROFESSIONAL EXPERIENCE

Business Intelligence, Analyst Engineer, Virtustream (A DELL Technology Partner), Boston, USA July ’19 – Aug ‘19

● Automated Cloud Capacity Consumption using ETL that results in better visibility of business from weekly to daily basis

● Developed script to automate data collection from multiple DPA (Data Domain Analyzer-16), resulted in saving licensing cost

● Performed Time series analysis ( ARIMA) and forecasting using the VMware tool – Wavefront, setting alerts, predictions SENIOR Data Analyst, TO THE NEW, India May ’17 - Dec ‘17

● Created reports and KPIs dashboards for Ecommerce & Cab domain projects using Tableau, SQL

● Reporting using Google Analytics and Tableau to create powerful data visualization for a government project (India)

● Responsible for documentation and prioritizing backlog and communicating priorities to clients/Stakeholders

● Performed data analysis, data mining and cleaning to support business decisions using python ML algorithm Data Analyst, TO THE NEW, India Feb’ 14 - April’17

● Performed Automation of ecommerce (American Swan) web application using Selenium IDE and Web-Driver (Java) which resulted in saving the 90% of the time for smoke and usability testing scheduled prior deployments

● Responsible for API Management and API testing using Postman and SOAP API resulted in catching the root of the error

● Implemented and followed Agile Scrum methodologies within the cross-functional teams of BA, designers, QA, and developers.

● Managed requirement gathering, reduced production issues/ errors and minimized errors by almost 25% per year Software Trainee, Magic Software Pvt. Ltd, India Oct ‘13 - Jan ‘14

● Created complex SQL queries to fetch details of women all across India for a campaign for vaccination and disease cure.

● Analyzed Government project data analysis using Advance Excel and SQL for detailed analysis of patients and campaigns TECHNICAL SKILLS

Data Analytics: Data Integration, Exploratory Data Analysis, Data Modeling, Financial Analysis, Database Design, Data Mining, Predictive Analytics, Patterns/Trend Identification, Data Visualization, and Quantitative Analysis, Business Analysis, Business Forecasting, supervised/ unsupervised learning Machine Learning: Classification, Regression, Logistic, Random Forest, Clustering (K- Mean), Decision Tress Languages: R, Python, SQL, Java (Beginner)

Tools & Packages: RStudio, Eclipse, Anaconda, PyCharm, SAS, Google Analytics 360 suite, Wavefront (Time series Analysis) Database, DW/BI: MySQL, SQL Server, Apache Spark, Tableau, MS PowerBI, Advanced Microsoft Excel, Dell Boomi Interpersonal: Problem Solving, Strong Analytical Skills, Critical thinking, Result/Solution-Oriented, Time Management, Strong work Ethic, Leadership, Collaborations, Team Oriented. ACADEMIC PROJECTS

LifeStory heath, Inc. [Dashboard creation/Healthcare Analysis using RStudio and R Shiny]

● Data mining sponsored project-developed an interactive dashboard using R shiny where charts/health graphs of patients can be analyzed to find visual differences and compares mass spectrometry for reporting purpose Twitter Data Analysis Using Cloudera [Sentimental Analysis]

● Used Apache Flume to gather Twitter live streaming data, Apache HDFS to design an end to end data pipeline that helped to analyze twitter data. Figured out the most retweeted users and the count of tweet and retweets in a specific period using HIVE Viacom Social Demo Targeting [Data Analysis/Financial Analysis using Tableau/ Python]

● Viacom sponsored project-performed detailed exploratory data analysis, regression modeling, analyzed the pricing strategy offered by company demographically, profit and loss in the regions, etc.

● Surprising result was the Impressions of female age range 18-34 are more active than male and hence suggested Viacom on this PUMA Strategy planning Project [Using Tableau and Predictive modeling using Python]

● Puma sponsored project, designed a predictive model to suggest a location in Midwest USA to guide puma opening a new store and help in making strategic decision making

● Designed a dashboard using Tableau to show details of number of orders in a specific geo location, sales, returns, rating of stores, etc. on monthly, quarterly and yearly basis

Rain Prediction [Using Python, Baseline model, Feature Engineering]

● Analyzed performance of different baseline model and chosen Random forest as my best model after optimizing. There was change in AUC (Area under curve) from 84% to 88%

● Applied Feature engineering (one hot encoding technique) to select the features in the model until it works perfectly

Contact this candidate