I have a strong foundation in financial analysis and business intelligence, and I specialize in transforming complex data into actionable insights to drive effective strategic decisions. Throughout my career, I have demonstrated the ability to contribute to the success of various teams through the implementation of advanced technologies and analytical methodologies. My skills range from advanced SQL queries and dashboard development in Power BI to programming in Python and VBA-Excel for report automation, allowing me to offer a unique combination of financial analysis, business intelligence, and programming skills.My experience includes:- Data analysis and dashboard development in Power BI.- Preparation of financial reports, modeling, and financial projections.- Cash flow analysis and KPI reporting.- Contributing to the preparation and consolidation of budgets, along with accounting validations.- Bank credit readjustment and financial advisories.- Conducting training on financial products.- Banking software testing and participation in digital transformation projects, including the implementation of the Flexcube banking core by Oracle.- Implementation of financial products in banking applications.- Creation of automated tools and financial simulators.- Management of relationships with international payment platform providers such as Stripe, Adyen, Paypal, Payu, Dlocal, Mercado Pago, among others.- Experience in managing external audits with Deloitte and EY.- Leadership of work teams, promoting collaboration and efficiency.I am currently in Cali, Colombia, I have just completed a Master's in Economic Consulting and Applied Analysis at the University of Seville, Spain. I am looking for opportunities that allow me to collaborate with innovative teams, whether remotely or in person in Seville. With a strong interest in data analysis, financial analysis, business analysis, programming, and consulting, I am ready to add value in financial, administrative, IT cross-sectional areas, and fields aligned with my academic background.
-
Business Intelligence AnalystRappi Dec 2021 - Dec 2023ColombiaDeveloping 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. -
Senior Financial AnalystBanco De Occidente Dec 2018 - Dec 2021Cali, Valle Del Cauca, ColombiaAnalyze 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. -
Financial AnalystBanco De Occidente Mar 2017 - Dec 2018Cali, Valle Del Cauca, ColombiaConduct 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.
-
Financial AnalystComfandi Sep 2016 - Feb 2017Cali, Valle Del Cauca, ColombiaAnalyzing 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. -
Tender AnalystMetálicas Costa Apr 2014 - Apr 2016Acopi - YumboResponsible 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.
-
Tenders AssistantDeltec S.A. Mar 2013 - Sep 2013Participate in the preparation and submission of tenders with the public and private sector.
Christian Gallego Education Details
-
Máster Universitario En Consultoría Económica Y Análisis Aplicado -
Economics -
Economía
Frequently Asked Questions about Christian Gallego
What is Christian Gallego's role at the current company?
Christian Gallego's current role is Data Analyst | BI Analyst | Financial Analyst.
What schools did Christian Gallego attend?
Christian Gallego attended University Of Seville, Universidad Del Valle (Co), Universidad Del Valle (Co).
Not the Christian Gallego you were looking for?
-
Christian Corrales Gallego
Controlling, Budgeting And Insurance Manager At Hispasat En HispasatMadrid2interpublic.com, hispasat.es -
Christian Gallego Arroyo
Madrid1gmail.com -
Christian Velasco-Gallego, PhD
Phd In Naval Architecture, Ocean And Marine Engineering | Data Scientist For Maritime + Smart MaintenanceSpain -
Christian E Verdonk Gallego
R&D Engineer In Air Traffic Management In Crida A.I.E. / Visiting Fellow In Atm In Cranfield UniversityMadrid
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial