Resume

Sign in

Data Analyst

Location:
Hayward, California, United States
Salary:
40/hr
Posted:
November 11, 2017

Contact this candidate

Summary

●SAS Advanced Programming: Familiar with Version 9 Advanced SAS, Proficient in testing of analysis data and programming code to meet regulatory and company standards.

●R and R-Studio: Track record of using advanced statistical methods and experience in predicting using Machine Learning Algorithms. Performed A/B testing using R-Studio

●Python: Certified Data analysis and visualization

●MS Excel: Created pivot tables. Designed and executed macros to automate data entry inputs. Formatted

Spreadsheets and workbooks for print, document reproduction and presentation.

●SQL: Strong ability to create and present reports using relational databases like SQL.

●Tableau: Created GIS maps and interaction plots using Tableau.

Technical Skills:

Languages: SAS, R, Python, d3.js, HTML

Tools: Minitab, Tableau, R-Studio

Databases: SQL, SQLite, MySQL

Packages: MS Office, Advanced Excel

Operating System: Windows, Linux

Experience

Statistical Analyst AT Tata consultancy SERVICES. (Nielsen Project). Jun-2011 – dec- 2014

●Worked on Machine Learning Algorithms (Logistic regression, Naïve Bayes, kNN, Decision Trees, Random Forests and Artificial Neural Networks) in Data Modelling and Data Evaluation.

●Generated report of assumptions in SAS environment using Normality, Breusch-Pagan and Linearity test.

●Extensively used PROC SQL and SAS/ODS for generating different output formats.

●Collaborated with data engineering team to expand data coverage.

Environment: SAS 9.4 in Windows, R-Studio, Microsoft EXCEL.

Accounts Payable, Cognizant Technologies Solutions. Sep-2008 –jun -2009

This Project is an Account Payable Project. Deals with the Out of Balance, Merging, E-processing. SUPERVALU is RetailBusinessownsmultipleproductsandtheymarketandselltheirProductsworldwide.

Education

California State University East Bay (June 2017)

Masters in Statistics

Psg college of Arts Science, Coimbatore, India (May 2011)

Master’s in Statistics

Psg college of Arts Science, Coimbatore, India (May 2008)

Bachelors in Statistics

Coursework includes:

Statistical Theory, Advanced Statistical Inference(Minitab), ANOVA and Regression Analysis(SAS), Machine Learning

and Data mining(R-Studio), SAS Programming, R Programming, Data Visualization(Tableau), Time Series Analysis

Statistical Analysis(Python)

Projects

●Annual Statistical Report of various food products from New York:

Performed and developed a report on increasing food calories in New York from the work published by “Allison. D. – Counting calories (1993).”

Tests Performed: One-Way Anova, 2- Sample T-test. (Minitab.SAS)

●Prediction and Classification Analysis on Airline Data:

Developed an average number of flight delays with machine learning algorithms (kNN) and predicted the overall performance of late flights with and without flight numbers in models from “Airline on-time Performance Dataset” donated by Bureau of Transportation Statistics.

Tests Performed: k Naïve Bayes Algorithm, Decision Tree, Random Forest (Classification) (R-Studio. SAS)

●Model Building for Housing Prices in Boston:

Performed regression Analysis and assumptions to analyze the dataset using the data step PROC REG and built a linear regression model for housing prices as dependent variable.

Tests performed: linear regression, normality, linearity, Breusch-pagan, Forward selection (SAS)

Time Series Analysis on Closing prices of Amazon Inc. Stock- (R-Studio, Tableau)

Performed Basic Time Series Analysis and autocorrelation function using ARIMA process on Amazon Inc. historical prices dataset extracted from Yahoo Finance Website. (R-Studio)

●Regression Analysis of Wage & Multivariable –(SAS, Tableau)

Performed multiple regression analysis on wage with 526 potential explanatory variables and validated the assumption of normality, equal variance, and independency in SAS. Identified influential observations by using leverage value, DFFITS, Cook’s Distance, and DF BETA. Applied Box-Cox transformation and simplified model using backward selection and Stepwise selection with evaluations of AIC, SBC, Adj R2, and Cp.

●Advanced SAS Programming- (SAS, SQL)

Collaborated with 2 classmates to collect data of NFL season data. Implemented analysis plan applied to the data, including player salaries and performance statistics for running backs. Specifically, carried out 1-way ANOVA and regression analysis. Created SAS Transport file, cleaned files, eliminated any extraneous variables, and combined cleaned data and regression analysis with Macro statements. Wrote SAS SQL procedures to manipulate aggregate and merge datasets.

●Prediction Analysis, Heart disease Analysis (Python, SAS)

Used SAS to create, read, update, and delete large data. Used SQL to cover exploratory data analysis, summarized data and applied regression analysis though SAS to fit the regression model.

Predicted by using regression equation whether the patient has the Heart disease are not.

●STUDENT ACTIVITIES & LEADERSHIP (STATISTICS)

●Member, CSU East Bay Data Science Club, CSU East Bay, Hayward, CA

1)Different tutorials were taught each week; topics included: SQL, R, Map/Reduce procedures using Hadoop,

H20 R Package/APL, Machine Learning algorithms: K-NN, Decision Trees, Random Forests, General Linear Models, Gradient Boosting Models, & Deep Learning

2)Participated in various team projects including: 1) Created a database with airline data from 1988, 2) Made predictions of people who perished on the Titanic, 3) Spectral Graph Theory project: utilized analytic methods for data visualization including spectral clustering and spectral embedding of graphs, 4) Data Science Pipeline project: retrieved, explored, and worked with Banking and Social Networking Data to create and work through a Data Pipeline, 5) Bay Area Route Finder project: Created driving directions for the Bay Area using A* (a popular A.I. algorithm).

3)Industry professionals shared expertise and career information at club meetings (Facebook, Google, Microsoft, H20, Pandora, Horton works, Revolution Analytics, & Share Through).

ACHIEVEMENTS & PROFESSIONAL AFFILIATIONS (CHESS)

Member, United States Chess Federation (USCF)

USCF Rating 1646

Participant, USCF Competition, Chicago, IL



Contact this candidate