We provide IT Staff Augmentation Services!

Sap Bw Hana Senior Consultant Resume

Warsaw, IN

PROFESSIONAL SUMMARY:

  • Having over 12 years of SAP experience, in which around 12 years of SAP BW/ BO/ HANA experience and around 1 year of Talend and MS SQL scripting experience. Strong techno - functional skills. Ability to manage projects - interact and communicate well with all levels of business users and stakeholders, including senior/middle management. Good working experience with various global market clients.
  • Extensively experienced in BW versions: BW 3.5, BW 7.0, BW 7.3, BW 7.4, BW 7.5 and BW/4HANA.
  • Over 4 years of HANA development experience, extensively worked on HANA Studio.
  • Good experience in BW on HANA and Native HANA.
  • PMP (Project Management Professional) certified project manager.
  • SAP Certified Application Professional - Enterprise Data Warehousing with SAP NetWeaver Business Warehouse.
  • Working extensively on various functionalities of SAP BI BW/BO/HANA and Talend ETL tool.
  • Well versed with BW on HANA and BW/4HANA technical areas.
  • Worked extensively on BW upgrades and BW on Hana migration.
  • Well experienced in Native HANA modelling and developing Calculation views.
  • Good experience in SAP SLT replication process and SDA (Smart Data Access) and SDI.
  • Hands on experience with S/4HANA CDS views development and extraction to BW. Knowledge on Fiori apps development.
  • Experience in SAP Data Services (BODS). Ability to architect on data models from various sources.
  • Well working experience on Near-Line Storage and knowledge on Dynamic Tiering.
  • Rich experience on developing complex BEx queries.
  • Experience in BOE reporting tools such as Analysis for Office and Web Intelligence.
  • Good functional knowledge on LO (MM, SD), FI (AR, AP, GL) & CO-PA modules.
  • Strong skills in implementing BW Inventory Management scenarios and ETL process.
  • Good working experience with BW BPS - IP (Integrated Planning).
  • Experience in developing universes using IDT from various sources such as SQL server and ECC.
  • Strong skills in BW Technical areas. Worked as a BW Solution Architect for multiple projects.
  • Good experience on Talend BigData ETL tool and SQL scripting. Hands on with SQL server Management studio.
  • Good experience in BW Analysis authorization and Securities .
  • Experienced with various industries such as Manufacturing, Healthcare, Consumer Goods, Oil & Gas, Palm Oil plantation & Mill and Paper plantation.
  • Projects management - experienced in handling projects as a Project Manager.
  • As a BW Technical Lead, worked on multiple performance tuning projects (Loading and Reporting).
  • Good experience in BW transformations coding - using ABAP
  • Involved as a key member, Team Lead and Project Manager in various projects. Undergone through all phases of realization, go-live, rollout and post implementation support of SAP BW and HANA, in functional modules MM, SD and FICO.
  • Effective team player, self-initiator and ability to work in a rapidly changing environment.

TECHNICAL EXPERTISE:

BI/OLAP: SAP BW/BI (3.5/2004, 7.x/2004s, BW 7.4, BW 7.5, BW/4HANA, Native HANA, BIA, BW workspace, BOE-3.1, 4.0, 4.1 & 4.2. Business Objects (Web Intelligence, Design Studio, Lumira, InfoView/Launchpad, Information Design Tool & Business Objects Enterprise 3.x, 4.x), Tableau

SAP/ERP: SAP R/3 (4.7 & ECC 6.x), S4/HANA

SAP Modules: MM, SD, FI/CO, COPA, PP, PM, HR

SAP Extraction: LO - IM, PO, SD, FI-GL, FI-AR, FI-AP, CO-PA, Generic, DB Connect and Flat file

ETL: BO Data Services (BODS), Talend ETL

Databases: SAP HANA, SQL Server (2012), MS Access, SybaseIQ

OS: MS-DOS, Windows, UNIX and SUSE Linux

Programming Languages: ABAP, SQL

Methodologies & other: ASAP, Agile and Waterfall

Industry experiences: Healthcare, Consumer Goods, Palm Oil plantation and Mill, Forestry - Paper plantation and Manufacturing.

PROFESSIONAL EXPERIENCE:

Confidential, Warsaw, IN

SAP BW HANA Senior consultant

Responsibilities:

  • GCMR project objective is to integrate the subsidiaries financial information into global database, such as gathering General Ledgers Line items, Accounts Receivables and Bank payments data.
  • Conduct initial kickoff sessions with the each subsidiary’s business users / SME’s and walkthrough on the functional requirements for the GCMR project.
  • Develop relevant data flows - design ADSO’s, data sources, transformations, DTP’s and Info Packages.
  • Design process chains for the periodic data extraction into ADSO’s.
  • Consume ADSO’s in HANA calculation views as base views.
  • Develop the HANA Calculation views - work on base views and star joins.
  • Involve in developing the target tables in HANA DB.
  • Connect non-SAP DB’s to HANA DB using BODS. Develop ETL flows using BODS jobs.
  • Develop transformations in the BODS jobs where required and map to the target.
  • Model calculation views with best practices and ensure the optimized performance.
  • Plan the developed objects transports into the next servers in the systems landscape.
  • Develop Open ODS views and enable virtual access using SDA to the requested subsidiary’s databases.
  • Work on Harmonization layer - where integrate data from multiple source systems (around 40 source systems).
  • Prepare Harmonization values for important attributes and ensure values are read accordingly at Star Joins.
  • Prepare a FRD document, technical document and testing verification documents.
  • Define testing strategy. Come up with the test criteria’s and prepare a test case document.
  • Drive the test cases with testing team and ensure KPI’s are reported accurate.
  • Work closely with BO team and ensure the Web Intelligence and Lumira dashboard reports are developed according to the management reporting needs.

Environment: s: HANA Studio 1.0, BW 7.5, BOE 4.1 - Web Intelligence and Lumira2.0, BODS and other non-SAP sources.

Confidential, Chicago IL

SAP BW HANA senior consultant

Responsibilities:

  • Responsible to interact with business users, understand the business reporting requirements and ensure to deliver the intended reports timely with quality.
  • Responsible to provide process improvement solutions, design and enhance the existing processes.
  • Involve in BW upgrade - from 7.3 to 7.5 BW on Hana version.
  • Liaise with upgrade project team, test BW objects and work on upgrade issues
  • Liaise with Basis team to apply the necessary SAP notes and resolve the upgrade errors and issues.
  • Develop HANA views for the existing data flows to access them in HANA environment.
  • Involved in BOE upgrade 4.0 to 4.2. Ensured the connectivity to BW and HANA is flawless after the upgrade.
  • Create Calculation views (graphical and SQL scripted), Open ODS views, ADSO’s & Composite providers as per business requirements to report them in BO Analysis Office and Web Intelligence.
  • Create reports and dashboards in BO Analysis Office/Webi and Tableau based on business needs.
  • Develop various reports and dashboards in the areas of Logistics (SD & MM) and Finance in BW HANA environment. E.g.: Consolidated Sales Dashboard, Wheatland Gross Margin report & ATC Inventory dashboard.
  • Provide backend BW support to develop Cognos packages and dashboards.
  • Migrating data from ECC and SQL server to HANA (Integration Project) using BODS ETL jobs.
  • Developed SQL stored procedures and SQL coding where required.
  • Worked on Performance improvement of SAP HANA Views.
  • Developed and implemented best practices and standards.

Environments: HANA (Hana Studio), SAP BW, BOE 4.2 - Analysis Office, Tableau, Cognos & Lumira2.0

Confidential

SAP BW Hana Team Lead

Responsibilities:

  • Responsible to engage with stakeholder and understand the requirements, develop HANA views and deliver management dashboards and operational reports.
  • Worked on requirements gathering, attended multiple workshops with key stakeholders and business users.
  • Documented the requirements and analyzed the business logic for the derivation of KPI’s and identified the data sources from various systems.
  • Involved in BW on HANA Life cycle implementation.
  • Developed Calculation views from various sources and Enhanced Standard HANA Views.
  • Configured BODS ETL jobs to replicate the required master and transaction tables to HANA database and scheduled replication hourly.
  • Developed various information models based on the replicated tables.
  • Consumed HANA Views into BW Composite Providers for BW reporting.
  • Created required ADSO and developed BEx reports for operational reporting.
  • Consumed Composite Providers into SAP Business Objects and created Webi Reports
  • Developed dashboards in Lumira for KPI’s.
  • Imported BW Models into HANA Calculation Views and Customized the Calculation Views.
  • Worked on Performance improvement SAP HANA Views.
  • Developed and implemented best practices and standards.

Environments: BW 7.5 (BW on HANA), ECC, HANA (HANA Studio), BODS, BO Webi and Lumira2.0

Confidential, MY

SAP BW Hana Team Lead

Responsibilities:

  • Gather requirements and identify the reporting scope.
  • Develop Data services jobs to replicate data in HANA Database.
  • Develop ADSO’s and data flows for the new source - Purchasing, Inventory, Billing and AR payment history.
  • Created various calculation views according to the reporting requirements in Webi.
  • Create and adjust BW security authorization objects and ensure there’s no impact for global reporting.
  • Ensured the existing global reports in BW are able to provide PM3 information. Adjusted ABAP routines in ECC.
  • Developed Webi reports for detailed reporting.
  • Prepared UAT plan and prepared the test script.
  • Performed UAT on the reports and ensured results are tally and obtain signoff from respective stakeholders.
  • Liaised with Basis team to create user id’s and add authorization to the new users.

Environments: ECC 6, BW 7.4 (BW on HANA), BO 4.x DataServices, Web Intelligence

Confidential, MY

Digital Application ETL Team Lead

Responsibilities:

  • Lead ETL activities using Talend BigData.
  • Manage requirements gathering workshops. Understand the requirements and prepare data discovery documents.
  • Liaise with Qlikview team and develop wireframe design of dashboards.
  • Develop ETL jobs in Talend using SQL Server scripting.
  • Conduct UAT workshops and ensure results are tally on dashboard with business source data.
  • Conduct s to the business users on dashboards and technical to Support team.
  • Manage post go-live support.

Environments: Talend 6.2, Qlikview11, MS SQL Server 2012

Confidential

BW HANA Lead

Responsibilities:

  • Responsible for BW technical upgrade of APRIL company, from version 7.01 system to SAP BW7.4 on Hana and enable business objectives.
  • Understand system landscape and conversion to Hana requirements, estimate level of effort, prioritize and schedule technical conversion until BW on Hana and related requirements.
  • Participated in BW upgrade from 7.01 to 7.4 in plan, pre-upgrade, post upgrade defect fixing.
  • Perform pre-upgrade and post upgrade activities. Ensure critical reports are tally and data loads are successful.
  • Creation of ADSO and Composite Providers.
  • Conversion of Standard Objects into HANA Optimized Objects
  • Perform the defect fixes and implement necessary SAP notes where required and test.
  • Creation of Data flows in BW Modelling Tools-HANA Studio
  • Work closely with Basis team and vendor.
  • Do clean up activity and migration of 3.x objects.

Environments: ECC 6, BW 7.4 on Hana

Confidential, MY

SAP BW Project Manager

Responsibilities:

  • Scheduled initial kick off meetings with stakeholders and gathered requirements with other key users of the project.
  • Prepared the project plan and blueprint document.
  • Designed and developed objects according to the requirements.
  • Developed custom extractors and to load PO related data, enhanced data sources using ABAP coding.
  • Conducted UAT and resolved issues raised during testing.
  • Prepared go-live activities and communicated with Basis team.
  • Performed go-live activities successfully.

Environments: ECC 6, BW 7.01

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Plan and manage BW rollout for Confidential North America - NJ.
  • Prepared the rollout project plan and consolidated the tasks from different teams.
  • Communicated with stakeholders and finalized the requirements.
  • Integrated functional team (FI and SD) to gather the functional details, Systems and Basis teams in order to plan the system resources. Prepared a plan on each team tasks and drove the initiatives as a Lead.
  • Created BW security authorization objects and roles. Ensured the flawless reporting to the new Company codes, Plants and Sales Organizations.
  • Developed critical reports in MM, SD & FI.
  • Conducted global reporting UAT with Business Analysts.
  • Created new data flow for Confidential America country and extracted the data into BW.

Environments: ECC 6, BW 7.3

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Prepared upgrade plan and timeline for BEx7.3 upgrade and coordinated with Basis team.
  • Testing performed on the queries migration and resolved the upgrade issues.
  • Worked with Basis team and ITI team to initiate an automated SCCM process for upgrade.
  • Conducted online WebEx sessions for all country users.
  • For BW critical reports performance optimization, worked with SAP.
  • Worked on recommendations and optimized reporting performance.
  • Performed POC on Vistex data sources. Worked closely with the Basis team and vendor to install the add-ins.
  • Performed setup table filling and extraction of the Customer Rebates and Bill back data sources.

Environments: ECC 6, BW 7.3

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Integration with QlikView tool. Backend development in BW.
  • Developed BW queries in Billing module to view Product cost and In Market Sales for BiO-LiFE.
  • Designed an APD for a periodic extraction into a DSO, in order to access data in QlikView dashboard.
  • Worked closely with the QlikView team to complete the backend design in BW.

Environments: ECC 6, BW 7.01, Qlikview10

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Worked closely with Basis team on the upgrade tasks.
  • Worked on SPDD and SPAU adjustments. Verified the differences and adjusted accordingly wherever needed.
  • Defined a testing strategy.
  • Ensured the BO connectivity and Webi reports execution.

Environments: ECC 6, BW 7.3

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Worked on Web intelligence reports development.
  • Created Webi reports based on the BW query.
  • Created Publication reports to end users.
  • Worked with Basis team and managed user restrictions in CMC.

Environments: BW 7.0, BO3.x

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • As part of BW system optimization - Initiated NLS - Near Line Storage concept and successfully completed the POC.
  • Liaised with Basis team to setup Sybase IQ server for Near Line storage and install required plugins in BW.
  • Created DAP jobs (Data Archiving Process) based on the time characteristics.
  • Verified the DB space recovered in BW table spaces and verified the space occupied in Sybase IQ.
  • Executed critical reports for statistics - before and after NLS.
  • Prepared a summary of the results and presented to the management.
  • Prepared a sizing document for NLS implementation and align with Systems team for the Infrastructure.
  • In terms of proper system resources utilization - Initiated for BW housekeeping activities and implemented automated processes.
  • Resolve BW ETTL issues and implement relevant sap notes.
  • Optimize ETTL process chains.
  • Manage system activities such as Cubes compression, Change log deletions, PSA deletions and statistics data loading.
  • Manage BW modeling part - cubes designing and give guidance to the team on all new designs and issues resolution.

Environments: BW 7.0

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Prepared the BW project plan according the SAP upgrade plan.
  • Identify the pre upgrade and post upgrade BW activities and perform during the upgrade in Development, Quality and Production systems.
  • Prepare a test strategy for BW objects in ECC upgrade.
  • Coordinate BW team with Basis and SAP teams. Drive the team accordingly.
  • Resolve the upgrade issues during the testing process.

Environments: BW 7.0, ECC 6

Confidential, MY

SAP BW Team Lead

Responsibilities:

  • Analyze the user requirement on the fixed valuation for COPA reports.
  • Involved in designing the functional spec with functional team to provide the logic. Design the R/3 custom table and create the BW data flow.
  • Create ABAP routine in the BW transformation to lookup for the relevant details in the current COPA DSO.
  • Create reports on the new MPRO.

Environments: BW 7.0, ECC 4.7

Confidential, MY

SAP BW Senior Delivery Specialist

Responsibilities:

  • Involved in identification of business requirements meeting the needs of end-users.
  • Extensively involved in defining the layers like Data Acquisition Layer, Quality and Harmonization Layer, Corporate Memory Layer, Data Propagation Layer, Business Transformation Layer, Reporting Layer, Operational Data Store Layer.
  • Extensively involved in Data Modeling, Creating Info Objects, Info Cubes, DSO and WDSO.
  • Developed Transformation and Start routines using ABAP to in corporate Business logic and perform data manipulation.
  • Performed Data Source enhancements and worked with generic extractors, User Exits and customized delta built up for Data Sources.
  • Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
  • Extensively worked on Query Designer and Web application designer to create Queries using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
  • Created different Currency translation types, exchange rate types by using RSCUR Tcode.
  • Developed data loading strategies for master data, transactional data and delta uploads.
  • Created Process Chains to automate the data load and data target administration and monitored the processes.
  • Involved in Performance Tuning Concepts like Compression, Aggregates, Partitioning, Indices and Line item Dimension.
  • Involved in documentation and end-user .

Environments: BW 7.0, ECC 4.7

Hire Now