Ankur Kumar Gupta

• +1-781-***-**** • ac3mx5@r.postjobfree.com • http://ankurkumargupta.tumblr.com

Profile

A result oriented analytics professional, Ankur has rich experience in the field of data analytics, data visualization and statistical analysis. He is a certified Tableau developer as well as a certified SAS professional.

Professional Summary

Experienced in development and design of reports and dashboards for supporting the business analysis in a corporate wide reporting using Tableau 7.X/8.X/9.X/10.X(Desktop, Server, Reader).

Strong proficiency in the full life cycle of business solution development including problem definition, requirements gathering and analysis.

Expertise in SQL and can independently mine data to translate business data needs into creative visualizations.

Experienced in data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and data reporting.

Experienced in utilizing SAS Procedures, SAS Macros, and other SAS application for data extraction using Teradata, defining the metadata, checking the data quality, data profiling, data cleansing and reporting,

Experienced in migration of Tableau workbook from developer to production environment.

Expertise in creating advance visualizations such as trellis chart with a map chart, tornado charts, bullet charts, stick & candle charts, funnel charts, pareto charts, bump charts, box-plot and others using Tableau.

Expertise in using advance Tableau features such as data blending, custom SQL, parameters, calculated fields, action filters, custom geocoding & level of detail calculations.

Expertise in creating advance analytics dashboards which includes market basket analysis, segmentation analysis, cohort analysis, trend analysis & what-if scenarios using Tableau.

Experience in Software Development Life Cycle (SDLC) that include duties such as providing documentation on design, testing and migration from development to production.

Excellent communication skills to be able to work with business owners to develop and define key business questions and to build specification for the data sets that answer those questions.

Relevant Knowledge, Skills, and Training

• Tableau Desktop 7.X/8.X/9.X/10.X • Tableau Server 7.X/8.X/9.X/10.X • SAS Enterprise Guide • Base SAS • Advance SAS • Teradata • Oracle • Advance Excel • Statistical Analysis • Alteryx

Certifications

SAS Certified Base Programmer for SAS 9

SAS Certified Advanced Programmer for SAS 9

SAS Certified Statistical Business Analyst Using SAS 9: Regression & Modelling

Tableau Desktop 9 Qualified Associate

Data Analysis & Interpretation Specialization from Coursera (5 course series)

Tableau Data Visualization Competition

Winner of the Tableau data viz competition sponsored by drivendata.org & Tableau and received $2000 as a prize money. Link for the winners list is: http://blog.drivendata.org/2016/07/19/fogwater-winner/

Ankur Kumar Gupta

• +1-781-***-**** • ac3mx5@r.postjobfree.com • http://ankurkumargupta.tumblr.com

Professional Experience

TIGER ANALYTICS

Tiger Analytics is a boutique data science & data analytics consulting organization. It provides services in the field of marketing & customer analytics, digital analytics, forecasting, pricing for its clients in various industries.

CLIENT: LINKEDIN INC. SAN FRANSISCO, CA

Sr. Analytics Consultant Sep 2017 till date

Consistently attended meetings with the subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.

Effectively used advance features of Tableau such as data blending, quick filters, actions, hierarchies, lod calculations etc.

Build prototypes for demonstration and illustration purposes for peer groups, business partners and senior leaders.

Build a Tableau data model which is used by business users to conduct their adhoc analyses on Tableau server.

Build a Tableau dashboard to show the quota vs achievement dashboard which is used by world wide team of Linkedin.

GLOBAL DATA MART INC.

Global Data Mart is a global information technology firm provides innovative and robust end-to-end solutions in the field of data analytics for its clients in various industries.

CLIENT: WELLS FARGO BANK ORLANDO, FL

Analytics Consultant Jan 2017-Sep 2017

Created a metadata in Oracle from seventeen tables which is used by team members on regular basis for their analysis.

Consistently attended meetings with the subject matter experts to acquire functional business requirements to build SQL queries that would be used in dashboards to satisfy the business’s needs.

Build prototypes for demonstration and illustration purposes for peer groups, business partners and senior leaders.

Created advance visualizations such as sankey diagram, pareto charts, bump charts and others using Tableau.

Created advance analytics dashboards which includes market basket analysis, cluster analysis, trend analysis & what-if scenarios using Tableau.

Combined customer complaints data using SAS and conducted multivariate analysis to perform hypothesis testing to see which issue area are significantly different from others.

Extracted data from flat files, excel spreadsheets and external RDBMS Oracle tables using SAS LIBNAME and SQL PASSTHRU facility.

Extracting data from the database using SAS/Access, SAS Macros, SAS SQL procedures and created data sets.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Ankur Kumar Gupta

• +1-781-***-**** • ac3mx5@r.postjobfree.com • http://ankurkumargupta.tumblr.com

CLIENT: WALT DISNEY WORLD CELEBRATION, FL Dec 2014-till date

Business Intelligence Analyst Dec 2014-Dec 2016

Worked in Tableau environment to create dashboards using Tableau desktop & publish them to server.

Consistently attended meetings with the subject matter experts to acquire functional business requirements in order to build SQL queries that would be used in dashboards to satisfy the business’s needs.

Created advance visualizations such as trellis chart with a stacked column chart, tornado charts, bullet charts, stick & candle charts, funnel charts, pareto charts, bump charts, box-plot and others using Tableau.

Combined customer data of various business units using SAS and built a logistic regression model to predict the potential future customers who are more likely to buy Disney annual pass.

Developed Tableau workbooks from multiple data sources using Data Blending.

Extracted data from flat files, excel spreadsheets and external RDBMS Teradata tables using SAS LIBNAME and SQL PASSTHRU facility.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and MTD type of analysis.

Act as mentor and Tableau SME for other Tableau users across the company.

BIOTIQUE, (BIO VEDA ACTION RESEARCH COMPANY) INDIA 2011-2013

Biotique is India’s leading natural cosmetic company, with over 500 employees, offering a range of over 200 skin care, hair care, sun care and make-up products for the retail and professional markets.

Area Manager. Responsible for the business operations in two states of India. Managed the marketing and sales activities of the regions. Led the team of 40 marketing and sales specialists. Supervised the entire distribution system for the assigned region.

Successfully launched the professional range of cosmetic products to over 60 retail stores in 10 cities.

Consistently achieved business targets on quarterly basis resulting in 27% increase in sales year on year.

Developed sales training module for sales specialist which helped to increase their sales by 32%.

Planned below the line marketing strategies.

Played a key role in redesigning the company's product offerings in response to a quickly changing market .

UNILEVER LIMITED INDIA 2007-2011

Unilever products are sold in 190 countries, generating sales of $69B in 2012, encompassing 14 brands with sales of more than $1B and over 173,000 employees.

Business Development Executive. (2009-2011) Responsible for the business operations in New Delhi. Managed the marketing and sales activities of the regions. Led a team of 250 people. Supervised the distribution system for the assigned region.

Successfully launched three new products in the retail market.

Mentored three employees, one promoted to an executive-level position and two were promoted to Sales Officers.

Received five rating for my consistent performance which only seven percentage of the employees get in Unilever Ltd.

Conducted sales training program periodically.

Ankur Kumar Gupta

• +1-781-***-**** • ac3mx5@r.postjobfree.com • http://ankurkumargupta.tumblr.com

COFFEE DAY-BEVERAGES DIVISON INDIA 2006-2007 start year – end year

The group has over 1000 Café Coffee Day joints, around 400 Fresh & Ground stores, over 1000 Coffee Day Express kiosks and sizeable 10,000 vending machines from Coffee Day Beverages Division. The group is now generating sales worth $400M.

Sales Executive: Responsible for generating new business and managing clients. Instrumental in marketing efforts of various product lines

Initiated start-up of coffee and tea vending machine in a vile territory. Within seven months achieved 30% growth in sales.

Received a PAN India order from Xerox for installation of coffee and tea vending machines.

Received an order from Moser Baer for their 5000 employees’ facility in Greater Noida.

Received an order from C-DAC which is a semi government organization.

CCS COMPUTERS PVT. LTD. NEW DELHI, INDIA 2005 – 2005

CCS is a ‘System Integration & Technology Support Outsourcing Company’ covering the entire gamut of the IT Services like Facilities Management, Break-Fix Services (AMC) and Managed IT Services that combines with ITIL Standards

Sales Trainee. Responsible for generating leads and to do area mapping.

Education

Master of Business Administration (MBA) Aug 2014

HULT INTERNATIONAL BUSINESS SCHOOL Boston, USA

World's most international business school. Top 10 FT ranking for international business and experience.

Master in Telecom Technology & Management May 2005

AMITY UNIVERSITY- Noida, INDIA

Bachelor of Science, Mathematics May 2002

LUCKNOW CHRISTAIN COLLEGE- Lucknow, INDIA

Contact this candidate