SUMMARY:

• Having Overall 15 years of Professional experience in which around 13 years of Professional experience in SAP BW/SAP BW on HANA/ HANA/ BOBJ.
• Excellent Team Handling Experience which I came across from Associate consultant roles to Solution Architect.
• Managed a BI team from operational perspective meeting internal & external SLAs.
• Worked in Countries India, UK, Chile, Kingdom of Saudi Arabia (KSA) and USA.
• Responsible for management of the project tasks and activities, including resource coordination, status tracking and communication of project progress and issues.
• Ability to develop & maintain effective relationships with stakeholders & business partners.
• Ability to effectively lead, build, deliver, and execute complex global BI initiative.
• Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL,
• Report Designing and Development, Production Deployment/Support and End - User Training.
• Expertise in SAP BW, SAP BW on HANA, SAP B4HANA, SAP MODELER and SAP BOBJ.
• Experience in Requirement gathering, Gap analysis, design, development, testing, documentation, maintenance, troubleshooting and Performance tuning.
• Working experience on SAP BW 7.4 and SAP BW 7.5.
• Having Good Experience on Migration to BW on HANA- Pre Migration Activities, Post Migration Activities and HANA Optimizations for Performance Tuning.
• Good understanding of LSA and LSA++.
• Extensively worked on Data Wares housing workbench Confidential Objects, Confidential Cubes,
• Classical DSOs (Standard and Write Optimized), Advanced DSOs, Composite Providers, Transformations, DTPs, Open Hub services.
• Expertise on Eclipse Modeling of Advanced DSOs, Composite Providers and Open ODS views using BW Modeling Tools in HANA Studio.
• Strong Experience Hybrid Modeling - BW Data Models with Native HANA Modeling Artifacts and vice versa.
• Experience with SAP HANA Data Modeling Artifacts - Attribute Views, Analytic Views and Calculation Views in HANA Studio.
• Good Experience on SQL Scripting for Calculation Views, Stored Procedures, Variables and Input Parameters,
• Calculated and Restricted Columns, Dynamic Parameters using Input Parameters, Currency Conversion, Hierarchies.
• Capable of creating highly complex transformations including development in ABAP/4
• Programming, comprising of Start routines, Field routines, End routines for data load processes involving multiple layers of data targets.
• Expertise in OLTP extraction from SAP R/3 using LO Cockpit, CO-PA, FI AR, AP and Generic Extraction also data from flat files.
• Worked extensively on Logistics (PP, PM, MM, QM and SD) and generic data extractions.
• Worked extensively on HCM, SCM, FI-CO and CRM, SRM.
• SAP HANA Data Provisioning using SAP Landscape Transformation Replication Server ( SLT).
• Expertise on Reporting using BEx Query Designer, BEx Analyzer, Analysis Office for Microsoft Excel, WebI, Design Studio and SAP Lumira.
• Expertise in development of Queries in BEx Query designer using Filters, Calculated and Restricted key figures, Structures, Variables (Char, Text, Formula, Hierarchy and Hierarchy Node) with processing types (Manual Entry, Replacement, SAP Exit, Customer Exit and Authorizations), constants,
• Exceptions, Conditions, Cell restrictions, RRI, Currency Conversions, Hierarchies and display in BEx Analyzer.
• Expertise in Reporting using Analysis Office for Micro soft Excel for Pivot Reports.
• Having Good Experience in Broadcasting of Queries, Workbooks and Web Templates to various audiences and to the Portal.
• Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
• Created Universes on top of HANA Calculation views and developed the Webi reports and dashboards using IDT (Information design tool).
• In WebI developed Adhoc Reports with BEx Queries as source using BICS Connection.
• Hands on experience on new SAP Business Objects 4.1 client tools like Information Design Tool, BI Launch Pad, Dashboard Design, Crystal Reports Enterprise etc.
• Experience in Creating Story Boards using SAP Lumira.
• Experience in Development of Dash Board Reports using Design Studio.
• Having Good Knowledge on Tableue.
• Extensively trained the end user for BEx and BOE reporting capabilities and also prepared end user training Materials.
• Expertise in Production Support issues which involved debugging ABAP routines, Data loads, Validation and troubleshooting of
• Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles Security, System Checks.
• Expertise in Support Projects - Load Monitoring using Process Chain, High Priority Tickets Resolving using Remedy/Peregrine/HPSD,
• Housekeeping Activities, Service pack upgrades testing activities etc.
• Good exposure to Project Management activities and involved in all the phases of Project Management & experience of helping Practice Heads/Sr Managers in building the Proposals and handling Requirement gathering workshops.

TECHNOLOGY EXPOSURE:

Key SAP Skills: • BW, BW on HANA, SAP B4HANA, HANA, ECC

Key BOBJ Skills: • IDT, Webi, Lumira, Analysis Office, Design Studio, Xcelsius

Key ETL Skills: • Data Services, SDA, SDI/SDQ, SLT

Key DW Skills: • SAP BW, SAP HANA, SQL Server

Programming Language: • ABAP, SQL, PL/SQL, T-SQL

WORK EXPERIENCE:

Confidential, NJ

Sr SAP BW/HANA Technical Lead Consultant

Responsibilities:

• Leading the overall SAP BW engagement in onsite/offshore capacity.
• Manage Client expectation and status reporting.
• Lead a team of 15 people from off-shore.
• Collaborating with process partner organizations to gain an in-depth understanding of their business information requirements and then designing, documenting, developing and testing complex HANA data models that assimilate data from multiple sources system (SAP and non-SAP) to effectively and efficiently solve business requirements.
• Responsible for Onsite/off-shore Coordination, preparation of detail design, code walkthrough, resolving technical and design issues and performing independent unit testing.
• Requirement gathering from Business and preparation of Functional Specs and Technical Specs.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Experience utilizing SAP Landscape Transformation (SLT) for real-time and non-real time) data replication from SAP ERP or non-SAP systems
• Worked on Stored procedures and scripted calculation views.
• Development of New Data Flows and Reports as per the RFCs (Request for Changes).
• Timeline Estimation for the Changes.
• Reviewed existing BW standard documentation to add some recommendations.
• Architecting a solution for supporting a requirement for BW/BI.
• Troubleshooting data and technical issues related to SAP BW.
• Managed Client BW environment to co-ordinate development, testing and transports to Production.
• Handling of Front end Tickets raised by Business and resolving them as per the SLA.
• Meeting the SLAs to deliver the reports to the business users.
• Broadcasting of Reports to the Portal and Email as per the Business requirement.
• Primarily focused on Front end reporting (Work books, Web templates, Dashboards) on SAP BW along with its integration with SAP Portal, KM and third party tools like Business Objects.
• Supporting the Offshore team in resolving the issues for Data Loads.
• Preparation of Metrics for Monthly Meetings with BUIT.
• Involving in CAB (Change Approval Board) meetings and presenting the RFCs for Business Approvals.
• Performance Tuning Activities for improving the Loads and Reports.
• Housekeeping Activities to keep system in Healthy condition.
• Preparation of POCs (Proof of Concepts) in Sand Box for HANA Migration.

Confidential, Camden, NJ

Sr SAP BW/HANA Technical Consultant

Responsibilities:

• Interacting with various internal business users & stakeholders to implement BW/BOBJ reporting projects from initial scope definition through analysis, design, implementation and On-going support.
• Prepared the Project Chart, Requirement gathering from the Business users, Creating the WBS to the team and Distribution of work.
• Data base Migration Activities from MS SQL to HANA DB.
• Worked on BW 7.5 version.
• Prepared Cutover Activities, Pre-Migration Activities and Post Migration Activities for Database Migration.
• Preparation of Test Cases for Testing after Migration.
• Worked on Performance Tuning Techniques to Push down HANA Transformation logic into HANA Data Base.
• Developed Confidential Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views, Calculation views.
• Developed HANA Modeling Artifacts - Attribute Views, Analytic Views and Calculation Views.
• Development of Hybrid Models by consuming BW Models into Native HANA.
• Used the Report /SDF/HANA BW SIZING to estimate the memory requirements of a BW system after migration to SAP HANA.
• Used the Report ZBW TRANSFORM FINDER to Analyze and remove unnecessary Confidential Cubes.
• Requirement gathering from Business units.
• Estimating the timelines for RFCs (Request for Change).
• Worked on Demand to Planning (D2P) and Procure to Pay (P2P) for Snapshot week Reports.
• Responsible for programming, testing, debugging, and documenting simple to moderate to highly complex ETL applications using SAP BW.
• Extraction of Data from SAP ECC (Generic and LO Extraction) and development of ABAP programs with SAP BW.
• Maintain and modify existing ETL applications and corresponding documentation.
• Develop new ETL processes of simple to moderate to highly complex scope and contribute to design specifications, using company standards, procedures, and techniques.
• Assist in the development of test plans for assigned projects.
• Development of New Reports or Modification of existing Reports as per the Business Requirement and Testing.
• Involving in House-keeping Activities and Performance Tuning and Optimization.
• Co-coordinating with different functional teams in SAP SD, SAP MM, SAP PP, SAP FI-CO.
• Designed Data flow architecture for Master& Transaction data.
• Development of Field, Start and End Routines using ABAP in the transformations for loading the data.
• Developed ABAP code for variables with customer exits.
• Developed BEx Queries using Variables, Conditions, Exceptions, Exception aggregation, Cell editors, Customer exit variables, Confidential and CKFs and Structures developed complex custom reports.
• Performance Tuning of Reports.
• Developed Sales Trending Reports using Offsets in BEx Query Designer.
• Worked on Currency Conversions in the Reports.
• BW Security - Worked Analysis Authorizations (RSECADMIN) for BEx Reports.
• Designed Web Intelligence Reports on SAP BW / BEx queries using BICS connection.
• Developed IDT Universes for WebI Reporting.
• Worked on Change & Transport Management of BW objects across the Landscape.
• SAP HANA Data Provisioning using SAP LT Replication Server (SLT).
• Developed Process Chains for load Monitoring and are scheduled to run periodically.
• Helping the Support team in handling load monitoring and Data mismatching issues.
• Development of Proof of Concepts (POCs) in Sandbox before starting the Actual development.

Confidential

SAP BW/HANA/BO Consultant

Responsibilities:

• Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL, Report Designing and Development, Production Deployment/Support and End-User Training.
• Involved in Data base Migration from MS SQL to HANA DB.
• Prepared Cutover Activities, Pre Migration Activities and Post Migration Activities for Data base Migration.
• Developed Models as per LSA++ Architecture in BW on HANA.
• Developed Confidential Providers using HANA Studio such as Advanced DSOs, Composite Providers, Open ODS Views, Calculation views.
• Involved in Data Model Design for Open ODS layer and Reporting layer.
• Worked on Performance Tuning Techniques to Push down HANA Transformation logic into HANA Data Base.
• Used the Program RS DYNTIER CHANGE to select and change the multi-temperature category of Data sources, write-Optimized DSOs.
• Development of Hybrid Models by consuming BW Models into Native HANA.
• Designed Data flow architecture for Master & Transaction data.
• Developed Field, Start and End Routines in the transformations for loading the data.
• Developed HANA Modeling Artifacts - Attribute Views, Analytic Views and Calculation Views.
• Worked with variables, Input Parameters, Calculated and Restricted Columns, and Currency Conversion in Calculation Views.
• Developed Stored Procedures with dynamic calling of Calculation views as per the requirement.
• Performance Tuning in HANA.
• Involved in SAP HANA Security including Object Privileges, Analytical Privileges.
• Extracted data from Calculation Views into SAP BW with the ODP (Operational Data Provider) Functionality.
• Developed Complex Calculation views using SQL Scripts.
• Requirement gathering from Business units.
• Estimating the timelines for RFCs (Request for Change)
• Doing Gap Analysis between the existing solution and the business requirement.
• Worked on SAP HR Module, Installed Business Content for Head Count and Personnel Actions ( Confidential cubes 0PA C01, 0PA C02 and Data sources 0HR PA 0, 0HR PA 1 and 0HR PA PA 1), designed BEX reports and Dash Boards as per the business requirement.
• Developed Headcount/Change in Staffing Level Reports, Comparison Previous/Current Year, 4 Quarter Comparison, 12 Month Comparison Previous Year, 4 Quarter Average, 12 Month Average Previous Year Reports for HR.
• Developed IDT Universes for WebI Reporting.
• In BEx Query Designer using Variables, Conditions, Exceptions, Exception aggregation, Cell editors, Customer exit variables, Confidential and CKFs and Structures developed complex custom reports.
• Performance Tuning of Reports.
• Developed Sales Trending Reports using Off sets in BEx Query Designer.
• In WebI Developed Adhoc Reports with BEx queries as source using BICS connection.
• Worked on Performance Tuning and Query Optimization.
• Created reports linking several universes for different subject areas like Purchase Orders, Accounts Payable, Pharmacy and Inventory for seamless reporting.
• In WebI, Created user Prompts, Conditions and Filters and used Alerts to improve the readability of the report. Extensively used Calculations, Variables, User Objects in the creation of reports.
• Created Canned Reports with various complex features, created charts and templates.
• Applied security features of Business Objects like row level, report level & object level security in the universe so as to make the sensitive data secure.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of the reports.
• Worked on Analysis Authorizations part of Security for BW Models.
• Worked on Analytic Privileges for HANA Information Models.
• Developed Process Chains for load Monitoring and are scheduled to run periodically.
• Helping the Support team in handling load monitoring issues.
• Involved in Incident Management and Change Management.
• Prepared End user Training Materials for Reports.
• Worked on SAP Confidential Manager (LCM), transported objects from one environment to another using this brand new tool.
• Developed the Proof of Concepts (POCs) in Sandbox before starting the Actual development.

Confidential

SAP BW/HANA Specialist

Responsibilities:

• Designed the Functional Specs and Technical Specs following the Blue print.
• Use of SAP BW 7.4 on HANA objects for modeling.
• Modeled and developed BW infoproviders on BW 7.4 on HANA after migration to HANA in accordance with LSA++ architecture.
• Developed Confidential Providers using HANA Studio such as Advanced DSOs, Open ODS Views, Composite Providers, Attribute views, Analytical Views and Calculation views.
• Designed the DFD Data Flow Diagram to Load the data from the source system to BW Reporting layer.
• In BW 7.4, designed the data flow to load the data for 15 sales companies using SPO (Semantically Partitioned Objects).
• Using HANA Studio, Modeled HANA Information Artifacts, Attribute, Analytic and Calculated Views
• Developed Field, Start and End Routines in the transformations for loading the data.
• Developed Weekly Reports, Monthly Reports, Days of Supply Reports and Pivot Reports and also developed the work books.
• Worked with SAP HANA LIVE Virtual Data Models.
• Involved in Unit Testing, System Integrated Testing SIT and User Acceptance Testing UAT .
• Transported the objects from Development to Production through Quality system.
• Created Authorizations for users to access only the corresponding company codes data.
• Created complex formatted Web reports using Web Intelligence.
• Involved in cutover activities for Go Live.
• Involved in the preparation of Health reports for the project Management.
• Ensure quality and timeliness of the Deliverables.
• Worked on BEx Query Designer, BEx Analyzer to develop various queries based on user requirements as well as utilization of business content related queries and workbooks.
• Using BEx Query Designer Formula variables, Conditions, Exceptions, Exception aggregation, Cell editors, Customer exit variables and Structures for developing complex custom reports.
• Worked with RFK’s and CKF’s in the queries.
• Designed and created reports using Web Intelligence (Webi) in Business objects.
• Designed Web intelligence Reports on SAP BW / Bex queries using BICS connection.
• Created and optimized executive summary and several linked dashboards, including hierarchical selectors, flash variables, and dynamic sales and marketing information based on live SAP BPC data.
• Process Chains are developed and scheduled to automate the regular Data loads.
• Involved in Support pack up gradation Testing Activities.
• Coordinating development between offshore and onsite teams. Interactions and dependency handling with Test team, Users for UAT.
• Status reporting to management and steering committee teams.

Confidential, Santiago, Chile

Sr. SAP BW/BO/HANA Technical Lead

Responsibilities:

• Involved in full Confidential implementation of BW 7.4 in SD, MM, AND FI modules.
• Successfully implemented Advanced DSO, Open ODS Views and Composite Providers for data flows with complex transformation look-ups and composite provider is used for reporting layer.
• Implemented Smart Data Access (SDA) solution for virtualizing data from Oracle, MS SQL Server
• SAP HANA Scripted calculation views accesses and aggregates millions of source data records in Real-time there by eliminating multiple data copies and achieving 100% virtualization
• These scripted calculation views were exposed to BW environment via Open ODS view promoting LSA++ architecture
• Worked on Data Modeling, Data Extraction, Data transformation, Data Loading, Scheduling jobs, Monitoring data loads and Reporting.
• Built statistics for virtualization scripts and implemented scripted calculation views for successfully pushing all filters onto source database. Analyzed SQL Script queries thoroughly with Planviz perspective to achieve optimized SQL plans. Performed source data profiling and Join-relocation has been examined.
• Involved in Architecting the entire BI-HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) exposed to frontend layer implemented with SAP BO.
• Customized Confidential Cubes and Start Routines. Installed Business Content,
• Performed Generic data extraction, Data Loading (Full/Delta Up-Load), Scheduling, Monitoring, Performance tuning and extracting.
• Worked extensively on Data Modeling design like creating Confidential Objects, Confidential Catalog, Confidential Cubes, DSO, MultiProviders, Confidential Sources, Confidential sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
• Worked on generic data extraction in CO-PA. Extracted Line Item data from GL, AR and AP.
• Extracted data from MM (Stock Initialization - “2lis 03 BX” data sources).
• Extensively worked in performing customer, vendor analyses in BW, and integrating data from Teradata to BW using UD Connect.
• Worked on BEx Analyzer, BEx Query Designer and WAD (Web Application Designer) tools to generate reports related SD, MM, and PP.
• Involved in Support pack up gradation Testing Activities.
• Used BEx Query Designer to Create Queries with Variables, Filters, Calculated Key Figures,
• Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI/BW Data Targets to Generate Reports.
• Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for
• Webi reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.
• Designed Web intelligence Reports on SAP BW / Bex queries using BICS connection.
• Generated BO Reports involving Complex Queries, Sub Queries, Unions and Intersection.
• Exported Universes to the Repository to make resources available to the users.
• Generated BO Reports based on time like Year, Quarter, Month and week based on Company code and Comparative reports.
• Reviewed all SAP MM reports and carried out modifications as per Clients requirements.
• Developed customer exit for variables and coded in user exit for BEX reporting.
• Data Load Monitoring using the Program /SSA/BWT and fixing the loads if get failed.
• Helping the Support team in handling load monitoring issues.
• Involved in Change Management and Problem Management for Handling of Tickets.

Confidential

SAP BW/BO Technical Lead Consultant

Responsibilities:

• Worked on Data Warehouse Workbench - Confidential Cubes, DSO Objects, Confidential Sources,
• Transformations, DTP Confidential packages, Data sources, Business Content & Data Marts, process chains to suit the Business requirements, ERP, LO Cockpit, Generic Extractions, Master and Transactional data Extraction, Activating Data sources, Setting of V3 update, deleting setup tables and filling up of setup table.
• Worked closely with Production Planning (PP), material management (MM), Sales and Distribution (SD), Logistics (LE), Financials (
• FI) - AP, AR, GL teams involving SAP and Non-SAP team members in creating Order-To-Cash (O2C), Procure-To-Pay, Point of Sale (POS) data via BODS and other integrated solutions.
• Involved in transporting objects from Development to quality and quality to production.
• Designed queries in BEx Query Designer and Restricted key figures, Calculated key figures, Variables, Filter, Free Characteristics, RRI.
• Exclusively Involved in Performance Related issue - Improved data load and query performance using compression, Statistics, aggregates, partitioning and BWA.
• Expertise in day-to-day activities like Scheduling, Monitoring process chains for daily Master data and Transaction data,
• Changing and activating reports as per the requirement, Handling Tickets, Data load failures and co-ordination with UC4 team.
• Worked on Warehouse Architecting reporting requirements into technical design and development.
• Created Confidential providers &BEx queries to simulate/validate results achieved from Design Studio reports.
• Worked on LO extractors 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 12 VAHDR, 2LIS 12 VAITM, 2LIS 13 VAHDR, 2LIS 13 VAITM, 2LIS 02 HDR, 2LIS 02 ITM & 2LIS 02 SCL.
• Designed and developed cubes and DSO 0SD C01 (Customer), 0SD C02 (Delivers), 0SD C03 (Deliveries), 0SD O01 (Order Items), 0SD O02 (Returns Items), 0SD O03 (Returns Items) adding

Confidential

SAP BW/BO Lead Consultant

Responsibilities:

• Interacted with Subject Matter Experts (SME), Business Analysts and Users for preparation of Data Modeling, Business Content, Granularity and Queries design.
• Worked extensively on customization of SD Confidential Cubes as per the User Requirements.
• Designed Data flow architecture for Master & Transaction data.
• Worked on Extracting Business partner master data from CRM coming from SCIMS legacy system Maintained in MDM the system of entry.
• Worked on custom extractors as well as business content extractors for both master data and transaction data.
• Enhanced the Data Source for adding new fields in the Extraction Structure according to requirement through User Exit CMOD.
• Worked on Data flow architecture of Business partner for master data reporting requirements.
• Worked on CRM WEB Client UI creating test data in the development to leverage the data model according to Business Partner reporting requirements.
• Created and Scheduled Confidential Packages for Delta Initialization (Full Load + Selection Conditions) and Delta data loading in to Confidential Cubes Via PSA, DSO objects.
• Developed Master data flow, reporting on Business Partner Fiduciary relationship, common eligibility, Compliances and non-Compliances reports for deployment 1.0.
• Worked in Integrated Planning to create Planning Models, Planning Sequences and Aggregation Levels and also created Queries with Input enabled.
• Developed BW Content for Business Partner, Product Master, Farm Records, Security for market sensitive data based on technical specifications.
• Involved in Data Source enhancements using user exit to restrict the data for certain limit of time from users.
• Created process chains, variants to automate the manual loads.
• Worked on writing baseline configuration, unit test, string test and integration testing scripts and uploading and executing in Solution manager & HPQC.
• Worked on HPQC Defect Resolution followed by Data fixes & Documentation for User acceptance tests (UAT) and also generate integration test scripts for
• Business Partner, Farm Records.
• Prepared Production cutover activities & transports strategy for smooth migration to QA & Regression box.
• Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures,
• Exceptions, Conditions with Charts and Worksheets to access data from BI/BW Data Targets to Generate Reports.
• Worked on up gradation of SAP HANA 1.0 interfaced with SAP BW 7.0, BWA and Business objects XI 4.0.
• Tested all query performance using RSRT debug mode and executed.
• Created Webi Reports Reports using Business Objects functionalities like Multiple Data Providers
• Merging), Prompts, Slice and Dice, Drill down, Cross Tab and Master Detailed created Complex queries.
• Worked extensively with the major functionalities of Business Objects Breaks, Ranks, Variables, Alerts, Formulas, Calculated measures, Filters, Sorts and Query Prompts.
• Used BEX Analyzer, BEX Web Analyser, WAD and Query Designer for Query Presentation, Management and Generation.
• WAD - Created Web Templates using Web Items.
• Extensively used Web Analyzer and Web Application Designer and published WAD reports on Enterprise portal as iView.
• Worked on Report Designer for the Highly Formatted Reports.
• Worked on tickets and tasks such as load monitoring issues, user issues and enhancements of existing objects.
• Designed and deploy ad-hoc reporting functionality using WebI.
• Helping the Support team in handling load monitoring issues.
• Involved in Change Management and Problem Management for Handling of Tickets.

Confidential

SAP BI/BW Consultant

Responsibilities:

• Driven BI Upgrade activities from 7 to 7.3 version.
• Gathering the requirement from business user and Prepared the business blueprint
• Activated the BI Contents
• Created various Confidential Cubes (Billing Cube, Delivery Cube and Sales overview cube), assigned dimensions to the characteristics and activated Update rules for the Confidential Cubes.
• Created the back end objects DSO, Infocube, Confidential Object and Multiprovider
• Extracted Data for FI using the following Business content extractors like - 0FI GL 1, 0FI GL 4, 0FI AR 1, 0FI AR 4, 0FI AP 1 and 0FI AP 4 and also enabling the Timestamp Delta mechanism with Coupled Extraction using the Timestamp Table - BWOM2 TIMEST and also using the control table BWIF AEDAT in R/3 System.
• Worked on WAD and created many templates using Web Items for the customer requirements.
• Used BEX Analyzer, BEX Web Analyzer, WAD and Query Designer for Query Presentation, Management and Generation.
• Created Web Templates using Web Items.
• Extensively used Web Analyzer and Web Application Designer and published WAD reports on Enterprise portal as iView.
• Worked on Report Designer for the Highly Formatted Reports.
• Debugged Data load errors, Delta Queue Monitoring, and Extractor Checker to trace and fix errors.
• Created DTP’S to load data from Flat File via Data Source into Staging DSO and initialized it by using Full & Delta process
• Created Jump report from BW to BW and also BW report to ECC Transaction for a particular Confidential type.
• Written ABAP code for the HR extractors for populating the data from ECC.
• Driving daily data load calls to ensure support client WCMC achieve agreed SLA
• Driving BI Performance calls and Driving Weekly Incident calls
• Developed Cross Tab Reports, Sub Reports by using Crystal Reports version XI.
• Used Data Integrator in ETL activities. Working with different transformations like Query, Key Generation, Pivot, Map operation, Table Comparison in Data Integrator.
• Creation of different data stores to get SAP tables, Developed jobs using Business Objects Data Integrator XI designer to extract data from source databases and flat files into oracle staging area. Performed Unit, System and Regression testing of the Business Objects Data Integrator ETL jobs.
• Created On-Demand Sub reports and Hierarchical Grouping.
• Exported reports into various formats like XML, PDF, HTML, EXCEL, and WORD for user.
• Passed parameters dynamically to Crystal Report in .net application at runtime.
• Developed Drill Downs report using Graphs in Crystal.
• Created event based process chain and also flag, monitor etc through ABAP code.
• Helping the support team for handling the Incident Tickets.
• Wrote ABAP code in start routines, end routines and field routines.
• Wrote ABAP code in CMOD (RSR00001) for global variables of queries.
• Created Input Variables, Authorization Variables and replacement path variables in Bex Queries.
• Participated in Data retention and Archiving managed by Source system team to store the historical transfer files prior 3 fiscal periods.
• Participated in Post Go-Live support and Go-Live Cutover plan with BI support Team.
• Involved in Support pack up gradation Testing Activities.
• Designed Universes and classes by Business Objects enterprise tool and build all the objects required for
• WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc), Cross-tabs and Sub reports.
• Handled various day-to-day Tickets of all priority/severity levels on both

Confidential

SAP BW Consultant

Responsibilities:

• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL), Purchasing (MM), Cost Center Accounting (CO-CA) and customized them as per the client requirement.
• Developed write optimized DSO’s for EDW layers and standard DSO for consolidation layers and created direct update DSO’s and APD for creating history data and for snapshot scenario reports.
• Developed transformations with start routine, field routine and end routine and involved in the creation and maintenance of DTP and Confidential Packages for loading data in to data Targets.
• Migration of Data Flows from 3.x to 7.X
• Co-ordinated with Change Management, Incident Management and Production Monitoring Teams.
• Worked on BI Accelerator to Improve the Query Performance.
• 1st Level IM Resolution Team (Offshore).
• Resolving IM tickets in Production and Ad hoc activities.
• Execution of requests raised to offshore (From onsite team - to include instructions) (RMs).
• Monitoring of regular loads using Process Chains.
• Worked in Change Management, Incident Management, Problem Management and Production Monitoring Teams.
• Used Perigrine to handle the tickets.
• Converted Routines in Transfer and Update Rules to Field/Start/End Routines in the BI 7.x flow.
• Running repair full loads.
• Performing weekend activities like rescheduling of Process chains,
• Rescheduling of Process chains, reinitialisation of the delta loads, Statistical setup,
• Copying an existing IP and making necessary changes without disturbing the original one that is in the process chains, Copying of Process Chains.
• Importing the transports from Development Systems to the Quality, Regression,
• Pre-Production and then into Production Systems & Perform Pre-manual & Post-manual actions while Importing the transports.
• In case of transport failures raising tickets to the respective GCs using Peregrine tool.
• Infocube Compression, Line Item Dimensions, Partitioning, Indices to improve the Query performance of the Reports.
• Executing the Queries through RSRT and tracing them using RSRTRACE when required.
• Executing all elementary tests (RSRV) to check the system performance and errors.
• Created Aggregates on Confidential Cubes to improve the query performance.
• Created BEx queries to facilitate reporting on InfoCubes, InfoSets, ODS and MultiProvider
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through Confidential view with BW universe as source.
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources.
• Created Formula variables, Conditions, Exceptions, Exception aggregation, Cell editors, Customer exit variables and Structures for developing complex custom reports.
• Worked with RFK’s and CKF’s in the queries.
• Used BEX Analyzer, BEX Web Analyser, WAD and Query Designer for Query Presentation, Management and Generation.
• Created Web Templates using Web Items.
• Extensively used Web Analyzer and Web Application Designer and published WAD reports on Enterprise portal as iView.
• Worked on Report Designer for formatting the Reports.
• Documentation for the problems faced and the rectification.
• Knowledge transfer to shadow resources regarding technical guidance & project.

Confidential

SAP BW Developer

Responsibilities:

• Installed the Business Content as well as created Confidential sources, Confidential objects, Confidential cubes, ODS Objects, Transfer/update rule process chains.
• Involved in activating Business Content for Standard Confidential Objects, DSO, InfoCubes related to FI, CO-PA, SD and QM.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Confidential Source, Defining Transfer Structure, and Metadata maintenance for the Confidential Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Designed Confidential cubes with daily and Monthly Granularity, extraction from PSA.
• Worked on Actual inventory, Retail sales, Actual Open Orders and Wholesale shipment flows for Current and Historical data which involves all kind of Generic
• Extractor and was involved in the complex design of the data flow.
• Extensively involved in debugging ABAP Routines.
• Handling of Incident Tickets using HPSD.
• Migration of Data Flows from 3.x to 7.X
• Converted Routines in Transfer and Update Rules to Field/Start/End Routines in the BI 7.x flow.
• Developed routines to implement complex pricing requirements not handled by standard SAP.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries.
• Improved the query performance by creating Aggregates.
• Worked on Query development Templates and Workbooks in BEx Analyzer.
• Created interactive reports in SD module by extracting the information on delivery and invoice status, shipping details and partner function details.
• Designed documentation for queries using BEx Analyzer Reporting tool for presentations.
• Extensively involved in the job scheduling and monitoring of Confidential packages using SAP BW Administrator Workbench.
• Created Confidential Packages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side.
• Worked on creating Start routines and End routines in update rules to ensure proper loading of data.
• Created Purchase order control report, this report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Developed an interactive report to list the purchase orders details for a vendor that has interactive drill down options to give the details of vendor from vendor master.
• Build Transactional and Master Process Chains for periodic upload of data.