Aditya Bairagi

Dallas, Texas (*****) 682-***-**** adnbpu@r.postjobfree.com LinkedIn

EDUCATION

The University of Texas at Dallas - Dallas, TX May 2021 M.S., Information Technology and Management (Dean’s Excellence Scholarship) Institute of Engineering and Technology - India May 2017 B.E., Electronics, and Telecommunication

TECHNICAL SKILLS

Languages: SQL, Python, SAS, Adv. Excel, R

Python Libraries: Pandas, NumPy, Scikit Learn, Stats-models, Matplotlib, Seaborn Big Data Tool: Apache Spark, HDFS, Scala, Apache Hadoop Databases: MySQL, SQL Server, PostgreSQL, MongoDB

Visualization: Tableau, Power BI, Qlik Sense, Adobe Analytics Statistical Techniques: Hypothesis Testing, A/B Testing, Customer Segmentation, Cluster Analysis Machine Learning: Regression, Classification, SVM, PCA, KNN Data Engineering: Batch Data pipelines, SQL Scripts, ETL, Star Schema BUSINESS EXPERIENCE

PNC Financial Services - TX, US Dec 2020 – Present Data Analyst

Evaluating business processes, anticipating requirements, uncovering areas for improvement, and developing and implementing solutions. Leading ongoing reviews of business process and developing optimization strategies

Transformed data to create aggregated tables from multiple tables to build weekly business report and executive-level summary in Tableau, briefing cross-functional team

Ensured data quality, identifying and eliminating inaccuracies and duplicates using SQL and Excel

Created live Dashboards using Power BI and Tableau by connecting to DynamoDB as an ODBC Data source

Performed Trend Analysis in Excel on customer credit card payment

Reported to the marketing team to improve marketing campaigns and product effectiveness using A/B Testing

Performed customer segmentation using K-means cluster analysis in Python_JupyterNotebook to identifying passive promoter and detractor customers

Predicted credit card defaulter using classification models, and collaborated with retention strategy team to improve customer retention by 12%

Webcraft IT - India June 2016 - April 2019

Data Analyst

Performed data cleaning, aggregation, validation, and data analysis on relevant e-commerce metrics which contributed to generating a business product revenue of $0.85 Million

Monitored and reported KPIs for the large-scale logistics of outsourcing components using interactive Tableau dashboard

Used statistical techniques to analyze the impact of outlier variables on the overall business functionality and built the consumer validation metrics using the PROMISE dataset achieved an accuracy of 92.57%

Developed Ad-hoc reports using MySQL, SQL_Server, Tableau, Power BI, Automated reports using macros and VBAs in Excel, achieving 25% efficiency by reducing manual cleaning and structuring of data ACADEMIC PROJECTS

Truck Fleet Data Analysis for identifying risk factors to Drivers across US Aug 2020- Dec 2020

Ingesting truck fleet data into Hadoop distributed file system (HDFS) using SCP, creating tables in Hive and Impala for data preprocessing, analysis, and building transformation tables using HiveQL

Creating Parquet tables in Impala and implementing PIG Script logic for loading data in Impala

Integrating Impala with Tableau via Cloudera Hadoop Server, Implementing Logistic Regression using R with deployment in Tableau for visualizing driver’s risk factor and calculating threshold to determine risk factor for each truck driver via Reserve Price Prediction Analysis of Berlin Airbnb Aug 2019 -Dec 2019

Devised an ML-based prediction analysis system to predict the room price in Berlin when booked through Airbnb

Formulated various data evaluation methods like - Normal Distribution & PCA to extract the effective parameters and transforming unstructured data into linear data vectors to analyze and train them with lower complexity

Optimized the network by tuning the hyper-parameters and train the predictive model with Random Forest, KNN, Linear Regression, and SVM but achieved a maximum accuracy of 68.90% in the SVM algorithm

Contact this candidate