SUMMARY

• Having 9 Plus Years of professional experience engaging with the business stake holders to understanding business needs and provide solutions out of SAP BI/BW BO & HANA experience encompassing a wide range of skill set, roles and industry verticals.
• Involved in 6 end to end full - life cycles implementation of SAP BI/BW & HANA projects.
• Participated for Agile/Scrum Internal Trainings in Confidential .
• Hands on experience in understanding and executing Agile/Scrum Projects.
• Involved in Collaborating with Client managers, reporting team, Business users and other Stake holders to understand the existing landscape and identify key business use cases for PoC’s.
• Interacted with Business stake holders in order to understand their structured and ad-hoc reporting requirements, Identifying KPI’s, Interacting with Functional Owners Prepared Technical Spec based on the FS.
• Having Project experience both at offshore and onsite with a focus on combining business process and technology to deliver strategic transformation capabilities for global clients.
• Played different roles like Scrum Master, Solution Designer, Team lead for Production support, Module lead & Team Member.
• Played a key role in migrations projects from SAP BW 7.0 to 7.4 and BW on HANA.
• Good communication, interpersonal and managerial skills, team player with positive attitude and self-motivated to work independently and in team as well.
• BI data load scheduling, monitoring and troubleshooting data extraction/load problems.
• Experience on PoC (Proof of Concepts) Developments on SAP BI /SAP BO integration.
• Experience in User Requirement Gathering, Design, Development, Testing, Production Support and User documentation.
• Hands on experience in design and development of Info Objects, DSO, Info Cubes, Multi Providers, Data Transfer Process (DTP), ADSO, Composite Info provider based on SAP HANA data models info provider based on SAP HANA data models and using BWMT tools.
• Hands on experience with BW modeling tools with ADSO, Composite provider and Open ODS Views. Data extraction from R/3 Systems, Retails systems, HR systems, Generic Datasources, Flat file structures and other 3rd party systems.
• Worked on BW support project activities data loading, monitoring and troubleshooting the failures. Worked extensively in SD, MM, PP, HR and FI Modules.
• Worked on Authorizations (PFCG), Analysis Authorization (RSECADMIN).
• Participated in user meetings to resolve ongoing Implementation issues, Performance and code reviewing.
• Creation of Generic extractors with different tables, views, FM’s to meet the business requirements.
• Open Hub solution for providing data feeds to other outbound interfaces.
• Authorizations.
• Documentation: Scoping, Technical specifications, Impact analysis with MD estimations.
• Worked on ECC-BW (CS/FI/SD/MM/PM/HR) and CRM-B (Survey/Leads/Opportunities/Marketing) integrations.
• Hands on knowledge in creating SAP BO 4.0 Information Design Tool Universes on top of SAP Cubes and Multiprovider using Relational OLAP Connection.
• Experience in Creating WEBI Report using SAP Bex and IDT Universes.
• Worked extensively with the major functionality of BO like Breaks, Ranks, Section, Filters, Sorts, Query prompt and Input Controls in WEBI.
• Done Proof of Concepts using Xcelsius Dashboard Tool.
• Good understanding of Business Objects Data Services (BODS)
• Reporting via Crystal Reports, Web Intelligence and SAP Lumira (formerly SAP Visual Intelligence),
• Design Studio, Explorer, OLAP Analysis
• ECC data consumption through business layer/universe (using Information Design Tool (IDT), Central Management Console (CMC)
• Universe/Business Layer Design via IDT.
• SAP BW query/cube consumption through BICS connection
• Support pack upgrade SP02 to SP06.
• Experience with SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Experience with SAP ECC table data model and analysis with Modules SAP SD and MM Tables.
• Experience with Data provisioning of SAP SLT replication schemas in SAP HANA for SAP ECC table’s replications.
• Experience in modeling using BW modeling tools like Composite provider, ADSO and Open ODS Views.
• Created master data objects as Attribute views, joined multiple master data tables depending on the requirement, selected key figures and attributes to give context to the master data.
• Involved in creation of Analytical views to support multi-dimensional reporting by joining Fact table data foundation to modeled dimensions attribute views, selected attributes and measures.
• Created Calculation views using data base tables, attribute views and analytic views, to address complex business requirements created SQL Script based Calculation views.

TECHNICAL SKILLS

Data Warehousing: SAP BI 7.0., SAP BW7.3 and SAP BW 7.4.

ERP: SAP ECC 6.0Database SAP HANA SP12.

Languages: C, C++, and SQL

Reporting: SAP BW3.5, SAP BI 7.0 and SAP BW 7.3 Bex & SAP B0 4.0 WEBI.

Operating Systems: Windows XP/2000/NT.

PROFESSIONAL EXPERIENCE

Confidential, IA

Sr.BW HANA Consultant

Responsibilities:

• Provided Solution & Design for Right Now Services Report through SLT (SAP Landscape Transformation) to perform real-time data replication into SAP HANA.
• Worked on OSS notes implementation.
• Interacting with Functional and Business users to understand business requirements.
• Translation of Functional Business requirements into very clear Technical specifications and then delivering solutions back to the Business.
• Prepare technical specifications and assign them to development coordinators to get the development done from offshore.
• Responsible for Design, Development, Construction and Testing of a reporting solutions.
• Executing new projects/developments using Agile Methodologies playing as Scrum Master Role.
• Handling a team of 9 members as SAP BW/BO HANA Solution Consultant from offshore.
• Extensively worked on SAP HANA BW modelling tools with new info providers like composite provider, ADSO and Open ODS Views.
• Expert in building HANA Enterprise and BW on HANA Landscape from Data Provisioning to Reporting.
• Liaison with onshore and offshore team in assessing the pros-cons while developing the BW designs.
• Deliver solutions which support best practices and must be robust, scalable and quality solutions on time and budget.
• Conducting Functional User Testing (FUT) and User Acceptance Testing (UAT) to make sure solutions are delivered as per Business needs.
• Developed SAP HANA data modeling using Attribute View, Analytic View, and Calculation View’s to show case the SAP HANA Modelling functionalities.
• Implementation experience and knowledge of SAP Hana reporting for different functional area Finance
• Export & Import of Packages
• Security & Authorization objects (Analytic privilege, System privilege, SQL privilege & Package privilege)
• Expert in understanding of the complete Architecture (Database, Data loading, Data modeling & Administration)
• Loading data into table definitions, suspending data loads, resuming data loads
• Monitoring and troubleshooting data loads
• Hands on experience on SAP HANA Studio 1.0
• SAP BW Technical upgrade: Conversion of data flows, data sources, queries, workbooks and security objects from version 3.x to 7.4 in BW DEV system and transported all through the landscape to BW Production environment.
• SAP BW authorizations migration from 3.x to Analysis Authorizations.
• Process Chains migration to include DTP flows.
• Testing and validation of 7.4 objects.
• Process Chain monitoring and bug fixes after upgrade to 7.4.
• Integration testing with SAP BO and Portal.
• Collected statistics from Data loads and Reports Execution timings before migration to HANA.
• Supported migration to SAP HANA via DMO option - SAP Notes implementation.
• Prepared project plan and execution for HANA for all applications in system.
• Prepared pre-and post-activities for all applications.
• Integration testing with SAP BO and portal after migration to HANA.
• Unicode checks for listed ABAP programs for prior to HANA migration
• Performance analysis by comparing pre and post migration runs time and presented to management.
• System Clean-up: Deletion of unused objects from the BW DEV system and transported through the landscape.
• SAP BW on HANA platform - Managed System Landscape preparation with Basis team.
• Followed SAP BW on HANA RDS for migration activities step by step - SAP recommended.
• System Copy - BW on HANA migration: project planning.

Confidential, IA

Sr. BW HANA Consultant

Responsibilities:

• POC on SAP BW powered by SAP HANA.
• POC on SAP HANA Data provisioning with SLT replications and Flat file data loads.
• POC on integration with SAP Business objects 4.0 With SAP ECC 6.0 EPH5.
• Collection of FI general ledger and cash flow reports requirements and design of Data Models
• Replicated tables and created attribute views, analytical views and calculation views for Finance general ledger and cash flow data models.
• Performed Configuration for SLT and Real-time replication for the finance data tables.
• Created BO IDT Business layers in BO ITD for HANA data models
• Designed Finance general ledger and cash flow operational analytical Reports in BO WEBI on HANA IDT universes.

Confidential, IA

Sr. BW/BI Consultant

Responsibilities:

• Supported BW upgrade from BW7.0 to BW7.4.
• Performed Test Cycle after upgrade.
• Troubleshoot and fix data load problems/errors.
• Converting BW objects to In-memory
• Optimizing BW data model with LSA++ architecture:
• Configured BW Data Model as Enterprise Data warehouse Layer and Architected Data mart Layer.
• Enabled Bex reporting on DSOs.
• Process chains optimization.
• SAP Notes implementation - to fix post migration standard bugs.
• Closely aligned with business SD users to understand the reporting requirements.
• Activated the standard business content for Sales shipping and Billing.
• Responsible for implementing Sales view Info cube for summarized sales, deliveries and Billing Information. Also required to create Multi provider on Sales, Deliveries and Billing Info cubes.
• Created custom cubes to merge data from standard data source and custom flat file sources for specific business reporting requirements.
• Configured Bex Web Analyzer for reports display via portal.
• Setup Bex Information broadcasting for automated email periodic notifications to SD users. Daily broadcast during month end closing cycle.
• To support critical month end closing by resolving tickets raised within SLA.
• Top-down troubleshooting: Incident resolutions included extensive trouble shooting to reconcile data and to fix data load or mapping errors.SAP BW Consolidation cube, SAP BW Data Protection Layer with underlying objects and finally into SAP ECC.
• Regular discussions with business users for incident resolutions like company code and management ID combination configurations and other mappings.
• Extensively involved in Production Support by loading Daily, Weekly and Monthly loads into the BI system from different source systems and other housekeeping activities.
• As a part of Production support involved in monitoring load failures, Delta loads, and monitoring the performance of the system.
• To send a complete data load analysis report to customer.
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data.
• Managed and monitored several data loadings, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.

Confidential, IA

BW Technical Lead for Production Support

Responsibilities:

• Responsible for environment build for SAP BW systems and leading the BW team from the offshore.
• Discussed new requirements with onsite counterparts as per the business process and generated functional and technical specs and deployed the same.
• Involved in Purchasing / Sales projects which include analysis, development, data modeling and Reporting.
• Involved in creation of new APD’s in order to get the master data texts as per the requirement.
• Enhanced the existing Purchasing and other LO Cockpit data source by appending new fields.
• Working on both Development and Production Support Projects.
• Created DSO for Customer Satisfaction Actuals L2 (Level 2 DSO) wrote a complex end routine to map the data from two DSO’s based on Driver DSO.
• Created two cubes and Multi-provider for Customer Satisfaction.
• Involved in writing Info object routines, Start routines and End routines.
• Root cause analysis for frequent failures of error DTP’s.
• Receiving the customers generated tickets via remedy and resolving them.
• Load monitoring activities using RSPCM, RSMO, SM37 and SM51.
• Actively and regularly involved in Load Monitoring of Daily, weekly and Monthly, Data Loads using Process Chains and Info packages.
• Maintaining rechecks for verifying the data in SAP R/3 and BW are same are not after data loads.
• Involved in taking necessary actions to correct the Info packages by doing Manual Update, reconstruction and running the info packages manually depending on the case.
• Experience in creating BEx Queries using Calculated and Restricted key figures, Variables, Structures, Exceptions and Conditions.
• Understanding the requirements from Business Pint of view.
• Filled the setup tables of LO data sources for initialization & delta.
• Involved with performance tuning of Queries by Compression, Partition and Indexing of Info Cubes.
• Created Multi provider queries and improves the performance of queries.
• Delivered Customized reports.

Confidential

SAP BI Consultant

Responsibilities:

• Built objects like ODS, SAP Queries, BEx Queries, Generic Extractors with InfoSet queries
• Involved in review process of WRP (Work Review Plan) and WPR (Work Product Review). Prepared Test Cases and results for User Acceptance Testing.
• Tracking all testing activities through HP Quality Center, managing defects fixing
• Developed Process Chains based on events as per the requirements
• Scheduled background jobs in the Maestro Tool for the project
• Participated in the cut over activities and Go-Live
• Analyzed the existing environment for impacts and regressions.
• Developed BEX queries by using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information
• Developed SAP Infoset Queries to provide the outbound extractors
• Post Implementation Support & Maintenance
• Worked on IBM Maximo tool to raise Change requests

Confidential

SAP BW/BI Consultant

Responsibilities:

• Involved in creating and managing of Info Areas, Info Object Catalogs, Info Objects, Application components, PSA, DTP, Info package, transformation.
• Involved in creating Info Cubes, DSO’s, Multi providers, Info sets, Open Hub Destination.
• Involved in creating Aggregates, Partitioning, Indexes, Roll-up and Compression to improve the Query performance.
• Involved in front-end BI elements like Queries, Formulae, Variables, Calculated Key figures, restricted key figures, Structures, Selection, Exceptions, and Conditions.
• Hands on experience in BW reporting using BEx Query designer, BEx Analyzer and creating Queries.
• Involved in SAP BI Integration & User Acceptance Testing.
• Involved in creating Variables like Characteristic, Text, Formula, using Processing Types.
• Worked on Generic and LO extractors for SD and FI/CO Module.
• Worked on Data Source Enhancement for SD Module.
• Uploading master data and transactional data both from flat files and SAP R/3.
• Creation of Process Chains, for upload of Transaction Data and Master Data.
• Monitoring and Error handling in PSA like modifying the error records and reloading the data.
• Installed objects from business content like Info Cubes, Multi Provider, DSO, Queries.
• Loaded many Hierarchies from Production Server to Development server by using KT.
• Involved in transportation objects from development to quality and production.
• PROJECT- Internal, Trainee from
• Trained on SAP HANA,BW7.4 and BO.
• Installed Business Content for standard InfoObjects, InfoSources, InfoCubes, Queries, Workbooks, and Roles.
• Created InfoSources for transactional data, master data/ texts, attributes, and hierarchies.
• Developed Generic extractors to extract virtually any R/3 data from Data base tables, views, Sap Queries.