Mandip Bhadra Email & Phone Number

New York, Ny, Us

New York City Metropolitan Area

Promoted to Consultant level C2 in September 2023 for outstanding performanceProject: Behavioral Health Data Analysis for Health Insurance Enterprise (October 2023 - Present)- Worked with Novawell within BCBS NJ to provide data analysis and pipelining of behavioral health data utilizing many different datasets; utilized SQL, Python and AWS extensively- Worked with clients to gauge user requirements and customer desires to enable large scale data standardization and output for many healthcare entities centering on behavioral healthProject: Scaling Delivery and Operations for Food Bank (May 2023 - October 2023)- Collaborated closely with clients to understand user requirements and operations, providing actionable product recommendations to increase efficiency- Enhanced web app daily delivery capability from 6,000 to 18,000 using data-driven decision-making and product development utilizing tools like React, Typescript, Javascript and DynamoDBProject: Web App for Startup (Oct 2022 - Apr 2023)- Regularly interfaced with clients to gather feedback, address blockers and refine product features based on real-world use cases- Implemented solutions for features such as product customization, logs, sim replacement, and eligibility criteria utilizing tools such as Javascript, HTML and CSS

- Worked in the Economics Department to study the effects of gender ratios on classroom/ workplace coordination- Built and refactored web application to establish functionality, implemented matching algorithm, automated testing, and analyzed result data. Coordinated with the professor to clarify and develop research focus. Utilized Python, Django, and OTree

Charlottesville, Virginia, United States

- Managed an application used to conduct summer classes within Canvas called CONEX. Application was used by over 230 students/instructors spanning 3 schools. - Built and refactored scripts to update and load relevant materials through connecting to MongoDB and implementing a REST API. Developed new features such as gamification, badges, user progression, and dynamic coursework editing.- Worked on new version of the site and refactored old code in order to restore performance and make easier to debug/develop in the future. Application is built with Node.js.

- Automated airline data collection and analysis utilizing tools like Python, Selenium, NumPy, and Matplotlib. Decreased data collection/upload time by 80%.- Indexed, partitioned tables, and optimized queries in order to decrease runtimes by over 70%. Utilized Tableau Server and Desktop in order to foster smooth, collaborative data analysis. - Utilized the Google Maps API to conduct data collection and processing on parking spots in US cities. Built Image Classification system using machine learning to identify relevant parking garages within photos.

Charlottesville, Virginia, United States

- Co-Founded a B2B service to connect construction companies with materials manufacturers based in India. - Built a demo application of the service using Django and pitched to different companies.

- Formed relationships with local businesses / business owners across the Northern Virginia Area in need of entertainment through the form of music. - Played as a regular at Potbelly Sandwich Shops, Arlington Fair, and various retirement communities such as Sommerset, Brightview, Sunrise, Waltonwood, and The Crossings at Chantilly; used entrepreneurial skills to establish local entertainment business.

Mclean, Virginia, United States

- Worked in MITRE’s Center for Advanced Aviation and Systems Development. Researched the effects of natural disasters on the airline industry, provided data analysis and research presentation materials.- Used Excel and Python to mine and automate data collection, and worked in a team towards estimating response and efficiency patterns of different transportation modes.

Mclean, Virginia, United States

- Worked in MITRE’s Center for Advanced Aviation and Systems Development. Utilized existing data to make predictions on tourism and contributed to a Computable General Equilibrium Modeling (CGEM) of international airline transportation. - Used SQL to provide research assistance towards understanding the impact of US airline mergers and acquisitions.

Bachelors, Computer Science

Bachelor Of Arts - Ba