You're seeing this page as if you were . The main menu is still yours, though. Exit from immersion
Pamela Chamorro PomaPC

Pamela Chamorro Poma

Business Analytics & Performance | Excel, BI, SQL

€324/day
London, GB
3-7 years

Average response time: 1 hour

About Pamela

I help organisations transform data into clear, actionable insights using Excel, Power BI, and SQL.

As a Business Analyst, I specialise in automated reporting, dashboarding, KPI frameworks, and forecasting models that support commercial and operational decision-making.

My work focuses on improving visibility, efficiency, and performance by building reliable data pipelines, Power BI dashboards, and Excel-based models tailored to business needs.

I use SQL and Python to automate Excel and Power BI reporting, build forecasting and scenario models, and support performance optimisation and planning across commercial and operational teams.

I combine strong analytical skills with a practical business mindset, ensuring insights are easy to interpret and directly usable by stakeholders.
  • English

    Native or bilingual

  • French

    Basic

  • Spanish

    Native or bilingual

Can work on-site
London (up to 50km)

Experience

  • Credit Bank of Peru
    Senior Analyst Lead
    BANKING AND INSURANCE
    March 2023 - August 2024 (1 year and 5 months)
    Lima, Peru
    • Led a 6-person analytics team delivering workforce planning insights across 300+ branches; applied time-series forecasting, regression modelling, A/B testing, and KPI frameworks to improve operational performance.
    • Designed and automated SQL-based ETL pipelines and rebuilt KPI frameworks, reducing manual reporting workload by 30%.
    • Delivered S/900K in annual savings via clustering, segmentation, and scenario modelling to optimise staffing resources.
    • Partnered with senior stakeholders to define analytical requirements, ensuring solutions aligned with strategic drivers and supported data governance standards.
    • Facilitated meetings with business teams to gather, analyse, and prioritise requirements, generating actionable insights for cross-functional initiatives.
    SQL Data analysis Microsoft Excel Microsoft Power BI Microsoft Powerpoint
  • Credit Bank of Peru
    Commercial Planning Analyst
    BANKING AND INSURANCE
    August 2021 - March 2023 (1 year and 7 months)
    Lima, Peru
    • Developed automated Qlik Sense dashboards with optimised SQL models, improving reporting accuracy and reducing manual effort by 50%.
    • Built predictive early-warning indicators and rolling forecasts to inform decision-making for senior stakeholders.
    • Converted business requirements into quantifiable commercial KPIs, enabling improved profitability margins and strategic alignment across teams.
    • Designed cost-allocation and financial-modelling frameworks, strengthening FP&A processes and P&L accuracy.
    SQL Data analysis Qlik Predictive Analytics Microsoft Excel
  • Conecta Retail S.A.
    Control, Management & BI Analyst|
    RETAIL (LARGE RETAILERS)
    March 2021 - August 2021 (5 months)
    Lima, Peru
    • Delivered S/261K annual savings and 28% reduction in dispatch costs via predictive analytics and process optimisation.
    • Built budgeting models and KPI frameworks for supply chain and distribution, improving financial planning accuracy. Created automated ETL pipelines and standardised reporting processes, enhancing data quality, governance, and auditability.
    Microsoft Excel Qlik SQL Forecasting KPI automation

Recommendations

Be the first to recommend Pamela

Help this freelancer shine by sharing your experience working together.

These freelancer profiles also match your criteria

AgathaA

Agatha Frydrych

Backend Java Software Engineer

4.7

(3)

2

BaptisteB

Baptiste Duhen

Fullstack developer

4.6

(4)

5

AmedA

Amed Hamou

Senior Lead Developer

4

(2)

7

AudreyA

Audrey Champion

Web developer

4.3

(3)

4

Education

  • MSc
    Warwick Business School
    2025
    MSc Business Analytics, Distinction
  • BSc
    National University of San Marcos
    2016
    BSc Industrial Engineering

Skill set

Categories