Harshit Aggarwal Email & Phone Number

United States

• Formulated multivariate regression models to analyze the impact of vaccine outreach on health outcomes, enabling targeted campaign delivery through customer segmentation and operational optimization while evaluating return-on-investment (ROI) for a public healthcare client• Facilitated collaborative sessions with stakeholders to define KPIs for a public healthcare client, documenting detailed business and data requirements, aligning with strategic goals, and ensuring feasibility• Modeled and migrated datasets containing over 1 billion rows from flat files to relational databases using Azure Data Factory, resulting in 40% improvement in querying speeds for opioid litigation client• Developed and maintained a comprehensive Purchasing Card (P-Card) analysis tool using customer, product, and transaction data, enhancing continuous monitoring transparency in financial operations• Utilized propensity score matching for public healthcare client to assess cost efficiencies related to Center for Medicare and Medicaid Services quality benchmarks, resulting in over $7.7 million in healthcare expenditure savings• Prepared detailed test cases, expected results and user guides, ensuring high-quality delivery and adoption in line with business requirements

Washington, District Of Columbia, United States

• Transformed unstructured data from various sources tracking policy measures to create concise databases using MS Excel and Tableau• Developed and maintained a data visualization dashboard using Tableau to understand the gendered impacts of COVID-19 for subject matter experts, heads of states and indigenous representatives, helping influence real-world decision-making

Washington, District Of Columbia, United States

• Created a Greenhouse Gas emissions calculator to measure carbon emissions financed by the loan portfolio based on methodology underlined by Partnership for Carbon Accounting Financials• Ingested data from multiple CSVs using a combination of Python and Excel, creating data views to be used in BI tools such as Tableau• Established key performance indicators to track performance of a $16 billion portfolio and generate recommendations for portfolio optimization

Philadelphia, Pennsylvania, United States

• Led the design and development of a road-safety device, raising over $100K in support from crowdfunding platforms• Created Amazon Alexa skill using AWS Lambda to support marketing lead generation for healthcare insurance company• Automated manual Excel processes to reduce reporting time for key performance indicators by 50% for telecommunications client• Maintained and integrated RESTful APIs, enhancing application functionality with third party APIs for user-authentication and real-time data fetching• Delivered user-friendly front-end interfaces utilizing React and JavaScript, collaborating closely with graphic designers, user experience specialists and product designers to ensure accessible and intuitive design• Conducted A/B testing on multiple web pages, resulting in a 25% increase in user engagement and a 15% boost in conversion rates by optimizing call-to-action buttons, headline text, and page layouts.• Utilized Agile methodologies to manage projects tasks and ensure timely delivery of features

Falls Church, Va

• Delivered analysis on social media (Twitter) and its ability to generate business intelligence• Programmed natural language processing (NLP) model to classify the intelligence of a tweet based on approximate string matching (fuzzy matching)• Implemented the model on an Amazon EC2 instance using R scripts and the Linux, Apache, MySQL, and PHP (LAMP) stack

Master Of Science - Ms, Business Analytics

Bachelor Of Science (B.S.), Computer Engineering

Activities and Societies: Drexel Theme Park Engineering DesignMinor in Economics

Education record