Juan Jose Avellan Cruz
Guatemala City,GU
Summary
Experienced Financial and Business Analyst with over 15 years of experience driving operational efficiency and strategic growth. Expertise in reducing costs, automating workflows, identifying revenue growth opportunities, and standardizing processes across diverse industries. Proficient in Excel, Power BI, Tableau, Python, Salesforce, and SAP, leveraging data-driven insights to deliver measurable results and enhance decision-making.
Overview
25
25
years of professional experience
1
1
Certification
Work History
Corporate Sr. Financial and Data Analyst
Conduent
01.2019 - 01.2024
- Company Overview: American business services provider offering digital platforms for businesses and governments.
- Budget & Forecast Management – Capex & Opex – Financial Strategy –Controls & Compliance – P&L Variance Analysis – Month End Close Support – Reporting & Reconciliation.
- Main Achievements
- Developed a Purchase Order Tool to improve monthly spend control, reducing errors by 15%.
- Created a process to track actual status from purchase orders, finding potential adjustments for the month-end & quarter close.
- Saved $25M by identifying and eliminating unnecessary equipment purchases through detailed cost analysis.
- Built Power BI dashboards to analyze Capex portfolio at expense and project levels, improving strategic decision-making.
- Implement a “Bottoms-up Forecast” process to get accurate financial figures.
- Produced monthly reports using advanced Excel spreadsheet functions.
Sr. Lead Pricing Analyst
Conduent
01.2015 - 01.2019
- Company Overview: American business services provider offering digital platforms for businesses and governments.
- Cost Analysis, Market Trend Analysis, Market Research, Pricing Modeling, and Pricing Strategies.
- Main Achievements
- Formulated a pricing strategy to secure a $200M HR services contract, outbidding competitors.
- Set up a record of winning prices for future reference by competitors and by area to analyze the market.
- Implemented IT and RE pricing workbooks to standardize workflow through different departments.
- Standardized pricing models across business sectors.
Financial Analyst
Xerox
01.2014 - 01.2015
- Company Overview: An American corporation that sells print and digital document products and services in more than 160 countries.
- Vehicle Fleet Control – CC expenses for Sales Department, Control – Labor allocation cost by project – Sales Pipeline control and reporting - Month End Close Support – Reporting & Reconciliation.
- Main Achievements
- Led the transition of the balance sheet reconciliation process from the USA to Guatemala.
- Analyze and automate the Balance Sheet reconciliation process.
- Elaborated a Risk Management policy for project implementation.
- Effective month-end close coordination across 11 states from the U.S West Coast.
- Transitioned the Balance Sheet reconciliation process from Guatemala to Manila.
Financial Officer
Serco Group
01.2012 - 01.2014
- Company Overview: British multinational defence, health, space, justice, migration, customer services, and transport company.
- Manage Company Profitability – Cash Conversion Cycle – Business Case Analysis – Financial Strategy – Accounting Cycle – Month End Close Management – Reporting & Reconciliation – Corporate & Tax Audits.
- Main Achievements
- Increase company liquidity through cash conversion cycle policies, optimizing accounts receivable, and supplier terms.
- Conducted project profitability analysis using NPV, IRR, and payback scenarios to support strategic investments.
- Effective month-end close coordination for accurate financial figures.
Project Manager
Serco Group
01.2011 - 01.2012
- Successfully managed multiple Accounts simultaneously by prioritizing tasks according to urgency, resource availability, and alignment with organizational goals.
- Planned, designed, and scheduled phases for Bringing new accounts to Guatemala mainly in the transportation Business namely Hampton's Luxury Liner, Classic Coach, Bolt Bus. Assembled the teams , stablish KPIs, designed the training materials and successfully started the business operations.
Credit Analyst
T-Mobil
01.2010 - 01.2011
- Conducted financial review of New customer lines of credit by assessing company financials and initiating credit application reviews. Worked closely with sales department to ensure a successful wining ratio without compromising the company risk.
- Ensured compliance with internal policies and regulatory requirements through diligent documentation of all credit decisions.
Project Manager
Inacsa
01.2003 - 01.2009
Accounts Receivables Manager
Copensa
01.2001 - 01.2003
Branch Manager
Banco G&T Continental
01.1999 - 01.2001
Education
Bachelor in Economy -
Universidad San Carlos De Guatemala
Guatemala01.2002
Skills
- Technical Skills: SAP R3 (FICO), SAP H/4 Hana, JD Edwards, Essbase, Hyperion, Salesforce, Power BI, Tableau, Python, Microsoft Excel (VLOOKUP, Pivot Tables, VBA)
- Professional Skills: Financial Modeling, Data Analysis, Data Visualization, Budget Forecasting, Cost Analysis, Process Optimization, Strategic Planning, Variance Analysis, Financial Reporting, Cross-Functional Collaboration
Certification
- Data Analyst, Datapath, 2024
- Business Intelligence Foundation Professional Certification BIFPC, Certiport 2024
- Financial Forecasting, Unis, 2023
- Six Sigma Green Belt, Conduent, 2020
- Kaizen, Conduent, 2018
- PMP, Conduent, 2016
- Knowing your client, Guatemala Central Bank 2011
- Money Laundry Prevention, Guatemala Central Bank, 2010
- Cost and Budget Analysis, Intecap 2009
Languages
Spanish
Native or Bilingual
English
Full Professional
German
Elementary
Timeline
Corporate Sr. Financial and Data Analyst
Conduent
01.2019 - 01.2024
Sr. Lead Pricing Analyst
Conduent
01.2015 - 01.2019
Financial Analyst
Xerox
01.2014 - 01.2015
Financial Officer
Serco Group
01.2012 - 01.2014
Project Manager
Serco Group
01.2011 - 01.2012
Credit Analyst
T-Mobil
01.2010 - 01.2011
Project Manager
Inacsa
01.2003 - 01.2009
Accounts Receivables Manager
Copensa
01.2001 - 01.2003
Branch Manager
Banco G&T Continental
01.1999 - 01.2001
Bachelor in Economy -
Universidad San Carlos De Guatemala
Similar Profiles
Deborah SwordDeborah Sword
Transaction Processor at ConduentTransaction Processor at Conduent
Nicholas BaranNicholas Baran
Sales Representative at ConduentSales Representative at Conduent
Carol DavisCarol Davis
Senior Supervisor, Medical Benefits Review Service at ConduentSenior Supervisor, Medical Benefits Review Service at Conduent
Jessie ParadisJessie Paradis
Customer Service Representative at ConduentCustomer Service Representative at Conduent
Sindy OrellanaSindy Orellana
Sales Manager Guatemala and El Salvador at Grupo Cadelga (Fertica)Sales Manager Guatemala and El Salvador at Grupo Cadelga (Fertica)