SUMMARY

• SAP BW/BOBJ & HANA Consultant with 9.5 years of professional experience in analysis, design, development; testing and production support of business applications with extensive experience in SAP BW/BI/BOBJ/HANA/BI - ABAP as Techno Functional consultant, analyst & team leading of SAP BW/BOE projects for major and multi-national clients.
• Experience covers various business sectors like Manufacturing, Retail, Oil & Gas, Building Technologies, Drive technology, Energy, Financial Solutions, Healthcare, Mobility, Consumer Products Retail, and Services
• Hands-on experience on SAP BW 7.4/7.x/3.5, SAP Business Objects (BO XI, 4.x), BODS, SAP BPS, SAP BPC, ECC 6.0, SRM and HANA 1.0 version.
• Worked on Information design tool (IDT), to create universes using multiple Data sources.Modified BW queries and generate WEBI reports in BO to meet user requirements.Integration reports between BOBJ and Tableau for visualization.
• Review, analyzing User requirements, defining scope and objectives with business strategies. Plan to on time deliverables.
• Excellent skills to develop reports using Business objects XI R/3 and Web Intelligence Rich Client 4.0., MS Excel Office for analysis, MS SQL and Dynamic CRM (MS).
• Strong work experience in Dimensional Modeling, and designing Star and extended Schemas, Fact and Dimension tables.
• Worked on BO Design studio and published the reports to SAP Fiori.
• Worked on SQL and Oracle DBs as data source for BW systems, experience on SQL stored procedures, extraction and retraction of data in SQL.
• Functional expertise in SAP SD, MM, PP, QM, PS, FI, COPA modules, CRM and SRM.
• Involved in implementations of SAP BW/BI source as SAP ECC Implementation which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, BEx Analyzer, Query Designer, Web Applications Designer and Testing and worked on pilot implementation in HANA.
• Extensive experience in multiple Production support projects for SAP BW/BOBJ/BPS/BPC/HANA and involved in couple of migration/technical upgrade projects - SAP BW 3.X to BI 7.0; SAP BI 7.0 to 7.31/7.4;
• Involved in HANA DB migration of Source system and accordingly SAP BW Data sources migration.
• BW upgrade experience includes proposed a detailed Implementation Plan on Upgrade BW 7.0 to BW 7.4 /HANA as to further improve the Data Manager Read Time, with the Analytical Index, Composite Provider and Hybrid Provider
• HANA - Worked on HANA Studio, Analytical & Calculation Views.
• Expertise in application specific extractions likes LO Cockpit (Logistics) and FI- GL, AR, AP and COPA modules.
• Maintained Knowledge Database for Project purpose and conducted User awareness trainings. Involved in all technical configuration/designs with cross module technical teams
• Expertise in designing and implementing BEx queries, Web Templates, Calculated and
• Restricted Key figures, variables, workbooks and security roles and profiles.
• Experience in BW and BOBJ reporting- Dashboards, BEx Reports, Workbooks, Roles, Jump Query (RRI), Calculated/Restricted Key Figures.
• Reporting - Exceptions, Conditional Formatting, User, Formulae Variables, Web Templates, Web Report publishing using Web Application Designer, create iviews and make them into Portals.
• Expertise in BI related ABAP with complex routines, user exits and function module extraction
• Excellent Communication skills and ability to work in team as well as an individual.

TECHNICAL SKILLS

ERP Packages: SAP Net Weaver 2004s, SAP R/3 4.6,4.7, ECC 6.0, Solution Manager

SAP: SAP BI 7.3/7.0, BW 3.5, BWA, BOBJ 3.X, SAP BPC/BPS & HANA

Reporting Tools: BEx Query Designer, BEx Analyzer, BOBJ- Crystal Reports, Web Application Designer, WEBI & Dashboards, Tableau, Design Studio and Lumira

Functional Module: Logistics - SAP SD, MM, PP, SAP PS, FI (AP, AR, TX & GL), CO&PA and CRM

Languages/Scripts: ABAP/4, C

Databases: Oracle 9i/10g, MS SQL Server, HANA

Operating Systems: Windows 95/98/NT/2000/XP/Vista/7/10, Windows 2000/2003 Server, Ubuntu

Others: MS Office, MS Outlook, MS Visio

Other Tools: HPQC 10, OSD, SDM12 and SAP IMS (AQ2)

PROFESSIONAL EXPERIENCE

Confidential

SAP BW/ BOBJ Consultant

Responsibilities:

• Involved in design phase of the project planning with Architects.
• Worked with Business and core team for requirements gathering and prepared specs for developments.
• Involved in development and converting MSSQL & Dynamic CRM reporting solutions into SAP Business Objects Enterprise Platform reporting and dashboards.
• Project includes SAP BW/SAP CRM/SAP ECC and SAP BOBJ with tools like WebI, UDT, IDT, Design studio, Crystal reports sourcing as MS SQL and Dynamics CRM.
• Developed BOBJ reports with multiple data sources from
• Hands on BW content with SAP CRM and customization, integration with multiple system SQL etc…
• Working on design and develop partnership program Dashboards and Field Inventory data from SQL server.
• Data extracted from SQL and data retraction done from BW to SQL by using Business Objects Data Services (BODS).
• Development and integrating BOBJ reports and integration in CRM web client/Knowledge in SAP Fiori.
• Worked on Microsoft SQL and dynamic CRM to use as source for new reports.
• Developed Crystal Reports for details Orders/Shipments on top of BW Queries and SQL stored procedures.
• Worked on SQL and Oracle DBs as data source for BW systems, experience on SQL stored procedures, extraction and retraction of data in SQL.
• Hands on expertise in troubleshoot and investigate on BOBJ Reports.
• Expertise and hands on architecture for BW Integrating ECC with CRM and SQL.
• Built Universes based on SQL stored procedures and built WebI report documents on top of multiple stored procedures. Built reports in Excel tools like BEx, Office for Ananlysis.
• Built knowledge base documents for project repository and prepared SAP RICEF documents and respective functional and technical specification documents for new developments under WOODS.
• Worked on Logistics, FI, COPA data sources.

Environment: SAP BW 7.4/7.0/3.X, ECC 6.0, BO XI, SAP BOE Business Objects 4.X - IDT, UDT, BI Launchpad, WebI Rich Client, Design Studio, Crystal Reports, SAP HANA, BEx, SAP - SD, MM, FI, PP, CO-PA, SOLMAN, SAP IMS/AQ2, Service now, MS SQL, Dynamic CRM.

Confidential

Lead, SAP BW & HANA Consultant

Responsibilities:

• Involved in Business meetings with Business Directors, Sales Development Managers, Architects for new solution developments, defining scope and objectives.
• Responsible for BW/BI Production support for Current SAP BI environment. Worked closely with Business users and Architect for requirement gathering and approvals on the design and plans.
• Support and enhance BI objects such as Info objects, Info cubes, Info sources/Data Sources, Master Data, Transformations, and Update Rules, DSO, Extractors, Info sets, Aggregates, Process Chains.
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as BEx web analyzers, query designers, Business Objects.
• Configured and customized applications for FI (AP, AR & GL), CO-PA, SD, MM, PS, Purchase modules. Global BI systems maintenance experience across countries.
• Extensively worked FICO & CO-PA modules, performed various cut-over tasks as per the cut-over plan. Performed various data loads for CO-PA data based on re-org and reconcile data stabilization.
• Worked on ABAP routines in transformations for various data analysis and comparison with ECC data.
• Developed generic extract data sources and replicated into SAP BW system and scheduled the Info package to load the Data.
• Error Handling and issues solving arising during user acceptance test.
• As a HANA modeler, developed multiple attribute vies and analytical views. Used these vies in Calculation view as per requirements. Built webI reports on top of HANA views.
• Created BEx reports where Formulas, selections, structures, exceptions, conditions, Currency translation, calculated key figures, restricted key figures and variables with user entry/default value customer exit and Replacement path.
• Extensively created and maintained Business Objects Universes and Reports using the Designer and Reporting modules. Involved in scheduling and publishing report to BO repository.
• Experience in using Information design tool (IDT), to create universes using multiple Data Sources and developed reports in Crystal reports sourcing data from MS SQL.
• Analyzing data in MS SQL Management Studio along with CRM Dynamic reports.
• Developed the dashboard in Design Studio connecting to BEx queries and published to SAP Fiori apps.Created visualization reports in Lumira.
• Designed and Developed the BI reporting, for Management reporting of Daily Sales using BEx.
• Developed reports using Web Intelligence Rich Client 4.0. Connected BO to various data bases by using ODBC/JDBS driver connections.
• Worked on detailed implementation plan on upgrade BW 7.0 to BW 7.4 /HANA as to further improve the Data Manager read time, with the Analytical Index, Composite Provider and Hybrid Provider.
• Worked on BW migration from BW 7.0 to 7.4 by using DMO and SUM tools. Involved in Pre-migration and post-migration activities along with SAP team.
• To maintain the performance and efficiency of the systems by controlling and frequent monitoring of the data flow on increased functionalities.
• Experience into handle Defect Management, Service Requests’ management and Enhancements
• SAP HANA DATA Provisioning using SAP LT replication server (SLT). Experienced in using BODS for extracting data from Non-SAP / BW to HANA DB.
• Active participation in maintenance and support of production system under SLA. Handled Application Maintenance role by managing all Incidents/CRQs.
• Delivered CRM, FI-CO reporting solutions based on BI-BW 7.4 & BI-BOBJ4.1 platforms to critical partners of the project. Handled CRM data as well.
• Handle special data loads for Logistics - SAP SD MM PS, CO-PA module by doing various reloads depends on scenarios.
• Developed reports using Web Intelligence (WebI)Rich Client 4.0 and Crystal reports.
• Created reports by using Analysis for Office reporting tool.
• Error Handling and issues solving rose in BW/BOBJ reports and Design studio.
• Worked on POC for SAP BW on top of HANA.
• Worked on HANA Analytical, Attribute & Calculation views
• Working on proposed scenarios, BW objects and observing the changes in new version of BW 7.4

Environment: SAP BW 7.4/7.0/3.X, ECC 6.0, SRM, BOBJ, MS SQL, SAP HANA, BEx Analyzer, WAD, SD, MM, FI, PP, CO-PA and AQ2 Tool

Confidential

SAP BW/BI Consultant

Responsibilities:

• Involved in preparation of design documents - Collection of IO, ODS design
• Responsible for creation and maintenance of standard and custom Info Sources, Info Objects, Info Cubes, and ODS Objects
• Involved in Analyzing the User requirements and provided necessary information from BI Content to meet all the standard requirements.
• Involved in determining the data flow for the business requirements for bespoke extraction and reporting, and translated these requirements into Dimensional Data Models in BI for Warehouse Implementation.
• Created Process chains and Meta chains for daily loads and Monthly loads of Transaction Data.
• Created various queries and extensively worked on Query Builder objects viz. Filters, Structures, Exceptions, Free Characteristics, Restricted Key Figures, calculated key figures, Variables, Offsets and Query Variants.
• Extensively worked on Custom Exit variables and developed code for No. of working days in a Month/Year-To-Date period/Rolling Year Period and Year-To-Date span in a Fiscal Year period based on User defined Key Date.
• Extensively worked on Web Application Designer (WAD) to develop the templates to meet the business requirements.
• Built real-time cubes for planning data flow. Worked on EPM Excel frontend for planning solutions (BPC).
• Involved in installing Info Objects, Data Sources, Info Sources, Data Targets, Info Packages and Info Providers to load Master and Transactional Data from SAP R/3 Systems into BW system as for the Client requirements by customizing them.
• Set up procedures for extracting data from SAP R/3 by using generic extraction.
• Responsible for all change requests & production tickets raised in Production environments and Extensively worked ondesign, development & release of solutions for CRM BI reporting according to user requirements in production environments.
• Delivered CRM, HR & FI-CO reporting solutions based on BI-BW 7.4 & BI-BOBJ platforms to critical partners of the project.
• Maintained consolidations and reconciliations for Finance and CRM data to compare data inSAPR/3/CRM andSAPBW after month end data loads as a part of month end activities.
• Developed data flows for CRM BW reporting on contacts & Organizations based on BP (Business Partner) & Marketing Attribute data using standard data extractors & DSOs such as 0BPARTNER ATTR, 0BPARTNER TEXT, 0BP RELATIONS ATTR, 0CRM MKTELM5 ATTR, 0BP ID ATTR, 0MKTG C04, 0CRM MKTATTR ATTR, 0CRM MKTMETA ATTR, 0ATR DS01.
• Designed CRM/FI-CO Dashboards usingSAPBO 4.1 -DesignStudiotool and optimized performance as per user inputs.
• Discussed & developed new strategies to implement BO 4.1 -DesignStudioand adopted all new changes of the tool asSAPis releasing add-ons to this tool regularly to improve customizations.
• Implemented BO-Webi Project to change CRM BEx WAD reports to Webi and successfully completed changes with better performance & usability using existing BEx queries/multi-Providers & Used Universes/BICS connections/IDT tool to connectSAPBI & BO.
• Involved in activating the Business Content Data Sources, maintaining Extract Structure, generating Data Source, activating & enhancing Data Source and used BADI to fill data in enhanced fields in Data sources.
• Designed end to end data models & developed critical flows in CRM such as Opportunity, Business Partner Data, Campaigns, and Leads & Activities data flows in global plat form and designed & enhanced exclusive local flows based on additional requirements of local regions.
• Actively participated in handling the tickets/ Incidents/Business queries.
• Involved in monitoring of various process chains on Daily/ Weekly basis.
• Working on NRT (Near Real Time) concept to fetch the near real time data from source
• Written Variable Exits, Exit Functions, Formula Functions to support the various elements of the business process for planning
• Designed and implemented configuration changes for both load performance and query performance optimization.
• Successfully handled System Integration Testing (SIT) and User Acceptance Testing (UAT)
• Handled post product support and performance issues.
• Implementing Best Practices suggest by SAP from Early Watch Report
• Provided End User training on SAP BI reporting.

Environment: SAP BI 7.0, ECC 6.0, CRM 7.0, CRM 5.0, Solution Manager, BEx Analyzer, Web Application Designer, SAP BO XI, SD, MM, PS, FI, COPA and BMC remedy, IMS system

Confidential

SAP BW / BPS Senior Consultant

Responsibilities:

• Start and monitor Data processing in BW (Daily / Weekly / Monthly and Ad-hoc) in Production
• Uploaded Master Data and Transactional Data into the Data Targets for OLAP from Flat Files and SAP R/3 as OLTP Source System.
• Handled & analyze the errors in the data loads.
• Answer first level of Manage-now Tickets related to reports.
• Collect information for performance monitoring.
• Analyzed end user requirements and raised tickets to proper resolution groups.
• Fix process chain errors like SID’s, Replication, Rollups, locked master data, TRFC struck at source systems and Master data issues in R/3.
• Generated and Maintained Aggregates and Rollup activities on Info Cubes as part of the Info Cube Management
• Solved tickets raised by end users by using Manage-now ticketing tool
• Maintained work history for all the tickets until it is closed down.
• Coordination and communication with the onsite team
• Developed Reports, master data objects as per the CRS documents and testing the data models enhanced with new fields and testing the new reports.
• Data analysis for the develop queries.
• Worked on PTR and CRs.
• Debugging the programs in BW.
• Responsible for maintenance of InfoCubes, ODS, PSA, InfoObjects, InfoAreas, Multi Providers, InfoSources, DataSources, and InfoPackages
• Created InfoPackages for scheduling the data load process with full and delta update mode, worked on SAP CRM data sources.
• Created Reports by using BEx Analyzer such that the execution time is evenly distributed throughout the report by using free characteristics, restricted key figures, calculated key figures, variables, and exceptions
• Data loaded by using BPS Planning Functions-sequences in planning mode.
• Updated data through PSA for the Info Cube, ODS using Delta, full update.
• The source system is upgrading to ECC and SRM 7 and working in this project from BW perspective. This upgradation is a challenging for us being a multiple client support.
• Replicating data sources
• Migrating BW 3.X data source to 7.0 versions.
• Creating Transformations and mapping for defective flows
• Testing the data sources and mapping
• Data load and validation in source system and BW
• Report validation

Confidential

SAP BW Consultant

Responsibilities:

• Effectively gathered systems requirement from client and taken signoff on approval of systems requirement.
• Led (/involved) the team through life cycle (Requirement gathering, gap analysis, HLD, Detail Design, Development, Unit testing, Assembly testing, System test support, migration to Production environment and post go-live support).
• Actively involved in converting Functional specifications into High Level Design (HLD)
• Active participation in providing Detail Design for the HLDs
• Active participation for HC - SAP Business Warehouse (HC-SAPBW)
• Created many test cases and Test scenarios for Unit testing, Integration testing of many BI reports and logged the defects using HPQC
• Involved in ABAP coding of transformations, extractors, program, function module and customer exit.
• Worked extensively in collecting the BI objects to the transport requests, released all transports to the Quality/Production system and resolved issues related to transport failures.
• Actively participated in preparation of KT Questionnaire to get most of the system information in hand before KT Execution
• Coordinated and lead the Operations team in Knowledge Transition phase
• Actively participated in KT Execution from site and coordinated the offshore team up to the speed
• Lead the Operations/Production Support team for e-link SAP Business Warehouse
• Coordinating between onsite team & offshore team to resolve issues for HC System
• Coordinated closely with team in resolving various maintenance tickets.
• Involved in maintenance and support of production system under SLA.
• Coordinating between onsite team & offshore team to resolve daily issues for both HC and e-LINK System.
• Initiated Job Aids for the Production Issues and their resolutions
• Actively participated in system validation during System maintenance/Bounce
• Coordinated closely with Basis team during Server Shift (Primary to Failover and vice versa)
• Primary responsible for Daily Operations SLAs with Client and Monthly SLA Metrics with Client
• Coordinated closely with team in resolving various maintenance tickets
• Coordinating between onsite team & offshore team to resolve issues for HC System.

Environment: SAP 3.X, BI 7.0, R/3, ECC 6.0, BEx Analyzer, Web Application Designer, SD, MM, FI, HR, RE, HPQC 10 and BMC remedy7.5