Having interned full-time for 6.5 months in the consulting industry, I am great at managing conflicting urgent deadlines. When everything is urgent, I will try my best to determine which task is most urgent, and complete this first. I will also prioritize the tasks that require more effort to complete. For instance, if I were assigned to update financial models and prep decks in the same day, I would prioritize updating financial models first. This is because updating financial models may require greater attention to detail and further research to ensure accuracy of data and modeling techniques, while I have had more experience in creating decks and marketing (through extracurriculars) so I feel more confident in being able to complete the deck in good quality in less time.

As the internal vice president of a Filipino students' association at my university, I had to oversee not only the financials but also the logistics and planning for our cultural appreciation events. In this association, we had different people in charge of different tasks (ie. contacting sponsors, ordering required materials, marketing the event, coordinating with university staff and students, managing the finances) and it was my responsibility to ensure they were all coordinated. Hence, I created a Google Sheet for everyone to log in their progress regularly, and this Sheet was made accessible to everyone on the team as a shareable and editable link. This way, progress data was clean, consistent, and up to date across all association members. In addition, as we planned the events, I created another Google Sheet for our financials where persons-in-charge would log event-related expenses once incurred, and I also updated the Sheet accordingly with any cash inflows (ie. membership fee, event fee, university funding). As the whole team referred to one Google Sheet (which could be viewed and edited simultaneously by multiple users) for all our finances, data available to teams were clean, up to date, and aligned at all times, which streamlined coordination and prevented miscommunication.

In my most recent consulting internship with Mercer, my team had just newly expanded its compensation and benefits survey data scope by about 3x the number of respondents for a total of 1.3 million data points. As this was considered a large dataset, it could no longer be analyzed through traditional methods on MS Excel, and hence I self-learnt Power Query on Excel to better clean and manipulate the survey data, breaking them down to eventually be analyzed with PivotTables.