Data Analyst

KUNAL GAUTAM

+1-720-***-**** *************@*****.*** https://www.linkedin.com/in/imkunalgautam

Data Analyst with 9 years’ experience in data manipulation, analytics and reporting. Holds adequate balance of technical Business Intelligence development knowledge and business engagement skills, to be able to make an immediate impact in business decisions. Proficient in SAS/BASE, SAS/SQL, SAS/Macro, SAS/Connect, SAS/Access, SAS/ODS, SAS/STAT and SAS/GRAPH. Involved in Coding, Unit Testing and Code Review Extract data from database using SAS SQL procedures, SAS macros and create SAS data sets. Performed data extraction, analysis and published results using SAS ENTERPRISE

Technical Skills

Languages: Python, R, BASE/SAS, SAS Macro, SAS/SQL, SPSS, TSQL, SQL, PL/SQL, Splunk, Hadoop

Databases: MS SQL Server, ETL

IDEs: MS Visual Studio 2014, RStudio, SPSS Modeler 16.0, SAS, NumPy, Pandas

Other Tools: JMP, HLM, LINGO, LISREL, Tableau, Qlikview

Machine Learning: Classification, Regression, Clustering, Recommendation System, Association Rules

Operations Research: Optimization techniques such as Linear and Simplex

Statistical Methods: Hypothesis testing, Principal Component Analysis, Clustering, K-Nearest Neighbors, Logistic Regression, Time Series Analysis, K-Means Clustering, Naive Bayes

Business Intelligence: Data Analysis & Reporting using Salesforce.com, Google Analytics, Fusion charts, Excel Pivots, charts

PROJECTS

Predictive-Analysis Projects: Used SPSS modeler 16.0 to complete various predictive analysis projects, through machine learning algorithms such as: PCA, Association Rules, Clustering, KNN, Decision Trees, Logistic Regression, Linear Regression, Naïve Bayes. Performed data analysis, data preparation, Model development, Model Interpretation, Model Evaluation.

Data Visualization: Used story telling techniques and created data visualization using Tableau, JMP and HLM. Created Dashboards with Quick filters, Parameters and sets to handle views more efficiently.

Big Data: Performed exploratory data analysis using tools as Python, Splunk for data parsing. Used Twitter API to search against a sampling of recent Tweets published in the past.

Data Wrangling: Performed Data analysis and Data preparation using SAS and R Studio. Used various SAS procedures like PROC SQL, PROC REPORT, PROC TABULATE, PROC FREQ, PROC MEANS, PROC UNIVARIATE, PROC SUMMARY, and PROC CONTENTS.

Semantic Analytics: Assembled an NLP pipeline to take raw text to annotated output – including high level concept and relation extraction. Used semi-supervised approaches in the context of NLP ability to create new algorithmic variations.

Optimization: Implement optimization models to solve complex problems to meet business and revenue objectives using LINGO and Excel Solver.

IT Business Analysis: Conceptualized database design for databank development, developed Business Requirement Document and led final testing on the UAT server; worked closely with BI and DW architects to build the applications and for overall strategy.

CORE COMPETENCIES

Strategic Thinking: Ability to influence the company strategy by identifying opportunities in rich data sets, and implementing data driven strategies that serves as growth catalyst for revenue and profits.

Modeling: Design and implement statistical / predictive models and algorithms utilizing diverse sources of data to predict demand, risk and business.

Analytics: Utilize analytical applications such as R, SAS, Python to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings driving value to business.

Project Management: Capable to handle more than one cross-company project at a time. Defined the project scope of work, financial plan, its goals and delivery – Managed all aspects of the project business plan, execution and budget.

Documentation and Communication: Well versed with documenting long professional reports. Ability to interact and effectively communicate with people from diverse backgrounds, highlighting teamwork and problem solving.

PROFESSIONAL EXPERIENCE

CONSULTANT Denver, Colorado

Arrow Electronics Jan 2016 – August 2016

Built a predictive model to predict Arrow Sales based on changes in macro-economic factors

Conducted Sentiment Analysis using customer reviews, to find customer preferences across different parameters

Conducted competitor analysis for five competitors of Arrow

Using SPSS (Statistical Package for the Social Sciences) to perform statistical analysis to create listing, table, and graph reports

GRADUATE RESEARCH ASSISTANT Denver, Colorado

University of Denver Sep 2015 – July 2016

Assisted Professors with a research project on Text Analytics and engaged in literature/journal searches

Participated in the conceptual aspects of research process and obtaining original data

Provided assistance with supervision of undergraduate/graduate students, grading examinations and critiquing student papers

SENIOR ANALYST Gurgaon, India

EDA Rural Systems Pvt. Ltd. Jan 2013 – Aug 2015

Analyzed large scale survey data with JMP and Stata for multiple variables. Evaluated model fitting, conducted model comparison, and derived relationship between income strata and demographic factors (income levels, communities, age, etc.)

Implemented risk evaluation modules to understand and predict credit worthiness of potential borrower

Data Quality checking, data validation, cleaning up data to make accurate reports and analysis for the clients to be used in key decision making.

Developed and maintained detailed project plans, action items, budgeting, and scheduling for all assigned projects

Explored different predictive models, including neural network, classification tree and multivariate adaptive regression, and evaluated their performance

Provided technical assistance to 15 institutions in risk management, customer relationship management, social performance management and operations. Authored assessment/visit reports and devised detailed actions plans

Authored assessment/visit reports and devised detailed actions plans

OPERATIONS ANALYST Chennai, India

Centre for Insurance & Risk Management, Institute of Financial and Management Research Aug 2010 – Dec 2012

Managed and manipulated data sets from multiple sources from more than 100 organizations. Primary data collection, secondary data collection from published/ unpublished sources and data analysis

Led project for development of web based solution/website representing national level micro-insurance databank

Created Database design, Maintenance, ER Diagrams, Indexes, and Temporary Tables using SQL Server.

Involved in Build, Debug and deployment of the Components

Liaison with IT consultants to articulate business considering system capabilities – JAVA and .NET platforms

Contributed in data analysis for research paper on "Protecting the poor, A Micro-insurance compendium, Volume II" published by ILO

MARKETING MANAGER & ANALYST Mumbai, India

Swadhaar FinServe Pvt. Ltd. (urban Microfinance Institution) Jan 2008 – Aug 2010

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

Generated weekly, monthly reports, dashboards Excel (LOOKUPs, Pivot tables, Charts) for business insights. Owned Customer Database, assessed trends, customer analytics and advised top management on new areas and key market drivers for business

Responsible for providing reporting, analysis and insightful recommendations to business leaders on key performance metrics pertaining to sales & marketing

Demonstrated deep understanding of customers' needs and market trends by cross-sell relevant products

Devised marketing strategies for Swadhaar; led team to plan and execute large scale expansion plan of 27 new branches

Ventured into alternate channel for business development; singlehandedly conducted primary/secondary research and analysis

MARKETING EXECUTIVE TRAINEE Delhi, India

DSCL Shriram Fertiliser & Chemicals May 2007 – Dec 2007

Analyzed business requirements to develop metrics and create reports for marketing campaigns and product pilots

Communicated effectively with external creative agency and developed brand and product line positioning

Established strategies based on the sales reports and worked with sales team to convert sales leads to new

Led team of 10 staff to manage sales and marketing of around 50 products in five districts

Established partnerships with Government agencies to increase sales

EDUCATION

Master of Science in Business Information & Analytics, University of Denver 2015-2016

Master of Business Administration, Vaikunth Mehta National Institute of Management 2005-2007

Bachelor of Sciences, BCKV 2000-2004

Contact this candidate