Professional Summary

Around *.*+ Years of experience as SAP BI Consultant in the field of Enterprise Applications (SAP) implementation support and Quality Assurance projects as in varied domains.

Involved in gathering functional requirements and Business Analysis by understanding the business landscape, through facilitated group sessions.

Includes preparation of Functional Documents, GAP analysis, UTP.

Major role as off shore coordinator in maintaining good rapport with the clients and responsible for organizing status meetings, client meetings, KNT and training sessions.

RACE Award Winner for Team Project and Star Performer as Individual for DR Projects.

ISTQB Certified Tester Level 2011

SAP BI Skill set:

BI Operations - Hands-on experience in areas of Data Loading (Full/Delta), Scheduling, Monitoring, working with Master Data, Transaction Data and Hierarchies.

Modeling - Experienced with creation and maintenance of Data Source, Info Package, Info Objects, DSO's, Info Cubes, DTP's and MultiProviders according to the reporting requirements and also monitored authorizations for key Queries.

Enhancement and Extraction - Enhancements of Data Source and Data extraction from R/3 systems (LO) as well as non R/3 systems such as Flat Files.

Business Content - Involved in evaluating Business Content and activating appropriate Business Contents for the business solution, as per client requirement.

BEx Reporting - Sound knowledge in BEx Analyzer and Query Designer, variables, formulas, calculated and restricted key figures, structures and filtering of data.

Process Chains - Involved in developing new Process Chains and sound experience in scheduling, monitoring and handling issues of Process Chains.

Business Objects 3.1/4.0: Worked on a showoff project on Business Objects using Xcelsius. Have good exposure with Business Objects in developing Universe, Xcelsius Dashboards on SAP as source systems, and Web intelligence reports.

BW on HANA: Sound knowledge on BW on HANA concepts and newer objects in SAP BW 7.4 like Hybrid Provider, SPO, Composite provider.

Planning: Worked on Integrated Planning using RSPLAN and BPC areas related to SAP BI. Used APO tools for SCM Systems in the areas of Demand Planning, GATP and SNP.

Experience

Currently working as SAP BI Consultant for Prolifics(www.prolifics.com) from August 2011 to till date

Worked as SAP BW/BI Analyst (Core Team Member) for Musgrave Supervalu Retail Group, Dublin, Ireland from Mar 2009 - Mar 2011

Worked as Assistant Professor for IT in Leinster College, Dublin, Ireland (www.leinstercollege.ie) for Bachelor’s and Advanced Diploma in Business Information Systems from Mar 2008 - Mar 2010.

Worked as Assistant Professor in MVGR College of Engineering, India from May 2005 to Sep 2006.

Education

Pursued MS in Computing from Griffith College (www.gcd.ie), IRELAND (2006-2008).

Holds first Class B.Tech in Computer Science and Engg from JNTU, Hyderabad (2005).

Prolifics Aug 2011 to till date

Clients: McKesson, PAC Coast USA, Home Delay Supplies, Lam Research

Completed Assignments: Fixed Assets (FI), Customer Returns Blocking to Data Partners (Master Data), Pricing Reconciliation (Sales and Billing), Contract Compliance, Balance Available Reporting, Due Date Reporting Reason Codes (FI), Common Owner Integration, New NRDC Setup (IM), TCS Cost Drivers (TP&E) (MM), MFC BI Reporting Initiative (Load Chargeback Rejection IDOC Error messages to BW), Syndication Program Changes to Fix the VISTEX field Sync Issue with Private Label Item Field in BI, Enhancement Pack Landscape - Build Consolidation Environments-BQB Regression (BI, Data stage),BW/BI structures,BPC 10.1 Input Schedules and Reports for PCA,CCA and CAPEX.

Current and Upcoming Assignments:

ETL Improvisation: Retiring IW/LPAD/DPA and Migration to SAP HANA/HADOOP via IS 11.0 and SAP BW/HANA systems for McKesson, Spend Performance Management on McKesson.

Quality assurance of BPC Implementation for Lam Research

Client: McKesson

Assignment 1: FIXED ASSETS (Project Systems and Investment Management)

Roles and responsibilities:

Involved in the design, development of Multi-dimensional Data Models, Info cube, Multi providers, Operational Data Store (DSO), Aggregates, Info Objects, Data Sources, Info Sources, Info Providers, Transfer rules, Update rules, and Generic data sources.

Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction and also Enhancements.

Extensively worked on Utilizing PSA for effective loads and Error handling.

Involved in creation of reports using BEX Analyser such that the execution time is evenly distributed throughout the report by using Free characteristics, RKF’s, CKF’s, Variables, Exceptions, Navigational Attributes, Text Variables, Filters, Structures and Conditions.

Improved performance by using SE38 for executing programs to resolve the problems on global settings, indexes and design of Info Cube.

Resolved validation issues independently of ABAP related to BI using Debugging Concepts.

Assignment 2: Mckesson Pharma Systems and Automation

Roles and responsibilities:

Worked on Data Source enhancements for SD, GL extractors.

Developed Generic extractors through Function Modules.

Developed code for Start, Field level, End Routines at transformation level and at Info package/DTPs.

Expertise to debug the code in various BW objects like Transformations, DTPs, Customer exits, Data Sources.

Experience in using Information design tool (IDT), to create universes using multiple Data Sources.

Created connections to BEx queries and BW Info providers using Business Intelligence Consumer Services (BICS) in IDT.

Assignment 3: Differential Pricing

Roles and responsibilities:

Created HANA modelling scenarios and activities such as adding a system, creating schemas.

Involved in designing information objects like Attribute views, Analytical views and Calculation views.

Manages data provisioning, migration and cleansing from legacy to target system using BODS.

Monitoring and troubleshooting data loads.

Modifying the Existing Technical Documentation for various models.

Worked on Flat file extraction and reporting tools using HANA.

Migrating standard Info cubes to Inmemory optimized Info cubes.

Migrating standard DSO’s to In-memory optimized DSOs.

Importing the BW Models in to HANA using HANA Studio.

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

Assignment 4: BW/BI Structures

Roles and responsibilities

Participates and provides critical feedback during preparation of requirements, functional and technical specifications.

Experience in writing/enhancing of Test Plan, Test Strategy specifying the system’s inputs, outputs, limitations, entry and exit criteria etc.

Experience in identifying and escalating system or business issues and any concerns.

Delivering test services to the program including test planning, specification, development, execution, and defect management activities.

Proficient in using Quality Center for Test Planning, Requirements Management and Defect Reporting and Tracking.

Expertise in analyzing Business/ System Requirements documents and Use Cases.

Experience in different kinds of tests such as functionality, positive, negative, smoke, integration, user acceptance, performance, regression, load, security, installation etc.

SAP testing including best practices for test documentation, test tools, and test approach.

Experience in managing unit, system, and regression testing on multiple projects, as well as providing support for end-to-end user acceptance testing.

Client: PAC Coast USA

Assignment 1: Upgradation BI 7.0, Maintenance and Support

Roles and responsibilities:

Involved in Load Monitoring and Process Chain Monitoring using RSPC, SM37, and RSMO.

Providing Daily Production Support from Offshore and quickly responded to alerts.

Loaded Master/Transaction data from SAP R/3 system and non-SAP systems into BW.

Resolved TRFC stuck up using SM50, SM58 and SAP Notes.

Involved in escalating high-prioritized tickets regarding extractions and load failures.

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

Interaction with client during weekly Schedule meetings.

Involved in submitting the Ticket Status (Open/Close) report, test cases, and system tests.

Maintain Work History Documentation and Screenshots for all the tickets.

Worked with BEx Analyzer to generate Queries and embedding them into workbooks.

Involved in Transporting the BW objects from development to Quality server and Production server following request priority for independent and dependent objects.

Musgrave Supervalu Retail, Ireland Mar 2010 to Mar 2011

Assignment 1: Implementation,Reporting Support and Process chain Administration

Roles and Responsibilities:

Created Data Sources for existing business process with RSDS Tcode.

Created Objects like Info Objects, Info Cube, DSO, and MultiProviders.

Created DTPs and used Formula, Conversion Routines in Transformation for Info Objects.

Modification of Info Source, Transfer Rules and Update rules with new Info Object and loading data to DSO and Info Cubes.

Extracted data from R/3 system by giving selection criteria's for the specific fields in IP.

Designed Process Chains using transaction RSPC as per client's requirement.

Testing of entire architecture as per specifications including IP's, DSO's, Info Cubes, Info Objects, DTP's, Transformation Formula's/Conversion routines, Process Chains and Function modules such that the data is loaded to Data targets.

Worked in development of Business Objects XI 3.1 including Designer, Desktop Intelligence, Web Intelligence, and Info view, Import & Publishing Wizard, QAWS, Xcelsius 2008, Report Conversion Tool, Query Builder and Webi Rich Client.

Report Creation using BO functionalities like Combined Queries, Slice and Dice, Drill Down, @Functions, Cross Tab, Master.

Mar 2009 to Mar 2010

Assignment 2: KPI Reports on Warehouse Management and Store Operations

Roles and Responsibilities:

Extensively worked on G.O.L.D for demand forecasting, merchandise management, store operations and supply chain management to reduce costs, increase efficiency and improve margin.

Data Migration from HHT Devices to G.O.L.D for Analysis and Reporting.

Created KPI Reports for Warehouse Management using IBM Cognos.

Scheduling Data Loads in SAP to get data from G.O.L.D for Order Management.

Lienster College, Dublin, Ireland Mar 2008 to Mar 2009

To teach at undergraduate and graduate level in areas allocated by the Head of Department and reviewed from time to time by the Head of Department.

To assist in the development of learning materials, preparing schemes of work and maintaining records to monitor student progress, achievement and attendance.

To participate in departmental and faculty seminars aimed at sharing research outcomes and building interdisciplinary collaboration within and outside the department.

MVGR College of Engineering, India May 2005 to Sep 2006

To participate in the development, administration and marking of exams and other assessments.

To contribute for development, planning and implementation of a high quality curriculum.

Corporate Trainings

oSAP BW, BI, SD, FI, MM, Data Stage

oSQL, Business Objects Reporting

oSAP HANA and SAP BODS,

oKnowledge Management Tool HP QC, Testing tools

oBusiness Planning and Consolidation

Memberships

oActive member of GCD's Alumni Body representing India.2007-2010 (www.gcd.ie/alumni)

oActive member of City and Guilds Smart screen, London, UK for Department of IT 2008-2011(www.smartscreen.co.uk) (www.cityandguilds.com)

oTeam Member, Assessment Panel for Exam Cell, ABE (www.abeuk.com) and City & Guilds

Notes

oCan start Immediately

oWilling to Relocate/Travel

oHave a valid visa as Permanent Resident card to work in Canada

References

Santosh Kumar Gade

SAP Application Developer

Sobeys

Stellarton, Nova Scotia

Canada

actjkb@r.postjobfree.com

Mobile: +1-416-***-****

Rajsekhar Raju Vetukuri

Systems Integration Developer

CGI

1350 René-Lévesque Boulevard West

Montreal, QC H3G 1T4

Canada

actjkb@r.postjobfree.com

EMP ID: T097520

Mobile +1-416-***-****

Office: 514-***-*****1012173

Madhavi Reddy Basani

SAP Techo Functional Consultant

SV&T Release Test Manager (Offshore)

Prolifics, India

actjkb@r.postjobfree.com

actjkb@r.postjobfree.com

91-40-399***** (O)

91-800******* (M)

Prasad Rao Boddepalli

SAP BI Consultant

SV&T Release Manager

McKesson Corporation

1Post Street

San Francisco, CA

United States

actjkb@r.postjobfree.com

Mobile: +1-925-***-****

Land: +1-614-***-****

Contact this candidate