Open to opportunities

Francisco Moreira

@franciscomoreira1

Message

Senior BI Analyst turning data into actionable insights using Power BI, SAP Analytics Cloud, Python and Generative AI.

Chile

Message

What I'm looking for

I’m looking for a role where I can lead BI and data analytics for commercial/customer strategy, build robust dashboards and forecasting, and use Generative AI to automate reporting—working with cross-functional stakeholders to deliver measurable business value.

I’m an Industrial Engineer with 9+ years of experience in data analytics, Business Intelligence, finance, and management control. I specialize in turning complex data into actionable insights that support commercial and strategic decision-making.

In my current role as Senior BI Analyst for Sales & Commercial at Coca-Cola Embonor, I deliver BI and analytics that drive sales decisions and Revenue Growth Management across a multi-channel beverage operation. I’ve designed executive dashboards in SAP Analytics Cloud and Power BI, built data models and Python automations to increase KPI refresh frequency, and integrated Generative AI (Claude) to accelerate query generation, data cleansing, and executive report production.

Previously, at Farmacias Ahumada, I led Customer Service & CRM analytics during a digital transformation, building the BI layer for the new CRM and automating NPS reporting to shorten measurement cycles. Earlier, in finance and advisory roles, I strengthened my foundations in management control, forecasting/variance analysis, and IFRS auditing—always with an analytical, autonomous, results-driven mindset focused on continuous improvement and reporting automation.

Experience

Work history, roles, and key accomplishments

Current

Senior BI Analyst

Current

Coca-Cola Embonor S.A.

Jan 2024 - Present (2 years 5 months)

Delivered Sales & Commercial analytics by building executive dashboards in SAP Analytics Cloud and Power BI for real-time visibility into quota achievement, product mix, and in-store execution. Developed data models and Python-based automations to reduce manual reporting and increase KPI refresh frequency, and integrated Generative AI (Claude) to accelerate query generation and executive report pr

SAP Analytics Cloud Power BI Python Data Modeling Dashboarding Stakeholder Management

Senior Data Analyst

Farmacias Ahumada (FASA)

May 2021 - Nov 2023 (2 years 6 months)

Led Customer Service and CRM analytics during a digital transformation and CRM rollout, defining the BI layer to measure case resolution and customer experience. Designed and automated NPS reporting, supported Subscriptions analytics for a loyalty model, and automated recurring reports to reduce operational errors.

CRM Analytics BI dashboards NPS Report Automation Customer Experience Analytics Budget control Data Storytelling Cross Functional Collaboration

Management Control Analyst

Komatsu Finance Chile

Jun 2017 - Aug 2019 (2 years 2 months)

Produced monthly closing reports and results packages for headquarters and the local board, supporting accurate financial and management reporting. Led cost and budget control (provisions, distribution by cost centers, annual budget, and forecasting), consolidated the business plan, analyzed forecast deviations, and presented results to senior leadership.

Budgeting & Forecasting Financial Statement Analysis Cost Control Executive Reporting

External Auditor

PricewaterhouseCoopers (PwC)

Oct 2015 - May 2017 (1 year 7 months)

Performed external audits of financial statements under IFRS, applying audit procedures and substantive testing across multiple industries. Analyzed accounts and balance sheet movements, reviewed high-risk areas (revenue, costs, expenses, fixed assets, cash, and receivables/payables), and supported issuance of final audited financial statements for portfolio clients.

IFRS External Audits Substantive Testing Risk Assessment Financial Statement Analysis Fixed Assets & Cash Review Audit Reporting

Logistics Planning Intern

Derco

Feb 2015 - Apr 2015 (2 months)

Built macros and automations to improve daily logistics workload planning and reduce execution times within the logistics center. Automated dispatch reporting between the distribution center and retail locations and created KPI reporting for internal and external customers.

Process Automation Logistics Planning KPI Reporting Operational Efficiency Data Processing