SUMMARY

• Motivated professional with around 8 years of extensive experience in SAP Data warehouse technologies, worked on various key roles in SAP BW/ ABAP/ BO - Data modeling, ETL activities and Report development. Involved in implementation in different module and in all phases like gap analysis, blue print and design and development, performance tuning testing and documentation and trouble shooting
• Working with functional teams to prioritize, understand, design, plan, manage and deliver reporting and analytics solution for the business. Work with business users and managers to understand requirements and articulate solutions.
• Strong in customizing & developing SAP BW components such as InfoObject, InfoCube, ODS/DSO, Multi-Provider, Infoset, Data Source, Info Source, Transfer Rule, Update Rule, Transformation Rule(7.0), InfoPackage, DTP, Scheduling, Monitoring, Process Chains, Open-Hub, DataMart.
• ABAP/4:Routines (transformation, start routines, end routines, update rule, transfer rule), Functional modules, User Exits (CMOD, SMOD), Event handlers.
• Extensive experience with various SAP and non-SAP extractions: LO Cockpit, CO-PA, Cross-Application generic extraction, Flat file.
• BW Reporting - Reporting using BEx Analyzer, Web Application Designer, BEx Query Designer. Expertise in creating BW components like Workbooks, Web templates, designed Queries using query elements like Free Chars, Filters, Restriction, Conditions, Exceptions, CKF, New Formula, RKY, New Selection, Variables.
• Extensive in understanding of Web Intelligence (Webi), Xcelsius (dashboards) and Crystal Reports.
• Experience in understanding of the complete Architecture of SAP HANA(Data loading, data modeling and reporting).

TECHNICAL SKILLS

Data Warehouse: SAP BI 7.3, BI 7.0, SAP BW 3.5, BW 3.X, BODS 4.0

ERP: Packages SAP ECC 6.0, R/3 4.7Cross Application ALE, EDI, IDOC, RFC, BAPI'S and SAP XI3.0

Operating system: Windows 98/2000, XP

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BI Consultant

Responsibilities:

• Extensively involved in project preparation, business blue print, realization, final preparation and go live and support phases.
• Analyzed reporting requirements and translated the requirements into multidimensional data module.
• Worked with functional consultant for mapping the source data to target Data Sources in BI.
• Develop logical data model( Extended Star Schema) for Data Marts like Info Cubes, Multi-Providers
• Customized, Extracted and maintained Data Sources such as Sales Order Header (2LIS 11 VDHDR) and Sales Order Item (2LIS 11 VAITM) for the SD module and Material Movements-Sales Order Delivery (2LIS 03 BF) for MM module.
• Used process chains to schedule the infopacakages and data transfer processes between Source System and Target Data Warehouse System (SAP BI). Also configured BW objects including generic data sources to extract data from Source System to SAP BI (Target System).
• Created Transformation Routines, Start Routines and End Routines as per the client requirements using ABAP.
• Involved in data archiving and expertise in Near line storage concept
• Worked extensively on various production support issues and tickets and administration of BI back-end operations to ensure data is successfully extracted.
• Handled Incidents and Change Requests as part of the support team
• Worked extensively with BusniessObjects Webi query/reporting tool, created drill-down in reports and created the Crystal reports using functionality like Add Queries (Command), Sub Reports, Drill down, Cross-Tab, Formulas, Parameters along with Dropdown lists etc.
• Worked Extensively on various production support issues and administration of BI back-end operations to ensure data is successfully extracted and Worked majorly in daily activities like monitoring loads
• Good understanding of various components of SAP HANA (Data loading, data modeling and reporting).
• Designed and implemented SAP HANA data modeling using Attribute view, Analytical View and calculation View
• Involved in SAP HANA Data Provisioning and using SAP LT Replication Server (SLT)
• Executed Data Extraction Transfer Loading ( ETL) using SAP Data Services 4.0
• Involved in SAP HANA Security including User Management, Roles and privileges

Environment: SAP BW 7.3,SAP BW 7.0 SAP ECC 6.0, BEx Analyser, Query Designer, Web Application Designer.

Confidential

SAP BI Consultant

Responsibilities:

• Managed and monitored data loads with full upload and delta mechanism.
• Monitored and implemented the solutions to the errors in the Production System.
• Extracted data by creating Infoset Query extraction method.
• Worked with functional consultant for mapping the source data (ECC) to target data source in BW.
• Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
• Scheduled Daily/Weekly/Monthly data loads.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.

Environment: SAP BW 7.0,SAP ECC 6.0, BEx Analyser, Query Designer, Web Application Designer.

Confidential

SAP BI Consultant

Responsibilities:

• Project preparation phase like gathering user requirements, performing GAP analysis.
• Worked on flat file extraction of master data and transaction data of Non-SAP R/3 systems into BW.
• Loaded custom hierarchies, from flat files, to enable drill-down reporting.
• Loaded the data from R/3 to BW and used Initialization with delta update and full update.
• Created Master Data InfoSources for Attributes, Texts and Hierarchies.
• Managed ODS & InfoCubes objects.
• Worked on Performance tuning of improving the load and read performance by maintaining indexes, partitioning, aggregates, and query properties by building Aggregates.
• Used BEx to create reports with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Published reports on web using Web Application Designer.
• Worked on User exits for customer requirements
• Created Process chains for effective scheduling of various processes
• Documented each stage of the project and attended status meeting every week
• Involved in data model design for acquisition layer, enterprise data warehouse layer, and architected data mart layer, reporting layer.
• Developed Specifications for Custom Reports, Interface, Data Conversion and Enhancement (RICEF)
• Identified and documented Source data to be extracted to Target Data warehouse system.
• Created and documented Transformation between Source System and Data Warehouse system with transformation routines(ABAP routines), calculations, formulas for ODS and Info Cubes.
• Created Process chains for all Master data and transaction data loading from acquisition layer to data warehouse layer, and finally to architected data mart layer.
• Transport the business object from developer environment to test and product environment.
• Worked on Creating Aggregates, Compressions, Indexes, multiproviders and parallel setups for data loading to improve performance and utilize data effectively.
• Extensively worked on Query Designer and Web application designer to create Queries to perform sales, delivery and billing analysis using Restricted Key Figures, Calculated Key Figures, Variables, filter and exceptions.
• Participated in planning, developing and documenting different Testing scenario ( Integrated testing, Performance testing, conversion testing, User Acceptance testing)
• Involved in documentation and end-user .

Environment: SAP BW 7.0,SAP ECC 6.0, BEx Analyser, Query Designer, Web Application Designer.