Data Project

Profile

Steadily Progressing professional with 10+ years of experience in Information Technology in SAP HANA, SAP BW 7.0 with IP, APO – DP & SNP, 7.4 on HANA, who has extensively worked with Accelerated SAP Methodology in 2 Full Cycle BI Implementations + Reporting from design, implementation and support.

Thorough understanding of SAP BEx tools and SAP BOBJ tools like Dashboards, Webi, Explorer and Analysis editions and other reporting using Tableau.

Successfully managed SAP BW projects using Dev/Ops strategy combined with Agile – SCRUM methodology.

Professional Experience

NTT DATA AMERICAS

Delivery Principal Consultant – SAP BI, BO APR 2010 – Till Date

RENAULT NISSAN TECHNOLOGY & BUSINESS CENTER, INDIA

Team Leader APR 2009- MAR 2010

SATYAM COMPUTER SERVICES LIMITED

Software Engineer FEB 2006 –FEB 2009

Technical Experience

Worked on ARIS for SAP to build an Enterprise Architecture using Business Process Management.

Broad Functional experience in Automotive, Manufacturing, Finance and Health Care & Retail sectors.

Experience in working with all the new feature of BW 7.4 and BW on SAP HANA, with all upgrade, migrate and integration scenarios from lower level version objects using the best modeling solution.

Proficient in understanding the Next generation data base management system which is SAP HANA (In memory data base) and various use cases related to SAP ERP and SAP BW.

Exposure and knowledge to latest versions of SAP HANA 1.0 SP 09 and various features in it.

Full coverage and hands on experience with Data Replication scenarios of SAP HANA which include SLT, ETL, DB connect and Flat files.

Proficient in extracting the data from SAP R/3 system. Expert in LO Cockpit & Generic Extraction.

Expert in design, develop on standard and custom Info cube, DSO objects, info object catalogs, Infoobjects, Transformation, Info package, DTP, Data source, Characteristics, Key figures, Multiproviders, Business content Installations, AODSO, Process chains, Semantic Partition Objects, Composite Providers.

Worked on various planning models using SAP IP for Sales Forecast, Financial Forecast, and Supply Forecast.

Worked on FOX code to create IP scenarios for planning cubes at various aggregation level.

Worked extensively on Business Explorer Suite tools -BEx Query Designer, BEx Web Application Designer, BEx Analyzer & BEx Web Analyzer and exposed the same to Business Objects AAO & Webi and Tableau.

Excellent skill set in building queries using Reusable Query structures, filters, Restricted Key Figures, Calculated Key Figures, formulas, conditions, and exceptions.

Create process chains and monitor data loads through email configuration and thereby reducing the frequent visit to production server.

Extensively worked on Webi Scheduler and Precalc Server Set up and broadcasted reports to email.

Achievements

3-times awarded as best performing employee in the Quarterly awards distribution ceremony.

Awarded the “Sparkle award” as part of immediate recognition for best deliverables in the project.

Project Experience #1

Employer: NTT DATA AMERICAS AUG 2016 – Current

Project: HONEYWELL SALES ADHOC REPORTING

Role: LEAD CONSULTANT

Environment: SAP BW 7.4 on HANA, HANA 1.0 SP09, BO AAO & Webi

Job Responsibilities:

Involved in full life cycle implementation, which includes Analysis, Requirements gathering, Development, and Reporting and Testing process.

Deployed Function specs, Technical specs as per the Templates specific to Quality Standards.

Created calculation views for Sales 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.

Implemented conditions and restriction in the reports based on the requirements, Developed Workbooks.

Designed and developed process chains for master data loads and transaction data loads

Involved in User Manual preparation and End User Training.

Created and maintained queries in BEx Query Designer, BOBJ Webi and BO Analysis Office for reporting.

Interaction with Key Business Users to blueprint BW IP Planning Scenarios and various reporting needs.

Project Experience #2

Employer: NTT DATA AMERICAS JAN 2016 – JUL 2016

Project: HONEYWELL RESIS – SPIN OFF

Role: BW TECHNICAL CONSUTANT

Environment: SAP BW 7.4 on HANA, HANA 1.0 SP09, SLT, BO AAO, Design Studio, WebI, Tabuleau

Job Responsibilities:

Review the functional specification document with Business and Technical Architects to understand the current landscape, scope, connections and mapping document.

Create and Migrate Data sources using Tables and Views for extracting Master and Text Data.

Collected, released and imported the BI Objects from Development to Acceptance to Quality boxes

Direct interaction with the business users

Create and maintenance of Info Objects, DSO,WODSO, Cubes, Transformations, DTPs, Data Sources

Created and maintained queries in BEx Query Designer for analysis and web reporting respectively which are published in Enterprise Portal

Fine tuning of the performance issues by handling the indexes, aggregates and compression

Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork

Involved in data validation to check report consistency with Data Targets and the source system.

Detailed testing of SAP HANA data modelling - Attribute View, Analytical View and Calculation view.

Worked on currency conversion in HANA models.

Used SDA (Smart data access) to access data from HPS Enterprise HANA views to PMT BW HANA Composite provider for integrated reporting.

Used calculated columns, Variables, Parameters, Decision Tables and Restricted Columns.

Used Open ODS and Advanced DSOs and Composite providers to integrate HPS data to PMT reports.

Worked on Self-service reporting tools like Tabuleau (Visualization), BO AAO (Reporting tool).

Designed the Data Model, Data Provisioning for Design Studio Reports.

Project Experience #3

Employer: NTT DATA AMERICAS JAN 2015 – DEC 2015

Project: HONEYWELL FINANCE DASHBOARD REPORTING

Role: LEAD CONSULTANT

Environment: SAP BW 7.4 on HANA, BPC NW 10.1, BOBJ WebI 4.0, AAO, Design Studio

Job Responsibilities:

Develop conceptual prototypes, identifying operational requirements, determining security architecture, data architecture and application architecture define and determine metadata strategy.

Analysing data acquisition and mapping, designing data transformations and cleansing.

Worked on full Life cycle Implementation of Cost Center Accounting Budget Input Application and Admin Tool.

Extensive Experience working with ABAP Programming/SQL statements /FOX formulas etc.

Sole responsible for the design, develop and test for initial phase of delivery.

Created Business Requirements Document (BRD) and Business Design Document (BDD) for Cost Center Accounting for budget input and Admin tool.

Involved in design and development of Transactional InfoCubes, Planning Area, Multi Planning Area, Planning Levels, and Planning Packages, Planning folders, Manual Planning

Function, User Defined and Predefined Planning Function, Data Slicing, ABAP, Fox Code.

Developed Reports for Zero based budgeting Plan Vs Actual Comparision using Universe designer.

Designed and developed BO reports for Budget Input Application using Webi.

Developed CCA reports such as Variance Report, Plan Vs Actual Comparison, etc

Created Embedded and Standard Models functions to support Account based and Multiple Keyfigure planning.

Select and Suggest salient features available in the technology to be used for the development of the system

Understanding and documenting business definitions of data to develop the data model.

Involved in creation of various 4-tier operational Business Objects Design Studio dashboards and Webi Reports.

Created Bex queries for top management dashboards for Finance Reporting with acute Business insights.

Used “Script logic” to write customized codes to meet specific variable business requirements and debug the data flow for any error in specific calculation types.

Interaction with Key Business Users to gather BW reporting needs.

Used Master Data validation for the entry of correct records before save into the system.

Used highly summarized data models like 10- dimensional info cubes and APD layers to stage data in BW.

Maintained cache memory in BW system for optimum performance based on query usage statistical history.

Customized ABAP code for variety of technical user parameters like default values, recently used, login authorization, user validation, hierarchy view, restricted data view by location and responsibility.

Optimize the data model by Harmonization, Compression, Indexing and Consolidate techniques.

Effectively include advanced features and additional functionality based on existing application Knowledge

Used standard and custom dashboard functions like print, email, save and refresh, back and clear functionalities.

Coordinated with SAP for any issues, clarifications and questions on Design Studio Application Patch work.

Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings.

Interaction with users to resolve BW reporting issues

Project Experience #4

Employer: NTT DATA AMERICAS JUL 2014 – DEC 2014

Project: HANA UPGRADE AND MIGRATION

Role: BW EXPERT CONSULTANT

Environment: SAP HANA, SAP BI 7.0, and SAP BW 7.4, SAP IP, BO AAO, and WebI, Design Studio

Job Responsibilities:

Successfully helped customers to their Requirements Elicitation for HANA database in SAP BW.

Active contributor in architecting solutions for the upgrade and migration from BI 7.0 to BW 7.4 on HANA.

Plan, review and execute migration tasks for SAP BW pre-HANA functions.

Experience with SAP HANA upgrade cockpit to handle data modelling, transformation and Reporting needs.

Worked on Quick Sizer - a Web-based tool designed to make the sizing of the SAP BW environment.

Participated in all phases of the customization process including Analysis, Design, and Coding, Test & Debug.

Participated in project management activities including scheduling the development, test and release phases.

Coordinating with BASIS for accommodating the changes in requirement.

Check Master Data consistency before and after upgrade.

Check inconsistencies with RSZ* Tables in BI and remove any inconsistency.

Extensive performance Tuning of Data loads suitable for HANA database.

Complete knowledge on User Authorization concepts in BW for restricted access in Reporting & View roles.

Worked on Performance Tuning Concepts like Compression, Aggregates, Partitioning, Indices and Line item Dimension, HANA optimized Cubes, HANA Optimized Transformation and ABAP statement.

Project Experience #5

Employer: NTT DATA AMERICAS JAN 2014 – JUN 2014

Project: HONEYWELL PMT BW DEVELOPMENT, MAINTENANCE & SUPPORT

Role: TEAM LEADER

Environment: SAP BW 7.0, SAP APO, SAP IP, BEx Anayzer, Portal, Precalc Server, Non – SAP interfaces

Job Responsibilities:

Gathered requirements from functional users in Purchasing, inventory, finance and sales for cross functions.

Worked on Building and enhancing BI objects that include Info Objects, Data Sources, Transformations, DTP, DSO, Info Cubes, Multi-providers, Info set and Open Hub.

Worked in Data Modelling using BI Extended Star Schema.

Worked in Business Explorer Analyzer for Reporting.

Customized and maintained Data Sources for the FICO, COPA Module.

Worked on Generic Extraction of Table, Views and function Module

Worked on ETL from Customer generated application specific generic extractors LIS, LO, CO-PA.

As part of Quality management standards to deliver the objects in quality performed Unit testing and recorded the test results in unit test cases documents in Quality Center Tool.

Worked on process chains, Monitoring and scheduling the batch jobs

Worked on Creation of Info Packages, info package groups and Process chain maintenance

Involved in managing of Info cube, which involves Info cube content, performance issues like Indices, Statistics, compression of Info cube and rolling up the data to the aggregates.

Good understanding and exposed to Precalc Services for Report broadcasting.

Experience in automating Data loads using process chains and Meta chains for BW.

Scheduled SAP background Batch Jobs using WCC- Autosys.

Shared knowledge to team members for different objects and maintained healthy people relationship management, to maintain teamwork.

Attending day by day meetings like Internal Review Meeting, Quality status and Client Review Meetings.

PSA Data Deletion on daily, weekly and monthly basi

Project Experience #6

Employer: NTT DATA AMERICAS JAN 2013 – DEC 2013

Project: ISC – SNP FORECAST VS ACTUAL REPORTING

Role: LEAD CONSULTANT

Environment: SAP BW 7.0, SAP APO – SNP, SAP IP, BEx Anayzer

Job Responsibilities:

Implementation of new Sales Inventory Operations planning process and report. The major functions are related to Inventory Handling, Demand Forecasting, Supply processing and Distribution networking.

The major function is to generate Sales Inventory Operations planning report which help the user to control the flow of Supply Chain process.

The Sales Inventory Operations Planning report enables the user to get the consolidated status of Demand, Inventory and Supply for each product of Honeywell Specialty Materials Fluorine Products business.

Ensuring the development process is carried out by following Software Development Lifecycle (SDLC) procedures; milestones are met as per the schedule.

Would be responsible to understand the ISC business process and effectively manage the project as per Honeywell Specialty Materials or PMT specific standards and guidelines

Detailed study of client’s business strategies and goals to design architecture of the system for future scalability

Design the system in such a way that Keane’s framework for Retail solutions would be utilized to the core thus leveraging maximum benefits of the framework

Enhance the existing data cubes to include additional fields which are required for Sales inventory operations planning report

Created Mega Sales Inventory Operations planning report and Mini Sales inventory operations planning report

Plan, Improve & Modify the underlying architecture in the project to attain the direction of instant reports with instant data using BWA.

Work & Modify existing reports from SAP BEx to SAP BOE Dashboard reporting using Portal and BOE.

Map the APO (DP and SNP)data to BW online and make them available in reports for easy planning and tracking

Performance tuning of queries using compression, aggregation and partitioning etc. and performance tuning of system to improve data load and system response time in order to achieve the value for business from BW.

Grant restricted access to the users in Enterprise Portal to maintain strict view.

Project Experience #7

Employer: NTT DATA AMERICAS JAN 2012 – DEC 2012

Project: ISC – DP FORECAST VS ACTUAL REPORTING

Role: LEAD CONSULTANT

Environment: SAP BW 7.0, SAP APO - DP, SAP IP, BEx Anayzer

Job Responsibilities:

Design APO – DP Plan data movement process and prototyping data movement, designing Meta data process and designing technical environment and prototype technical components.

Development of Function module to extract Demand Planning area from planning book.

Create Planning Info objects and setup master data and add to Planning DSO and Info-cubes to store transactional data and transformation for mapping DSO and Info cubes

Creating Multi-provider to combine forecast data and actual data

Involve in transports of Info objects, Info cubes, ODS objects, Queries from Quality to Production Servers

Help the users on understanding BW reports and customize instantaneously according their needs.

Creating customized workbooks for users to execute the report.

Creating a Remote cube to facilitate ad-hoc reporting and use for validation purpose.

Manage the development environment, code and unit test the modules and establish integration.

Project Experience #8

Employer: NTT DATA AMERICAS APR 2010 – DEC 2011

Project: HONEYWELL BW – RAPID DELIVERY LEAD

Role: QUICK SOLUTIONS LEADER

Environment: SAP BW 7.0, BEx Reporting

Job Responsibilities:

Worked on Enhancements Requests to modify DSO / Info cube / Reports

Restructuring Existing cubes to include the Cost Model data from ECC.

Develop custom extraction routines for FSCM loads and reporting from ECC.

Develop O2C, P2P, B2R, Inventory Reporting for various business users.

Modification to existing Data Source as per requirement

Created and maintained queries in BEx WAD for analysis and web reporting to publish in SAP Enterprise Portal

Developed Custom Generic Data Sources through Views & Work on BW objects to extract LIS/LO Cockpit, Generic, OLTP & Flat file extraction of real- time data from R/3.

Installed LO extractors for Sales for Info Cubes, Info Source and Info Objects as per the Client Requirements.

Created & Scheduled Info Packages and populated DSO objects & Info cubes with full update and Delta Update

Worked on creation Queries, calculated key figures, Restricted Key figures, Structures, Variables to enhance the reporting features.

Project Experience #9

Employer: RENAULT NISSAN TECHNOLOGY & BUSINESS CENTER APR 2009 – MAR 2010

Project: RENAULT SPRING 3 BW

Role: TEAM LEAD

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Roles and Responsibilities

Develop Language dependant objects for multi users needs.

Develop and execute IP based functions (standard and formula based) to meet customer needs.

Find operational gaps in the project and assist the client by suggesting suitable ideas to resolve them.

Actively involved in Unit Testing, PAT after Delivery and close the defects gap by transporting as required.

Develop Reports, WAD and language dependant texts tightly integrated to the corresponding reports and queries.

Grant restricted access to the users in Enterprise Portal to maintain strict view.

Monitor monthly-jobs before account settlement process in process chains.

Ticket based analysis for any production related issues regarding data coordination.

Monitor Project performance on a weekly and monthly basis to maintain good health.

Conduct project related training for the team to check individual knowledge.

Identify the working knowledge of associated systems lying with SPRING to know the architecture and technical details at the input and output nodes.

Developed Custom Generic Data Sources through Views

Worked with Early Watch Reports for improving the loading and Query Performance

Extensively worked on end to end Testing using HP QC

Interacted with Client very frequently understanding the requirement for creating various type of reports

Worked with Performance related issues like Aggregates, Partitioning and Compression

Monitoring of info packages and analyzing the reasons for frequent failures of info packages

Developed load strategy and created process chains to schedule the loads on daily, weekly and monthly

Involved in setting up the procedures for extracting the data from ECC by using the LO COCKPIT and GENERIC extractions

Project Experience #10

Employer: SATYAM COMPUTER SERVICES LIMITED JAN 2008 – FEB 2009

Project: CPROJECTS BW DEVELOPMENT PROJECT

Role: TEAM LEAD

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Roles and Responsibilities

Full implementation of Projects Systems Data for BW reporting

Design and Develop reports based on the specifications provided by the client

Uploading master and transaction data from flat files and SAP cProjects

Worked on Generic Extraction and Flat file Extraction & Testing of all developed solutions.

Identifying the data in the source environment and Mapping the data to the BW environment

Created and maintained queries in BEx WAD for analysis and web reporting to publish in SAP Enterprise Portal

Worked on Dashboard reporting using WAD and developed Dashboard reports.

Involved in transports of Info objects, Info cubes, ODS objects, Queries, Currency Update and UOM inputs.

Created the Process Chains to automate the loading process.

Experience in automating loads using process chains and use of BW Monitor to supervise

Monitoring daily and weekly running chains and resolving the issues.

Played different roles like SCMA (Software Configuration Management Authority) and SDM

(Service Desk Manager) proactively.

As SCMA, involved in Project related QMS documents and Version Controlling and co-ordinate the Project Process Monitoring audits at Project level.

Project Experience #11

Employer: SATYAM COMPUTER SERVICES LIMITED JUN 2006 – DEC 2007

Project: NESTLE AMS BW ADMIN

Role: BW ADMIN

Environment: SAP BW 7.0, SAP IP, BEx Reporting & Portal

Roles and Responsibilities

Capturing the information and producing the deliverables from the business requirements gathering sessions

Understanding and documenting business definitions of data

Developing the data model

Monitor the data loads from various source systems like R/3, SEM and APO by means of process chains.

Analyze the errors in the data loads and report to the corresponding team.

Mange master data, text and hierarchies.

Mange the data targets by having the correct and up to the date data.

Reconstruct the data requests from PSA in case of data load failure.

Roll up data from info cubes to aggregates, edit and maintain the aggregates.

Re-initialization of business area in case of inconsistency in data targets.

Study and analysis of cross transporting.

Ensuring integration testing of data from various sources

Documentation in the area of change management.

Ticketing, which include investigation of error or any change request

Documentation in the area of change management.

Ticketing, which include investigation of error or any change request

Played Quality Team Lead role to maintain the version control for the deployed code in production.

Delivered the work items through the Software Quality Assurance process on time without any slippages.

Providing Production data load support

Publishing key data stored in BI through BI Web reporting

Project Experience #12

Employer: SATYAM COMPUTER SERVICES LIMITED MAR 2006 – MAY 2006

Project: CBPM (CORE BUSINESS PROCESS MANAGEMENT) – PROCESS MODELING

Roles and Responsibilities

Bridge the IT-Business gaps, by developing Enterprise Architecture Models viz. Business Process, Business Rules, System Interface for various application systems thereby leading to Integration.

Identify and depict the core purpose of an application system as a process model. Further drill-down of these high level models to individual processes.

Depict the Business Rules of an application system in a model with useful information like Error messages, Field/ Form level validation etc

Implement Sales and Inventory Reports for US & European Region

Analyzed Business Objects Templates, Query and Reports and identified the gaps in the business requirements and functional needs.

Designed the data migration steps from database to universe

Involved in business meetings and discussions to examine the requirements.

Conduct weekly status meetings

Solving the tickets raised by the users within the SLA Periods.

Providing daily Production Support from Offshore (Approximately 60 Daily Loads)

Resolving critical production failures & informing the client with reason & how it was rectified.

Maintaining the Log sheets updated on a daily and weekly basis.

Analysis of load performance issues and suggesting a solution to improve performance of loads and report.

Monitoring daily and weekly running chains and resolving the issues.

Testing of all developed solutions

Re-initialization of business area in case of inconsistency in data targets.

Worked on Dashboard reporting using Portal and BOE snapshot reports.

Involved in transports of Info objects, Info cubes, ODS objects, Queries from Development to Quality Servers.

Education

Bachelor of Engineering in Electronics and Communication AUG 2001 - APR 2005

Anna University Chennai, INDIA

Contact this candidate