Aniparna Sengupta

Aniparna Sengupta

Data Engineer ll at Amazon Fulfillment Team, GHC'24 · Ultimate Medical Academy

Seattle, Washington

In My Own Words

Enthusiastic and a driven professional with experience in SQL development , visualization in Power BI and Data analysis in Python.

Fast learner, culturally adaptable and proactive under pressure with a strong sense of commitment.

Completed Master’s Degree in the field of Business Analytics at the Naveen Jindal School of Management, University of Texas at Dallas and contributing to projects in Business Intelligence, Data Analysis using tools like Tableau, R Studio ans Advance MS Excel.

Work Experience

Operation Analyst

Ultimate Medical Academy

2018 – Present

SQL, Excel, SSRS, SSIS(ETL), Power BI • Extracted data using procedural SQL and displayed pending loan amount of each student using SSRS • Implemented webpage features in SSRS using linked report to display extensive information about the student • Introduced checkbox features in SSRS which gives authority to the user to add new activity through which student loan files count get precise by 90% • Worked on extracting data from excel using SSIS and implemented the student grant files count in SSRS • Performed trend analysis using Power BI to determine the reason through which student retention can be improved • Trained the team on Microsoft visual studio and explained them the process to implement linked reports

BI Engineer Intern

Amazon.com, Inc

2017 – 2017

SQL, R, Excel, Tableau • Fetched 2 billion records from Redshift cluster using SQL and analysed the data with Tableau to perform cohort trend analysis • Extracted the characteristics of the best sellers using K-means clustering technique and ran multiple models (individual fixed effect OLS Regression, Ridge & Lasso Regression, Decision Tree) with accuracy rate of 80% to calculate the Seller DSI based on all seller's individual fixed effect upon the predictors • Recommended the team to consider the sellers rating and seller's return rate of the product as important input features that will enhance the accuracy rate of calculating the seller DSI • Presented the model and findings in a 6-pager document to stakeholders in Supply Chain Optimization Team (SCOT)

MFI Project|Programmer Analyst

Exilant Technologies Pvt Ltd

2012 – 2016

SQL, R, Advance Excel, Tableau • Executed vendor sales data analysis (including seasonality effects) to forecast manufacturer demand for various apple accessory components • Performed OLS regression to estimate demand at different accessory components price and at different quarter cycle. • Executed batch job using SQL to generate report to the client on the predicted demand data • Presented the result using Tableau to the client and recommended accessory components pricing plan based on the manufacturer demand which helped client increase profit by 20% Apple Travel|Business Intelligence Developer SQL, Excel • Extracted employees travel data (300,000 approx.) to analyses the travel cost undertaken by the client • Optimized the SQL queries used in quarterly batch job to fetch the employee's data and improved the performance time from 3 mins to 2 secs. • Utilized MS Excel pivot tables, data validation and graphical manipulation to analyse the data before usage • Designed storyboards, custom reports, dashboards and scorecards to estimate travel expenditures by time and employee's role • Analysed recent trends and events to forecast the best time in a year to travel to vendor's location with minimum cost

Education

M.S. Business

The University of Texas at Dallas

2016 – 2018

M.S. Business