Data Analyst Resume
SUMMARY
- 3+ years of experience predictive analytics, data analysis, data management and Visual Analytics
- Experience in data preparation for various statistical modeling, which includes data cleansing, descriptive statistics, missing data analysis, data validation and preliminary data reporting
- Knowledge of Machine Learning techniques like Regression Models, Clustering Analysis, Decision Tree, ANOVA, t - tests
- Knowledge of advanced concepts of MS Excel such as pivot tables, graphs and advanced functions VLOOKUP, IFELSE, etc. and Macros.
- High-level experience in Base SAS, SAS/SQL, SAS/STAT, R, SQL, SPSS modeler, Tableau, D3.js.
PROFESSIONAL EXPERIENCE
Data Analyst
Confidential
Responsibilities:
- Developed a robust sports analytics platform with a suite of analytic tools for various sports. This suite will be a powerful asset to coaches, scouts, analysts and avid fantasy sports players containing massive amounts of data for analysis using SQL
- This suite is used to make accurate predictions on player performance, productive team entropy and determining player value
- Also, fantasy sports players gain a competitive edge by using state-of-the-art machine learning algorithms to predict performance
- Used R for data visualization using ggplot2 packages and built Dashboard/Stories over data using Tableau
Skills Exercised: SQL - R - Tableau- Machine Learning
BI Analyst
Confidential
Responsibilities:
- Developed, enhanced, maintained implementations within business intelligence (BI) applications that support business continuity and problem incidence functions
- Worked with team of 15-20 people and gained experience with data modeling, database design(SQL), various supervised and unsupervised ML techniques using R
- Experience with descriptive statistics and TEMPeffectively represented them graphically using Tableau and MicroStrategy.
- Also built rich and dynamic dashboards using out-of-box features, customizations, and visualizations using D3.js
- Working knowledge of Waterfall and Agile development methodologies (Scrum, Sprint), Rally / CA Agile Central experience
Skills Exercised: SQL - R - EXCEL- MicroStrategy- Tableau- Communication Skills- Leadership
Research Assistant
Confidential, Charlotte
Responsibilities:
- Aim of the Project: Reduce overall health care costs
- Connected Healthcare Project Scope - $1.7MN
- Process Data worth of 100GB of Healthcare Data - Truven Dataset. Analyzed demographic parameters - age, gender, location, industry effect the cost related variables such as hospital costs, diagnostics costs, consultation fee
- Working knowledge of publicly funded health insurance programs, such as Medicare and Medicaid
Skills Exercised: SAS Query Builder - Prepare data sets- Tableau - Data visualization
Database-Graduate Assistant
Confidential, Charlotte
Responsibilities:
- Assisted professor with classroom instructions, exams, record keeping and projects for the course Database Design and Implementation- MySQL
- Tutored and assisted 100 to 150 Under-grad and Grad students individually or in small groups to halp them master assignments and reinforce learning concepts presented by Professor for course
- Performed weekly and monthly analysis using SSRS, Tableau to generate reports on merit level of students and increased their performance level by 2% after each exam
Skills Exercised: SQL - EXCEL - SSRS- Banner Service-Tableau- Communication Skills- Leadership
Junior Data Analyst
Confidential
Responsibilities:
- Obtained and analyzed the informational business requirements from clients and created database tables with various constraints including primary key, foreign key by writing SQL queries
- Analyzed large data sets using statistical software, such as SAS, R, Python, and SPSS, to discover new business insights.
- Data cleaning, data visualization, detection of missing data and skewness and model development were performed on data
- Machine learning & statistical models predict binary response on dataset with 28variables and achieved model accuracy of 75% and sensitivity of 54% with Random forest
- Developed Tableau visualizations and dashboards using Tableau and implemented the system using D3.js
Skills Exercised: SQL – R – Python- SAS – Tableau- Machine Learning
Data Analyst
Config Technologies
Responsibilities:
- Extracted, compiled and tracked data and analyzed data using SPSS to generate reports on a weekly, monthly and quarterly basis.
- Run reports based on team needs by writing SQL quires to extract data.
- Develop prediction model using Linear/Logistic/Decision Tree/Random Forest models in R & Python, used MS EXCEL to create pivot tables, charts
- Developing tidy dataset, Data visualization in R using dplyr, tidyr& ggplot2 packages and building Dashboard/Stories over data using SSRS, Tableau and Excel.
- Conducted reports for implementation of marketing strategies, leading to 34% growth in customer acquisition.
Skills Exercised: SQL – R - Tableau – EXCEL- SPSS- Python
TECHNICAL SKILLS
Programming Languages: R, SAS (Base) D3, Python, C, C++, JavaScript, HTML, CSS
Database skills: My-SQL, Microsoft SQL Server, Teradata, PL/SQL, T-SQL
Analytics: SAS, SPSS, EXCEL, WEKA, SSIS (ETL), SSRS, SSAS, ERWIN, HIVE, Hadoop, MapReduce
Operating Systems: Windows, LINUX, UNIX
Machine Learning Algorithm: Linear & Logistic Regression, Market Basket Analysis, Time Series, Apriori Algorithm, Clustering, PCA, Decision Trees, Random Forests, SVM, ANOVA Other tools Tableau, Power BI, MicroStrategy, SAS E-Miner, SAS Enterprise guide, R studio, Eclipse, MATLAB, MS Office