Andres Felipe Bermudez Valencia

Andrés Bermudez Valencia ECONOMIST Bilingual economist with expertise in corporate finance, project valuation, capital allocation, and structuring stock market portfolios. I am known for my discipline, honesty, responsibility, and easy-going nature. Additionally, I possess skills in leadership, effective communication, efficiency, and advanced Excel proficiency. My areas of expertise and interest include macroeconomics, data science, business modeling, finance, company valuation, Python programming, statistics, econometrics, project valuation, and Excel process automation. - - https://www.linkedin.com/in/andr%C3%A9s-felipe-berm%C3%BAdez-valencia-8ba686135/ https://github.com/Andresberval PROFESIONAL EXPERIENCE EDUCATION Economist - Universidad del Valle Investment Portfolio Management Compliance Course Financial Risk Certification ISO 31000 Financial Risk management Financial Risk Measurement Diploma Excel Modelling of finance projects GED Software and Programming SONICARE SOLUTIONS | Business analyst • Supporting sales department to various government departments, such as the Defense Logistics Agency (DLA) and the Federal Emergency Management Agency (FEMA). Identifying price differentials and providing the company with winning options. • Acquiring and managing DIBBS (DLA Internet Bid Board System) for bids submitted to the federal government. • Supporting sales department by bringing sales to private institutions for more than $ 45.000 (avg. yearly). Sales to companies such as Aggie Charmille, Beckman Coulter, Thales Australia, and others. • Reporting to senior executives and CEO within the company. EFICACIA | Finance Analyst LANGUAGES Spanish English German Native B2-C1 A2 KNOWLEDGE AND SKILLS Assertiveness Solving Problem Detailed oriented Leadership Customer Services Excel Python SQL Finance Modelling Mathematical skills The company focuses on staff and HR outsourcing. Their main project was based on TI and technological shifts. Most of the projects required the following tasks and activities: • Project evaluation modeling and monitoring • Gathering of information and data to model financial projects • Incomes and expenditure financial controlling of projects • Macro modeling for client profile automation • Construction of KPIs for financial and project control • Financial systematical reports using Dashboards in Excel and Power BI • Analysis and construction of profitability and return financial indicators. SINGLAR CONSULTORES | Finance Analyst • Financial analyst providing support and financial advisory to companies such as IMCOR PAPELES in the following areas. • Financial evaluation of projects for IMCOR Papeles to purchase a paper processing machine to save resources and improve processes. • Modeling and monitoring budgets using process automation in Excel. • Cash Flow, Treasury report and debt reports monitoring for companies associated. • Financial valuation of projects CENTRAL CONTROL | Financial Analyst • Assist in the modeling of the company's- budget. • Prepare the company's Income Statement projection. • Calculate profitability based on NPV and IRR. • Monthly expense control of the company. Comparative report of projected versus actual expenses. • Debt structuring analysis. Optimize debt rollover strategies. Debt waiver. Construction of debt indicators. • Finance valuation of the project • Financial profiling of potential clients. REFERENCES Yakov Pekar Senior Database Engineer and Data Architect +1 - https://www.linkedin.com/in/yakovpekar/details /experience/ SUPERGIROS | Finance Risk Coordinator • Elaborate and develop a financial risk manual. • Ensure company compliance with Colombian financial risk regulations. • Train staff in financial risk laws. • Model liquidity risk measurement. • Monitor metrics and policies adopted by the company by Colombian law. • Develop a contingency plan model. • Model and monitor the company's asset Value at Risk (VaR). • Assess the company's financial risk according to ISO 31000 standards. • Analyze financial statements. TENORIO GARCIA | Finance Analyst ©AZURIUS • Successfully negotiated with the Treasurer of the Municipality of Villamaría to address and resolve the outstanding debt owed to Tenorio García for public lighting services. • Financial modeling and monitoring • Financial support to the main manager to monitor the contract’s performance. • Cash Flow analysis. • Support the Public Street Lighting to assist any possible advantage on the contract. • Assist the manager to provide any possible financial way to decrease expenses. • Modeling and monitoring company´s budget • Administrative support ALORICA (PriceLine Partner Solution) | Senior Sales Specialist • Hold sales convertion rate over 25% every month • Average monthly sales exceeding $ 100.000 USD TELEPERFORMANCE (Dr. Pepper) | Customer Service Representative • Bilingual customer service agent (Spanish/English) for the beverage brand Dr. Pepper. • Empathic and calm handling of customer concerns • Customer service by phone and email • High-quality score in customer service all over 95% during my working time COVATRANS | Compliance Assistant