Data Analyst

Megha Waghmare

347-***-**** • New Jersey • *****.********@*******.*** • www.linkedin.com/in/meghawaghmare/ PROFESSIONAL PROFILE

• Strong hands on experience implementing dashboards, data visualization and analytics using Tableau Desktop and Server.

• Created Tableau scorecards, dashboards using stack bars, bar graphs, scatter plots, geographical maps, Gantt charts using show me functionality with large data volumes from various data sources

(sqlserver etc.).

• Experience in analyzing the BI needs, interpreting business user requirement and translating them into reports.

• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.

• Team player with good communication and interpersonal skills. Responsible for interacting with business partners to identify information needs and business requirements for reports.

• Ability to handle multiple tasks concurrently and meet the deadline. CORE COMPETENCIES

* Policies & Procedures * Predictive Modeling * Binary Logistics * Pricing

* Database Integrations * Critical Thinking * Email Marketing * Training

* Economic Interpretation * Transaction Analysis * Complex Logic * Forecasting

* Market Analysis & Research * Quantitative Modeling * Data Mining * Leadership SOFTWARE EXPERTISE

Tools - SPSS, MSSQL Server/MySQL, R, Python, Google Analytics, Mixpanel, CRM, Salesforce KORE, Tableau, 9.0, Geoda, MS Word, PowerPoint, Excel, Outlook, SharePoint, Google sheet, FTP/SFTP, CanopyLabs, Salesforce Marketing Cloud

SAS - SAS Enterprise guide, Model Building, Multiple Linear Regression, Correlation, Heteroscedasticity, Probability Distribution, Hypothesis Testing, Multicollinearity Testing, Formulation, Logic Regression, Interpretation, Data Mining, ANOVA test, A/B testing. SAS Visual Analytics - Survey Analysis, Text Analysis, Cluster Analysis, Lead scoring, Decision trees

WORK EXPERIENCE

Data Analyst – NEW YORK CITY FC, New York, NY (an American professional soccer club playing their home games at Yankee Stadium), Sep 2016 – Present

Megha Waghmare, MA • Page two

• Recruited off campus for the principle role of transforming a stagnant ticket sales and fan relationship department into a smooth-functioning and revenue-generating unit producing

$147,000 in new sales with residuals the first seven months.

• Collaborate with the advertising establishing a “75 Mile Target” campaign identifying potential season ticket holders living within a 75-mile radius of the stadium.

• Converted data into actionable insights by predicting and modeling future outcomes.

• Create ticket campaigns using KORE (Salesforce) with segmented data boosting overall sales.

• Conceives insights based on ticket holder’s likes-and-dislikes to optimize fan base growth and retention increasing overall sales 22% over previous years.

• Reviews and analyzes economic data to prepare reports to senior management detailing results of investigations keeping abreast of economic changes.

• Analyzes market demographics suggesting strategies that determine customer need and volume potential implementing solutions to improve company’s profit margins.

• Analyzes revenue “break-down” and campaign insights to identify “the ideal fan” and fan behavior that converts into sales.

• Trains new hires (customer service, graphic specialist, support staff) in effective product knowledge, product technique and customer service methodologies.

• Monitors and updates database on a weekly basis.

• Recognized by management as “…a dedicated, detailed oriented, no-nonsense get-it-done-now and get-it-done-right professional” when dealing with projects and people. EDUCATION

Master of Science – Applied Economics (3.52/4.0) - University of Cincinnati, Cincinnati, OH 2016 Kautz-Uible and Taft Fellowship

Projects -

• Evaluated the economic burden and debt of educational debt on households using SAS

• Performed salary analysis of university staff

• Analyzed spending of married versus unmarried individuals

• Quantified relative importance of non-market goods using housing market data

• Researched global imbalance and the financial market

• Performed crises intervention for a case load of first-time college students with emotional and behavioral disturbances resulting in family unification and conflict resolution.

• Pioneered “best practices” policies keeping staff and students motivated, engaged and focused.

• Assisted professors in teaching “Introduction to Microeconomics” enabling students to “get it.” Bachelor of Engineering – Electronics (3.17/4.0) - Nagpur University, Nagpur, India 2012 CERTIFICATIONS

• What is Data Science? IBM Institute

• Python for Data Science, IBM Institute

• Data Analysis with Python, IBM Institute

• Data Analysis Using SPSS, National Institute of Mental Health & Neuro Sciences, Bengaluru, India

Contact this candidate