ShamsuAmanulla

Specialist SAP BI-BW-HANA

Contact: 408-***-****

Email: aculpv@r.postjobfree.com

Location: Rockaway, NJ

PROFILE

Have 10 years of extensive experience in software analysis, design, development in back-end and front-end technical experience in SAP BW and BOBJ and HANA - Implemented 2 full life cycle BW project in FI, HR, SD, and EHSmodules.

Experience Architecting and positioning any combination of these products in a best-practice Enterprise Solution.Experience working with business users to effectively capture and define BI requirements and turn these into a BI solution design.Involved in data analysis, working on the report requirements for multiple business users- delivering solutions for the requirements, analysis of ECC, BW and suggesting which report tools can be used.

SAP BW/BOBJ:

Business Areas –FI, CO, EHS, HR, PM, SD.

Broad SAP BusinessObjects experience including Designing user friendly, high performing, effective and secure BI solutions/applications/reports using a mix of BusinessObjects tools and technologies including Web Intelligence, Analysis, Dashboards, Universe Designer/Information Design Tool.

Experience Architecting and positioning any combination of these products in a best-practice Enterprise Solution. Expertise with Design Studio, Webi and Universes.

Experience working with business users to effectively capture and define BI requirements and turn these into a BI solution design.

BW- Info Cube design, multiproviders, Sematic partition of Infocube, Write optimized DSO, Multi providers, transformation, performance tuning, data modelling, process chain maintenance, data extraction from ECC & non-SAP data sources, BEx Query.

Involved in data harmonizing between non SAP and SAP data source and advise business to decide reporting solutions based on the need.

Mentoring the subordinate to work on the development of reports based on the requirements.

Data modeling for the BOBJ reports.

Involved in ECC data source enhancement, creating generic data source, enhancing existing BW data sources.

Worked on several production support issues during on-call support, monitoring process chain, fixing data load issues in BW& BI.

Customizations - Data source enhancements, generic extractors, user Exits and Logistics Cockpit configuration and customization, Data extraction from flat files for Master data and Transactional Data, update/transfer rules creation, Business Content Activation, Direct and Flexible update of Master data.

Extracted data from SAP and non- SAP Source Systems and modeled Process Chains.

Experience in activating standard Business Content, extending and enhancing using User Exits according to the end-user requirements.

Experience in Design and Development of Queries, Reports and Workbooks,Web Report publishing using BEx Analyzer and BEx Query Designer and WEBI, BI Launch Pad.

BW operations- Data load management, event processing, experience also in Scheduling Start Process and Process Chains of Events, Data source Enhancement, OLTP extraction data, Loading (Full /Delta Up-Load), Monitoring, Remote Cubes, Data Mart and Open Hub Service, Performance Tuning, Aggregates, BW Transports.

ABAP- Reporting, User Exits, Customer modifications in BW and ECC.

Have worked in analysis of KPI’s for HR and FI

HANA:

Experienced in SAP HANA implementation, SAP System Landscape transformation (SLT), and SAP HANA data modeling using Attribute View, Analytic View and Calculation Views. Knowledge in using SAP BODS.

Experienced in importing SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.

Designed, Developed and debugged various Information Models (Attribute, Analytic and Calculation Views) to model data for reporting team.

Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View. Developed SQL scripts in Calculation views.

SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)

Executed Data Extraction Transfer Loading (ETL) using SAP Data Services 4.0

Reporting Accessing Analytical and Calculation views from EXCEL.

Loading data into HANA using SAP Landscape Transformation (SLT) and Data Services Transformation(DST)

Created analytic views and calculate views based on the data in the underlying tables.

Created Package, Created Attribute views, Analytic Views.

Have designed custom BW Objects using BW LSA.

Education & Certification: Bachelor of Technology(B.Tech)– Pondicherry Engineering College, Pondicherry University - Pondicherry, India 1993–1997

Professional Experience

Canadian Pacific Railways July2014- Present

Minneapolis, MN

Specialist SAP Business Intelligence / HANA Developer

Canadian Pacific Railways use SAP BW for their entire operations, such as Locomotive Servicing, Car Management,Human Resources, Environmental Health& Safety, Crew Management Application, Revenue Reporting are one among them.

We have upgraded to SAP BW 7.4 on Hana – currently in the process of developing the Hana optimized DSO/ converting SPO’s into Hana Optimzed Cubes, Composite Providers .

Created attribute, analytic and calculation views for SD module as part of the current POC.

Data Provisioning and replicating data from source system to HANA Database using SLT and Business Objects Data Services.

Replication of the selected tables of SD from ECC to SAP HANA. Performed transformations during the replication process.

Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.

Monitoring the replication process using SAP HANA studio and SAP LT replication server for transactional integrity.

Experience in Importing meta data, Table definitions, Performing initial load and Replication, Resuming and Suspending data loads using SAP HANA IMCE(In memory calculation Engine) studio.

Performed data modeling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Migrating standard Infocubes to In memory optimized Infocubes using migration Tool.

Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool.

Importing the BW Models in to HANA using HANA Studio.

Consuming the HANA Models in BW by creating the Transient Providers.

Involved in data modelling, creating multiproviders, Sematic Infocube, enhancing transformation, maintenance of DSO and PSA for data archive, process chain creation, fixing the issues related to BW data flow for production, data modelling, performance tuning, BEx Query – creating and enhancing queries.

Currently working on mini full cycle implementation for CR50 – creating new generic datasource, bringing into BW, creating new BEx report and enhancement of existing reports.

Canadian Pacific de-commonsioned Mainframe, all Crew Management Application(CMA) data is in the process transfer in BW. CMA has employees – Vacation Summary, Over time, regualr pay hours for Canada and USA.

Have handled couple of mini project – Locomotive Service Management – Which involves HCM Timesheet Approved from CATS DB. The process involves identifying extracting data from ECC to data modelling, ABAP tranformation and then to creating queries and workbook.

Develop dashboards, universes, and WEBI reports for enterprise Business Intelligence (BI) portal.

Crew Management Application – Using the flat file data from mainframe and HR related info – data modelling – Query – workbook.

Have also handled report development in BEX Query Designer for EHS, HCM – Train Accident Statistics, WCB Claims by Employee, Motor Vehicle Incidents,Headcounts & FTE, Timesheet Approved are few to mention here.

Handled BI adminsitration part for db size growing exponentialy – retention of PSA, Change log – deletion of older data using PC.

Per management request, creating all the BEx Query reports for EHS – Claims, indementies, personal injury, employee vacation, pay, overtime has been re-designed in BO Design Studio – as other dashboards for KPI Overview, Downtime Analysis,Work Order Management .

Handled produciton support activites once a week on a monthly basis, discussion with business for the requirements and other issue they would face during their day to day use of the application. Handled code review, created test plan in HP ALM.

ADP, New Jersey April 2008-June2014

SAP BW /BOBJ Developer

ADP had an SAP product called "Global View" for managed Payroll and HR. I handled the reporting and analytics piece of the product which solution heavily on BI/BW. Payroll cluster data and HR data was fed in nightly through BI connectors and I was in charge of building new reports in BI and enhance existing ones.

ADP had an SAP product called “SAP Money Movement” - FI module which primarily used to provide payroll for a particular company, we will collect the money from them and process in our system to pay the employee, in this category they are different scenarios like direct deposit, check, 401k,garnishment, FSA they are described as products in ADP. For every product there is different DSO and Infocube.

Designed and involved in creating several Multiproviders, Infocubes, DSO, transformation, process chain maintenance, performance tuning, data modelling.

Worked in developing queries in BEx Query Designer.

Involved in Business blueprinting – gathering requirements, analysing user requirements, identify performance indicators.

Understand and analyse the existing reports, the source of the data and the user analysis

Activated Standard BC Infoprovidersfor PA, Benefits, Payroll and Time Management.

Worked in extending standard data sources in HR – Headcount Transaction data- 0HR_PA_PA_1, 0HR_PA_EC_01, 0HR_PT_2, 0EMPLOYEE_TEXT, PERSON_ATTR.

Used generic extraction using Views and Function modules to extract ztables into BW.

Have worked on analysis of KPI for FI and HR – Staff Cost per FTE, Projected Headcount, Vacancies, and Training hours per FTE, Net Income, Gross Revenue, and Earning before Taxes.

Created Reports for Benefits, Time Management, and Travel Expenses & Personnel Administration. Created reports at various levels of analysis and restricted the user access through Analysis authorisations. Created Analysis authorisations for various users in the hierarchy to restrict access to each report and characteristics and Key figures.

Extracted the data from HR modules and uploaded the data into HR Info Cubes for PY_C02 Payroll data, 0PABN_C01 Benefits, Staffing Assignments 0HR_PA_OS_10HR_PA_CM_1, and 0PT_C01 Time and Labor Data and worked on transformations.

BO Responsibilities:

Worked on Business Objects using Universe designWEBI reports over universes.

Created financial reports, charts using Universes as the main data provider and reports such as Quarterly variance, Regional, Actual vs. Forecast, Balance sheets etc. were developed.

Handled issues and provided support for reports on Crystal Enterprise environments (Development, UAT, Testing, Production)

Created Reports for Benefits, Time Management, and Travel Expenses & Personnel Administration

OfficeMax, Chicago, IL Nov 2007-Mar2008

SAP BW Consultant

Assessed project requirements defined by customer, including desired reports and performance expectations. Involved in Business blue print and technical specification. Developed of Functional Specifications for standard cost reporting. Developed Technical Design Documents including GAP Analysis.

Configured and activated Business content according to the requirement based on the Application areas. Extracted data from data source 2LIS_03_BX, 2LIS_03_BF, 2LIS_03_UM to extract an opening stock balance, material movements and valuated revaluations in Financial Accounting.

Created Multiprovider to all access reportable Objects on daily and monthly level. Configured, activated and enhanced Business content for base actual cost and project actual cost according to the requirement.

Generates the BEx Reporting between actual data and planned data and facilitating the clients to analyze the Business scenario. Provided production support in BW reporting. Generated reports using BEx Analyzer and WEBI.

Integrating and extracting data into SAP BW environment from the Business Objects (Data Integrator) system. Designed, Developed and maintained the Xcelsiusdashboards.

Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects.

Multidimensional Data Model using Extended Star Schema designed and developed Info cubes, DSO, Info Source and Data Source. Used Open Hub for exporting data out of SAP BW into other formats. Created Start Routines, Transformation rules for DSO and Info Cubes.

Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.

Analyzed OLAP performance using BW statistics. Improved query and load performance using Aggregates, Partitions, Indices, Packet Size, Data Selection, and Data Compression.Used SAP BW Business Rules to improve report performance and functionality.

Tele2Telecom, Amsterdam, Netherlands Aug 2007- Oct 2007

SAP BW Consultant

Assessed business requirements and defined technical specification documents for Personnel Actions, Benefits & Payroll for Human Resources. Leading the BW Implementation and BOBJ (BI 4.) Reporting integration.

Worked closely with the end users on a day-to-day basis for their reporting needs. Created Architecture documents for the BW implementations with the naming standards.

Implemented BW-HR reporting for HR users. Created report for Headcount, Payroll and Benefits BEX &WEB Intelligence reports. Activated BI content heavily for the first ever BW implementation for the company. Define configuration for the implementation.

Created Universe and Web Intelligence reports using BEx queries. Defined best practices to use BEx queries in Business Objects. Helped Basis in setting up the BW landscape for transports management and configuration. Performing testing for BI 3.1 toolset.

Monitored Process Chain on a Daily basis. Created generic data source/extractor for Profitability Analysis (ECC) data to combine R/3 data into BW.

Architected the dataflow in Business Warehouse. Defined cubes and DSO’s using the standard Data sources from HR. Defined BEx queries as per the report requirement. Defined best practices on BW and BO data services integration. Data was transformed in both BW and BO Data Services.

Managed, Configured and Performed Transports between multiple BW environments. Defined practices for BW transport management. Created multiple process chains for Delta & Full Data sources. Troubleshooting data and technical issues related to SAP BW.

Managed Client BW environment to co-ordinate development, testing and transports to Production.

Maxis Telecom, MalaysiaAug 2006- July 2007

SAP BW Consultant

As a BW consultant involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, unit testing (UAT) to Go live production support.

Involved in analyzing and designing the data flow from ECC to BI and responsible for deployment.

Responsible for design, development and extraction of data from ECC source system into BI from SDand MM using LO cockpit extraction methods.

Extracted data from data sources like 2LIS_02_ITM, 2LIS_02_SCL, 2LIS_02_HDR and populated into the procurement infocubes 0PUR_C07, 0PUR_C08, and 0PUR_C09 to evaluate service levels.

Created setup tables for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the ECC system to the delta queue of the BI system.

Performed LO-Cockpit extraction to pull data from ECC SD modules into BI system extracting the Header and Line item data from the Sales and Distribution (SD) modules (Sales Order "2LIS_11_VAHDR/VAITM", Shipping/Delivery "2LIS_12_VCHDR/VCITM") and (Billing "2LIS_13_VDHDR/VDITM”).

Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom BOBJ reports.

Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.

Published Dashboards on to Business Objects Info view and provided access to the end users.

Vodafone – Romania April 2005 –Aug 2006

SAP BW Consultant

Gathered information from end user based on their needs. Development of BW objects (Info Objects, Info Cubes, Data Sources, Info Sources) and responsible for data loading (Master Data and Transaction Data).

Uploaded Master and Transactional data from flat files and SAP as the OLTP source. Worked on exporting of BW objects (Object Transport) to quality assurance and then to the production environment.

Created Process Chains for the data loads and to automate it and optimized the process chains by dividing processes chains into level1 and level2 process chains in order to optimize the scheduling and loads in BW.

Responsible for customizing and activation the Business Content Objects and Loading the data into ODS Object and Info Cubes. Scheduled Extract Jobs, Grouping of extract Jobs, Monitoring of Transfer and Update rules for data Loads, Monitoring of Status display and Load Statistics for Update Process.

Worked on enhancing business content as per the requirement. Created Aggregates to Improve query performance. Extensively worked on standard and custom defined LIS and LO extractors. Extensively worked on BEx Browser, BEx Analyzer and Info set queries.

Created calculated key figures, restricted key figures, variables and exceptions. Organized business roles and functions and managed workbooks using BEx Analyzer.

Contact this candidate