Data Sap

SAIKRISHNA MYLAVARAPU

SUMMARY OF EXPERIENCE:

SAP HANA BW BO certified consultant with 10.8 years of experience as Techno Functional Lead Consultant.

Expertise in various versions of SAP HANA, BW and BO with multiple implementations and Support projects experience, Strong Hands-on experience in large-scale Data Warehousing projects.

Functional exposure and working experience on various modules such as FI -CO,COPA, SD, MM, BW-IP, HR,PS,PM, IS-Utilities, IS-Retail, SRM and SAP CRM.

Good hands on experience in various phases of the project such as design, development, deployment and hyper care support.

Managed project delivery expectations and relationships with various business units and IT Teams.

Extensively worked in Data Extraction from SAP and Non SAP (Legacy) Systems using LO, FI_GL, LIS, Flat File and Generic Extraction Methods.

Extensively worked on BW and BO reporting tools.

Created Composite providers, Open ODS Views, Multi Providers, Info Cubes, DSO and generic extractors based on the business requirement.

Extensively worked with ABAP Programs, Routines in transfer rules, Update Rules, Transformations routines.

Extensively worked in batch schedules using process chains for data loading.

Hands on experience in Performance tuning Techniques for overall system performance

And improving performance of Reporting execution times.

Extensively worked on creation of Information Models in HANA as per best practices.

Extensively worked on Data Provisioning in HANA.

Having good Understanding and knowledge of Integrating Big data with HANA.

Having good knowledge of Installation, configuration, Sizing and development processes to implement projects in Lumira.

Published Documents and maintain control over documents in Lumira server by creating groups.

Created Technical Specifications from Functional Specification documents.

Excellent Communication, work ethics, Go-getter, Self-starter, Analytical, Presentation skill with ability to work in a team and individually.

EDUCATION :

Bachelor of Engineering (B.Tech), Nagarjuna University, April 2001.

CERTIFICATIONS :

Certified in SAP BW 7.0 ( P_BIE_70 ) ( ID : 217705125 )

Certified in SAP HANA (C_HANAIMP131) ( ID :000******* )

ITIL Certified.

TECHNICAL SKILLS:

Business Intelligence : SAP BW 3.5, BI 7.X, BW 7.4 on HANA, BO 4.0

ERP : SAP R/3 4.7/4.6C and SAP ECC 5.0/6.0

Reporting : BW BEx, WAD, SAP BO .

Functional Module : SD, MM, FI-CO, CRM

Programming Languages : ABAP/4, SQL Script, PL/SQL.

PROFESSIONAL EXPERIENCE:

Sanofi Aventis Jan 2014 to Aug 2015

SAP HANA BW BO Lead Consultant

Bridgewater, NJ.

Environment : SAP BW 7.4, BO 4.1 and HANA 1.0 SP08

Project Description: BW 7.4, BO 4.1 and HANA Implementation.

Responsibilities:

Worked on design of Architecture of SAP HANA.

Interacted with senior business executives to review business requirements and propose optimal solutions based on SAP best practices.

Prepared project plans and effective systems development schedules, and monitored team work to ensure that tasks are performed according to schedules.

Guided the team in creating Design Document and technical detail level of Documents

Review all developments created by team members.

Developed Data models in BW based on LSA++ Architecture.

Developed the data flow that consist of Data Source, Transformation and Info Providers.

Worked on integration, loading, scheduling, and managing data for BW-IP .

Worked on development of Universes in BI/BO 4.1 using IDT from relational databases.

Worked on development of Reports in BI/BO 4.1 using BO launch pad, Crystal Reports, Design studio and Lumira .

Worked on troubleshooting and Performance improvement of BO Universes and reports.

Worked on SQL ( SQL Script ) Developments in creating Scripted views.

Worked on design and development of HANA XS APIs.

Worked on Creation of Information Models in HANA Studio.

Created Analytical and Attribute Views and Calculation Views based on best practices.

Worked on Data Provisioning using SLT Replication server from ECC.

Worked on ETL Process for Non-SAP Source using BODS.

Worked on Analytic Privileges.

Worked on various components of SAP HANA.

Medtronic July 2013 to Dec 2013

SAP HANA BW BO Lead Consultant

Mounds View, MN.

Environment : BW 7.3, BO 4.0 and HANA 1.0 SP05

Project Description: BW, BO and HANA Implementation.

Responsibilities:

Worked on design of Architecture of SAP HANA.

Interacted with senior business executives to review business requirements and proposed optimal solutions based on SAP HANA.

Worked on Creation of Information Models in HANA Studio.

Created Analytical and Attribute Views and Calculation Views based on

best practices.

Worked on Data Provisioning using SLT Replication server from ECC.

Developed Process Chains to automate the whole daily data loads .

Worked on Data Provisioning using BO data services from Green plum.

Experience with various aspects of HANA modeling including creating schemas and importing source system metadata.

Worked on various components of SAP HANA.

Worked on development of Reports in BI/BO 4.0 using BO launch pad, Crystal Reports, Dashboards, Design studio .

Baylor College of Medicine Jan 2013 to June 2013

SAP HANA BW BO Lead Consultant

Houston, Texas.

Environment: SAP BI 7.3, SAP BO XI 4.0, HANA

Project Description: BW Implementation and Support, BO Implementation

Responsibilities:

Installed Standard Data sources, Enhanced Standard DS and install Standard Business content Info objects DSO and Info cubes.

Worked on FI, SD, HR and SRM Modules.

Developed Process Chains to automate the whole daily data loads .

worked on development of start routine and transformation routine.

Performance tuning for Info cube designer, data loading and Queries design.

Created Multi Providers, based on Info cubes, DSO objects.

Enhancement on Transactional data sources and Master data sources.

Created Calculated Key figures, restricted key figures, Cell restrictions, Formulas, Customer Exit Variables as per reporting requirement.

Production Cutover Plan for transportation of Standard, Generic data sources and Enhancements Objects R/3, all BI Objects and Data load.

Power User Training and User Manual Preparation

Creating the Business objects WEBI reports based on SAP BEX Query.

Created BO Dashboard Reports.

Worked on Creation of Information Models in HANA Studio.

Reliance Power Ltd July 2011 to Dec 2012

SAP BW BO Lead Consultant

Mumbai, India.

Environment: SAP BW 7.1 Support, SAP BO

Project Description: BW and BO Support .

Responsibilities:

Resolved support issues and maintenance activities like Data loading, Job Monitoring, Scheduling the jobs, designing and use of the process chains Write logic to bring Master data in Transactional data using transformation routine.

Performance tuning for Info cube designer, data loading and Queries design.

Query performance Tuning using RSRT.

Created Multi Providers, based on Info cubes, ODS Objects.

Enhancement on Transactional data sources and Master data sources.

Customer Exit Variables as per reporting requirement.

Creating the Business objects WEBI reports based on BEx Query.

BSES Power Ltd April 2010 to June 2011

SAP BW Consultant

Delhi, India.

Environment: SAP BI 3.5 Implementation and Support

Project Description: BW Implementation.

Project Responsibilities:

Activated standard Business Content as per business requirements for IS-Utilities Module.

Creation and customization of SAP BW components including Extract Structure, Data Source, Info Objects, Transformation, DSO, Info Providers.

As per business requirement created Generic Data source’s in ISU – DM, Billing, and FI-CA module and based on that created DSO’s as per business Logics.

Created Master and Transactional Process Chains for Daily/Weekly/Monthly data loads and scheduled accordingly to upload the data into info providers with appropriate dependencies.

Worked on Mass upload of ISU-Sales data process.

Creating Web templates based on report requirement, assigning queries to template and Generate PDF as well as Excel Format.

Done master data enhancement adding fields based on reporting requirement.

Created processes for Data Mining with Analysis Process Designer.

Performance tuning for Info cube designer, data loading and Queries design.

Extensively worked on authorization concept in BW 3.5.

Reliance Infrastructure Ltd April 2009 to March 2010

SAP BW Consultant

Mumbai, India.

Environment : SAP R/3 4.7, SAP BI 7.0

Project Description: BW Implementation and Support.

Responsibilities:

Installed Business Content Cubes, designed and developed DSO, Cubes,Multi providers and Info sets to meet business needs.

Configured Data sources in R/3 by using LO Cockpit initialized the setup tables. Scheduled and Implemented delta mechanism for Periodic loads.

Involved during realization,final preparation phase and hyper care support.

Implemented SD, MM Modules

Preparation of Technical specification documents.

Created and customized of Extract Structure,, Data Source, Info Objects, Transformation, DSO,

Info cube, Multi Provider, Info sets.

Performance tuning for Info cube designer, data loading and Queries execution times.

Extensively worked on New Authorization Concept in BI-7, Created Authorization objects, User Specific Roles.

Created processes for Data Mining with Analysis Process Designer.

Having hands on Experience on Web Application Designer.

Creating web templates, assigning queries to template.

Reliance Energy Ltd April 2007 to March 2009

SAP BW Consultant

Mumbai, India.

Environment : SAP R/3 4.7 BW 3.5.

Project Description: BW Implementation and Support.

Responsibilities:

Implemented CS,DM,FI-CA and Billing Modules for IS-Utilities.

Monitor periodic data loads from SAP R/3 to BW.

Modified standard Content & created custom info sources, data sources, communication structures, transfer rules & update rules for info cubes & ODS.

Developed Generic Extractor using Tables and Views and extracted data as per the business requirement.

resolved support issues and maintenance activities like Data loading, Job Monitoring, Scheduling the jobs, designing and use of the process chains.

Worked Extensively on Query Designer using Conditions, Exception highlighting, restricted key figures, Variables, Filters, Free Characteristics, Structures, and Cell Restrictions.

Created Master and Transactional Process Chains for Daily/Weekly/Monthly data loads and scheduled accordingly to upload the data into info providers with appropriate dependencies.

Created Authorization in 3.5 with roles and assigned the same to appropriate users.

Created processes for Data Mining with Analysis Process Designer.

Hindustan Unilever ltd Jan 2005 to Mar 2007

SAP BW Consultant

Mumbai, India.

Environment : SAP R/3 4.7, BW 3.5 .

Project Description: BW Support

Responsibilities:

Worked extensively on BEx Analyzer for queries creation and changes.

Preparation of test plans, test cases and execution & reporting..

Monitoring periodic data loads and error rectification from SAP R/3 to BW.

Preparation of Technical specification Documents

Manual Scheduling of Daily/Weekly/Monthly data loads and Process chains.

Telecom Domain Experience – Non-SAP Jan 2002 to Dec 2004

Consulting Engineer

Hyderabad, India.

Environment: Telecom Support ( Non-SAP)

Project Description: Client is a Telecom Company.

Responsibilities:

Distribution of Work Sheet to the Team Member as per Daily work Orders.

Coordinated the work assigned by site visits and Checking the Installations

Testing of Tele Device Installations and Operations.

Preparing weekly, monthly, yearly MIS Reports

Trained new members in the team and getting productive quickly.

Contact this candidate