Data Analyst and Business Intelligence

HARDIK JHAVERI

**** ****** ***** #** ***********, MD 20783 301-***-**** ********@***.***

EDUCATION

University of Maryland, College Park – Master of Science, Information Management (GPA: 3.83) May 2017 Specialization – Data Analytics and Strategic Management Coursework – Statistics, Data Science, Business Intelligence & Modeling, Data Visualization, Decision Analytics, Information Audit University of Mumbai, Mumbai, India – Bachelor of Engineering, Information Technology (GPA: 3.7) May 2015 TECHNICAL SKILLS AND CERTIFICATION

■ Analytics: R, Python, SAS 9.1, IBM SPSS, Rattle ■ Data Visualization: Tableau, D3.js, Keshif, QlikView

■ Database: MySQL, SQL Server, Oracle, PostgreSQL ■ Web Technologies: HTML, JavaScript, CSS, PHP, Drupal

■ Tools: MS Office, MS Visio, MS Project, StatTools, UML, JIRA ■ Programming Languages: Java, C++

■ Certified in Business Analytics specialized in Customer, Operations and People Analytics from Wharton School of Business, PA PROFESSIONAL EXPERIENCE

Marketing Data Analyst, Clarice Smith Performing Arts Center, College Park, MD Aug. 2016 - Present

Conducted qualitative surveys and focus groups to analyze demographic data and implement CRM strategies based on feedback

Generated dashboards on Tableau and ad-hoc reports in SQL based on monthly budget status to assist financial planning and control

Computed key performance indicators in SAS to recommend strategies growing customer acquisition by 15% and evaluate targets

Conducted SWOT and PESTEL analysis to identify new business opportunities and potential risks to improve campaign performance Software Developer Intern, EMC Corporation, McLean, VA May 2016 – Aug. 2016

Analyzed client specifications to build functional requirements document and work flow diagrams in Agile Scrum team

Designed a proactive Enterprise Risk Management Software based on principles of NIST 800-37 Risk Management Framework

Developed an interpreter in Java to extract data from XML and JSON files and create objects for assessing security settings

Tested security settings of diverse assets against compliance regulations of PCI, HIPAA and other customized specifications

Integrated interactive dashboards using Tableau to report risk score to manage vulnerabilities before threats escalate

Engineered a remote execution environment using Saltstack to deploy the software; downsizing operation time by 20% Data Analyst Intern, Palsan Business Services, Mumbai, India Apr. 2014 – Jun. 2014

Promoted sharing and maintainability by creating a normalized sales MySQL database with stored procedures and triggers

Created an ETL tool in Python to collect and collate unstructured data from multiple sources to create data warehouses and marts

Developed a model in R to classify users based on shopping trips; performed market basket analysis with 92.4% accuracy

Designed dashboards using Tableau to visualize key findings and identify trends; increasing overall sales by 20% PROJECTS

Consultant, Coursalytics: Using Crawler, NLP and analytics to discover insights

Gathered requirements from CTO to develop system architecture using scope, design, process flows and non-functional requirements

Applied Natural Language Processing techniques on unstructured text to factor into algorithmic decisions and make predictions

Performed inferential and causal data analysis to identify patterns affecting user’s careers and increasing company’s user base Volunteer Research Assistant, Digital Curation Innovation Center: Human Face of Big Data

Built a geographical web application using Leaflet JavaScript to explore historical data about Asheville’s urban renewal project

Identified user stories to design conceptual prototypes and mock ups for user interfaces by evaluating data patterns

Modeled a PostgreSQL database and formulated SQL queries to support back-end functionality for filters and data entry screens Data Mining and Predictive Analytics: Predicting Hotel Ratings

Analyzed TripAdvisor dataset of 100,000 rows and built a recommendation engine to predict customer preferences

Applied machine learning algorithms like Naïve Bayes, Random Forest, Regression and Clustering achieving accuracy of 96.3% Data Visualization: Washington DC Crime Investigation

Analyzed relationship between various crimes, its time and location to discover hidden insights by finding patterns in data

Visualized live data to create Dashboards on Tableau incorporating storytelling maps, animations, networks, and temporal graphs Social Media Analysis: Privacy Settings on Facebook and Twitter

Performed ETL process, t-test analysis and ANOVA using SPSS to study how privacy settings affect social network

Designed dashboards and reports in ggplot2 to visualize data analysis, strategic insights, pinpoint correlations and dependencies PUBLICATIONS

Cloud Computing: Emergence, Evolution and Future in India IJSER: ISSN 2229-5518 – Volume 005 Issue 6

Database Management: A Performance and Tuning Perspective IJCIT: ISSN 2279-0764 – Volume 003 Issue 5

Contact this candidate