SAP BW Consultant with 8 yrs. of IT experience with strong Business Intelligence experience with various technologies like SAP HANA, SAP BW 7.3 , BI-ABAP and BI-BO for implementation and Application Maintenance projects. In SAP BW, worked on Functional areas like SD, MM, and TM, FI GL, AP, and AR . Also have ABAP/4 development experience as BW Analyst.

PROFESSIONAL SUMMARY:

• Worked in all phases of BW/BI full life cycles including analysis, design, development, testing, deployment, post-production support/maintenance, documentation and end-user training.
• Developed business process documentation including Technical Functional design documents and Gap analysis documents.
• Designed and developed various objects in BW like Info Objects, Info-cubes, DSO objects, Info-Source, Open hub, Multi- Provider, APD, Business Explorer, Process chains, Meta chains.
• Implemented complex business logics using Start routines, Field routines, End routines and Expert routines with ABAP.
• Good experience in using standard extractors including LO Cockpit extraction, Generic extractors using Table, View, and Function Modules and writing Customer Exits.
• Performed Data Extraction from flat files, BI as source and Non-SAP source like Oracle.
• Expertise in Reconciling data between BW and source systems, conduct the Unit, Integration, Regression, and UAT of the BI/ BW dataflow and reports
• Widely used BEx for building Queries and workbooks and preparing end user training documents.

• Expertise in front-end Components like BEx Queries, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Worked on User exits for various variables.
• Experienced in performance tuning Query Data Load using ABAP code re-validation and BW functionalities like Aggregation, Compression, Roll Up, BIA Indexes, and Secondary Indexes on DSOs.
• Good knowledge on Transports and Authorizations.
• Experience in efficiently using standard Business Content, extending and enhancing according to the report requirements.
• Worked on SAP HANA 1.0 project using various data modeling areas like Creation of various views like Attribute, Analytic, Calculation views, packages, schemas, data provisioning, users roles management, SQL Joins, transformation capabilities, filters, SLT replication and Objects migration from BW on RDBMS to BW on HANA.
• Good understanding of business environment, excellent communication skill and ability to work proactively in a fast paced environment.
• Excellent analytical skills.
• Communicate effectively with colleagues and business users.
• Enjoy working in a fast paced, high pressure environment.

PROJECTS SUMMARY:

Confidential

Role: Senior SAP BW/ABAP Consultant

Responsibilities

• Working in production environment, support production configuration and assisting in change management and defects.
• Service Level Agreements based ticket fixation and Respond to user requirements, problem resolution, develop designs, and process modelling
• Responsible for daily BI activities and SLA Management.
• Resolving the issues that occur during the Loads based on Severity Level.
• Responsible for Interacting with the Customer, Understanding Customer business requirements, analysis, technical design, development and testing of various global templates
• Daily Monitoring activities like Analysing ABAP Dumps, Update Monitoring, Alert Monitors, System Traces, Lock Entries Set Alert Threshold, and Operation modes.
• Adhere to good systems development methodology and prepared project related documentation functional design, technical design, test scripts during the different stages of a project.
• Analyse and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Interact with business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for BW Reporting and applications.
• Working on design and develop of Incident turned enhancements from functional areas like TM Transport Management , CS Customer service , MH Material handling and FI/CO.
• Perform analysis and design write technical specifications configuration and programming in SAP/BI environment, including testing and implementation.
• Design complex, custom BW solutions or component objects translating complex requirements into an optimal BW design.
• Perform routine program modifications, performance tuning, problem solving, debugging, and unit testing.
• Support the on boarding and training of BW Power Users. This includes providing technical training of key BW toolsets such as BeX web analysers, query designers, Business Objects.
• Worked in report components in Queries like Calculated Key Figures, Restricted Key Figures, filters, restrictions, Variables, Exceptions, Conditions and User exits.
• Conducted daily, weekly, monthly status meetings. presentations , resolution of issues and mitigation plans
• Re-modelling and enhancement of existing Objects in BI
• Validate Daily, weekly , Monthly data loads and reports
• Production deployment of new reports and maintain BI Reports documentation.

Confidential

Role: Senior SAP BW/BO Consultant

Responsibilities:

• Analyse and configure BW/BI 7.0 data environment to facilitate custom reporting and data analytics solutions.
• Built and enhanced 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, User Exits, BADI.
• Interacted with business to gather requirements, prioritized work, developed enhancements to the existing system,
• Coordinated testing, and performed change management/training for BW Reporting and applications.
• Worked on Inventory data sources like 2LIS 03 BX, 2LIS 03 BF and 2LIS 03 UM
• Worked on comprehensive process of Order to Cash cycle posting and reporting
• Good functional knowledge of Sales Distribution Sales Orders, Deliveries, Billing MM Purchasing Inventory Management , FI and general business process of SAP R/3.
• Worked on creating, modifying and configuration of BADI's Objects.
• Develop and drive the implementation of BW best practices and standards for the team.
• Supported the on boarding and training of BW Power Users.
• Worked extensively on BO UDT and Web Intelligence.
• Created and maintained Business Objects reports in Web Intelligence Info View.
• Designed and developed standard reports, cross-tab reports.
• Prepared test cases for Unit testing created various test cases to validate the data, performance and look feel of the reports.
• Displayed data using remote cubes and pulling data from SAP BW using Open Hub Service using Info spokes and transferring the data to non-SAP systems.

Environment: SAP BI 7.0, SAP 3.5, ECC6, SQL Server, BeX Analyzer

Confidential

Role: Senior BW Developer

Responsibilities:

• Designed both functional and technical specifications.
• Involved in development of Cockpit objects for query analysis.
• Involved in enhancement of the data sources in order to add new field as per client requirement.
• Populated the historical data for new info object in info cube by using re-modelling method.
• Designed user's manual for training.
• Worked on comprehensive process of Order to Cash cycle posting and reporting.
• Worked on simplified Order to Cash cycle like order-to-invoice and invoice-to-cash
• Worked on SD business processes OTC and sales order processing, Delivery, shipping and billing
• Day to day interaction with the end users collecting information and to further discuss any issues on the reports
• Responsible for design of the data flow and developing DSOs for Line items, Info Cubes for summarization, and Multi Providers for Cross reporting
• Built new DSO's info Cubes, multi-providers to support SD, FI, GL, AR, and AP reporting requirements.
• Enhanced extract structures for Master Data to bring additional fields in to BI and created custom Data Sources for transaction data to meet the business requirements.
• Developed Paid GL Line Items, AR Monthly, and Budget vs. Plan workbooks to automate the close process for AR and GL teams
• Developed new BEx Queries, workbooks based on the different Info Providers
• Maintenance of Hierarchies Structures
• Create CKF and RKF as needed and adopt performance on all queries
• Created queries in Query Designer and deployed to the Portal
• Activated required BW Statistics Objects and created a virtual Cube that is required for Reports.
• Developed process chains to automate the initialization and delta updating of all data.
• Created over BEX queries and assigned them to roles by department.

Environment: SAP BI 7.0, SAP 3.5, ECC6, SQL Server, BEx Analyzer

Confidential

Role: BW Offshore lead

Responsibilities:

• Worked on Lo Cockpit and performing necessary procedures like setting up of update Mode, deleting set up tables, filling up of set up tables and loaded data from SAP ECC to SAP BI.
• Scheduling and monitoring of Data loads.
• Maintaining reconciliations to verify the data in SAP R/3 and SAP BW are same or not after the data loads.
• Worked on Creation of Process chains.
• Testing the reports with data and Rectified the issues occurred.
• Involved in performance enhancement features such as cube partitioning, Indexing, maintaining aggregates and compression.
• Set up periodic Data loads from legacy system flat files
• Creating and managing dataflow using DTP, Transformations and info packages.
• Designed and developed queries to generate reports in BEx Designer
• Involved with performance tuning of queries by compression, repartitioning of info cubes.
• Created aggregates for info cubes to improve query performance.
• Created new and linked universes.
• Created Master detail, Charts and Cross-tabs reports to view data in an analysed way.
• Involved in developing finances KPI reporting
• Developed 34 process chains to automate the initialization and delta updating of all data
• Working on various routines and enhancement ABAP coding
• Utilized new BI 7.0 transformations and DTPs for all new developments.
• Utilized the Analysis Process Designer APD to populate summary cubes using complex queries on other cubes.

Environment: SAP BI 7.0, SAP 3.5, ECC6, SQL Server, BeX Analyzer