Data Analyst

Summary:

Available data analyst skilled in interpreting and analyzing data sets in a fast paced environment. Proficient in using Excel, SAS, R, Python and Tableau.

Education:

Master of Science in Management Information Systems, Oklahoma State University, Oklahoma. May 2017

Bachelor of Engineering in Electronics and Telecommunications, University of Mumbai, Mumbai, India. May 2013.

Qualifications and Skills:

Proficient in working with SAS Enterprise Guide, SAS Enterprise Miner along with Tableau to analyze large sets of data and information and ability to understand and manipulate them.

Experienced in data preparation for various statistical procedures and modelling which includes data extraction management, analysis, data cleaning, reporting, presenting dashboard outputs.

Proficient in analytical, decision making and problem solving skills.

Extensive knowledge of Cisco CCNA.

Proficient in MS Office including Excel and PowerPoint.

Proficient in written and verbal communication skills.

Professional Experience:

Frost International Ltd Data Analyst Aug 2012-July 2015

Review architecture documents and diagrams to define data strategy for generating business rules to extract data from various source systems and to document data dictionaries, metadata with table/column details.

Conduct data profiling to create datasets for analysis.

Performed different statistical analysis using Microsoft Excel statistical functions and data analysis toolkit to train, validate and test hypothesis for large and complex datasets with conditional constraints like rates, demand and geographic sourcing.

Validate customer orders using historical data, price-points and order history to derive trends, entry and exit strategies with cost optimization.

Extensively used SAS and SQL for data mining, harvesting and research over incremental datasets spanning multiple years, geographies and product lines.

Prepared data agnostic presentations for decision making.

Manage end to end customer orders from vendor sourcing, order management, shipping to customer warehouse.

Academic Projects:

OLAP Cube Design and Data Mining on CHSI healthcare data: Spring 2016 Tools used: Microsoft Visual Studio, MS SQL Server, Microsoft Excel, Management Studio

Designed dimension hierarchies, created partitions and aggregations to speed up processing of MDX Queries.

Used different techniques of statistics like regression, clustering on OLAP cube and reported the documentation for the same.

Story-telling on Hollywood movie revenue using Tableau 9.3: Spring 2016

Performed extensive analysis on data regarding Hollywood movie revenue using Tableau.

Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau

Created and modified metrics and made necessary functionality for application.

Developed tableau workbooks from multiple data sources

Presented Dashboard outputs to different stakeholders.

Predictive Analysis for Enrollment of prospective students using SAS Enterprise Guide and SAS Enterprise Miner: Spring 2016

Employed Cross Industry Standard Process for Data Mining (CRISP-DM) for business understanding, data understanding, data preparation, modeling, evaluation and deployment in order to score for enrollment.

Data Analyzing, data cleaning, data collection and storage, imputed, transformed, clustered and validated student data in order to build a best fitting model.

Oversampled data during the initial phases so as to build a model capable of predicting enrollment and adjusted the prior probabilities while scoring the new data set.

Developed a predictive model with 3 objectives: Increase new freshman enrollment, diversity and SAT score of entering students.

Publications:

Touch Screen Controlled Wheelchair with Tracking System

International Journal of Nano Engineering, Nano Engineering and Nano Technology

(VOLUME 4 • NUMBER 2 • ISSN: 2229-7383) November 10, 2012

Published a Technical article on Touch Screen Controlled Wheelchair with Tracking System in the International journal of Nano science, Nano engineering and Nano Technology explaining the concept of the product along with its working.

Technical Skills:

Analytic and modelling tools: SAS Enterprise Guide, SAS Enterprise Miner, Tableau, IBM Modeler.

Software proficiency: Microsoft Visual Studio 2015, SQL Server Analysis Services, Tableau 9.0, Microsoft Suite (Word, Excel, Powerpoint)

Programming languages: Base SAS, SQL, R, Python, Java.

Contact this candidate