Jordi Batlle
Brussels
Summary
Results-oriented Analyst skillful in managing and breaking down large volumes of information. Proactive at heading off issues in operations, workflow and production by uncovering trends affecting business success. Rational [Job Title] with [Number] years of experience enhancing operations for organizations through information systems solutions. Proven track record of transforming specific business goals related to growth and efficiency improvements into new system designs. Knowledgeable innovator known for recommending new technologies to enhance existing systems and introduce new systems.
Overview
15
15
years of professional experience
1
1
Certification
Work History
Global Pricing Analyst
REGUS - IWG Group
08.2022 - 01.2024
- Analyse margin, occupancy, and sales figures to recommend price changes across all markets
- Assess price change requests and provide feedback
- Prepare New Sales weekly report for management
- Ad-hoc analysis to identify price change opportunities for non-office products to improve occupancy and revenue
- Process improvement: Implemented Macros/VBA and formulas to speed up manual tasks.
Pricing & Reporting Analyst
Certas Energy - DCC Group
05.2021 - 08.2022
- Lead pricing analysis and processes for the French and Danish markets
- Lead weekly presentations/calls with management
- Perform analysis and reporting of volume and margin performance on a daily, weekly and monthly basis
- Implemented Macros/VBA and formulas to automate all the Excel based daily reporting reducing the processing time by more than 50%
- Pricing strategy review: identified opportunities to improve volume and margin performance
- Ensured our prices complied with French Government constraints
- Responsible for developing and setting up the pricing and reporting tasks for our most recent acquisition of petrol stations in the Luxembourg market
- Built up strong relationships with the territory managers and other parties in France
- Managed all technical issues with our third-party vendors
- Resolved all incoming queries in the French and Danish inboxes
- End of Year review rating: Exceeds (4 out of 5)
- Rewarded with the company’s Living the Values Award for going above and beyond.
Data Analyst
Britvic
01.2020 - 03.2020
- (Contract terminated due to Covid-19 restrictions)
- Built financial models to estimate P&L variation after price changes within Britvic and Pepsico drinks range
- Extracted data from SAP BW and used Excel to build the models (pivot tables, advanced formulas, goal seek scenario, slicers, built macros to automate tasks)
- Competitors prices analysis to find gaps where there is an opportunity to increase our prices
- Built PowerBI dashboard to show graphically Britvic’s prices compared to competitors
- Reported findings to the Revenue Growth Manager and Sales Director
- Built a dashboard to show price per volume gaps to compare Britvic’s sales to its Wholesales clients.
Technical Analyst
Bank Of Ireland
02.2019 - 12.2019
- (Contract terminated due to department outsourced)
- Ran reports to ensure data accuracy and performed UAT testing on the new software under development to guarantee a successful transition of the department tasks to the outsourcer Willis Tower Watson
- Used available macros and updated when needed to produce reports in Excel
- Ran weekly/monthly control reports to ensure contributions accuracy for Bank of Ireland pension schemes
- Ran calculations and instructed the Fund Manager of the monthly investments/disinvestments
- Ensured monthly pension balances are completed after payment
- Ran ad hoc reports from SAP and other internal systems as per management request
- UAT testing of key system changes and upgrades and report of results to ensure successful system releases.
Tax Custody Supervisor
State Street
05.2018 - 12.2018
- Delivered investment tax related services for clients focused on managing tax reclaims and relief at source documentation for markets in scope with special attention to US FATCA requirements
- Ran department MIS reports for head of department and Produced insight reports for clients.
Tax Custody Senior Analyst
Deutsche Bank
08.2016 - 05.2018
- Processed withholding tax reclaims and validated tax forms, POAs and related documentation
- Processed relief at source documentation
- Processed dividend payments and other corporate action operations
- Prepared payment reports for tax authorities and clients; Monitored mailbox and resolved incoming queries
- Used Excel to improve and automate processes to save time and improve accuracy
- As Senior Analyst, checked team’s operations, managed MI reports and on demand reports for clients, client services and tax authorities, and performed analysis on escalations received for management
- Performed weekly and monthly balance reconciliations on ledger accounts
- Investigated and reconciled payment breaks assigned to department accounts
- Processed reclaims payments, including booking FX trades when needed
- Trained a team in Bangalore to outsource some processes.
Corporate Cash Management & Electronic Banking Analyst
Deutsche Bank
- Provided account and cash management guidance and technical support to corporate clients
- Resolved cash management and e-banking queries, including payment queries (via SWIFT and SEPA), payment monitoring, SEPA direct debits, FX support, cash-pool issues, pricing updates and billing complaints
- Successfully closed 85%+ of queries within 24 hours in compliance with all service level agreements (SLA)
- Quickly developed expertise in new SEPA transfer regulation to facilitate ability to coach and train clients on its use and encourage their ability to troubleshoot and resolve less-complex issues
- Trained and mentored new employees in all department operations to grow their professional competencies.
Operations Administrator
WorkHuman
12.2009 - 07.2012
- Responsible for Master Data Management: definition, creation and maintenance of merchants’ database and inventory; Coordinated third-party vendors for key markets to ensure efficient order fulfilment according to client SLAs
- Used SQL to query the Oracle database and produce company MIS dashboards for management’s analysis
- Reduced delivery time of average turnaround orders 9% and shrank the number of orders sent beyond tier by 50% by following up with providers and creating/implementing a checklist to improve the status visibility and transparency of the order process.
Customer Service Executive
WorkHuman
08.2008 - 12.2009
- Order management: Replied to Spanish, French and English-speaking enquiries via phone and email; Processed and managed client orders; Tracked orders and inventory to provide clients with accurate delivery timeframes
- Closed 95% of order tracking, stock issues, delivery timeframe and user support issues within 24 hours to consistently meet chartered customer service levels
- Produced department KPI reports for management’s analysis.
Skills
- MS Excel
- Analytical Thinking
- SQL Programming
- R Programming
- Python Programming
Certification
- Certified [Job Title], [Company Name] - [Timeframe]
- [Area of expertise] License - [Timeframe]
- Licensed [Job Title] - [Timeframe]
- [Area of certification] Training - [Timeframe]
Languages
English
Advanced (C1)
French
Advanced (C1)
Spanish
Bilingual or Proficient (C2)
Timeline
Global Pricing Analyst
REGUS - IWG Group
08.2022 - 01.2024
Pricing & Reporting Analyst
Certas Energy - DCC Group
05.2021 - 08.2022
Data Analyst
Britvic
01.2020 - 03.2020
Technical Analyst
Bank Of Ireland
02.2019 - 12.2019
Tax Custody Supervisor
State Street
05.2018 - 12.2018
Tax Custody Senior Analyst
Deutsche Bank
08.2016 - 05.2018
Operations Administrator
WorkHuman
12.2009 - 07.2012
Customer Service Executive
WorkHuman
08.2008 - 12.2009
Corporate Cash Management & Electronic Banking Analyst
Deutsche Bank