SUMMARY

• Having 10+ years of total IT experience into SAP BI/SAP BW/SAP - HANA Modeler/BW on HANA/ABAP/SAP Business Objects (Webi, Design Studio) .Expertise with hands on exposure in Implementations and Maintenance of SAP BI Applications/BI on HANA/BO/Native HANA.
• Expertise on Sap BW 3.5, SAP BI 7.0, 7.3, 7.5(BW Powered by HANA), SAP Hana Studio 1.0, SAP ECC 6.0, SAP R/3 4.7E, SAP BO 4.1, SAP Design Studio 1.0.
• High Expertise in Designing Info Cubes, ODS, Symantec Portioned objects(SPO Cubes, DSO's) Info objects, Multi providers, info set, Transformations, Info sources, Transfer Structures, Transfer rules, Update Rules, Communication Structures, Info package, DTP, Activating Data sources, deleting and Filling setup tables, business content installation.
• Expertise in writing Start Routine, End Routine, Expert Routine, Field Level Routine, customer Exits.
• Expertise in designing APD (Analysis Process and Design), OHD (Open Hub Destination), Data Archiving using NLS (Near Line Storage).
• Expertise in Extraction (Generic Extractions, Flat file, LO Cockpit, COPA).
• Expertise in improving data load and query performance by doing indices, Number Range buffering, compression, aggregates, rollup, partitioning etc.
• Worked extensively in Front-end Business Warehouse Components like BeX Analyzer in building Queries by creating calculated key figures, restricted key figures, Variables, structures, Formulas, Exceptions, Conditions.
• Rich exposure on currency conversion, unit conversion at query level and at transformation level in BI.
• Rich exposure to SAP BW components like OLTP extraction data, Loading (Full /Delta Up-Load), Scheduling, Monitoring of data loads through Process Chains.
• Transportation of requests across landscape.
• Expertise in designing Information data models on HANA studio like attribute views, analytical views, calculated and also in creating variables, hierarchies, currency conversion, Input Parameters, Analytical Privilege, Decision tables, stored procedures, Restricted Columns, Calculated Columns.
• Expertise in creating configurations using SLT(monitoring daily loads), SDA from different source systems to Hana studio.
• Expertise in designing BW models in HANA eclipse environment.
• Expertise in Replication server Cockpit (LTRC), Replication server setting (LTRS), Filtering initial and replication load for huge tables at source level using the table DMC ACSPL SELECT.
• Expertise in Consuming HANA information models in to BW using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object for reporting using BEx Analyzer.
• Hands on experience in installing Business Content and HANA Live according to the blue print.
• Rich exposure in Business Objects 4.1 in creating Universe using UDT & IDT and designing BO reports using WEBI (Web Intelligence), Dash Boards using Design Studio.
• Rich exposure on scheduling reports in BI Launch pad
• Expertise in designing WEBI report using input controls, ranking, drill, break, conditions, merge dimensions, variables, calculated context, filter, combine queries aggregate functions.
• Rich exposure on checking cordialities, resolving loops, and traps by creating Alias and context, Cascading List of values, Hierarchies in universe.
• Rich exposure on collecting and transporting the objects in SAP BO using Promotion Management tool
• Prepared documentation to keep track of design of cubes and ODS, capturing the requirements showing the information flow right from the R/3 level to the cube level.
• Designed the Dashboards using Analytic, Basic and container components in SAP BO Design studio.
• Designed the dashboards by applying Conditional formatting, Cascading Dimension filter’s, list box, dropdown box, dynamic filters, filter panel, filter line, info charts, cross tab, Text etc.
• Experience of working in SAP BI/BW in IS utility sector.

TECHNICAL SKILLS

Confidential

Senior Consultant

Environment: SAP BI7.3, 7.5(BI on HANA), Bex, ECC 6.0, SAP BO 4.1, SAP Design Studio 1.0

Responsibilities:

• Created the reports (YTD, MTD) in SAP Frontend (Bex) that meet user requirement.
• Worked on priority tickets.
• Worked on Ticketing toll HPSM, and OTT (Online Ticket tracker) to track the status of CRT (Change requests).
• Designed NLS (Near Line Storage) dataflow to archive the data in to SAP IQ data base by automating the data loads using process chain, and troubling the data load issue.
• Retracting the data back to BI from NLS in scenarios when the data model is changed or loading the data to BI that is already archived to NLS.
• Designed APD’s to export BI the data to the Application server.
• Worked on Incidents like Currency issue, data mismatch issues, short dump, lock issues; hierarchy issue etc. and trouble shoot the issues.
• Worked on Change Requests to meet the user requirement and transported the objects across the landscape.
• Worked with BW models in HANA eclipse environment.
• Designed Hybrid data models using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object for reporting using BEx Analyzer.
• Consumed HANA information models in to BW using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object.
• Worked on creating new hierarchies, loading hierarchy data from R/3 to BW for Update Method Full Update, Insert Sub tree, Update Sub tree.
• Worked on ABAP OOPS code to fill the data to the objects by look up method using Start routine, end routine, expert routine, field level routine, user exits, BADI.
• Worked on creating Bex variables and wrote User exit to fill the data to variables at Run time.
• Worked on AO (Analysis Office) by creating new work books, executing the Bex reports using AO.
• Worked on data models which include the Modules COPA, FI, SD, and MM.
• Designed the Dashboards using Analytic, Basic and container components in SAP BO Design studio.
• Designed the dashboards by applying Conditional formatting, Cascading Dimension filter’s, list box, dropdown box, dynamic filters, filter panel, filter line, info charts, cross tab, Text etc.

Confidential

Technical Leader

Environment: SAP BI 7.4, HANA Studio, SAP ECC 6.0

Responsibilities:

• Using SLT monitoring daily loads and replicated tables to Hana studio.
• Expertise in creating configurations using SLT, SDA from different source systems to Hana studio.
• Monitoring the loads into Tables and initiating the load, replication in to tables using the Data Provisioning in LTRC.
• Enhancing the tables by adding new fields and populating the data by writing the transformation logic in includes in LTRS.
• Filtering records using T code LTRS.
• Designed Hana information models attribute view, analytic view, calculation view, stored procedure and also in created variables, hierarchies, currency conversion, Input Parameters, Analytical Privilege, Decision tables, stored procedures, Restricted Columns, Calculated Columns.
• Expertise in Replication server Cockpit (LTRC), Replication server setting (LTRS), Filtering initial and replication load for huge tables at source level using the table DMC ACSPL SELECT.
• Designed Analytic view by mapping input parameters with attribute views, cascading list of values using input parameters.
• Expertise in Consuming HANA information models in to BW using Transient provider, Composite Provider, Open ODS View, Advanced DSO, Virtual Cube, Virtual Info object for reporting using BEx Analyzer.
• Created Webi reports, dash boards using Design studio and on top of Hana Column Views.
• Created Webi queries with Hyperlinks in order to linking from one document to other document, combined multiple queries.
• Designed Universe using UDT & IDT and created BO reports using WEBIntelligence, Dash Boards using Design Studio.
• Collected and transported the objects in SAP BO using Promotion Management tool.
• Created Webi report using input controls, prompts, ranking, drill, break, conditions, merge dimensions, variables, calculated context, filter, aggregate functions, Combine Query.
• Replicating virtual tables from third party database using SDA data provision.
• Worked on import and export functionalities to get models and files (csv) to studio for views.
• Done unit testing for the newly created objects as a part of Change Request.

Confidential

Technical Leader

Environment: SAP BI 7, SAP R/3 4.7E

Responsibilities:

• Installed the new Business Content objects.
• Created BW reports using Bex Analyzer and used calculated/restricted key figures, variables, conditions, exceptions, structures and Involved in estimation and planning for all the reports.
• Monitored the data loads and recovered the failure loads. Monitoring the background jobs & logs (SM37) and data loads by using (RSMO)
• Checking TRFs by Using T-code SM58, when data load is long running
• Monitoring (ACR) Attribute change run, which is most important/critical in production box
• Enhanced the data sources with new requirements.
• Worked on data mismatch issue that occurs in reports.
• Created queries that meet the user requirements.
• Created the process chains and triggered the chains on daily, weekly, monthly basis.
• Resolving issues like change Run failed because of Rollup
• Done unit testing for the newly created objects as a part of Change Request
• Migration of data sources from emulated data sources in 3.x to BI.7 environment.

Confidential

BW Consultant

Environment: SAP BI 7, SAP R/3 4.7E

Responsibilities:

• Working on monitoring incidents like Invalidate characteristics, Time limit exceeded, IDOC, TRFC, Duplicated key, SID issues, Short dumps etc.
• Worked on Report issues, where there is mismatch of data from Source System to Target System.
• Working on IM’s and Functional tickets raised by onsite team.
• Implementing outage bundle activities during LO extractor changes, Cleanup of the delta queues and Scheduling the V3 jobs in source system
• Deleting and Filling of Setup tables and running full repair loads
• Activating and scheduling/rescheduling the Process Chains
• Working on performance aspects like initial filling and deactivation aggregates, data package adjustment, parallel processing in DSO activation and ACR etc
• Activating the Transformations, Transfer rules and update rules, when they are in inactive
• Testing the objects in dev & Quality system.
• Monitoring the Data loads by process chains in BW (Daily / Weekly / Monthly)
• Monitoring the background jobs & logs (SM37) and data loads by using (RSMO)
• Checking TRFs by Using T-ode SM58, when data load is long running
• Monitoring (ACR) Attribute change run, which is most important/critical in production box
• Coordinating and communicating with the onsite team during urgency or any critical issue
• Raising the tickets (P2, P3 & P5) and assigning to related resolution group, if the issue is not in our scope.
• Always reached (SLA) Service Level Agreements

Confidential

BW Consultant

Environment: SAP BI 7, SAP R/3 4.7E

Responsibilities:

• Monitor the data loads in BW from various source systems like R/3 using process chains in development segment.
• Created Process chains with Process Type Remote Process Chain, which pass the Trigger to the Destination System and Call the Process Chain in Target System, and get the signal back to the Process Chain in Current System.
• Created Process Chains with Various Process like Interrupt, Decision between Multiple Alternatives, Is the previous run in the chain still active?, Loop Process Chains, Delete Index, Initial Fill of New Aggregates, Roll Up Filled Aggregates/BWA Indexes, Wait when ODS activation running, Wait for rollup to prevent failure if CR running, Compression of the Info Cube, Activate Data Store Object Data, Activate ODS Data (Only Requests Loaded OK), Complete Deletion of Data Target Contents, Attribute Change Run, Deletion of Requests from PSA, Deletion of Requests from the Change Log, Raise Event PROCESS CHAIN FINISHED, Execute Info Package, Data Transfer Process, Prevent large change run, Check status of data provider.
• Created a Process Chain which will raise an Event of any given day through a Parent Chain and trigger another dependent Process chain.
• Passed the Trigger to the below process, when trigger is not passed.
• Created a Process Chain to Trigger on specific days (1, 2, 3, 4, 5 ) of a given month.
• Created a Process Chain to trigger on specific day of week in a month (Every 3rd Sunday).
• Created a Process chain which will pass Trigger to other Process chain which will run based on Event Raised.
• Extensively worked on Administrative workbench.
• Involved in Data modeling to design custom Info Providers, ODS based on reporting requirements.
• Modify standard and create custom Info Source/Data Source, ODS, and Info Cubes, transfer structures, transfer rules, update rules for ODS and Info Cube
• Creation of Info packages for scheduling the data load process with Full and Delta update mode.
• Troubleshoot the data load issues wherever is possible.
• Analyze the errors in the data loads and report to the corresponding team if it is not in the scope of administration.
• Mange Master data, Text, Transaction by having the correct and up to the date data.
• Reconstruct the data requests from PSA in case of data load failure.
• Re-initialization of business area in case of inconsistency in data targets of any structural changes in the dataflow.
• Monitor all Administrator Workbench schedules, aggregate loads, realignment runs, ODS loads, batch jobs in BW.
• Liaise with BW Basis, BW Development team to resolve issues that arise during data loads and aggregation activities. This could include analysis of short dumps, IDOC issues, table space issues, etc.
• Resolving issues like Change Run Failed because of Rollup.

Confidential

BW Consultant

Responsibilities:

• Extensively worked on Administrative workbench.
• Extensively worked on scheduling the data loads through CONTOL-M in AB5 &QB5 Servers, and corrected loading problems in both AB5 & Qb5 Servers
• Raising the defects to the specific team in a mercury tool, when we are not to supposed to solve the defect in AB5 & QB5 Servers
• Responsible for the REV Track system in maintaining, creating Rev Tracks for entire GSAP-GB BW project used in the transport worked in layer architecture.
• Modify standard and involved in Data modeling to design custom Info Providers, ODS, Info Objects, custom Info Source/Data Source, ODS, and Info Cubes, transfer structures, transfer rules, update rules for ODS and Info Cube, based on reporting requirements
• Creation of Info packages for scheduling the data load process with Full, init, repair full and Delta update mode.
• Extracted data from SAP R/3 by using LO extraction & Generic extraction and from Non-SAP Source Systems using Flat file extraction
• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads
• Extensively built Queries on Info Cubes, ODS objects and Multi-Provider using BEx analyzer
• Created Virtual Characteristics in the Queries.
• Created various variables and written USER EXITS based on the report/customer requirement
• Designed and developed process chains (RSPC) for master data loads and Transaction data Loads. And these Process chain are Scheduled for periodic loads
• Created Queries by using BeX Analyzer and Involved in creating calculated key figures, restricted key figures, Variables, structures, Formulas, Exceptions Conditions and web reports.
• As a Quality team member involved in Unit testing and delivered objects
• Involved writing Technical spec preparation and documented in Global Live Link.