Diya Patel Email & Phone Number

Chicago, Illinois, United States

- Modernized operational reports using Power BI, allowing the alliance operations team to become proactive rather than reactive in addressing issues with airline partners that could affect the customer experience or interfere with airport and network operations- Transformed views of 8 key operational metrics to provide day and airport level insight, gathering data from SQL servers and creating 45+ visualizations that represented United Airlines’ relationship with 150+ alliance partners, both in Star Alliance and beyond- Launched a new reporting tool that used over 300,000 data points to provide key insight into customer sentiment on alliance partners

- Lead a 5-person project team in generating key business insights and developing a sentiment analysis scoring methodology for client- Leverage sentiment analysis, Python, and Tableau to identify and highlight key data trends in 100+ topics and ~100,000 data points- Build relationship with client through weekly meetings to determine business needs and a final presentation to the executive team- Collaborate with a community of like-minded students and professionals about avenues for growth in data science and analytics

- Performed statistical analysis on 23,000+ data points and conducted market research on donor recruitment for the client- Created a deliverable with 15+ Tableau, Octave, and Python visualizations and 4 targeted recommendations for organizational growth- Mastered additional data analytics technologies such as SQL, Excel, and R by attending 4 advanced technical modules

Washington, District Of Columbia, United States

- Worked with a case team to present a 16-slide deliverable analyzing sales and operations and recommending 5 targeted solutions- Adapted to applying data analytics and visualization technologies in the consulting sphere through an intensive 10-week training course

- Designed, marketed, and led 7 student-centered events each semester to cultivate a strong community for 99 first-year residents- Managed administrative duties such as budgeting limited funds and coordinating between campus offices to resolve urgent problems- Initiated and facilitated group discussion to resolve conflicts between residents and maintain a positive living environment

Washington, District Of Columbia, United States

- Conduct in-depth industry and capital investment analysis on business aviation and defense, two key issues of interest to the company- Draft a multistep plan to increase the success of procurement bids by researching market competition, guidelines, and relevant resources- Demonstrate efficiency by simultaneously working on 4 short- and long-term research projects, meeting or surpassing deadlines

Georgetown University, District Of Columbia, United States

- Wrote and published articles about science-related events, critically thinking, organizing, and planning to meet deadlines- Compile interviews with a wide variety of sources, including subject matter experts, and present information in a digestible format

- Innovated to solve an industry-wide challenge and won a competition among 150+ intern teams after evaluating the needs of key stakeholders, finding opportunities to maximize impact and minimize costs, and presenting to company leadership- Overhauled existing data management software to improve efficiency, modernize systems, and consolidate different data flows, resulting in an estimated annual savings of $135,000+ and new opportunity for future growth- Delegated 100+ hours of weekly tasks to optimize productivity across the team, ensuring the creation of a deliverable- Met deadlines and completed tasks in 2 week sprint periods while collaborating with a team spread through 3 countries and 9 states

Washington, District Of Columbia, United States

- Assisted in legislative research, press briefings, data entry, constituent correspondence, and other general office operations- Attended legislative hearings and staff briefings on various topics such as foreign affairs, international business, and R&D laws- Acted as the first method of contact by answering policy questions and handling messages from constituents with differing opinions

- Wrote grant proposals and coordinated with an international network to promote economic stability for women in Guatemala City

Watertown, Connecticut, United States

- Maximized efficiency through workflow management to fill 100+ prescriptions daily- Streamlined a medication inventory worth over $150,000 to lower business costs while maximizing profits and customer experience- Managed high volumes of financial and health data through programs like QuickBooks, Best Rx, and Excel- Responded to customer needs by answering questions and connecting patients to pharmacists when necessary

Shelton, Connecticut, United States

- Increased membership by 100% and diversity from 43% to 59% by marketing to and connecting with underrepresented groups- Led team to rank 4th in the division at the World Championships and win an Automation and three Innovation in Control awards

Shelton, Connecticut, United States

- Reviewed, merged, tested, and optimized over 3,000 lines of code from 7 different programmers each season- Integrated calculus-based algorithms that allowed the robot to adapt to the environment using data from sensors into the code- Trained 5 freshmen, sophomores, and juniors in C++, code structures, and control systems by working one-on-one and conducting in-depth code reviews and feedback sessions- Optimized alliances and exploited weaknesses of other teams at competitions by analyzing data on 35 to 70 teams’ performances

- Revised and presented the team business plan, which included a mission statement, SWOT analysis, and financial overview- Authored a value-driven business model and a business pitch that placed 21st internationally in the Innovation Challenge

Shelton, Connecticut, United States

- Promoted STEM education for 1,500+ students by growing the Outreach Committee and launching STEM challenges

New Haven, Connecticut, United States

- Collaborated with Yale professors and students to study the molecular makeup of proteins for potential future medical applications- Delivered weekly presentations about the molecular structure of proteins to a panel of professors from Yale University and University College London- Compiled information about and designed visualizations for numerical data on 200+ protein structures- Constructed computational models to compare structures solved by NMR and X-Ray crystallography

Bachelor Of Science In Foreign Service - Bsfs, Science, Technology, And International Affairs, Senior

Activities and Societies: Hoyalytics, Resident Assistant, Cornerstone Mentor, Asian American Student Association, Autumn Leaves Musical

High School Diploma

Salutatorian, High Honors, Student Council President