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