Arpit Bajpai Email & Phone Number

Raleigh, North Carolina, Us

● Developed a model to identify customers with the highest propensity to respond to the bank's cross-selling marketing campaign.● Collected, compiled, and wrangled messy data from multiple SQL Databases, Excel Spreadsheets, and SAS files then transformed them into useful features that increased model performance.● Created a debt liability model using a SARIMA model, improving accuracy by 70% over the existing model.● Gathered data from multiple sources, cleaned and preprocessed it to ensure high-quality input for modeling.● Applied data augmentation techniques such as upsampling, downsampling, and SMOTE to address class imbalance and enhance model performance.● Collaborated with cross-functional teams to implement data-driven strategies and drive business growth.

Charlotte, Nc, Us

● Implemented demand forecasting model using an ensemble of Linear Regression, Tree Based Models, and Neural Networks, improving forecast accuracy by 50%. ● Developed a data pipeline that automates all data gathering, organization, and calculation from a time-intensive process taking several hours every month into a process that occurs automatically at the start of every month. ● Drove interaction and partnership between managers to ensure active cooperation across multiple teams to best define analytical needs and best meet stakeholder defined goals.

Houston, Texas, Us

• Transferred and Transformed data from Excel, SQL, SAS, and Tableau to pandas’ data frames to operate in.• Ensured smooth communication between the development team and the client, focusing on a correct transition of the requirements and specifications.• Consolidated and refactored legacy program modules that significantly improved code maintainability and reduced deployment time 80%• Automated the creation of visualizations according to specifications gathered from stakeholders saving 4-6 hours per forecasting cycle.• Identified errors and inconsistencies in the original excel model, increasing forecast precision and accuracy. • Translated excel formulas into business requirements and translated said requirements into python code increasing program reducing transcription error forecast to forecast.• Automated creation of excel reports using formulas such as VLOOKUP and pivot tables with Python.• Worked on Agile methodology and involved in scrum meetings to give inputs as technical expert to application design for performance tuning and admin requirements.• Created pivot tables and charts using worksheet data and external resources, modified pivot tables, sorted items, and group data, and refreshed and formatted pivot tables.• Used a variety of reporting tools like Python and Excel Spreadsheets to assess Product program performance for the new system integrations.• Reviewed Code using GitHub pull requests, improved code quality, and conducted meetings among peers.

Houston, Tx, Us

• Performed Bayesian Regression Analysis to forecast the company’s revenues using Python achieving 99% r2 accuracy in order to help the hospital better allocate its $2B in revenues across the year.• Collected, compiled, and wrangled messy data from multiple SQL Databases, Excel Spreadsheets, and CSV files then transformed them into useful features that increased modeling accuracy and provided greater insight into the dataset.• Designed a package that automates data preprocessing, feature engineering, and modeling so that projections can continue to be made on a consistent basis, saving an estimated 120 hours quarterly.• Generated dashboards and visualizations using Plotly that provided insight into the trends of how often certain medications were prescribed and communicated that information to non-technical stakeholders.

New York, New York, Us

• Taught industry-leading data science practices to 40 students through over 300 hours of instruction split between lecturing and 1-on-1 coaching to advance expertise in Python and modeling techniques like Linear Regression, Logistic Regression, Decision Trees, Random Forest, XGBoost, and Support Vector Machines.

• Researched individual businesses and examined KPIs to evaluate the growth and profitability and then presented findings to Principia’s Managing Director.

Bentonville, Arkansas, Us

Cashier at Wal-Mart

Data Science Bootcamp, Data Science

Bachelor'S Degree, Management Information Systems, General

Education record