Data Sap

Vishall Pradeep K S

[pic]

. Senior SAP NetWeaver Development consultant with broad experience from

development of system prototypes to integrated enterprise-wide SAP

implementations; proven expertise through 4 implementation projects from

blue print to Go-Live.

. Around 6 years of Industry experience in SAP supporting clients running

in different sectors, provided solution for the complex business

requirements mapped in SD, MM, FI and CO using ABAP, SAP NetWeaver BI, BO

and BO Mobile.

. Successfully performed various roles such as onsite coordinator, project

lead, consultant, mentor, trainer and developer.

. Worked as BI Team Lead and Onsite Project Coordinator for a Middle East

Rollout Implementation, BI Stabilization project.

. Experienced in providing custom business solutions in SD, MM, FI and CRM

modules.

. Managed a team up to 10 consultants in various projects including onsite

assignments, onsite-offshore co-ordination and offshore developments.

Vast experience in handling various issues in areas of SD, MM, FI, CO and

APO and provided optimal business solutions.

[pic]

. Proficient in analyzing, developing and implementing SAP BW systems.

. Involved in BW upgrade planning from 3.x to BI 2004s.

. Worked extensively on DB Connect to Load data from Oracle database and

SQL DB.

. Good understanding of ETL Tool Informatica to validate data.

. Excellent knowledge of SAP BW components like InfoCube, Multiprovider,

InfoSource, InfoObject, Data Store object, Installing Business

content, Technical content and Transformation.

. Expertise in Generic Extractors, User Exits, Data Loading (Full /Delta

Up-Load), Scheduling, Monitoring, Process Chains, MultiCube, Remote

Cubes.

. Extensive knowledge in Data Modeling, Data Extraction and Data Staging

using LO Cockpit/ Info-structures.

. Extensive knowledge on Roles and Custom defined Authorization Objects.

. Evaluated statistical performance and suggested recommendations to

basis support for optimization. Improved data load and query

performance by doing compression, aggregates, partitioning.

. Expertise in Report Generation - Worked extensively in BEX Analyzer in

building Queries and saving in Workbooks (Excel work Sheets) and

created Custom Queries using Conditions, Exceptions, Variables &

Structures and created aggregates for frequently used queries, RRI -

Jump queries, Web Application Designing (WAD), Crystal Reports and

Trained End-users.

. Working experience with Integration of BEx Query with Business Objects

. Experience in designing complex reports based on discussions with user

groups and created various objects using built-in @functions (like

@prompt, @select, @where, @aggregate aware), complex SQL queries and

joins.

. Experienced in created Universes by employing various techniques

including loop detection, prompts, conditions, classes, objects,

dimensions, measures and details, joins, cardinality, keys, data

integrity, LOVs (list of values), aliases, derived tables, multiple

contexts and hierarchies.

. Worked extensively on web application designer and portal content.

. Extensive experience in implementing programs for MM, SD, FI and

Purchasing modules.

. Worked on CO-PA and generated Data Sources on the basis of Operating

Concern.

. Worked extensively in the following areas:

ABAP/4 Reports . Dialog Programs . SAP Script . Smartforms

. Extensive experience in analyzing business processes and creating

technical specifications, coordinating and reviewing the performance.

. Interacted closely with the users and Business Analysts to define the new

business process requirements.

[pic]

ERP : SAP R/3 5.0, 6.0.

Data Warehousing : SAP BW 3.5, BI 7.0/7.3.

APO : SAP SCM 4.10 & 5.10.

SAP Tools : ALV, BAPI, BADI, Smart Forms, ALE/EDI IDOCS,

User exits.

SAP Modules : SD, MM, PP, PM, QM & FI/CO, CRM 5.0.

Languages : ABAP/4, SQL.

[pic]

. Bachelors in Electronics and Communication Engineering, Anna University,

Chennai, India.

[pic]

Client : Discount Tire Corporation

Feb 2013 - Till date

Role : Sr. SAP BW Consultant

Module : SAP SD, MM & FICO

Environment : BI 7.3, ECC 6.0

Responsibilities:

. Analyzed business rules, to determine data requirements, source systems

and data transformation strategies.

. Responsible for logical/physical data models for source and targets to

satisfy the requirements.

. Responsible for the mapping definitions defining the rules for mapping

data from sources to the target Data Warehouse.

. Responsible for designing Interfaces, Functional and Technical

Specification documents.

. Provided technical leadership and mentoring to a data management team

developing a Data Warehouse.

. Analyzed the POSDM DataSources and enhanced it via BAdi.

. Enhanced the Article and Site master data.

. Created an APD application to send data from a BW Multiprovider

(0FILG_M30) as a text file to a folder in the application layer. It

involved ABAP routine and formula.

. Created a Generic DataSource using Table/View option for a custom table

using the timestamp field and loaded the same into a write optimized DSO.

. Created a custom query for the APD process to pull data from the cube and

used the query as source in APD.

. Created write optimized DSO's, standard DSO's, end routine and process

chains.

Client : IBCS Trading Corporation, Cyprus/Sharjah

Oct 2012 - Jan 2013

Role : Sr. SAP BW Consultant

Module : SAP SD, MM

Environment : BI 7.0, ECC 6.0, Business Objects BOXI 4.0

Responsibilities:

. Installation and configuration of Business Objects Mobile on the BO XI3

server.

. Configuring Business Objects Mobile client application.

. Configuring the device with necessary parameters to access Business

Objects Enterprise Server.

. Customizing parameters in Business Objects Mobile to access local and

server documents.

. Designing custom BO mobile dashboards for access from IPad.

Client : IBCS Trading Corporation, Cyprus/Sharjah

Aug 2012 - Jan 2013

Role : BI Team lead

Module : SAP SD, MM

Environment : BI 7.0, ECC 6.0, Business Objects BOXI 4.0

Responsibilities:

. Involved from the blueprint discussion and designed the layout based on

the business requirement.

. Installed standard cubes and its related objects from business content

and loaded the master data and transactional data.

. Developed a custom DataStore Object, InfoCube and Multiprovider which

displays sales data

. Loaded the setup tables for SD and MM related DataSources.

. Worked extensively with Inventory cube 0IC_C03 with marker and no marker

update compression.

. Loaded the historical and current data into Inventory cube by setting up

marker and no marker update.

. Used Delta Update mechanisms for uploading the data / delta records to BW

from R/3 in specific intervals.

. Handled flat file loading from application server to the InfoProviders.

. Created program to trigger the process chain via event.

. Created customer exit variable in report to display messages and

manipulate values.

. Created generic extractors, customized tables and the programs for flat

file loading.

. Designed BEx Reports providing insight of Business Intelligence for

Business Analyst for Decision making using Structures, Formulas,

Selections Calculated Key Figure, Restricted Key Figure and Variables.

. Created a Report to Report Interface (RRI) for showing the sales data in

region wise.

. Used APD to make the In-market report as DataSource and combine values of

the report to the DSO.

. Developing the Master/Transactional data process chains considering the

dependency among the BW objects and automated the triggering and

monitoring of the same on daily, weekly and monthly basis.

. Involved in designing of daily, weekly, monthly data loads using process

chains.

. Created Authorization object and roles for the end users and developers

using the object S_R_COMP, S_RS_COMP1, RSECADMIN (Analysis

Authorization).

. BEx Query has broadcasted through email via BEx Broadcaster.

. Created WebI reports out of sap BEx queries, published reports and

migrated to Quality and Production environments.

. Used BICS connectivity for X-Celsius dashboards.

. Created prompts for WebI reports using @prompt functions.

. Extensively used various components including Gauges, Scorecards, Charts

(Pie, Bar, Column, Line, Combination charts, Maps and other selection

boxes) which best suit for the analysis.

. Made use of alerts in gauges, charts, scorecards and maps with dynamic

band ranges which varies with selection made by other components. (what-

if-analysis)

. Developed Pop-up windows, alerts like traffic light, multi colored line

charts (actual in one color and the budget in another from the month

where actual ends), User instructions displayed as a dialogue window by

hovering on the respective windows help.

. Created end user training to the report users.

. Involved in transport activities like the TP's collection release and

import of BW objects from development till production.

. Involved in the post go-live support for the project in fixing the issues

and requirement gathering.

Client : Mosaic, FL

Apr 2011 - Jul 2012

Role : SAP BW/BI Team Lead - Implementation & Upgrade BI 7 & ECC 6.0

Module : SAP SD, MM, QM & FI

Environment : SAP BI 7.0, SAP ECC 6.0, Bex Analyzer, Business Objects

XI R2 products: Designer 11, Webi XIr2

Responsibilities:

. Upgraded BI 3X to BI 7.0 SPS -10.

. SAP BI 3X TO NW 2004s (BI-70) Upgrade: Strategy Plan, Prepare, upgrade &

post upgrade maintenance.

. Involved in pre activities of BI 7.0 upgrade & creating process flow

(Converting data classes of Infocube, Checking inconsistency of

InfoObjects, Migrating of info package group etc).

. Excellent experience with post activities after upgrade (switching over

to new standard templates, actions for data warehouse scenario Activation

of source systems & replication of Data source etc).

. Designed & Executed detailed project plan, for NW 2004s.

. Involved in APO Demand Planning while creating Data source based on

planning area and bring the data to the BW for generating forecast

reports.

. Involved in customizing the FI-AR and AP Data sources and enhanced

several fields according to Users requirements.

. Heavily Involved in Data warehouse design reviews for other modules and

suggested effective ideas.

. Worked extensively on custom data sources and custom cubes to meet the

client's requirements.

. Worked on Billing Details for sales orders reports based on Billing Date

and Material.

. Worked on DTP, Error DTP, Standard DSO, Bex Queries, Migrated

DataSources, Emulated DataSources, Transformations, Variables, Calculated

Key Figures, Write Optimized DSO, Reference IO and Debugging tool in DTP.

. Worked extensively on LO Cockpit extractions for SD and MM. Loaded the

data from R/3 to BW and used Initialization with delta update and full

update methods.

. Extensively worked on Open Hubs for transferring Business data to analyze

in another business process.

. Created the Process Chains for the Custom cubes, for loading master data

and Transactional data which is used for the daily loads.

. Worked extensively on Bex Analyzer (RRMX) and created queries using BW

Reporting Variables, Navigational Attributes and Filters. Developed

workbooks and used RRI Jump Queries to drill down to other queries.

. Involved in Creating the Variable exists for the Various Reporting

Requirements.

. Extensively used calculated and Restricted Key Figures, Restricted

Characteristics, Structures, variables and conditions for the queries.

. Worked on WAD to deploy Queries into Portal. Worked on several Web Items

in WAD i.e. Command Wizard, table Graph, Tab, Text Elements, containers,

Drop Down Boxes etc. Implemented Dependant Dropdown box values using

Command Wizard.

. Developed and analyzed the preparation of standard query structure in BEx

Query Designer to be used in the Business Objects.

Client : Newell Rubbermaid - Atlanta, Georgia

Jan 2011 - Till date

Role : Sr. SAP BW Consultant

Project Description/Scope: APO Process Chain Monitoring [Weekend Support]

. To monitor the scheduled APO jobs on weekends, to fix the tickets and

critical errors

Responsibilities:

. Provided solution for various process chain failures in APO production.

. Worked on RSPC, RSA1, SM37 and SP01.

. Monitoring Process chains, Change pointers, repeating the failed steps,

restarting the error background jobs.

Client : Sudarsan Chemical Industries Limited, Pune, India

May 2010 - Mar 2011

Role : Sr. SAP BW Consultant

Module : SAP SD, MM

Environment : ECC 6.0, SAP BW 7.0

Responsibilities:

. Involved in creating the HLD for functional spec.

. Involved in design and implement the cut-over plan.

. Involved in design and implement the deployment plans (go live and roll

out).

. Involved in estimation and efforts.

. Involved in requirement analysis and intake check to identify open

issues.

. Execute the effective Knowledge transfer to production and support.

. Involved in perform design workshop with the developers.

. Involved in preparation and test cases and test plan.

. Involved in peer reviews and execute peer unit test.

. Design and Implement a cut-over plan.

. Design and Implement a deployment plan for go-live.

. Developed Custom Aggregation Levels, Filters, Planning Functions and

Planning Sequences for various applications which handles different

version.

. Created Process Chains to automate the data load and data target

administration and monitored the processes.

. Developed formula type planning functions to derive Versions

. Post Production support, which involves daily monitoring of data loads

via process chains, trouble shooting and correcting the known errors and

escalating the unknown to the SAP support team.

. Created queries based on calendar day, week, month, and year to obtain a

variety of reports for Sales reports (Returns as per customer and month,

fulfillment rates, and comparison between orders and returns), queries

contained restricted and calculated key figures, filters, and condition.

. Actively involved in resolving of load failures like master data and

transaction loads and monitoring the data loads from various systems like

R/3 and flat file.

. Involved in DataSource enhancement.

. Attribute change run and overall improvement in data load performance and

worked extensively on Administration as well as data warehousing

workbench.

. Extensively worked on utilizing PSA for error handling.

. Involved in developing various routines and modify the routines as per

business requirement.

Client : Sony Pictures Entertainment

Nov 2009 - April 2010

Role : SAP BW Technical Consultant

Module : SAP SD, MM.

Environment : BW 3.5, ECC 5.0

Responsibilities:

. Interacted with the management and business End-users to identify

business requirements.

. Involved in Modeling, Extraction and Reporting.

. Activated the Business Content for Inventory Management data that

includes 0IC_C03, Update Rules, Transfer Rules, Basic InfoObjects and

Queries.

. Implemented Snapshot scenario for displaying Historical stock balances

on a monthly level of all materials.

. Enhanced the R/3 Data Source for obtaining Net value, Gross value and

Budget value.

. Activated R/3 Data sources like 2LIS_03_BX, 2LIS_03_BF, and 2LIS_03_UM.

. Customized LO Setting for Inventory application that includes maintaining

extract structure, Maintaining data source, Deleting setup tables,

Filling setup tables and for queued delta.

. Taking care of Transportation activities within the client landscape.

. Created the Process Chains which is used for daily uploads.

. Involved with performance tuning of Queries by maintaining Aggregates,

Compression, partition and indexing of InfoCubes.

. Worked extensively on BEx Analyzer. Created queries using BW-Reporting

Variables, Navigational attributes and filters. Developed several queries

and workbooks using BEx Analyzer according to end users requirement.

. Prepared user Training Manuals and conducted end-user training before

going live.

. Transported Info Objects, Info Cubes, Queries, and update rules,

Multi cubes from Development to Quality.

Client : Kansai Nerolac Paints - Jaipur, India.

Oct 2008 - Sep 2009

Role : SAP BW/ABAP Information Analyst

Module : SAP CRM

Environment : SAP CRM 5.0

Responsibilities:

. Developed a DataStore Object which has Dealers and Potential along with

unique number as a primary key.

. Developed a Custom InfoCube as a CRM Mapping InfoCube which consists of

an Dealer and Competitors as its Dimensions

. Developed a Report for displaying Potential summary and detailed report

which displays the total number of prospects, total number of prospects

potential and total number of opened prospects.

. Developed a Company Dealing company report which displays number of

dealers and dealers sale.

. Developed a CCD details report which displays total number of CCD

prospects and CCD counters and total counter sale.

. Validated all the variables, formulas, text variables, restricted and

calculated key figures, custom exits.

. Included the newly created DTPs in the Process Chain for that automatic

scheduling of data loads.

. Analyzed the CRM Questionnaire fields and created a custom DataSource

using a function module which handles delta extraction.

. Created Unit test Case documents for the developed objects.

. Collected the object to create CR to move by using transport connection.

. Prepared technical documentation as per deliverables and Interacted with

users for gathering information on reporting requirements.

. Created Process chains for master data and transaction data loads.

. Involved in creation of reports using Query Designer such that by using

Conditions, Exceptions, Free Characteristics, Restricted Key figures,

calculated key figures, user entry Input Variable and formula Variables.

Client : IT / ITES - Technopark, India

Apr 2008 - Sep 2008

Role : SAP BW/ABAP Trainee

Module : MM, SD

Environment : SAP ECC 5.0, SAP BW 7.0

Responsibilities:

. Creation of Technical specifications based on Functional specifications.

. Technologies used: ABAP, BI.

. R&D for the developments.

. Handling remote demo for customers.

Executive Summary

Technical Summary

Technical Skills

Educational Qualification

Project

Contact this candidate