TAVLEEN K. ALLAGH

Rochester, NY ***** 315-***-**** adc83y@r.postjobfree.com https://www.linkedin.com/in/tavleen-allagh/ EDUCATION

Master of Science, Information Management -Syracuse University, NY, USA (GPA-3.7/4) Aug 18 - May 20 Certificate of Advanced Study in Data Science

Relevant Coursework: Big Data Analytics, Applied Data Science, Data Warehouse, Business Analytics & Decision Making Bachelor of Science, Computer Science -Visvesvaraya Technological University, India (GPA- 3.9/4). Aug 14 - Jun 18 Relevant Coursework: Database Management, Operational Research, Data Mining, Probability and Statistics SKILLS

Data Analysis: R (dplyr, ggplot, shiny, mlr, jsonlite) Python (Pandas, NumPy, Matplotlib, NLTK, Scikit, Seaborn, Plotly, PySpark) Data Visualization & Business Intelligence: Tableau PowerBI Adobe Analytics Google Analytics Database Management: PL/SQL T-SQL SQL Server MySQL Oracle PostgreSQL SSAS SSRS SSIS Machine Learning Algorithms: Linear & Logistic Regression Random Forest SVM Naïve Bayes Apriori Decision Trees Other Tools: MS-Office Advanced Excel (Power Pivot, Regression, Optimization) MS-Access MS-Visio Git Visual Studio Software Project Management: SDLC (Agile and Waterfall Methodology) Software Testing Trello JIRA Certifications: Tableau Desktop Specialist Stanford SQL Hands-on with Amazon Redshift WORK EXPERIENCE

Data Engineer and Business Intelligence Intern Kodak Alaris - Rochester, NY May 19 - Present

• Re-engineered ETL process from IBM DataStage to Microsoft SSIS to minimize data loss and manifest an optimized system.

• Migrated Azure Data Factory Pipelines from V1 to V2 using Azure tool kit to maintain version control.

• Revised PowerShell Scripts and a trigger system to automate source-target mapping to form Azure Analysis Cube.

• Optimized and created frictionless experience for tracking real-time data by building customized dashboards for stakeholders. Data Engineering Intern iConsult Collaborative – Syracuse, NY Oct 18 - Apr 19

• Elicited requirements and devised solutions using data pre-processing and statistical analysis to build an integrated system.

• Enhanced user decision making through business intelligence by successfully interpreting data improving data infrastructure.

• Strategized and automated system using SQL Server and Access to solve data storage problems reducing human error by 67%. ACADEMIC PROJECTS

Big Data Analytics Interest Rate and Loan Default Prediction Sep 19 - Dec 19

• Integrated 2.2 million records of loan data by imputation, binning & discretization of independent variables using PySpark.

• Performed feature engineering, exploratory analysis & dimensionality reduction to finalize list of features for ML modelling.

• Achieved an accuracy of 94% in predicting interest rates using Linear Regression and Decision Tree Regressor algorithms.

• Judged classification model performance using Logistic Regression with AUC of 0.9, showing feature importance for loan default. Data Warehouse Data Warehouse Implementation for Martflix Inx. Jan 19 - Apr 19

• Designed dimensional model and performed ETL through Microsoft SSIS to build a Data Warehouse for retail store MartFlix.

• Developed MOLAP and ROLAP cubes to view data at different hierarchy using Microsoft SSAS for business intelligence.

• Sliced and diced OLAP cubes to develop insightful dashboards using SSRS & PowerBI to improve inventory turnover by 65%. Data Analytics IBM HR Analytics Employee Attrition and Performance Jan 19 - Apr 19

• Evaluated importance of effort-reward imbalance, retention strategies and overtime policy in predicting employee attrition.

• Executed Random Forest with an accuracy of 90% in identifying Sales Representative have 50% chance of leaving company.

• Recommended that the HR audit needs to focus on overtime policy, monthly income and age to lower the attrition rate. Data Analytics Improving Airlines Customer Satisfaction Sep 18 - Dec 18

• Analysed 1.3 million records, performed data mining and cleaning using R to improve customer experience on a flight journey.

• Implemented classifiers such as SVM, ARM and Decision Tree to examine the features and impact of external factors.

• Demonstrated an accuracy of 87% and communicated insights found from the analysis through a dashboard built in R-Shiny. Database Administration and Management Library Management System Sep 18-Nov 18

• Built a comprehensive database in SQL using SDLC to alleviate the problem of university supplies in the Syracuse Libraries.

• Created ER diagram using MS Visio, created optimized SQL queries, functions, procedures and triggers in MS SQL Server.

• Devised forms and macros for users by providing restricted access using VBA in MS Access with an intuitive user interface.

• Generated ad-hoc SQL reports to cater the 10 major data questions around student facilitating business decisions. LEADERSHIP, AWARDS AND RECOGNITION

• Community Engagement Manager for Nanhi Kali (Non-Profit Organization), Syracuse University

• Co-Chair for Student Life Committee (Graduate Student Organization), Syracuse University

• Teaching Assistant for Data Warehouse at Syracuse University for a class of 35 students.

• Academic Excellence Award for outstanding performance at Visvesvaraya Technological University

Contact this candidate