SUMMARY:

• Around 8.5 years of professional experience in design, development, implementation using SAP BW.
• Worked in 4 complete life cycle Implementations from blueprint to production support.
• Extensively involved in business requirement gathering, GAP analysis and converting the business requirements into preparing the functional specification accordingly.
• Worked in implementing SAP HANA/BI solution involving over all solution architecture, design and deployment of business intelligence projects and also expertise in handling production support issues which includes fixing data issues, root cause analysis.
• Expert in recommending best approaches/practices to clients and also evaluating tools to support business and technical requirements.
• Extensively worked in supporting large user group in training, developing user manual and navigating users in different report requirements.
• Strong domain knowledge in Supply chain (SD, MM, IM), Finance business areas.
• Extensively worked on Modelling, extraction, reporting using SAP BW.
• Experience in define Design Documents for HANA Models (Information Views), Security Management including User Roles and Privileges.
• Extensively worked to create Attribute View based on Master Data, Analytical View based on measures & attribute view, Calculated View based on combination of tables, column views, Attribute Views and Analytic Views.
• Experience in Calculation Views (Graphical and SQL Script Using CE Functions) by creating joins, unions, projections and aggregation levels based on the business logic.
• Experience in Developing Stored Procedures using SAP HANA SQL - Script - CE Functions & SQL Script Debugging.
• Experience on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Packages, Table definitions, Attributes (Simple, Calculated, Local), Measures (Simple, Calculated, Restricted, Counters) and Hierarchies, Input Parameter, Variables, Data Foundation, Semantics, Performance Analysis etc.
• Experience in Data Provisioning Using Trigger-based replication (SAP Landscape Transformation (LT) Replication Server), SAP HANA Direct Extractor Connection (DXC) and ETL-based replication (SAP DATA Services - BODS).
• Experience in data provisioning using SAP BODS to HANA from a SAP and Non-SAP Sources like Microsoft Server Environment.
• Expertise in Report Generation - Worked extensively in BEX Analyzer, WAD in building Queries, Workbooks and created Custom Queries using Conditions, Exceptions, Variables .
• Extensively worked in creating work books, variable exits and Report to Report Interface.
• Strong experience working with BO tools Universe Designer, Web Intelligence and developed BO Reports using BICS connection and also expertise in promoting jobs across environments using LCM.
• Extensively worked in creating complex LO extractors, enhancing the extractors.
• Expertise in Performance tuning of Queries by maintaining Aggregates, Compression, Partition, Indexing of info cubes, OLAP cache.
• Strong production support experience involving data load monitoring, data load fixes, improving loading performance etc.
• Extensively worked under Onsite/Offshore model for support activities.

TECHNICAL SKILLS:

ERP: SAP R/3 4.6C and ECC 6.0

Functional Skills: MM, PP, SD,IM, PS, FI, PC and FI/CO-PA

Data Warehouse: SAP BW 3.1/3.5, and SAP BI 7.3/7.4

Data Base: MY SQL Server 2000/2008, Oracle 8i, 9i, 10g and MS ACCESS,HANA

Reporting Tool: BEX Analyzer, WAD, BOBJ, webi, Analysis for Office

WORK EXPERIENCE:

Confidential

Environment: SAP BW 7.3/BI7.4, ECC 6.0, Business Areas: SD,MM, IM, FI,PS

SAP BW-HANA Consultant

Responsibilities:

• Worked in requirement gathering, documenting the requirements, Designing, implementing the solution for different complex Requirement and then support the application.
• Involved in design and architecting landscape of the complete BW system and also good in understanding challenges of business users and provide solution accordingly using SAP BW/BO.
• In depth functional knowledge in areas of SAP SD, MM, FI, COPA, IM, PS.
• Involved in writing the technical specifications, standard modeling and Implementation, documentation for HANA.
• Performed Data Modeling and developed Analytical Views for the transactional data, Attribute Views for the master data, and the Calculation Views as final model in HANA Studio.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using the Real-time SLT Process
• Extensively worked to create Attribute View based on Master Data, Analytical View based on measures & attribute view, Calculated View based on combination of tables, column views, Attribute Views and Analytic Views.
• Experience in Calculation Views (Graphical and SQL Script Using CE Functions) by creating joins, unions, projections and aggregation levels based on the business logic.
• Experience in Developing Stored Procedures using SAP HANA SQL-Script - CE Functions & SQL Script Debugging.
• Created the necessary Calculated Attributes, Restricted Measures, Calculated Measures and Input Parameters using the HANA studio tool.
• Extensive knowledge in Displaying Audit Trails of Information Models, Export/Import of Models, Activating Impacted Objects, Checking Model References, Comparing Object Versions.
• Experience to set Modeler Preferences like Case Restriction on attribute view, analytic view, calculation view, procedure and Field Name Preferences, specify a location for job log files.
• Used the HANA studio Functions like Conversion, String, Mathematical and Date to suit the business requirements in Calculated Attributes and Calculated Measures.
• Involved in importing the BW models from SAP BW system (using HANA DB) to the HANA Studio as Analytic views and Calculation Views.
• Understanding the existing SAP BW Models and documenting the business flows in SAP HANA.
• Created the Analytic Views based on the Info cube models in SAP BW/BI system.
• Created the Graphical Calculation Views by including the Analytic views using Unions, Projections and Joins based on the business logic.
• Worked on designing SAP BW data Flows (DSOs, Transformation and DTPs) in the BW (on HANA database) Scenarios and imported the DSOs, Info cubes to the HANA studio tool.
• Revived and resolved both Front end and Back end performance issues.
• Extensively worked on BOBJ WEBI reports. Developed Business Objects WEBI reports with filters, ranks, prompts, drill downs, variables, charts, text cells, cross-tabs.
• Developed complex webi reports using merged dimensions, multiple queries, filters and functions.
• Worked on post go live production support in monitoring data loads, fixing and improving performance of load issues and investigating in finding root cause for data issues and worked extensively on support tickets.

Confidential

Environment: SAP BW 3.5/BI7.0, ECC 6.0, Business Areas: SD,MM, IM, FI,PS

SAP BW Consultant

Responsibilities:

• Worked in requirement gathering, documenting the requirements, Designing, implementing the solution for different complex Requirement and then support the application.
• Involved in design and architecting landscape of the complete BW system and also good in understanding challenges of business users and provide solution accordingly using SAP BW/BO.
• Worked in the Informatics Project and helped the team for the development of the Daily,Weekly, and Monthly deliverables of Sales, Purchasing, Material Management, FI reports to the users.
• Contributed to all aspects of SDLC including gathering of requirements, creating the functional specs and technical specs, building of back-end and front end objects including Cubes, DSO’s, Transformation’s, Data Source’s and also review designs, data validation, upgrades, UAT testing and training to the end users.
• Migrated the data flows from BW 3.5 to BI 7.0 and worked with the 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL, OFI GL 4 data sources and extracted the data to the BI Cubes 0PUR C07, 0PUR C08, and 0PUR C09 and also the finance targets.
• Developed the GL Reports, Purchase order quantity confirmed as requested, Purchase order items confirmed as requested, Purchase orders confirmed as requested, Invoice variances Bex Reports based on the requirement.
• Created and deliver presentations to the senior management for both technical and non-technical subject matters.
• Create, maintain, monitor and execute the BW/BI process chains as per the requirements.
• Analysis of the Production issues, data issues, technical, process issues, upgrading the objects, Queries and provided support to Business Users in a timely manner after Go-Live.
• Co-ordinated with the Basis, Security and other teams in the Go-live and upgrade stages.
• Documented any changes, issues as required following the SDLC practices and Suggesting any design changes for the Performance improvements.
• Extensively worked on BOBJ WEBI reports. Developed Business Objects WEBI reports with filters, ranks, prompts, drill downs, variables, charts, text cells, cross-tabs.
• Developed complex webi reports using merged dimensions, multiple queries, filters and functions.
• Enabled OLAP Cache for all info providers and Query’s to improve Bex Query performance.
• Developed flexible queries with variables using filters, Navigational attributes, Restricted Key figures, Calculated Key figures, Reusable structures and Currency translation factors in bex.
• Worked on post go live production support in monitoring data loads, fixing and improving performance of load issues and investigating in finding root cause for data issues and worked extensively on support tickets.

Confidential

Environment: SAP BW 3.5/BI7.0, 46C,ECC 6.0, Business Areas: SD,MM,IM,FI,PS

SAP BW Consultant

Responsibilities:

• Involved in the overall design and implementation of SAP Business Intelligence solution which includes gathering requirements, analysis, design, development, performed reviews, support and tuning of large, complex integrated reporting systems.
• Participated as a development team member in projects requiring extensive data analysis skills and data migration tasks
• Applied deep understanding of SAP BW to design solutions, troubleshoot issues both on the SAP BW and Business Objects side to maintain satisfactory report generation performance.
• Expert in evaluating and recommending best approaches and tools to support business and technical requirements.
• Worked extensively on standard and custom defined LIS, LO extractors. Used LO structures for extracting sales order, delivery billing information and also Generic for some complex requirements.
• Involved in technical upgrade and functional upgrade from BW 3.5 to BI7.0
• Written Customer Exit Variables for calculating values with the help of the user entry variables.
• Expertise in using Analysis Process Designer to provide solution for complex business requirements.
• Involved in setting up a process to in integration SAP BW to SQL server and Oracle data bases using UD connect and DB connect.
• Involved in production activities like data load monitoring, fixing load failures, improving load performance, PSA clean up, table space tracking etc.
• Worked on improving load and reporting performance using APD(load) and BI accelerator, aggregates, re-partitioning.
• Extensively worked in ABAP to build report on system tables, function modules for generic extractors.
• Extensively used Information Broad casting to broad cast month end reports to different user groups.
• Involved in functional testing and performance testing of various projects. Benchmarked all High volume projects before migrating to Production.
• Created Information Broadcasting settings on queries to broad cast to mail box, Fill OLAP Cache and published reports to user groups to validate the recent data loaded to BI.
• Developed various RRI / Jump Targets using RSBBS and use customer exits for unique requirements.
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE .

Confidential

Environment: SAP BW 3.5, SAP R/3 4.7 Business Areas: SD, FI, COPA

SAP BW Consultant

Responsibilities:

• Expertise at understanding business requirement and provide solution to improve business process and also convert business requirements into Functional and technical documents.
• Involved in developing complex start routines, update routines so as to meet different business requirements.
• Involved in design and building of Cubes, ODS, Multi Providers, Remote Cubes, Info sources.
• Worked on CO-PA, LO, generic extractors and worked on enhancing standard extractors to meet customer requirement.
• Worked on R3 extractors Generic and FI extractors and enhancing them to meet business requirements.
• Worked on activating the standard business content Info Cube Customer, Sales Overview, Purchasing Data and Vendor Evaluation.
• Developed various data extraction procedures for master data (full and delta load) and transactional data (full and delta) using LO Cockpit and generic extractors for customer-defined tables.
• Created Process chains and designed a mechanism to trigger the process chains when a file arrives in application server.
• Extensively worked on query performance techniques using aggregates, partitioning, Compression.
• Involved in extracting and enhancing master data and transactional data sources.
• Involved in setting up process for reconciliation of data between source and data ware house.
• Used calculated and Restricted Key Figures, restricted characteristics, structures, variables and conditions for the queries.
• Involved in design and developing solution to fix data in a data target using business riles.
• Developed Info spokes and implemented BADI on different data Targets to extract the data as a part of data corrections.
• Recommended and implemented long term solutions to improve the query and load Performances.
• Attended all High priority issues in production and resolved successfully.
• Developed Intercompany reinsurance prototype to replacing the statutory reporting that comes from the Orion Database. Intercompany transactions move all balances. This consists of statutory analysis as well as Schedule P reporting.
• Extensively worked on APD to improve reporting performance for YTD, ITD, reports.
• Built new queries and workbooks on different data Targets and also involved in creating new variable and user-Exits for the same.
• Involved in solving production support issues like load failures, Rollup, Indexes, change run.
• Involved in house keeping activities of the production system like keeping track of table spaces, Index analysis, ST03, ST04.
• Revived and resolved both Front end and Back end performance issues.
• Involved with performance tuning of Queries by maintaining Aggregates, Compression, partition and indexing of Info Cubes.
• Developed data marts of transferring data from daily inventory cube to weekly inventory cube.
• Used ODS to stage the data before transferring the ODS contents to the InfoCube, ODS reporting to give details of delivery items and schedule line items.
• Modified extract structure to add social security number and coded user exit EXIT SAPLRSAP 002 to extract this data to BW.
• Monitoring data loads and fixing failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded to ODS.
• Developed various RRI / Jump Targets using RSBBS and use customer exits for unique requirements.
• Resolved Query Performance issues using transactions such as RSRT and RSRTRACE .
• Involved in improving the performance of the queries using OLAP cache.
• Written ABAP interface to trigger events in process chain based on back ground job status for creating Index jobs and PSA deletion jobs.
• Focusing on creating Test Plans, Unit Testing, Integration testing, Extractor testing and enhancements.