Juan Sebastián Quintero

FP&A Lead

ADDI

Mar 2021 - Sep 2021 (7 months)

Finance Business Partner

CMA CGM

Sep 2020 - Mar 2021 (7 months)

Colombia Cluster (CO, EC, PA, VE)

K

Financial Planning Consultant

Klear Innovations Inc

Oct 2019 - Apr 2020 (7 months)

Key Responsibilities: • Performed quantitative analysis of financial and operational data to provide accurate and timely recommendations to management by identifying patterns, correlations and opportunities for growth. • Developed, maintained and monitored financial reports leveraging MS Power BI to highlight trends and analyze causes of unexpected variance vs budget and forecast. • Built financial and business forecast with sensitivity and scenario modelling.

Senior Financial Planning, Reporting & Analysis Analyst

Nokia

Sep 2017 - Jul 2019 (1 year 11 months)

Key Responsibilities: • Designed, maintained and reviewed NAM Business Operation Dashboard Package for Orders, Sales, and Sales Margin by Business Group and Customer Business Team monitoring variances and recommending actions to management. • Ad-Hoc reporting and analysis by using Oracle Smart View, Microsoft BI Add ins (Power Query & Power Pivot) and Power BI for Business Operation KPIs to improve financial status and business performance. • Leveraged FFAST Regional Forecasting System to support the sales operations team in the extraction, consolidation, and analysis for Business Operations KPIs to improve operational efficiency. • Understood business needs and requirements, turning those goals into concrete projects, e.g. data drill d

Business Intelligence Specialist

Claro Colombia

Mar 2017 - Sep 2017 (7 months)

Key Responsibilities: • Used Business Intelligence (BI) tools that help end-users analyze data in a SQL data warehouse. Acted as a facilitator to perform business process analysis. • Analyzed the financial and commercial data from business units exploring data to discover patterns and correlations. • Provided performance monitoring and insights via scorecards, dashboards and ad hoc analysis leveraging Power BI and Tableau. • Adhered to the Software Development Lifecycle (SDLC), leveraging agile development methodology.

Financial Planning Analyst

Claro Colombia

Aug 2014 - Mar 2017 (2 years 8 months)

Key Responsibilities: • Analyzed KPIs current and past trends including areas of Revenue, COGS, OPEX and CAPEX. • Evaluated potential investment projects to determine key metrics such as cash flows, payback period, NPV and ROI. • Ad-Hoc reporting and analysis leveraging Microsoft BI Add-ins (Power Query, Power Pivot and Power View/Maps). • Developed financial models and analysis to support strategic and operational initiatives. • Partnered cross-functionally with Business Intelligence department to help validate data from Dashboard reports.

Finance – Business Decision & Support Intern

Diageo

Jan 2014 - Jul 2014 (7 months)

Key Responsibilities: • Supported the marketing teams in decision-making, conducting financial analysis of innovation projects. • Designed and maintained reports based on collected data by channel and category. • Guaranteed price stability in SAP/ERP and correct communication to commercial teams. • Monitored budget of investment in A&P, maintaining data integrity to ensure accuracy of results. • Supported the company's pricing strategies and discount levels.

Juan Sebastián Quintero

About

Detail

Timeline

Résumé