Post Job Free

Resume

Sign in

Data Analyst

Location:
Houston, TX
Posted:
June 30, 2020

Contact this candidate

Resume:

Email: add8a4@r.postjobfree.com GitHub: https://github.com/akshittandon96 Mobile: +1-346-***-****

LinkedIn: https://www.linkedin.com/in/akshittandon/ AKSHIT TANDON

PROFESSIONAL EXPERIENCE

Campus Solution Services, University of Houston, Houston, Texas February 2019 – May 2020 Data Analyst (Research Assistant)

• Developed ETL processes for data conversions and construction of data warehouse for approx. 15,000 students.

• Collected, organized and analyzed data for different departments based on varied Key Performance Indicators.

• Performed data reconciliation to maintain data integrity and data consistency within multiple data sources.

• Developed, administered and updated Peoplesoft applications using SQL, PL/SQL and PeopleSoft tools. Atos IT Solutions, Irving, Texas June 2019 – August 2019 Data Analyst (Intern)

• Boosted revenue and reduced SLA penalties by redesigning the company’s strategic approach to analyzing data.

• Obtain varied data and analyzed it to produce actionable reports and answer questions around efficiency and cost.

• Analyze resource utilization and performance data to identify variables impacting performance and scalability.

• Worked with cross-functional teams to structure problems and develop integrated information delivery solutions. National Informatics Center, New Delhi May 2017 – September 2017 Software Developer (Intern)

Worked in a team-oriented environment for all aspects of product development (design, implementation, test, and maintenance support)

Debugged, maintained and added new functionalities to the proprietary applications.

Enhanced user-friendly functionalities and interfaces of websites. SKILLS

Programming Languages: Python, R, C++, Java, SQL

Database: MongoDB, Oracle, MySQL

BI Tools: Power Bi, Tableau, Statistics

Others: Docker, Shell Scripting, HDFS, Agile (Jira), GIT, Linux PROJECTS

Kaggle Competition - Boston Home Value Prediction

Developed multivariable linear regression, Random Forest (Regression Forest) and gradient boosting classifiers to predict the house prices based on several features. Compared 3 models based on RMSE value and R-squared value.

Performed data cleaning and normalization, statistical modeling for feature selection and feature extraction, data visualization, k-cross validation and hyperparameter tuning. Worldwide Flight Data Analysis:

Analyzed large datasets, with information about worldwide flights, routes and schedules from all major airports, stored on Hadoop File System (HDFS).

Analyzed Key Performance Indicators such as fights per airport, delays per airports, number of flights from airports at a given hour etc.

Compared Avro and Parquet file formats against traditional approach in terms of storage and performance in Hadoop.

Used Apache Spark, MapReduce and Python.

Brain study Publications Data Analysis (Text Mining):

Performed explanatory and statistical analysis on a dataset that contains un-structured data split across multiple files about Brain Study Publication with billions of rows.

Generated and interpreted PDF plots, clusters (to group similar publication topics together), network graphs, page ranks, wordclouds and linear models.

Used R Programming, SQL, Scientific R libraries, Gephi, and Statistics. EDUCATION

Master of Science (MS), Computer Science August 2018 - May 2020

University of Houston-Main, Houston Texas

Specialization in Data Analytics. Cum GPA - 3.87/4.0

Expertise: Machine Learning (Python), Big Data Analytics (Python, Apache Spark, MapReduce, HDFS, NoSQL), Visualization

(C++, OpenGL), Statistical Methods (R programming) and Experimental Design (Microsoft Excel). Bachelor of Technology (B. tech), Information Technology August 2014 - May 2018

Guru Gobind Singh Indraprastha University, New Delhi



Contact this candidate