Data Marketing

Than Tirouvingadame

(Data Analyst / Sr. Tableau Consultant)

SUMMARY

Around 8 Years IT experience in Data Analysis, Business Analysis, and Project Management.

Master’s degree in Big Data Analytics.

3 years’ experience as Tableau expert in Tableau Desktop, Tableau Server, Tableau Public, Tableau Online, Tableau Reader. Proficient in Tableau 9.2 Desktop, Server - developing KPI Metrics, reports, dashboards for C-level executives. Adept in pulling data from different sources, data blending, creating calculated fields, parameters, filters, preparing story boards to show business trends.

Seasoned professional with impeccable business judgement, experience in evaluating business trends, transforming customer data into actionable, data-driven insights to improve business.

Hands on experience in SQL, Hive, Impala, Pig, Hadoop, SAS, R, SPSS, Tableau, MS Access and Excel Macros (LOOKUPs, Pivot tables, Charts, Formulas-IF ELSE etc.)

Thorough understanding of Predictive Analytics, Machine Learning, Data Mining concepts - Clustering, Classification, Regression Analysis, Sentiment Analysis, probability, Statistical modeling, Bayesian methods, time series analysis, ARIMA modeling, forecasting, Hypothesis testing.

Well versed in using BI tools - SAP Lumira, SAP Business Objects Explorer, Dashboards, Excel Macros, Share Point to develop charts, pivot tables for analysis.

Experienced in Web, Digital Marketing, SEO, using Google Analytics, Salesforce.com.

Proven documentation, report writing and presentation skills. Blogger in LinkedIn on Analytics.

Subject Matter Specialist and Columnist in popular magazines in India writing on Personal Finance.

EDUCATION

Master’s in Analytics, Bowling Green State University, Bowling Green, Ohio, August 2015

Master’s in Marketing Management, Tamil Nadu Agricultural University, India, April 1995

WEB URL’s

LinkedIn URL: http://www.linkedin.com/in/ThanTirou

https://github.com/TThan/MedicareDataAnalytics

SKILL SUMMARY

Big Data Analytics – Hive, Impala, Pig, SQL, Hadoop, MapReduce.

Predictive Analytics/Data Mining with Decision Trees, Clustering - R, SAS, SPSS, Minitab, Excel Solver.

Statistical analysis using Regression analysis, Time Series Analysis, Forecasting using ARIMA modeling.

Business Intelligence: Data Analysis & Reporting using M.S. Access, Excel Pivots, charts, SAP DW.

Data Visualization: Tableau, SAP Lumira, SAP BO Explorer, Dashboards

Digital marketing: SEO optimization, keywords, Google Analytics, Salesforce.com

Marketing Automation tools: Salesforce.com, Google Analytics

Possess sound knowledge in fields of Marketing, Finance, Production and Personnel Management.

PROJECTS

Big Data: Big Data Analytics in Health Insurance data: Tools - Impala, Hive, Tableau. Used Hive and impala (Hadoop) to query joining different data sources and show business insights, growth areas.

Forecasting: Forecasting Gas Consumption using Time Series Data: Technique –Time Series Analysis: ARIMA Modeling, Tools used – R, Minitab. Sales was forecasted using ARIMA modeling.

Forecasting: Forecasting Electricity Generation by the US Electricity Industry: Tools Used- R, Minitab. Historical data was analyzed and the future electricity generation was forecasted.

Predictive Analytics: Predicting Income from Census Data: Data mining techniques –Logistic Regression, K Means Clustering and Naive Bayes. Tools used – R, Tableau.

Predictive Analytics: Predicting Student Retention for State University: Technique – Logistic Regression, SVM, Random Forest, Decision Tree and Naïve Bayes. Tools used – R, Tableau.

Predictive Analytics: Predicting Retail Price of Cars by Regression Modeling: Technique- Linear Regression. Tools Used- SAS, R and Minitab.

Portfolio Selection Problem: Technique -Non-Linear Programming. Tools used - Excel Solver, R. Optimizing the portfolio of stocks for profit maximization.

Data Base Management System for Falcon Silk Screening LLC: Tools used - Access, SQL Server.

Statistical Analysis of Population by Age of 50 States of USA: Tools used – R. Exploratory Data Analysis of the data to come up with business insights.

PROFESSIONAL EXPERIENCE

City of Palo Alto, Palo Alto, CA Apr2016 till date

Data Analyst

Generate and manage Weekly, Monthly KPI Metrics Dashboards for the Office of the CIO, using Tableau Desktop 9.2, Tableau Online pulling data from multiple data sources viz., Share point, SAP, Fire Eye, Trackit, Excel etc.

Owner of the Tableau environment: decide on the no. of licenses, architecture, who gets license, reporting rights such as editing, publishing rights etc.

Conduct Data analysis including acquisition, cleansing, transformation, modeling, visualization, documentation and presentation of results.

Training, mentoring team on using Tableau reports, dashboards and assist them in developing, customizing their reports.

Run KPI Metrics meetings, keep Open Data Portal up-to-date, and assist with Public Records Requests.

NetApp, Sunnyvale, CA Dec 2015 to Apr 2016

Reporting & Metrics Analyst

Centralized Dashboard for KPI Metrics Project – Developing weekly, monthly Metrics Reports and Dashboards in Tableau for C-level executives. Publishing in Tableau Server for global access. Strong hands-on experience on Tableau Desktop 9.2, Tableau Server and integrations, Excel Macros, VBA, Oracle DBMS, Share Point, MS Power Point etc. Developed formal release cycle and publishing strategy in Tableau server.

Preparing rich visualizations, attractive presentation layers, best practices around Dashboards, story boards to show business insights to the top Management.

Data Quality checking, data validation, cleaning up data to make accurate reports and analysis for the C-suite execs to use in key decision making.

YoungBull$ Education, Mumbai, India Aug 2008 to Jul 2014

Business Intelligence Analyst

Digital Marketing Campaign Optimization - Web traffic, SEO/SEM Optimization, Tagging, Reporting, Landing Page tests, Sign-ups and Purchase flow conversions, Campaign Management, Funnel Analysis using Google Analytics and Salesforce.com.

Generated weekly, monthly reports, dashboards using Tableau, R, SQL, MS Access & Excel Macros (LOOKUPs, Pivot tables, Charts) for business insights. Owned Customer Database, assessed trends, customer analytics and advised top management on new LOBs, key market drivers for business.

Predictive Analytics- used Logistic Regression, Linear Regression in R for mining customer data, building model, customer segmentation and targeting email campaigns.

Achievements-Headed Digital Marketing Campaign Project. Funnel Analysis, Path analysis, A/B testing, MVT testing, added microsites to engage customers. Analyzed data flow, provided regular and ad-hoc business analysis for business insights about digital media and campaign performance. Resulted in 42% jump in Lead generation.

Lateral emSoft, Mumbai, India Nov 2006 to Aug 2008

Marketing Data Analyst

Marketing analytics including pre-campaign analysis to identify customers for campaign, post -campaign analysis to evaluate campaign success, and recommendation for future campaign performance.

Analysis of production data for process improvement and reduction of costs (e.g. Trouble Shooting and Root Cause Analysis)

Achievements - Created new market for “Tracer” brand of Vehicle Tracking System & Reefer Tracking System. Proposed new GPS based Passenger Information System (PIS) for Indian Railways.

Monsanto Chemicals, Kurnool, India March 1998 to May 2000

Territory Manager – Marketing

Devised & executed Promotional campaigns to achieve the sales targets.

Achievements: Established brand in virgin market from zero to Indian Rupees 60 million in 2 years.

Garden Supplies and Services, Chennai, India Nov’ 1996 to Feb 1998

Marketing Manager

Launched new product, devised & executed Promotional campaigns to achieve sales targets.

Achievements: Established brand in all superstores in Chennai, improving visibility & awareness.

E.I.D Parry (India) Ltd., Chennai, India June 1995 to Nov’ 1996

Sales Officer

Responsible for selling fertilizers and pesticides in rural markets in Tamil Nadu, India.

Achievements: Trained the newly recruited Field Workers to educate farmers on all our products.

AWARDS

Junior Research Fellowship for Master’s degree in marketing management in 1993-95

Gold medalist – 2 times for chess in University Level Annual Sports Meet 1990, ’92

BLOG POSTS ON BIG DATA ANALYTICS

https://www.linkedin.com/pulse/when-use-multinomial-logistic-regression-than-tirouvingadame?trk=prof-post

https://www.linkedin.com/pulse/issues-recommender-systems-than-tirouvingadame?trk=prof-post

https://www.linkedin.com/pulse/comparing-hive-impala-than-tirouvingadame?trk=prof-post

https://www.linkedin.com/pulse/how-analyze-stocks-applying-smoothing-technique-gain-tirouvingadame?trk=prof-post

https://www.linkedin.com/pulse/sentiment-analysis-iphone-using-twitter-data-than-tirouvingadame?trk=prof-post

https://www.linkedin.com/pulse/wanna-tell-story-tableau-than-tirouvingadame

Contact this candidate