Social Media Data

Saurabh Ladhe

*** **** *****, *** **, Boston, MA, 02215 857-***-**** ************@*****.***

https://www.linkedin.com/in/saurabh-ladhe

EDUCATION

Northeastern University, Boston, MA 05/2018

Master of Sciences in Engineering Management, GPA: 3.6 Relevant Courses: Business Intelligence and Data Warehousing, Database Management and Design, Data Mining and Machine Learning, Data Collection, Storage and Retrieval techniques, Project Management, Operations Research, Engineering Probability and Statistics

University of Pune, Pune, India 05/2015

Bachelor of Engineering in Mechanical Engineering, GPA: 4.0 TECHNICAL SKILLS

Languages: SQL, R, Python (NumPy, Pandas), MDX, DAX, MATLAB Databases: MS SQL Server, MySQL, PostgreSQl, Oracle SQL 11g, MongoDB, AWS (S3, Redshift, RDS) Tools: SSIS, SSRS, SSAS, Talend, Alteryx, Qlik, Tableau, PowerBI, Looker, MS Visio, Toad EXPERIENCE

Project Consultant: Analytics – Search Engine Optimization 01/2018 – 04/2018 Intelli Bookkeeping, Boston, MA

• Conducted Keyword Research for and improved company’s domain rating by using Ahrefs

• Analyzed organic, referral and social media web traffic using Google Analytics to track project success

• Improved social media and referral traffic by managing backlink contacts through Hubspot CRM Industrial Engineer 06/2015 – 04/2016

Ratna Industries, Pune, India

• Converted customer’s specifications into technical design for production

• Conducted time studies and cost analysis for cost and time optimization

• Analyzed and forecasted inventory stock requirements and weekly work/machine hours suing Excel

• Negotiated with outside vendors for contracts and deliveries PROJECTS

Data Warehouse Design and Business Intelligence Reporting for a Retail Company 09/2017 – 12/2017

• Designed a dimensional model with star schema for a data warehouse that integrated data from various sources

• Performed data profiling to create DW Bus and Integrated the data using various ETL processes in Talend

• Created calculated fields, pivot tables and defined hierarchies in Tableau and Qlik Sense

• Designed insightful dashboards and reports with heat maps, charts, filters and drill down features for analysis

• Performed market trend analysis with respect to customer demographics such as age, education and location Design and Implementation of a Relational Database for an Health Insurance Company 01/2017 – 04/2017

• Designed a health insurance database to store hospital, patient, and claims data along with CPT and ICD-9 Codes

• Visually presented the database model in an E-R diagram by using Toad Data Modeler

• Created the database in MS SQL SERVER using various queries to define tables, constraints, stored procedures

• Populated the database with sample data by using various packages and data flows in SSIS

• Designed a front-end website to enable administrators’ access and management of the database Analyze Major League Baseball (MLB) data with R 01/2017 – 04/2017

• Determined which score statistic affects team’s success by using regression analysis on past score data

• Scraped the data using a MLB API and cleansed the data using dplyr and stringr packages

• Stored the data in a relational database by using RSQLite package and created visualizations using ggplot2

• Calculated Pearson’s correlation coefficient using stats package and concluded that RA/G was most important Analyze Boston Logan Airport traffic data to determine future expansions requirements 09/2016 – 12/2016

• Conducted time series analysis on massport.org traffic data to determine trends using Excel

• Performed regression and hypothesis testing on the data for model fitting

• Calculated predictive flight traffic for next 10 years with a 95% confidence interval

• Concluded that 2 new international terminals will be required for handling future traffic needs

Contact this candidate