SHILPA RANJAN

+1-617-***-**** adbmtg@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 (5+ Years of experience in Data Analytics field) Business Intelligence, Data Engineer, Virtustream (A DELL Technology Partner), Boston, USA July ’19 – Aug ‘19

● Automated Cloud Capacity Consumption using ETL(python) that results in business visibility 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, KPIs, dashboards for Ecommerce, Insurance & Cab domain projects using Excel, Tableau & SQL

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

● Responsible for documentation and prioritizing backlog, presentations, communicating priorities to clients

● Performed data analysis, data mining and cleaning to support business decisions using python ML algorithm

● Used SQL to integrate data from multiple data sources, analyzed data to show statistics and other information

● Worked with other team members on report automation and the overall data plan to support future reporting needs 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

● Experienced in combining data from multiple sources and analyzing large sets of data (Big Data Processing)

● Ability to effectively communicate analysis to wide variety of audiences; ability to storytelling driven by underlying data analyses.

● 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 data 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 warehousing, Data Mining, Predictive Analytics, Patterns/Trend Identification, Data Visualization, Quantitative Analysis, Business Analysis, Business Forecasting, supervised/ unsupervised learning Machine Learning: Classification, Regression, Logistic, Random Forest, Clustering (K- Mean), Decision Tress model Languages: R, Python, SQL, Java

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

Viacom Social Demo Targeting [Data Analysis/Financial Analysis using Tableau/ Python]

● Viacom sponsored project-performed detailed exploratory data analysis, quantitative 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, also delivered a Tableau dashboard showing profit, loss, page impressions (Organic or paid), trends for CPM (Cost per Thousands) PUMA Strategy planning Project [Using Tableau and Predictive modeling using Python]

● Puma sponsored project, designed a predictive model (Random Forest and K Means clustering) to suggest a location in Midwest USA to guide puma opening a new store and help in making strategic decision making

● Designed a dashboard to show details of orders in a specific geo location, sales, returns, rating, etc. on quarterly and yearly basis LifeStory heath, Inc. [Dashboard creation/Healthcare Analysis using RStudio and R Shiny]

● Data mining sponsored project-developed an interactive dashboard 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