Profileimage by Anonymous profile, Product owner. Senior Business Analyst. Organization consultant.

Edouard BORREL

available

Last update: 05.02.2018

Product owner. Senior Business Analyst. Organization consultant.

Graduation: Engineer / MSc Civil Engineering + MBA
Hourly-/Daily rates: show
Languages: English (Full Professional) | French (Native or Bilingual) | Spanish (Full Professional)

Skills

Product owner, and Senior Business process analyst and Management consultant with 16 years of experience in the integration of operational and financial data, and cross functional team management.
 
Adaptive, Inquiring, Pursuit of the widest optimum results.
 
  • Distinctive value proposition:
    Identification of the Integration Risks, from the needs to the solutions.
  • IT transformation and Financial performance optimization consultant:
    from Vision, to Delivery.
  • Organizational design, architecture definition, implementation and change support.
  • Dimensions for analyses: definition and improvement.
  • Financial & IT consulting :
    Enterprise Resource Planning [ERP] SAP Financials, FICO SD MM.
    French fiscal system, European and international integration (IAS/IFRS).
  • Leading design assistance, enterprise solutions design, feasibility studies.
  • Financial modeling. KPIs.
  • Operational implementation in the following sectors:
     Energy  -  Construction  -  Manufacturing

Project history

Freelancer Consultant
since 11.2002

edouard.borrel@gmail.com

 Since Nov. 2002 ABBAS Consulting
 Owner, Consultant, self employed.
Projects

July '15-March '16 Total Energy (gas & electricity supply)  Services  &  Utilities  Paris area – France
 Implementation of a financial & automated billing system, using SAP IS-U.
Reference Business consultant for utilities / Team Member of a 3-people design team.
Profiling & Procurements: from operations accounting, to estimates for month-end closing.
Entirely autonomous on the needs and solution design. Solving integration issues.

Key-words New business development. Profiles & Profiling. Settlement. Estimates and adjustments. BI. Statistics.
 EDI XML vendor interfaces. ETL. System automation. IS-U, SD and FI-CA integrations.

• Functional context & Challenges
- New market development: adding from the gas supply, the electricity supply.
- Coordinated development from marketing and commercial teams, to business, legal, and finance teams.
- No product owner: partners expect to be a force for bringing forward proposals and foresight.
- Extremely short delays. Condensed functional IT team. Remote technical IT integrators.

• Functional role
- In charge of the coherence of the financial figures.
- Solution for statistical estimate calculations for consumption: reconciliating physical devices, distribution contracts, and supply contract.
- Integrated solutions for the reconciliation of energy purchases on EEX (Futures) and EPEX (Spot), estimated billed, meter-read billed and unbilled payables and receivables.
- Interfaces with the Distributor.

Apr. '03- Sep. '14 EDF (Electricité de France) then eRDF (distribution infrastructure)  Services  &  Utilities  Paris area – France
 Implementation of a financial & automated billing system, using SAP ECC6.
Team leader / Reference consultant: Solution and Integrations design,
Leading design for the product owner, through realization.
Highly autonomous on the design, realization, and solving issues.

Key-words Deregulation. Going to market. Spin-off. Big data. BI. Statistics. Taxes.
 Legacy interfaces. ETL. System automation. DRP. IS-U and FI-CA studies.
FI-AR, FI-GL, FI-BL banks, SD-SALES, MM-MAT, CO-PCA, CO-CCA, CO-OM (OPA/IO), ALE, XML.

• Functional context
- Application of Directive 2003/54/EC concerning internal market in electricity.
- Going to market with a sample group of 4 million business professional clients.
- Enterprise Spin-off and generalization to 35 million clients (residential, business professional, industrial), consumers and independent producers, and €1billion monthly billing.

• Functional analysis of general group needs
- Needs assessment with senior management, hierarchical and lateral managers,
- Functional design of integrated solutions
(RICES: Reports, Interfaces, Conversions, Enhancements, Specifics, general architecture),
- Accounting requirements and audit warranty,
Direct interviews with external auditors.

• Full-lifecycle implementation project
- Needs assessment,
- Blue print and Gap analysis,
- Design, definition and functional customizing of the above sub-modules,
- Design, definition and validation of the bespoke developments (with FTP, debug ABAP, XML)
- Unit tests, integration tests and validation tests, volumetry test (benchmark),
- Training and functional support,
- Rise in production, Go-live, productive system declaration (3 different Go-Lives on this project),
- Functional & Operational ongoing support, extensions and improvements, upgrades.
- Accounting and controlling business support.

• Achievements
- Team leader & integration leader within bespoke developments, and within lateral projects.
- Design, definition, realization and support of a complete billing system utilizing SAP R/3.
- Design, definition, validation and support of a complex statistical estimate of individual consumption stream for the unbilled revenues to be posted to the financial system.
- Various feasibility studies (data warehouse, IS-U and HANA among them) and solution's design.
- System integration: Design, definition, validation of standard and bespoke
incoming and outgoing interfaces from and to legacy systems dating back to the 1970s and to new DataWarehouses BO.
- Invoice dematerialization: XML structure design assistance.

• Specifics Utilities/Energy
- Understanding of the metering devices' structure: simple Residentials and multiple Industrials.
- Data collection and abnormality dealing.
- Time slot management: Supplier/Distributor difference and conversion.
- Prorate upon price/tax change, and client consumption profile.
- Data valuation, XML invoicing, accounting, cash collection.
- Invoicing: Initial, Periodic, Interim, and Final.
- Drill in data volume, Query.

• Other functional details
- Application of Directive 2006/112/EC of the common EU system of VAT.
- Change in interpreting the French Law FR-2003-8 concerning the CSPE (tax for the public service of electricity).
- Change in interpreting the law of the tax duty: from discreet delivery to continuous flow.
- Application of the European Regulation 260/2012 establishing the SEPA payment method.

• Technical context & details
- Developments over unstable customized SAP layers and Core Model.
- Upgrades (DB & ERP SAP ECC6 technical layers; Core model layers; controlling scheme).
- System automation using scheduling tools: Control-M, CFT transfers and Idocs.
- Participation in the Disaster Recovery Plan (DRP program).

Oct. '06 BOUYGUES CONSTRUCTION  Building & Public works  West. Paris area – France
Project auditing, SAP SAS-France team.
• Dedicated Engineering Construction & Operations (EC&O) support from SAP AG-Waldorf, Germany.
• Workshop team leader by functional area, prepared audit report.

March '03 RENAULT DIAC  Automotive  East. Paris area – France
• Key user and end user training for Assets Accounting (FI-AA).

Nov. '02-Apr. '03 CEGETEL SFR  Telecom  Paris financial district – France
 ERP SAP Roll out.
• Training materials conception: General Ledger (FI-GL) and Auxiliary accounting (FI-AR) & sales documents (SD).
• Document creation for the knowledge center regarding FI-SD processes and integration.
• Key-user and End-user training organizer.

 Mar. '00-Jun. '02 PRICEWATERHOUSECOOPERS (PWC CONSULTING)
 Management Consultant,
 Financial & Cost Management applied to consumer & industrial products industries.
Key clients
 RICHEMONT (CARTIER, VLG, RID)  Luxury  Geneva, Freiburg   Switzerland
 Functional assistance to a legal merger of 50 Swiss companies.
• Led meetings with the corporate management of the 7 main companies
(InterDiCa/RID, Cartier, Vendôme Luxury Group, Cartier High Jewelry, Jaeger-LeCoultre, Piaget, Vacheron Constantin).
• Business processes analysis on cash flows linked to logistic, production, purchases and sales.
• Overview of the forecast systems.
• Understanding of several production plants: manufactures, quality and traceability management, valuable raw material management and finished products warehousing.
• Business processes analysis on general and management accounting.
• Mapping of the 3 information systems hosting the finance and operations of the 50 companies.
Consolidation proposals.

 BSN GLASSPACK - OWENS ILLINOIS  Molded Glass  Paris, Reims, Lyon   France
 Full lifecycle ERP SAP standard Implementation & big bang roll out: 20 plants over Europe.
• Controlling (CO) and Accounting (FI) Core Model design involvement: Accounting (purchasing FI-AP and self-billing on external logistics, general FI-GL & asset accounting FI-AA, etc.) and Controlling (profitability analysis CO-PA, costing CO-PCA, overheads CO-OM-IO/OPA, projects PS) business process definition.
• Responsible for accounting user training:
- Training materials design, Key-user and end-user training (50+ people).
• Accounting data migration follow-up and control:
- Accounting entries subsequent to changes on stock valuation methods (20mEUR).
• Accounting Maintenance and End-user support:
- Dedicated operations support: compensation, clearing, down payment, discounts, VAT statement, month-end closing,
- Cash management operations: payment program, payment materials, bank account clearing.

• Full-lifecycle implementation project:
- Functional customizing of the above sub-modules,
- Unit tests, integration tests and validation tests,
- Data migration,
- Training and functional support,
- Rise in production,
- Go-live,
- Technical support.

Oct. '99-Feb '00 Last year of studies

June – Sept '99 PRICEWATERHOUSECOOPERS (PWC CONSULTING)  Services  Paris financial district – France
 Junior Consultant.
Controlling: Creation of a management and internal control tool.
• Development and implementation of a financial analysis database using MS Access.
• Documentation and end user training.

 June – Sept '98 BOUYGUES Immobilier  Building & Public works  Paris area – France
 Junior financial engineer.
  Property development projects.
• Project development (land prospection, market studies, feasibility studies with architects, financial modeling, pre-technical studies, steering committee defense).

 June – Sept '97 ZURICH FINANCIAL SERVICES  Banking & Insurance  Paris – France
 Assistant to the Chief Financial Officer.
Recurring operational result segment optimization.
• Modeling new insurance provision system.
• Development and implementation of statistical models.
 

Local Availability

Only available in these countries: France
Anywhere in Europe,
even Worldwide with restriction to working permit, 

Other

download PDF resume on :
fr.linkedin.com/in/edouardborrel/
Profileimage by Anonymous profile, Product owner. Senior Business Analyst. Organization consultant. Product owner. Senior Business Analyst. Organization consultant.
Register