SUMMARY

• Having around 11 years of IT experience, in which more than 10 years of SAP BW/ BO/ HANA experience and more than 1 year of Talend and MS SQL scripting experience. Ability to interact and communicate well with all levels including senior/middle management and stakeholders. Experienced with various global market clients.
• 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.
• Experienced with various industries such as Healthcare, Consumer Goods, Oil & Gas, Palm Oil plantation and Mill, Paper plantation and Manufacturing.
• Strong skills in BW Technical areas.
• 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.
• Projects management - experienced in handling projects as a Project Manager.
• As a BW Technical Lead, worked on multiple performance tuning projects (Loading and Reporting).
• Well versed experience in data provisioning technique SLT replication into HANA DB.
• Good experience in BW transformations coding - using ABAP
• Experience in developing SQL script based Calculation views.
• Extraction of CDS Views from S/4HANA into BW on HANA. Ability to develop CDS views.
• Good working knowledge on latest BW/4HANA environment. Developed Eclipse based data flows.
• Rich experience on developing complex BEx queries.
• Experience in BO reporting tools such as Web Intelligence, Design Studio and Lumira.
• Experience in developing universes using IDT from various sources such as SQL server and ECC.
• Experience in SAP Data Services. Ability to architect on data models from various sources.
• Good experience on Talend BigData ETL tool and SQL scripting. Hands on with SQL server Management studio.
• 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 SKILLS

BI/OLAP: SAP BW/BI (3.5/2004, 7.x/2004s, BW on HANA, BW/4HANA, Native HANA, BIA, BW workspace, Business Objects (Web Intelligence, Design Studio, Lumira, InfoView/Launchpad, Information Design Tool & Business Objects Enterprise 3.x, 4.x)

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, 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, MI

SAP BW HANA Lead/Architect

Responsibilities:

• 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 SLT system to replicate the required master and transaction tables to HANA database and scheduled replication hourly.
• Developed various information models (Basic views, Master data views, Consumptions views) based on the replicated tables.
• Developed both SQL scripted calculation views and graphical views.
• Consumed HANA Views into BW Composite Providers for reporting.
• Created required ADSO and developed BEx reports for operational reporting.
• Consumed ADSO and Composite Providers into SAP Business Objects and created Webi Reports
• Developed dashboards in Lumira for KPI’s.
• Based on key stakeholders request, developed CDS views in S4HANA system and extracted into BW on HANA.
• Performance tuning of Design studio Dashboards.
• 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

Environment: s: BW 7.5 (BW on HANA), S/4HANA, HANA (HANA Studio), BOE 4.x and Lumira2.0

Confidential

SAP BW Hana Team Lead

Responsibilities:

• Understand system landscape and conversion to Hana requirements, estimate level of effort, prioritize and schedule technical conversion.
• Participated in BW upgrade from 7.0 to 7.5 in plan, pre upgrade, post upgrade defect fixing.
• Identify BW objects and map the BW system for a system wide assessment on the impact of the conversion to B4h environment.
• Creation of ADSO and Composite Providers.
• Conversion of Standard Objects into HANA Optimized Objects
• Worked on performance tuning for data loading- improved by pushing down the necessary ABAP coding to HANA XS engine execution.
• Creation of Data flows in BW Modelling Tools-HANA Studio
• Worked on HANA Views and Converted into Composite Providers.
• Work closely with Basis team and vendor.
• Do clean up activity and migration of 3.x objects in preparation of the system for the conversion for B4h environment.

Environment: s: ECC 6, BW 7.5 (BW on HANA)

Confidential

SAP BW Hana Team Lead

Responsibilities:

• Gather requirements and identify the BW reporting scope.
• Develop Data services jobs to replicate data in HANA Database.
• Develop HANA Information views to generate data based on Billing and AR payment history.
• Developed Webi reports for detailed reporting. Ensured results are tally with source.
• Prepare UAT plan and prepare the test data load.
• Perform UAT on the global reports and ensure results are tally and obtain signoff from respective stakeholders.
• Designed process chains for regular data loading.

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

Confidential

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 trainings to the business users on dashboards and technical training to Support team.
• Manage post go-live support.

Environment: s: Talend 6.2, Qlikview11, MS SQL Server 2012

Confidential

SAP BW Hana Team Lead

Responsibilities:

• Understand system landscape and conversion to Hana requirements, estimate level of effort, prioritize and schedule technical conversion until BW on Hana and related requirements.
• Perform pre upgrade and post upgrade activities. Ensure critical reports are tally and data loads are successful.
• Do clean up activity and migration of 3.x objects in preparation of the system for the conversion for BW on Hana environment.

Environment: s: ECC 6, BW 7.4 on Hana

Confidential

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.

Environment: s: ECC 6, BW 7.01

Confidential

SAP BW Team Lead

Responsibilities:

• 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.
• 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.

Environment: s: ECC 6, BW 7.3

Confidential

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 training sessions for all country users.
• For BW critical reports performance optimization, worked with SAP.
• Worked on recommendations and optimized reporting performance.

Environment: s: ECC 6, BW 7.01

Confidential

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 Confidential .
• 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.

Environment: s: ECC 6, BW 7.01, Qlikview10

Confidential

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.

Environment: s: ECC 6, BW 7.01

Confidential

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.

Environment: s: BW 7.0, BO3.x

Confidential

SAP BW Team Lead

Responsibilities:

• As part of BW system optimization - Initiated NLS - Near Line Storage concept and successfully completed the POC.
• Prepare 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.

Environment: s: BW 7.0

Confidential

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.

Environment: s: BW 7.0, ECC 6

Confidential

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.

Environment: s: BW 7.0, ECC 4.7

Confidential

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 training.

Environment: s: BW 7.0, ECC 4.7

Confidential

SAP BW Senior Specialist

Responsibilities:

• Gathered requirements from the stake holders.
• Prepared the project plan and go live check list.
• Worked as a lead in the project.
• Developed the BW architecture for the business requirements.
• Performed UAT with the user.
• Post go-live support.

Environment: s: BW 7.0, ECC 4.7

Confidential

SAP BW Senior Specialist

Responsibilities:

• Gathered business requirements from the stake holders.
• Developed cubes, DSOs and Multiprovider.
• Involved in the full loads.
• Developed reports, variables and related reporting components.
• Travelled onsite and demonstrated the reports to the stake holders.
• Involved in sign off the reports.

Environment: s: BW 7.0, ECC 4.7

Confidential

SAP BW Senior Specialist

Responsibilities:

• Performance optimization
• Attend BW support change requests and incidents
• Attend ETL L3 support
• Created aggregates to improve the query response.
• Created extractors in R/3 using views & function Modules.
• Implemented SAP Notes for source system Upload settings.
• Implemented SAP Notes to overcome issues pertaining large DSO’s sizes.
• Worked on splitting large info cubes to small info cubes to overcome high effort in administration and maintenance activities.
• As Inventory queries taking time to execute, have improved the performance by compressing the cube with marker updates.
• Worked on enhancing the query performance by correcting hierarchies’ settings.
• Enhanced the DSO settings to overcome load performance.
• Activated Number range buffering to improve load performance.
• Monitor BI Statistics Growth using t-code RSDDSTAT and deleted data which is not required.
• Done ABAP optimizations for codes in User Exit for R/3 Extractors and BW variables.

Environment: s: BW 7.0, ECC 4.7