K Vishnuvardhan +1-210-***-****

SAP – BW BO & HANA Consultant acqycg@r.postjobfree.com

Has 10.6 years of experience in software industry working on various technologies such as SAP BI/BW 7.4, 7.3, 7.0, 3.5, BO 4.0, 4.1 & HANA.

Around 7 years of comprehensive experience in SAP BI BW & BO with Designing, Implementation, Maintenance and Support projects with various BO tools like Universe designer, IDT, Web Intelligence, Xclecius,SAP Lumira and SAP Designer Studio.

Has around 3 years of SAP HANA implementation expertise.

Working experiences of various domains such as Banking, Media, Retail and Technology as a Developer, Technical Lead and Architect involving in all phases of the project.

Working experiences on ABAP coding and debugging.

Working as Technical Lead & Architect managing the BW and HANA teams for a critical financial migration project from Legacy systems to SAP BW and HANA.

Worked in a versatile & Complex environments with different strategic partners such as Infosys, Deloitte, IBM, TCS etc in implementing the critical projects.

SAP BW& BO EXPERTISE

Worked on SAP Net Weaver 2004s BI 7.4/7.3/7.0 Implementation Projects and possess sound knowledge on the various New Concepts in BI 7.4/7.3.

Extensively Worked on Extraction, Data Modeling & Reporting. Created Semantically Partitioned Objects (SPO), Info Cubes, Data Store Objects, Info Objects, Transformations, Data Transfer Process, Data Sources, Info Packages, Multi Provider, Info Sets, Virtual providers, RDA and Open Hub Destination & Involved in BW related ABAP such as Enhancing Standard DS using BADI.

Worked in functional area’s of General Ledger, AP/FA, LO Cockpit and Generic Data Extraction Data Extraction for both Master data and Transaction data. Data extraction from ECC, CRM, Flat files, Third Party systems.

Worked with SAP AGS Team on various performance issues related to the project on BWA & SAP BW7.4/7.3.

Extensively Worked on BWA related problems and solutions.

Very good working expertise on BW Reporting using Query Designer, Bex, WAD.

BO 4.0, 4.1 experience using IDT and reports with Web I, SAP Lumira, Crystal Reports. Designed dash boards using tools like WAD,Xcelsius, and SAP Designer Studio.

SAP HANA EXPERTISE

Very good knowledge in HANA In-Memory concepts.

Worked in End to End migration of SAP BW Environment to HANA DB.

Working on Native HANA modeling. Created Attribute, Analytical and Calculation Views & Good Knowledge on Delta Merge Process.

Experience on data loads using SLT for transaction data loads & created HANA views on top of these replicated tables.

Good under standing of data loads to HANA using DXC and Data Services.

Experience of designing the Composite Providers and reporting on top it using SAP Lumira.

Worked on DSO and Cube optimizations as part of DMO migration.

Experience of SAP HANA Dynamic Tiering NLS based on SAP IQ

Good knowledge on SQL scripting.

PROJECT DETAILS

Project I Oct 2014 – Till Date

Client

Bank of America, USA

Duration

10 Months

Project

HANA Development

Position

SAP BHANA Consultant

Roles & Responsibilities

Analyze the Existing project to understand the scope for HANA.

Worked with SAP to understand the technology and tools that can be used for Bank environment. Worked on POC's for SAP LT, HANA views, composite providers and NLS SAP IQ.

Implemented the SAP LT for replicating the ECC tables(FAGLFLEXT,FAGLFLEXA,BSEG,BKPF etc..) for GL transactions data.

Created the Attribute, Analytical and Calculation Views using HANA Studio on top of the replicated transaction data.

Created composite providers on top of the HANA Views.

Implemented the Dynamic tiering for Hot, Warm and Cold data using the Near Line Storage and SAP IQ.

Test plans of reconciling the data on existing BW models with the HANA modeling

Working on moving the changes & validations to Test environment and working on data load and system issues with SAP.

Working on POC for implementing the SAP Lumira.

Environment

SAP HANA, SLT, NLS SAP IQ, SAP ECC 6.0

Project II Jan 2013 – Sept 2014

Client

Bank of America, USA

Duration

21 Months

Project

BW DB Migration to HANA

Position

SAP BI/HANA Technical Lead

Roles & Responsibilities

Involved in End to End activities of BW migration to HANA using DMO.

Extensively involved in various meetings and worked with different teams in planning and executing different cycles.

Created custom ABAP programs to perform the Pre/Post DMO activities. Created the check lists. Reviewed and resolved any code Inspector errors.

As part of this process involved in many cycles and different approaches for the DB migration.

Extensively worked with SAP on many issues that we identified as part of this migration.

For all the issues that we encountered in different cycles and for SAP suggested notes, we have collected Pre/Post DMO Transports to correct the issues.

As part of Pre DMO activities, worked on tasks like Execute Code Inspector program, Running Object Validation process, Data validation process and preparing for Post DMO Activities.

As part of Post DMO, Worked on tasks that the team can start in Parallel once the Notes & Transports are validated, W Validations - Transports & Validations check.

Optimized all the required info cubes as part of post DMO migration.

As part of BW Remediation step worked on Transformations generation process, outbound transformations process and MP & Queries generation, Validate Data Load Capability - Verify Data load capability is functioning.

Extensively worked on various cycles and issues for arriving to one final document with detailed steps for a smoother Migration.

Environment

SAP BW 7.3, HANA, SAP ECC 6.0

Project III Mar 2012 – June2013

Client

Bank Of America, USA

Duration

18 Months

Project

FPP Implementation

Position

SAP BI Tech Lead/Architect

Contribution

Managing the SAP BI team of 10 resources which includes BACI, Deloitte, TCS & Infosys.

Contributed as onsite tech lead, interacted with business and functional teams to understand the requirements, design the solutions, working with offshore team in completing the project activities on schedule for multiple areas like GL, FPP(Financial Provision Point), SFR(Standard Financial Reporting) etc.

Working with Business users for their future requirements of General Ledger data for various downstream systems to support.

Designed and developed the BW Data models to support the highly challenging and huge data volumes of GL balances and Transactions.

Worked as various BWA challenging issues.

Purpose of the project is to provide the data to legacy downstream applications like MIRD, Green sheet, FTP etc..

Worked with the ADB (Average Daily Balances) data sources provided by SAP for Bank of America to meet the specific requirements.

3FI_GL_SI* Data sources for multiple ledgers like US GAAP, IFRS and Local. Enhanced them using the BADI ZCL_IM_RSU5_SAPI_BADI for user requirements

Designed and developed the BW Data models to send huge volumes and meet the SLA's.

Worked on very tight and challenging data load requirements and providing the data on time to the down streams.

Using DSO Active Tables, Open Hubs and APD’s sending the data to downstream systems as per their requirements and successfully completed the project of providing the data from SAP BW by replacing the legacy system data transfers.

Extensively involved in co-ordination between different teams like ETL, Autosys and downstream business systems.

Environment

SAP BW 7.3, SAP ECC 6.0, Outbound Systems

Project IV

Jun2011 – Feb2012

Client

Bank Of America

Duration

9 Months

Project

GL/APFA/Performance Team - Implementation and Maintenance

Position

SAP BI Consultant

Contribution

As offshore Tech lead executed the Offshore-Onsite model project.

Involved in business requirements discussions, converting the functions spec requirements into Technical specs for the Account Payables and Fixed Assets area of GL.

Worked with the Data sources 0FI_AP_4(Vendors: Line Items with Delta Extraction ), 0FI_AP_50(Check Register )/ 0FI_AP_51(Check Register: Line Items) etc

Enhanced the data sources using BADI ZCL_IM_RSU5_SAPI_BADI for custom field requirements, created Master data objects, and ODS, Cubes, Multi Providers and Transformations.

Developed 40 reports on both AP/FA area to suite the business requirements

Worked with SAP on various issues like BWA/SPO Rotations, 7.3 upgrade and other system issues during the migration from 7.0 to 7.3.

Environment

SAP BW 7.0/7.3, SAP ECC 6.0

Project V

Sep 2010 – May2011

Client

Home Retail Group - United Kingdom

Duration

9 Months

Project

Implementation

Position

SAP BI & BO Consultant

Contribution

Extensively involved in Offshore-Onsite project execution to get the required information to develop the objects.

As per the TDD installed the new data source 2LIS_02_SCN, Changed the DS 2LIS_02_SCL.

Generated the new generic data sources using the tables. Replicated the new Data Sources and created Master data objects, ODS, Cubes, Multiproviders and Transformations.

Involved in Writing the OOPS ABAP Start Routines, End routines and Field Routines for various Transformations.

Transported the developed objects to Quality system and then to production system.

BO reporting: Created the Universes using the IDT and reports on top of Web I. Created Dashboards using WAD.

Environment

SAP BW 7.0, SAP BO, SAP R/3 (Version 4.6C)

Project VI July 2009 – Aug2010

Client

Yell Group - United Kingdom

Duration

15 Months

Project

Enhancement of existing Implementation

Position

SAP BI Consultant

Contribution

Involved in meetings with business users, Requirement gathering.

Prepared the FDD and TDD specifications from Business Requirement Specifications.

Worked on extracting sales and billing data from 2LIS* data sources.

Generated, Replicated and migrated new Data Sources and created Master data objects, ODS, Cubes for PV Data i.e New Media products, Yellow Pages, TP products.

Created/Modified the reports, workbooks related to PV data using Universe Designer, Web Intelligence and Crystal Reports.

Created an Xcelsius dash board for PV data.

Transported the developed objects through Rev Trac Tool.

Involved in Integration test and UAT Phases for newly developed BI objects.

Environment

SAP BW 7.0, SAP R/3 (Version 4.6C), BO 4.0

Project VII May 2007 – Mar 2009

Client

CHEP, Orlando US

Duration

20 months

Project

Implementation & Support of the existing SAP BW

Position

SAP BW Associate consultant

Contribution

Support Daily Data load Operations.

Dealing with large volume data loads from R/3, Siebel, Flat files.

Fix the load failures and Root Cause Analysis for determining route cause for repeating problems.

Solve the user issues like data mismatch, query modifications as per the requirement without missing SLA.

Performance tuning of the reports to improve the response time.

Performing enhancements required to solve problems.

Designing and implementing the enhancements requested by the customer.

Environment

SAP BW 7.0, SAP ECC 5.0, BO 4.0

Project VIII

Sep 2005 - Mar 2007

Client

KODAK, USA

Duration

18 Months

Project

Enhancement & Support of the existing SAP BW implementation

Position

Project Engineer

Contribution

Support to Daily Data Upload Operations.

Resolved the CR’s & PR’s raised by End Users and Client IT Team in the Support Process.

Load and monitor activities on the non production systems.

Created, modified the queries as per user requirements.

Raising tickets to the functional consultants when the issues related to R/3 and other modules.

Communicating with the onsite associates, development team and regarding the data loads and issues faced on daily, weekly and monthly basis

Loaded the flat file data to the Cubes as per the user requirements.

Documented the Root Cause Analysis where there is no workaround for incidents raised.

Follow-up with the End User for missing approvals on the pending tickets.

Environment

SAP BW 3.5 R/3 4.6 B

IT EXPERIENCE

Bank of America, USA from June 2011 to Sept 2015

WIPRO Technologies, India from March 2005 to May 2011.

Contact this candidate