Eric - Consultant technique BUSINESS OBJECTS
Ref : 140327A001-
93160 NOISY LE GRAND
-
Consultant technique (47 ans)
-
Freelance
ATOS, Paris, France
SAP BW BO & ETL Consultant, 11/2006 – 12/2013
Technical Scope: Windows, SAP Business Warehouse (BW) 7.0 / 7.3, SAP Business Objects Business Intelligence (BI), SAP CRM, BEx Query Designer / Analyzer, BOBJ 3 / 4 (Universe Design Tool, Webi, Analysis Edition for OLAP), Word, Excel, PowerPoint, ABAP, SQL
Play key role in various SAP BW and BO global reporting projects for worldwide clients. Collaborate and communicate with colleagues, clients, and stakeholders.
Key Achievements:
Atos International, Global IT System: Collaborated with team members and source system SMEs for implementation of SAP 7.0 and BOBJ 3.1, as well as upgrades to SAP 7.3 and BOBJ 4.
Successfully designed and implemented BOBJ universe and reports allowing global stakeholders to analyze CRM KPIs for sales leads & opportunities, marketing campaigns, and contacts.
Performed requirements analysis, developed technical scenarios and specifications, assessed workloads, led design workshops, designed BI data model, and wrote technical documentation for BW Info Providers and data flows, BEx queries, BOBJ universes and reports.
Implemented Info Objects, DSOs, Info Cube Transformations and routines, and MultiProviders; developed ADPs and Open Hub services for transactional and master data extraction; and enabled data extracting by activating business content and creating generic extractors.
Created delta and repair process chains, wrote BEx queries with restricted and calculated key figures / variables, and promoted transport requests between platforms.
Advised on solutions development and report enhancements; reviewed, investigated, and resolved trouble tickets submitted by end-users.
Facilitated development activities, created test scenarios, coordinated UAT, and provided technical assistance for on-shore project and off-shore support teams, and handled knowledge transfer.
Electricite De France (EDF) BI / ETL Project: As SAP BW / ETL consultant, provided lifecycle project management for major reporting effort with 300+ stakeholders for France’s leading power and gas supplier serving 30M+ clients.
Conducted requirements feasibility assessment, led design workshops, coordinated end-to-end testing and data flow QA testing.
Prepared detailed technical specifications for BW data flows, queries, universes, reports, and Informatica ETL extracts from BW, CRM, and ISU.
Built BW DataSources, DSO, Infocubes, Open Hub destinations, transformations, DTP, and process chains.
Developed strategy to automate data quality error handling resulting in reduction of affected rows in ETL area.
Wrote ABAP codes for customer exits, transformation routines, and data source enhancements.
Managed implementation of Analyzer Workbooks, BOBJ Universes and Webi reports for 30+ KPIs across service contract quotations, service contracts, sales contracts, complaints, activities, cash and energy consumption.
Provided on-going user support, troubleshooting, and problem resolution; evaluated and implemented change requests.
Agence Des Eaux Seine Et Normandie (AESN): Business Intelligence Developer building data warehouse and reporting dashboards for financial aids and payment KPIs for Department of Ecology agency.
Supervised 4-member team of ETL and BOBJ Developers; coordinated scheduling, reviewed progress, and conducted necessary follow-up.
Handled requirements gathering; designed and developed data model, developed BO universe and ETL (ODI) data flows, and Webi reports.
SOFT COMPUTING, Paris, France
Business Intelligence Developer, 3/2005 – 9/2006
Technical Scope: Windows, SSAS, SAP BusinessObjects, Universe Designer, Desktop Intelligence, Business Intelligence (BI), SQL, Teradata
Contracted with clients to work on business intelligence reporting projects in alignment with scope and requirements.
Key Achievements:
Caisse D'Epargne (BPCE Group): Charged with designing, developing, and implementing BO universes and Deski & Webi reports for marketing campaign KPIs for this retail banking and insurance company.
Crédit Municipal de Paris (CMP): Implemented SSAS for KPI reporting.
~ Prior experience as ASP.NET Application Tester Intern with AXA and Programmer Analyst Intern with Société Générale Investment Banking and Banque Populaire (BPCE Group).
BUSINESS INTELLIGENCE & DATA WAREHOUSE CONSULTANT
Highly motivated professional with exceptional technical skills and extensive experience in SAP BW / BO life cycle development, BI application design, and data warehousing for global clients. Define requirements and prepare detailed technical specifications to ensure solutions meet business and user needs. Supervise and collaborate with on- and off-shore development and technical teams; coordinate task delivery and quality.
AREAS OF EXPERTISE:
• Data Warehouse Design / Development
• Business Requirements Gathering
• Software Development Life Cycle
• ETL Data Source & Target Mapping
• BI Applications / Reporting Dashboards
• Technical Specifications Development
• Implementation / Deployment / Upgrades
• Troubleshooting & Problem Resolution
TECHNICAL PROFICIENCIES
Platforms: Windows, Microsoft SQL Server, Oracle
Applications / Tools: SAP Business Warehouse (BW) 7.0 / 7.3, SAP BusinessObjects Business Intelligence (BI), SAP CRM & ISU, BEx Query Designer / Analyzer, BOBJ 3 / 4 (Universe Design Tool, Webi, Analysis Edition for OLAP, BI Launch Pad), Teradata, Informatica PowerCenter, Word, Excel, PowerPoint, Visio, SQL Server Analysis Services (SSAS)
Languages: ABAP, SQL, UML