SAP BW Consultant

Madhu Kodavanty

Ph: 734-***-****

Email: *********@*****.***

Experience Summary

Over 11 years of experience in information management and development with focus on Business Intelligence and Data warehousing using SAP

Technologies. Expert in Project Management, Business Consulting, Business Analysis, Metadata Management, Reporting and Dashboards with SAP

HANA, SAP BW and SAP Business Objects product suites.

SAP BW Experience

• Successfully implemented 4 End to End HANA projects.

• Successfully implemented 11+ End to End Full BW Implementations.

Expertise in translating business requirements from Power Plant, SCM (Material Management, Warehouse Management, Purchasing,

•

Inventory Management), EAM (Plant Maintenance, Quality Management, Project Systems, SD(Sales, Deliveries, Billing), Finance into

technical implementations supported by sound data models.

Experience working in Utilities and Oil & Gas domains.

•

• Extensively worked on new features on BW 7.3 like new run time options to load only unique records, “Reading directly from DSO Rules,

Remodeling of DSO’s, setting up NLS parameters in Query Designer etc.

• Expertise in creating process chains, Meta chains, Scheduling Start Process, monitoring process chains etc.

• Hands on experience in BW reporting using BEx Query designer & BEx Analyzer using which Created Structures, Calculated key

figures, Restricted key figures, Customer exits, Formulas, Selections, exception and conditions.

Performance tuning of BEx queries using Indexes, aggregates, Cube compression and partitioning.

•

• Expertise in LO (SD, MM, WM), FI and Generic data extraction mechanisms.

• Expertise in creation of BEx Analyzer Queries, Workbooks, structures, variables, calculated key figures, restricted key figures, and RRI

reporting, Ad Hoc Queries.

• Expertise on creating APD’s (Analysis Process Design) for complex scenarios.

• Expertise in Process Chain Creation and monitoring.

• Extensively Worked on the BW Archiving(NLS)

Prepared training documentation for the End Users on BW Report Usages.

•

Conducted training for end users and provide technical directions to associate developers and contractors.

•

Experienced working on Onsite Offshore Delivery Model.

•

Have created OSS Messages for solution resolutions.

•

• Having an excellent presentation, communication and interpersonal skills.

SAP HANA Experience

• Profound knowledge of HANA Architecture.

• Expertise in HANA Data Provisioning with both Data Services and SLT.

• Expertise in creation of Attribute, Analytic and Calculation Views.

• Expertise in Export/Import on objects in HANA.

• Expertise in Creation of Stored Procedures in SQL.

• Expertise in HANA Security Maintaining Users and Authorizations, Analytic Privileges.

• Expertise in SAP HANA SLT.

• Expertise in FI Standard Accelerators.

SAP BW on HANA Experience

• Profound knowledge of BW on HANA Architecture.

• Adept in optimizing BW Objects DSO’s/Info cubes/Planning objects.

• Experience on analysis of optimized objects.

• Experience on resolving various issues during Optimization.

SAP BW Upgrade Experience

• Experience on BW upgrade from BI 7.0 to BW 7.3.

• Involved in the Pre Upgrade Activities

• Running of Reports for activation of all the Objects.

• Running RSRV for the Consistency Check for Master and Transactional Data.

• Running the Report RSUPGRCHECK Report for Checking the Consistency Check.

• Alpha Conversion Check.

• Experience on Post Upgrade activities.

SAP Business Objects

• Good Understanding of SAP BI integration with BO.

Expertise in SAP Business objects Universes creation and modification with UDT and IDT.

•

Expertise in Web Intelligence reports creation.

•

• Experience on Qaaws, BICS functionalities for Xcelsius dashboards.

• Expertise in Business Objects Explorer.

• Expertise in Lumira.

SAP Data Services:

• Good Understanding of Data Services Architecture.

Expertise in jobs, workflows and data flows.

•

• Expertise in various transforms.

Expertise in object migration from DEV QA PRD.

•

Project Management Skills

• Demonstrated proven project and team leadership qualities through several cross functional SAP project implementations.

• Have acquired tremendous experience on a worldwide corporate platform from both a business and technology perspective.

• Have achieved success through my ability to cultivate business relationships in an organization and communicating effectively

throughout all stages of a project.

• The core of my professional focus has been on application project lifecycle management in a team environment, collaborating with both

clients and consulting partners to achieve business initiatives.

• Applied and implemented ASAP methodologies (Project Preparation, Business Blueprint phase, and realization, Final Preparation, Go live

and Support).

• Proven abilities in handling account management activities SOW, MSA of critical accounts, building client relationships, vendor

management, and delivery related activities. Major areas of expertise include the following:

Account/Engagement Management Vendor Management

Strategic Planning and Execution Pre Sales Support, Customer Mining

Budgetary Planning & Control Outsourcing & Managed Services

Team Development & Leadership Grooming Business Consulting

Billing, Invoicing, SOW, MSA, Contract Management and Process & Procedures Re engineering

Renewal. Off shoring Assessment and Implementation

Negotiating new billing rates during new and contract Six Sigma methods.

extensions.

Technical Skills

SAP R/3 V 4.7, ECC 6.0.

ERP

BW 3.5, BI 7.0, BI 7.3, HANA 1.0 SP4.

Data warehouses

Languages C, C++, Java and ABAP/4.

Reporting Tools BEx, WAD,UDT, IDT, Webi, XCelsius.

Operating Systems UNIX, Windows XP, Windows NT, Windows2000, Windows 98, DOS.

PL/SQL, Oracle 8i, HANA.

Databases

Conceptual Knowledge ALE, IDOC, RFC, BAPI.

User interface OLAP, Visual Basic, SAP UI5.

Domain Knowledge SD, MM, FI, CO, CRM, HCM.

Internet Technologies HTML, JSP.

Archiving Technologies NLS.

Testing Tools HP Quality Center, HP ALM

Office utilities MS Office, MS Excel, MS Visio, MS Power Point.

Project Management Tools IPM+, MS Project Plan

ITIL Tools Service Now, Remedy, Star Team, Solution Manager

SAP Business Objects Data Services 4.0

ETL Tools

Academic Qualification

• Masters in Software Engineering from Illinois Institute of Technology, USA

• BTech in Computer Science from JNTU, India

Certifications

• HANA Application Associate Certification

• J2EE Certification

Professional Experience

Employer: Infosys Technologies (US) Sep 2010 Till date

Role: SAP HANA Architect/Principal Consultant

Client: Southern California Edison

Environment: SAP BI 7.3, ECC 6.0, GRC 10.0, BO 4.1, and SAP HANA SPS6.

Projects:

BAM CCM: This project is to provide the reporting solution for all the change management data that resides in the REMEDY change management

tool. We are developing a data warehouse layer in HANA to stage the Remedy data and report out the data to end users through SAP Business

Objects Lumira. All the sensitive auth roles are taken care in HANA Analytic Privileges.

SCE.com: This project is to provide a reporting solution though SAP Business Objects through Lumira by developing the HANA modeling layer to

stage all the SCE.com portal transaction data from the IBM Commerce and LDAP databases. Data Services is used as the ETL tool for extracting the

data and staging in the HANA models.

POLAR: This project is to provide reporting on details of all the poles installed and the related notification details for status tracking. Have

developed custom DSO’s and HANA views and exposed the data through Odata Services for the SAP Process Orchestration reporting.

SCASE: This project is to provide reporting over all the unique documents stored in a custom tool called SCASE. Have developed the HANA views

exposed data through Webi Reporting to provide the necessary information to the clients.

Corporate Medical Services: This project is to provide reporting over various Medical and disability information of the employees. Have developed

custom DSO’s and HANA views and exposed the data through Virtual provider back to SAP BW for reporting.

Environment Health and Safety: This project is to provide the custom reporting for the Health and Safety factors within the client . Have activated

standard business content, customized DSO’s and created Webi reports for the same.

FI SLT: Successfully implemented the FI standard accelerators for Finance and Controlling areas to provide accelerated response and real time

reporting.

NLS: Successfully implemented the archival of FI and HCM domain BW objects.

BW Migration: Successfully implemented the BW migration from BW 7.0 to BW 7.3 and HANA upgrade.

GRC NERC CIP: Successfully implemented the NERC CIP Compliancy reporting which provides the details on the roles, accesses and the role

provisioning through the Webi reports and Dashboards.

CRM: Successfully implemented the end to end CRM reporting for all the CRM areas like Campaign Management, Service Contracts, Service

Confirmations, Leads, and Opportunities etc.

Responsibilities:

• Performed project management duties involving resource management, time management, effort estimates and the Project Plan. Also

responsible for the project end to end design/implementation and delivery.

• Responsible for the end to end delivery of multiple projects.

• Interacted with stake holders, Business users, functional and technical teams to understand and gather the business requirements for

preparing functional and technical design specification documents.

• Developed the process flows and use cases as per the business requirements.

• Responsible for trouble shooting problems and providing solutions for a successful project delivery.

• Participate in project reviews, design and Code reviews and provided solutions wherever needed to fine tune the issues.

• Developed and implemented complex Script based Calculation View and stored procedures.

• Developed Odata Services to expose the HANA data to SAP Process Orchestration.

• Implemented near real time data load for reporting through Stored Procedure logics.

• Developed and implemented the technical design to consume the existing BW DSO data through SAP HANA views in HANA Studio and

then exposing them to Business Objects for reporting for multiple projects.

• Responsible for the SLT implementation for the Finance Month End Processing.

• Worked along with the Security Team in Role Identification/Creation and Role Assignment.

• Developed Universes to support the Webi Reports and XCelsius Dashboard for various projects.

• Worked on Business Explorer to create Information Space for the Business to explore the data to perform adhoc data analysis.

• Conducted User Training for various BI Tools and developed training documentation.

Employer: East America Corp (US)

Client: ADP May 2010 – Sep 2010

Role: SAP BW/BO Lead

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Co ordination multiple teams at onsite (BASIS, Infrastructure, Data Center etc.) as per defined RACI matrix for the project

• Liaise with the customer for Release management

• Participate in project reviews, design and Code reviews

• Participate in knowledge management activities across project teams

• Gathered reporting requirements for FSCD and BCA modules and developed functional design document.

• Interacted with development and testing teams to ensure correct execution of the project.

• Monitoring of Info packages, PSA Deletion and Setting up of Quality Server for Unit Testing.

• Involved in Integration, Regression testing, production support activities.

Employer: Direct Relief International

Client: Direct Relief International Dec 2007 – Jun 2009

Role: SAP BW/BI Lead

Environment: SAP BI 7.0, SAP ECC 6.0

Responsibilities:

• Responsible for requirement gathering and Fit Gap Analysis.

• Involved in mapping the SAP ECC logistics Data Extraction from Data Source using LO Cockpit Extractor to upload the

master/transaction data into Info cubes.

• Developed generic extractors, Data Sources, Info Sources for Data extraction, transformation and loading from SAP R/3 system to SAP

BW.

• Extensively worked on test script creation, Integration and Regression testing.

• Extensively worked on creating Webi reports for FI, SD and MM modules.

Employer: Suphala IT Pvt Ltd. Jun 2006 – Sep 2007

Client: PDL Pharma’s, Mentor Graphics

Role: Sr. SAP BW/BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SEM 3.1, CRM 3.0

Responsibilities:

• Gathered reporting requirements and designed the data flow from SAP R/3 to BW for specific functional areas like, FI CO, SD, MM and

QM.

• Involved in creation of Data Sources, Info Sources for Data extraction, transformation and loading from SAP R/3 system to SAP BW.

• Improved the Query Response time by reorganizing the Dimensions & providing Line Item dimensions.

• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit

by using enhancements and writing User Exit programs as per requirements.

• Developed various reports like Aged Inventory Report, Days of Supply report, Safety Stock Days of Supply reports.

• Worked on performance tuning of queries by maintaining Aggregates, Compression and Partition of info cubes.

• Involved in production support activities like data load monitoring and issue resolutions.

Employer: Four Soft Info Systems Aug 2003 – Apr 2006

Client: Cadila healthcare, MNC Financials

Role: BI Consultant

Environment: Business Objects XI, Crystal XCelsius, Oracle

Responsibilities:

• Gathered reporting requirements for finance and SD domains.

• Involved in creating and maintaining Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi Providers, Info Sources,

Data Sources, and Info Packages.

• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit

by using enhancements and writing User Exit programs as per requirements.

• Worked on the design and development of the BO Universe.

• Worked on SD and FI rapid marts.

• Created queries and generated reports on the universe using Crystal reports.

• Developed dashboards using XCelsius.

Contact this candidate