Second Walmart Connect Internship Advertising measurement / measurement science• Reduced manual iteration time ,improved reliability and modeling workflow of the Category Walmart Advertising Mix Model (Marketing Mix Modeling for a category) by creating an automated/standardized model reconciliation hub. Improving model TAT by 1 day for each model created• Implemented model reconciliation hub by creating a Python ETL pipeline to extract data across measurement solutions , transform the data into reconciliation insights needed to fine-tune/align MMM model with other solutions, and finally load data into new GCP tables. Automated ETL pipeline through Apache Airflow. Created dashboards to visualize model reconciliation data by using RShiny, Tableau, & excel file created by python script• Learned end to end the Category Walmart Advertising Mix Modeling process from EDA, model training/validation, hyper-parameter tuning, model optimization, to creating presentations of results and findings to share with suppliers/sales

•Created/Updated/Resolved tickets in ServiceNow relating to Hardware and Software support at Rutgers University•Collaborated effectively across multiple departments within Rutgers University to ensure the completion of tickets

First Walmart Connect Internship• Automated reporting processes for Billing Operations Team using VBA programming, streamlining data cleaning, calculation of KPIs, andvisualization, to track KPIs more accurately and increase efficiency in reporting, allowing for an improved workflow for monthly reporting needs• Reduced time to generate monthly reports time by 90% (-10 hours), saving substantial amount of time, previously used to manually clean the data• Leveraged Tableau to calculate and visualize Billing KPIs, for data backed decision making and improving operational insights• Transformed manual SOPs and repetitive tasks into automated VBA scripts by gathering requirements, testing, and deploying solutions

• Created /maintained complex SQL queries and stored procedures that feed and refresh the data models surrounding Labs,Pathology,and Inpatient Orders• Created automated monthly reports by using T-SQL & Crystal Reports, tracking key KPIs from new pathology testing offered• Worked closely with a team of systems analysts to assist in the implementation and support of a variety of applications that support day to day functionsthroughout our hospital leveraging agile approaches (specifically around Labs, Pathology and Inpatient Orders)• Developed and implemented solutions for users in their daily workflow by tracking various KPIs with the use of T-SQL, and SAP Crystal Reports• Met with Lab Operations, understood concerns and translated requirements into functional technical requirements, ultimately used system capabilities to optimize workflow for a variety of personnel including pathologists, lab Technicians, and pathologist Assistants