Guillermo Mogollon Colmenares

• I joined in the Private Equity Group in a tight knit team dedicated to commercial due diligence for large PE firms focusing in the software sector. • I worked in a commercial excellence case in which 13 different criteria were evaluated to determine whether an investment in a digital banking product was worthwhile. • The Commercial Excellence case framework sought to determine the extent of potential improvement of the evaluated investments' market position, sales effectiveness, and overall revenue generation in order to determine how much value could be added to ensure a successful exit. • I was responsible with communicating with expert networks to source and perform over 30 expert interviews with both competitors and customers of the potential PE investment gathering extremely valuable primary insights and getting smart on the digital banking sector and obtaining intricate details of the functionality, market position and customer perception of the product considered. • I participated in multiple client development projects spanning from planning for a large pension funds' structuring of a new technology operations unit by assessing how different comps structured their technology and data team's hierarchies. • I conducted multiple expert interviews for a project aiming to produce and pitch a market overview of data connectors to potential investors. • I participated in a project to accurately segment the technology sector into its different branches as part of a pitch to potential software investors. • I participated in an intensive training covering mentorship, the depths of the tools available at Bain, understanding its distinct culture, professional standards and the harder skills like excel, presentation skills, financial modeling and running a case

• Agrolend is a financial services company in São Paulo dedicated to providing credits to medium sized farms around Brasil, with a fast process eliminating the bureaucracy that delays farmer's abilities to fund development and obtention of equipment/technology. • Created, with mentorship and feedback of experienced data professionals, new system to internally handle the loan portfolio, accounting for the revenue accrual, loan receivable value for a given date and provision of doubtful debts for active loans within any given period of operation. • I created, from scratch, dashboards showing the regional variations of corn and soy production in Brasil, important for credit analysis. • Manipulated data on Python, loading it into excel and then presenting charts with analytical commentary through looker studio. • Gained practical skills through on the job mentorship from experienced professionals whilst experiencing work at a fast-growing financial services company in the heart of Brasil's financial sector. • Learnt Portuguese in a business environment fully immersing into the language and culture having to communicate, present and deliver all work in Portuguese.

Participated in the BEL program; a highly competitive program designed to empower high achieving students from underrepresented minorities to delve into management consulting by forming part of a case team at Bain. Received formal training on excel, presentation skills and the Bain toolbox to use these skills to solve the case at hand. Formulated a conclusion with regards to a market penetration question the client was facing, with full autonomy and constant mentorship from more senior consultants in the case. Presented market research data, analysis and final personal recommendation to the case team and partners.

Transcribed multiple sensitive interviews in Spanish and English for a Ph.D Student in the Department of Sociology on a study regarding illegal immigrants in the US; completed CITI Human subject training course.

Wrote and presented a full report to Prohabil’s owners assessing the viability of continuing operations in Caracas. Completed field research interviewing CEOs and customers, secondary research through STEEPLE and SWOT analysis.

Led volunteer group to gather nutritional data of children in 30 food-halls in Caracas’ biggest slum. Identified sectors most affected by the crisis to devise a food distribution plan, after visiting 10 halls for assessment. Directed questionnaires of socioeconomic data regarding impacts of Venezuela’s crisis on the parents of children.