Christian Gallego Email & Phone Number

Seville, Al, Es

Colombia

Developing advanced SQL queries and Power BI dashboards according to business needs; data cleaning and extraction from different information sources; analyzing and validating financial data, invoices, accounting accounts, databases, and transactions; automating and ensuring the availability, accuracy, and quality of different financial reports; reconciling transactions; implementing cash flow analysis methodologies, and accounting validations; preparing financial data projections; conducting reporting reconciliations and negotiations with key payment platforms (Adyen, Stripe, Dlocal, Paypal, PayU, Mercado Pago); experience with payment platform providers in Mexico, Brazil, Uruguay, Peru, and Ecuador; experience in handling external audits with Deloitte and EY; proactively communicating unusual findings in the databases.

Cali, Valle Del Cauca, Colombia

Analyze databases; conduct audits and financial tests on the bank's applications (Flexcube, Siscar, and Siif) that ensure the proper functioning of existing financial products and the launch of new products; contribute to the preparation of the individual and consolidated budget; validation and monitoring of the bank's cost model implemented by Deloitte; report KPIs; perform settlement of transfer interests; provide financial advisories to other areas; validate financial information; report Colombian market rates; develop financial simulation tools; participate in various digital transformation projects. Financial Team Leader - Core Banking Project - Flexcube (Oracle) Jun 2019 – Jan 2021 Gather financial definitions from various bank areas; convey key knowledge to areas of interest; certify financial information generated by Flexcube; specify requirements in technical documents for the development of functionalities by Oracle; coordinate the efforts of the financial team; perform simulations and financial projections; report project progress. **Achievements: I implemented SQL controls that identified and corrected operational errors in payment plans, avoiding negative impacts on customers; using Excel and Macros, I developed tools that minimized operational efforts and enhanced the efficiency of financial tests by 80%; I facilitated the understanding of payment plans through simulators for the sales force and support areas; I conducted the financial certification of Flexcube for its implementation in production.

Cali, Valle Del Cauca, Colombia

Conduct financial audits on assigned accounting accounts; prepare the portfolio placement report; perform accounting captures in SAP; contribute to the budget preparation; audit the operation of portfolio applications (calculation of current and overdue interests, principal, fixed charges, payment applications, and updates); re-liquidate financial obligations; confirm the accuracy of payment plans for new financial products in the Siscar, Siif, and FirstData applications. **Achievements: I automated financial reports through Cognos Analytics and automated Excel templates, saving more than 3 hours weekly; automated about 60% of the templates used for portfolio tests, which reduced response times.

Cali, Valle Del Cauca, Colombia

Analyzing requests for corporate credit limits; analyzing and presenting to management the financing alternatives for internal projects; supporting the analysis and validation of financial figures.** Achievements: Proposed and developed a financial scoring for the analysis of credit limits, which facilitated decision-making and control of associated financial risks; automated the calculation of annual budget scenarios.

Acopi - Yumbo

Responsible for the tender department. I prepare and submit commercial offers in procurement processes through tenders with the State. I analyze financial and legal documents from other companies to establish strategic alliances for participation in temporary unions. I carry out analysis of procurement processes that allow determining which processes offer a higher probability of winning.Achievements: In the first year, I achieved sales of more than one billion pesos, doubling the company's average revenues from previous years, and in the second year, I achieved sales of more than two billion. I created and structured the tender department within the commercial area. I strengthened financial, legal, and technical indicators to facilitate participation in procurement processes. I generated and strengthened commercial allies to participate as temporary unions in procurement processes.

Participate in the preparation and submission of tenders with the public and private sector.

Máster Universitario En Consultoría Económica Y Análisis Aplicado

Especialización En Finanzas, Economics

Economista, Economía