Resume

Sign in

SAP BI Reporting Expert BW/BO/BI4

Location:
Atlanta, Georgia, United States
Posted:
November 06, 2018

Contact this candidate

Resume:

DIAKA CAMARA

French &Canadian Citizen / TN visa

**** ********* ******

***** ******* **

ac66k4@r.postjobfree.com

+ 33 6 19 66 64 11

SUMMARY:

• Having 11 Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of 9 years of SAP Business Warehouse experience encompassing a wide range of skill set, roles and industry verticals.

• Worked on SAP HANA implementation projects with both Native HANA and SAP BW on HANA Landscapes based on HANA ASAP 8 Methodology.

• Worked on Data Modeling, Data Provisioning, Reporting, Security and Authorization aspects of SAP HANA 1.0

• Experience working on HANA Enterprise Modelling including Attribute Views, Analytical Views, Calculation Views, SQL scripting, CE functions, Analytical Privileges.

• Excellent knowledge on: HANA Optimized InfoCubes, HANA Optimized DSO's, Transient, Composite, Hybrid Providers, Publishing HANA Model in SAP BW, Import SAP NetWeaver BW Model to HANA .

• Experience in migrating the Standard DSO and Info Cube to HANA Optimized DSO and InfoCubes.

• Experience in Importing BW models Info Cube, DSO in HANA as Analytical view.

• Good understanding and experience in providing security restrictions on models using Analytic Privileges and assigning to Authorization roles for different types of users in SAP HANA.

• Experience in Data-Provisioning techniques suing SLT SAP Landscape Transformation to perform real-time data replication into SAP HANA and near time data loading into HANA using SAP BODS.

• Experience in Configuring and Consuming SAP HANA models in BI clients such as Lumira, Predictive Analysis BusinessObjects Explorer MS Excel.

BW Expertise:

• Implemented 2 end to end full-life cycles using ASAP methodology across various modules in SAP BI/BW projects.

• Worked on Management Work Bench with creating and maintaining Data targets like Info Objects, DSO, Info cubes and Virtual Provides like Info sets, Hybrid Providers and Multi Providers.

• Strong experience in BW 3.x and BI 7.x version and upgrade technical and functional .

• Strong experiences in installing the Standard Business Content objects and enhance them into custom objects based on the business requirements.

• Worked on BW support project activities data loading monitoring and troubleshooting the failures .

• Experience in system maintenance tasks Delta queue cleaning, Setup table deletion validation

• BW load/job automation through process chain and Control-M.

• Worked extensively in SD, MM, PP, and FI Modules.

• Strong in performance tuning Data loading and BEX reports and job failure reduction activities. BO Expertise:

• Working knowledge and proficiency with Business Objects Reporting tools BI launch Pad, Web Intelligence, Dashboard designer, Dashboard Design, BO Explorer.

• Working knowledge on creating universes using IDT on SAP HANA views and reports development on the same using Web Intelligence.

• Excellent understanding work Experience of building Complex Universe s of Normalized De-Normalized schemas using Information Design Tool IDT.

WORK EXPERIENCE

Jan 2018 – Jul 2018 Confidential ERPF project, Paris - MEUDON Position SAP BW on Hana Consultant

Accommplishment

• HANA and Business Objects Development done across all the business Areas for the BI Projects: Developed all Technical Specifications based on Functional Specifications that outlines required Characteristics, Measures and Business Rules. The Technical Specification outlined the overall HANA design to meet and satisfy the Business Reporting Requirements.

• Developed the following HANA Data Models: Attribute Views for master data, Analytic Views for Transaction Data and Calculation Views Graphical and SQL Script to Join/Union the various Attribute and Analytic Views for report consumption with time dimensions.

• Created Universes on top of HANA calculation views and developed the Webi reports and dashboards using IDT Information design tool .

• Involved in loads initialization in SAP BW system followed by extraction LIS/LO Cockpit extraction, FI, CO-PA extraction from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.

• Had created reports using SAP BO Analysis Office 1.3 and 1.4 for multidimensional ad-hoc analysis of Headcount Analytics data from SAP BW and HANA in Excel.

• Worked with LCM Life Cycle Management Console to Transport the Objects In System Landscape Dev, QA and Prod

• Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation.

Technical landscape : SAP BW, SAP BI4, SAP CS, JIRA, Servicenow, VPN Extractor : 2LIS_18_*** services order/notification, ... Feb 2017 – June 2017 Atos France on CNAV project, Paris - Crimée Position SAP BW 7.3 SAP BI Expert

• Led design workshops with businesses and formalized the businesses’ needs

• Led the design solution by writting the High level requirement from the business design workshops

• Reviewed and managed detailed functional specifications by the developer team Technical landscape : SAP BW, SAP BI4, SAP PCM

Feb 2016 – Dec 2016 L’Oréal, Paris Aulnay Sous-Bois Position SAP BI TMA Team Lead

• Advised on change requests and specify with delivery team,

• Collected and analyzed the business requirements for change

• Analyzed specifications and translated for development team

• Managed tickets and support requests : Analyse and solving incidents

• Managed BI TMA Team : planning, performance feedback, team schedule

• Involved in loads initialization in SAP BW system followed by extraction LIS/LO Cockpit extraction, FI, CO-PA extraction from SAP R/3 system and Non-SAP systems and scheduling regular Full Loads / Delta Loads using Process Chains.

• Worked with SAP ABAP team and created code that will result in the highest performance possible.

• Provided Knowledge transfer KT and Training to BW team members and Super Users and guidance to team members on Excel- to-SAP project related to Manufacturing during all phases of project.

• Captured the BW data elements required by the end users and extensively involved in analysis, design, development, configuration, testing, deployment of BW Objects Info Objects, ODS, DSO, InfoCubes, InfoSets, MultiProviders, InfoSources, DataSources and corresponding extract, transformation, communication structures.

• Implemented the BI 7.0 concepts of Transformations and DTPs using the existing datasource migration and involved in up gradation and migration from BW 3.5 to BW 7.0

Technical landscape : SAP BW, SAP BI4, SAP FI-CO, Informatica, SQLServer Nov 2015 – Jan 2016 Danone, Paris Saint-Ouen

Position SAP BW 7.4/HANA Technical Designer, Initiative lead

• Assisted in identification of key client process and technology issues and solution recommendations

• Led the program for scope definition and planning phases to develop a program roadmap and end-to-end execution plan

• Drove program teams to develop detailed project schedules and milestones, project plans, budget, scope, timeline and risks and risk mitigation plans

• Created reports by connecting to IMCE from SAP Lumira, SAP Business Objects Explorer BEx and MS Excel through ODBO/MDX for multi-dimensional reporting.

• Led the execution of program end-to-end to meet the business and technology objectives

• Provided leadership and mentored junior consultants in the engagement team (Onshore & Offshore) Technical landscape : SAP BW7.4, SAP HANA, Informatica, SQLServer March 2014 – Jun 2015 Alcatel-Lucent, Paris-Nozay

Position SAP BW 7.3 SAP BI Team lead

• Worked with SAP BI and BOBJ Business users, Project managers and architects in requirement gathering, analysis and creation of best practice architecture.

• Enabled Single Sign-On SSO feature, imported SAP BI roles into BusinessObjects, enabled automatic imports of SAP BI users, managed users and groups in Central Management Console CMC Reviewed and managed project blueprint

• Worked closely with Production Planning PP, material management MM, Sales and Distribution SD, Logistics LE, Financials FI AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash, Procure-To-Pay, Point of Sale POS data via DataStage and other integrated solutions.

• Worked with Business Users on design changes and deployed Business Objects Rapid Marts, sourced data from SAP, Non-SAP and flat-file datasources.

• Created 5 Universes using Universe Designer, worked with tables, fields and joins, involved in resolving loops by creating aliases and contexts using SAP BEx queries.

• Created/Edit queries and reports in BOBJ - InfoView for multidimensional analysis and trained users on drill-down, cross-tab, triggers, master detail, slicing and dicing, ad-hoc reports by Web Intelligence WebI, Voyager workspace, scheduling and publishing to BO Inbox, email, FTP, .. in multiple formats html, pdf, ActiveX doc,..

• Involved in data extraction from SAP R/3 system and Non-SAP systems and scheduled Full Loads / Delta Loads using Process Chains.

• Created Dashboards and Scorecards integrating reports using Business Objects dashboard manager.

• Worked with SAP BASIS team in regards to moving Transport Requests and worked with SAP SECURITY team in providing authorizations for Users by assigning specific Roles.

• Involved in developing and conducting extensive Unit testing, Integration testing FIT, Regression testing, User Acceptance Testing UAT and documentation.

• Involved in Realization, Final Preparation, Go-Live and Post Implementation, developed production support plan and resolved production support issues.

Technical landscape : SAP BI4, SAP HANA, SAP BW7.4, SAP SRM, SAP BPC 10.0 Extractor : 2LIS_12_*** 2LIS_11_*** Flat files ... Apr 2013 – Jan 2014 ERDF, Nanterre

Position AMOA, GMAO PS Maximo Team Lead

• Led the project budget, planning, risk, and reporting (COMOP, COPIL)

• Planned, animated and organized recurring project instances and communication management (project committees, trade synchronization committees etc.),

• Prepared the committes materials and related reviews

• Follow-up of the schedules: coordinated the project branches (PCM settings, implementation of BI controled of the respect of the milestones, Identified and follow adherences between the flows, interactions with the leaders of the flow

• Identified and manage project risks, quality and flow depending on the charge of project Technical landscape : IBM MAXIMO, SQLServer, CARL, BIRT May 2012 – Mar 2013 EDF, Colombes

Position Software engineer

• Listen to the business stake holders to understand business needs, analyzes complex business requirements, reporting requirements and propose the best solution for them, and convert them into write the functional specification.

• Worked alongside the database administrator and SAP BW consultant to identify the technical names and sources for the KPIs key performance indicators defined by the final user.

• Worked on BEx Query Designer in designing queries using Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.

• Created 2 BOBJ Reports on BEx queries that were built on BEx Query Designer and wrote complex queries including Sub queries for Supply Chain business areas.

• Worked closely with the Database and ETL team to get required table structures.

• Involved in working with different database environments PROD, DEV, and QA and migration of the universes and reports using LifeCycle Manager. Established a change control for each development.

• Conducted Training sections for all BI Business Users and created end-user training documentation. Technical landscape : SAP BW, SAP BI 4, BEX, ISU, CRM, REVTRAC, CONTROL-M Feb 2012 – Mar 2012 BNPP, Paris Vincennes

Position SAP BW Technico-Functional Consultant

• Modeling and extracting data (Cubes, DSO, transformation, routine, Multiprovider, process chains - Processing and loading data

• Development of the application reports

Technical landscape : SAP BW, SAP BPC 7.5, SAP REFX Sep 2011 – Jan 2012 COFELY, Paris Defense

Position Software engineer

• Migration from OutlookSoft CPM 4.2 to SAP BPC 7.5

• Designed, tested, and developed software

• Helped improve performance of software

• Managed the functional review Workshops

Technical landscape : SAP BPC 7.5, OutlookSoft CPM 4.2, VBA May 2010 – Jul 2011 CNRS – Paris

Position Accounts certification insurer

• Harmonized accounting reporting

• Managed the reporting tools

• Defined appropriate reporting

• Evaluated and improved the effectiveness of governance, risk management and control processes

• Provided F.D. with boards that helped to prepare the external audit Technical landscape : SAP FI, SAP BW, SAP RH

Oct 2009 – Apr 2010 SAP, Paris Defense

Position Systems analyst

• In charge of researching problems and providing solutions

• Responsible for recommending new software and hardware

• Managed daily operating systems and computer programming

• Checked with client the requirements changement and these impacts Technical landscape : SAP SRM, SAP BW

Jan 2009 – Sep 2009 Faurecia, Paris Nanterre

Position Software engineer SAP SRM

• Responsible for requirement gathering by working with business and technical users, analysts, Project managers, and involved in analysis and creation of architecture that can be considered 'best practice' and scalable.

• Tested the solution delivered before the user

• Planned and managed user acceptance tests

Technical landscape : SAP SRM, MS Office, SAP BI 4 Nov 2007 – Oct 2008 LaPoste, Paris

Position Change management Coordinator

• Provided tactical support to change management initiatives, such as new systems, procedures or organizational practices. Collaborated with business operations leadership, senior change management staff, communications, training, HR, IT and OD Specialists in the formulation and execution of plans and activities to support project implementation.

• Put into action a structured change management approach and methodology for the personnel side of change caused by projects and change efforts. Under the direction of the Group Manager, executed and measured a set of actionable and targeted change management plans, icluding communication plan, sponsor/stakeholder plans, and business readiness and measurement plan.

• Supported change management strategies and plans. For example, communicated with and engaged stakeholders, and measured readiness, adoption, and proficiency of target audiences. Collaborated with business unit, training, communications, and organization design resources to implement plans. Tracked and reported progress against plans.

• Identified potential people-side risks and anticipated points of resistance and developed specific plans to mitigate or address the concerns. Identified resistance and performance gaps and worked to develop and implement action plans to correct.

• Escalated issues to Group Manager for resolution as needed. Technical landscape : ISO 9001, TPM, GANT, AMDEC, 5S, MV, Lean management EDUCATION

2009 CNAM Paris, France

Qualification: Unit of studies Business Intelligence 2008 Paris Est Marne la Vallée, France

Qualification: MASTER Degree Management Economic Ingeneering Feb 2008 SAP BW La Défense, France

Qualification: Basic concept of Datawherehouse in SAP BW, analysis and reporting in SAP BW SKILLS

Work License EU Citizen, Canadian Citizen

Driving license B

IT Competent with MS Office suite, ABAP, SQLServer, ETL, Informatica Reporting & Modeling: SAP BW - BEx, SAP BO BI 4.2,SAP BPC, BFC, REFX Languages French: Mother tongue

English: Advanced

REFERENCES

Available on request



Contact this candidate