Operations Data Intern

Sanket Mandare

** **** ******, ****** ****, NJ **306 551-***-**** *********@*****.*** www.linkedin.com/in/sanketmandare/ EDUCATION

Pace University, Seidenberg School of CSIS, New York, NY August 2015 - May 2017 Master of Science in Information Systems

University of Mumbai, PVPP College of Engineering, Mumbai, India February 2010-June 2014 Bachelor of Engineering in Information Technology

TECHNICAL SKILLS

Programming Languages: SQL, Python, VBA, Perl, PHP, HTML5, CSS3

Database Knowledge: MS SQL Server, MS Access, MySQL, Oracle 11g

BI and Analytics: Tableau, IBM SPSS Modeler, IBM Watson, XLSTAT

Library and Packages: NumPy, Pandas, Selenium, BeautifulSoup, urllib, matplotlib, seaborn, ggplot2

Tools Microsoft Excel, Salesforce, Toad, Star UML,Arc GIS, Microsoft Visual Studio, MS Visio Certifications: Salesforce.com (SFDC) Level 1 certified by Cloud coaching international National Computer Science Academy certified in SQL (cp-207) and MS Excel Big Data University Certified in Python, NoSQL and Dbaas WORK EXPERIENCE

Operations Data Intern, Interactive Advertising Bureau (IAB) October 2017-Present

Worked with Operations and Investment & Relations team to administer and regulate data quality and data Integrity

Supervised weekly membership data and ensure adherence to IAB’s data governance entry policies in Salesforce

Built and maintained data driven excel files shared between vendors and operations team within the company

Evaluated current processes and developed then integrated automation improvements using python for reporting

Architected SQL queries in toad to fetch data and Tableau to design template grids to control and improve workflow

Analyzed the vendor’s participations in different C&C’s and targeted top 75 accounts with maximum participation

Designed and built various dashboards in tableau for executives to recognize top 10 membership participations in events

Provided key insights to the team to develop and modify the interface to provide best user experience to sales team Data Analyst, Onshore Constructions Company Pvt. Ltd July 2014-June 2015

Conducted data clean up and data preparation on clients’ supplied data to monitor its completeness and accuracy

Worked with cross-functional departments to provide data driven analytics in form of ad-hoc reports using MS Excel

Built easy to understand dashboards and reports which aid decision making and organization strategy development

Performed market analysis to meet the objectives effectively, saving inventory by 2% supporting the overall business

Designed dashboards in Excel to analyse and provide insights for the ongoing projects based on historical patterns PROJECTS

Personal Prime Time: Tableau

Cleansed over 2000+ records collected through IAB’s Research and Survey to determine the pattern of entertainment and undermine the prime time concept across United States

Analysed personal preference for different categories of entertainment on multiple attributes on sample population

Build multiple dashboards to be presented to vendors to help them use the insights to enhance the business effectively Data Integration Automation Project: Python

Created a data integration system to increase goals and sales for the sales team to expand new set of opportunities in the growing advertising market for IAB

Designed an automated workflow for the membership data from partners using Python, Salesforce and Excel

Automated the reporting process by designing an application that would send out reports on weekly basis Juvenile Crime in New York: Arc GIS

Cleansed and filtered the juvenile crime data in New York for recent years to create maps using various GIS techniques

Identified which areas of New Yok are most affected by comparing it using two data frame technique and created buffer to show how many youth detention camps are present in respective areas

Created multiple layers to check if there is any pattern between crime, divorce rate and number of schools in the areas

Contact this candidate