TARUN KUMAR

Chicago, IL adkegd@r.postjobfree.com 773-***-**** https://www.linkedin.com/in/tarunkumar0490/ GitHub Tableau-Public PROFILE SUMMARY

SKILL SET

Big Data and Data Mining Tools: Spark, Sqoop, Hadoop, Hive, HDFS, SQL, T-SQL, SparkSQL, YARN, Oozie, Zookeeper Machine Learning Algorithms: Decision Tree, Random Forest, Linear and Logistic Regression, Clustering, Neural Network, KNN, CNN R and Python Packages: GGPlot2, NumPy, Pandas, Matplotlib, Seaborn, NLTK, Spacy, SciPy, Scikit-Learn Databases: MS SQL Server, MySQL, PostgreSQL, Snowflake, MS Access, DynamoDB, MongoDB Programming/Scripting Languages: SQL, Python, R, Scala, C#, DAX, PowerShell, jQuery, JavaScript, HTML, CSS, XML Tools/Platforms: Tableau, Power BI, MS Office Suite (MS Word, MS PowerPoint, MS Excel), MS SQL Server, SSIS, SSRS, SSAS, MS Visual Studio, Jupyter, RStudio, SharePoint, Google Analytics, AWS, Azure, HPSM, JIRA EDUCATION

Master of Science in Business Analytics Dec 2019

University of Illinois at Chicago – Liautaud Graduate School of Business Chicago, IL Bachelor of Technology in Electronics and Communication Engineering Jun 2012 Jaypee University of Engineering & Technology India PROFESSIONAL EXPERIENCE

Data Analyst TVG-Medulla LLC, Oak Brook, IL Jun 2020 - Dec 2020

● Collaborated with C-Suite executives and cross-functional business/technical teams to identify and define important metrics; Built out the data and reporting infrastructure using Power BI and SQL to provide real-time insights into clinical, marketing funnels, financial, operational, and business KPIs

● Designed and implemented A/B experiments in Python on marketing data to increase the customer acquisition rate by 20% and increase the monthly revenue by over 2%

● Composed complex T-SQL queries, stored procedures, and views to provide structured data to business units by combining millions of rows of data from 9 disparate data sources

● Analyzed the Search AdWords campaign data in Spark and optimized the search keywords for Google Analytics marketing campaigns thereby reducing the total cost by 20%; Implemented and executed complex Map/Reduce jobs to perform jobs with large data volume in time efficient manner

Data Research Analyst Abbott Laboratories, Lake Forest, IL Feb 2020 - May 2020

● Leveraged market and sales data of healthcare and medical devices domain into innovative features, insights and opportunities through data mining, data cleaning/curating, wrangling, missing values imputation, excluding outliers using R and Python libraries NumPy, Pandas, SciPy and scikit-learn; Created the VBA scripts and macros to automate the data extraction from Excel files

● Ensured data quality assurance and increased accuracy of machine-learning algorithms such as linear and logistic regression, decision tree, random forest by nearly 11%

● Composed SQL scripts and procedures to retrieve data from large disparate sources to construct data ETL to support organizational data warehouse; Developed interactive dashboards in Power BI using DAX queries to provide tracking of KPIs Data Science Intern VisTracks, Chicago, IL Aug 2019 - Dec 2019

● Extracted raw customer data from AWS Redshift and performed statistical analysis, survival analysis, CLTV and logistic regression to predict customer behavior; Developed dashboards in Tableau to support analysis providing vital insights into customer base

● Recommended customer retention strategies, identified new areas of customer acquisitions, revenue growth; Developed ad-hoc reporting and analysis solutions to support business continuity Information Technology Analyst TATA Consultancy Services Limited, Pune, India Mar 2018 - Jul 2018

● Analyzed data stored in CMS portals for a multi-industrial client with $31 bn revenue to drive insights into identifying important levers resulting in reduction of migration timeline by 30%; Implemented ETL process for data migration to SharePoint Online increasing the efficiency by 40%

● Authored 10+ business intelligence reports to monitor monthly and quarterly performances, improving the crucial business decision making process by 20%

● Implemented Fast Query Search Service Application in SharePoint environment to provide enterprise-wide federated search capabilities by writing optimized complex SQL/T-SQL queries; Reduced the content search time by 50%

● Supported and streamlined solutions deployment into production by collaborating with cross-functional teams; Orchestrated end- to-end application deployment processes leading to successful project deliveries

6+ Years’ Experience Healthcare Analysis Wholesale and Retail Analysis Data/Business Analysis

Machine Learning Requirements Analysis ETL Distributed Systems

Customer Support & Relations Databases & Data Modeling Agile Methodology Execution Dashboards/Reports

Proactive & Results-oriented Team Player Leadership Skills Customer centric Senior System Engineer/ System Engineer Infosys Limited, Pune, India Jun 2013 – Mar 2018

● Led the team of 4 on ETL project increasing the overall platform efficiency by 70% and decreasing the timeline by 40%

● Led and mentored the team of 4 to provide efficacious technical support (SLS) to the end-users reducing the resolution time by 40%; Communicated with stakeholders on a regular basis to resolve the issues and ensure client satisfaction

● Designed, implemented, and maintained the multi-lingual CMS platforms supporting the daily business operations for a Wholesale and Retail domain client with $31.9 bn revenue and Healthcare client with $18 bn revenue

● Implemented decision tree, random forest and regression based classification machine learning algorithms to classify client’s potential fraudulent and whitelisted transactions to recommend patterns in fraudulent transactions

● Administered time-series driven auto regressive integrated moving average (ARIMA) forecasting model in Python for HR business partners to forecast annual employee attrition and retention strategy; Drove 2.8% reduction in employee attrition over a year

● Prepared the estimation documents stating the efforts and resource needs for the new development and enhancement requirements; Performed the GAP analysis and prepared the PA documents for multiple projects

● Developed and maintained databases by composing SQL/T-SQL queries to support the backend of various web applications; Created stored procedures, functions, views, and triggers for efficient database management

● Collaborated with developer team to build, test, and validate real-time dashboards populating live business data from the ERP’s relational databases for an efficient campaign tracking and insight generation using Power BI

● Identified issues, provided solution, defined relevant metrics, made data-based recommendations, and drove commercialization of new products in partnership closely with business intelligence and other stakeholders to impact decision making PROJECTS

● Analysis & Visualization of On-Time Performance of Airlines: Developed the visual dashboards and stories to best describe the on- time performance of Envoy Air using key flight delay metrics and compared its performance against the other airlines in the industry

(Excel, Python, Numpy, Pandas, Tableau)

● Customer response Prediction to Direct Marketing Campaign: Implemented PCA to reduce initial 368 variables to 28 significant variables and trained predicted models such as Decision Tree, Logistic Regression, Gradient Boosting and SVM; Compared their performances using ROC (Python, Numpy, Pandas, Matplotlib, Scikit-Learn, Jupyter)

● Credit Data Analysis: Trained Decision Tree model with various parameter combinations to determine the risk involved in issuing a loan to new applicants (R, RStudio, C50, rpart, ROCR, randomForest, readxl, ggplot2, dplyr)

Contact this candidate