Data Analyst

Aakriti Garg

Fairfax, Virginia ***** ● 757-***-**** ● *************@*****.*** ● LinkedIn: linkedin.com/in/aakriti-garg

Summary of Qualification

Proven skills with 5 years of experience in Qualitative and Quantitative Analytics and Data-driven Visualization. Expertise in R, Tableau, machine learning, predictive and statistical modelling, ETL processing and Agile methodology with good understanding of SDLC. Experienced team leader and corporate trainer with strong presentation, communication and writing skills

Education

George Mason University, Fairfax, VA, USA December 2018

Master of Science in Data Analytics Engineering GPA: 4.0

VIT UNIVERSITY, Tamil Nadu, India May 2011

Bachelor of Technology in Biomedical Instrumentation Engineering GPA: 3.7

Technical Skills

Programing Languages: R, Python, VBA, C#, HTML, VB script, UNIX shell

Database: MS SQL Server, MongoDB, MySQL, SQL Profiler

Machine Learning: Linear and Logistic Regression, Decision Tree, SVM, KNN, Navie Bayes, Monte Carlo Simulation, Google Analytics

Analytical Tools: R Studio, Tableau, RapidMiner, WEKA, SPSS, SAS Enterprise Miner, IPython Jupyter, Frontline Solver, XLMiner, MS Power BI

Professional Experience

Graduate Teaching Assistant, George Mason University Jan 2017 - Present

Serve an assignment to the professor helping him with designing assignments and PowerPoint presentation on various data analysis methodologies like optimization, decision trees, Monte Carlo Simulation

Addressing students’ queries for the Operational Research course focusing on prescriptive and predictive analytics

Research Assistant, George Mason University Jun 2017 - Aug 2017

Worked on a research program for the Finance department to study the pattern and trends of the home loan industry

Integrated datasets for loans offered by Fannie Mae and Freddie Mac to the performance files for each loan for 15 years

Business Data Analyst, Condeco Software Pvt. Ltd. Oct 2015 - Oct 2016

Served as a Business data analyst by using Data Visualization tools like Tableau, Microsoft Power BI and R studio on large data sets to perform interactive reporting and analysis of the dashboards

Used R and SPSS for predictive analysis of the complex datasets for various upcoming product enhancement

Analyzed trends, data patterns and anomalies while working on different business intelligence and application development platform

Performed data quality check for bugs detected in the application, understanding legacy platform and analyzed customer requirements of systems for building future upgrades for workspace management product

Business Analyst, Cognizant Technology Solutions (CUNA Mutual Group, WI) Nov 2011 - Sept 2015

Performed data modeling on the employee data used for predicting the best composition of retirement plans profile for an employee

Used R and SPSS for the employee data for the renowned credit union to perform customer profiling

Developed SQL queries and complex nested SQL subqueries for extensive data quality checks on outbound files and inbound files, data migration, analysis, and validation

Built Tableau dashboards for visualization of various retirement plans to perform exploratory analysis on various retirement plans offered to employee

Served as a Business Analyst responsible for gather business requirements, analyze data/workflows of an MVC web application to automate the document validation and submission of retirement plan adaption by an employee

Jr. Analyst, Comviva Technologies Limited Jun 2011 - Nov 2011

Performed data quality check for data integration platform with the E recharges and the offers on the same

Worked closely with stakeholders to understand requirements regarding solutions, ensure data quality and perform Gap analysis

Developed visualization using Tableau and MS Excel to explore the sales trends for different region of Comviva’s client base

Created reports of E-recharge trends and offer utilization to be used by the network operators and distributors

Academic Projects

Changing Trend in Murder Weapons in the USA (https://agarg6.shinyapps.io/us_homicide_analysis/)

Performed data exploration to find patterns between attributes with previously unknown relationship, crime and altitude of living

Developed various graphical representation of the various variables to draw inferences from the dataset

Perform statistical analysis of data to understand underlying correlations and association between the different variables

Developed an interactive R Shiny App to visualize and analyze the changing trend in the choice of murder weapon in USA for the last 34 years

Analysis of Applicants’ Profile for the MBA Program

Developed a predictive data model to shortlist the profiles of applicants for the MBA program for an A-class business school

Performed feature selection to reduce dimensionality of the dataset to design an accurate data model for admission procedure

Performed data exploration of the dataset to identify underlying patterns

Created Tableau dashboards for visualization of the identified trends and relationships

Analysis of Homicides Cases in the USA

Analyzed the homicide cases for the last 25 years throughout USA to identify the safety standards for each state

Perform analysis to evaluate the efficiency of the police department to resolve the reported cases for each state

Conducted correlation regression to analyze variable dependencies and study associations and relations between variables

Data Conditioning for NOVEC’s ARIMA forecast model

Developed a python script to condition the meter reading data collected by NOVEC to feed the forecast model that is used to make prediction about the daily electric usage by NOVEC customers

Analyzed the data to perform data exploration to draw insights from the collected data and the suppliers’ data used for billing

Kaggle – Yelp Dataset Challenge

Web scarped data from Yelp website is analyzed to identify trends and fetch insights of the food and hospitality industry of USA

Performed data exploration to identify trends like the most preferred cuisine, the US state with highest reviews, most commonly served dishes

Performed sentiment analysis using the NLP techniques to classify user reviews of the listed restaurants

Performed analysis of the classified reviews to identify the most liked and disliked features of the industry

Accomplishments

Served as Student Organizer for Gravitas 2011, an International Technical Festival with 15000 participants at VIT University

Served as organizer for the first TedX workshop at Cognizant, Chennai conducted in year 2013

Served as placement coordinator of VIT University on-campus career services

Contact this candidate