SUMMARY:

• Total 9 years of I.T. work experience.
• 9 years of consulting experience in SAP BI across Implementation, Development, Support and rollout.
• 1 Year of Experience in SAP HANA and SAP bobj
• Executed two End to End Implementations across BI7.0
• Prototype building, efforts estimation, technical solution & delivery management expertise in SAP - BI.
• Active participation in all the project lifecycle engagement stages including RFP response, customer presentation, due diligence, implementation, support and closure.
• Data loading methods using Std SAP Extractors. (LO), Data loading methods such as Full uploads, Init and Delta loading.
• BEx reports (Query building, query Properties, variable creation, currency translation creation, exception display, Conditions, Calculated KF, Formula KF etc),performance optimization.
• Job Monitoring, Error handling, Bug Fixing.
• Activation and Installation of Business Content data sources in R/3 for SD,MM,SRM,CRM Modules.
• Installation of InfoObject Catalogs and InfoCubes for SD, MM, PP modules.
• Resolving the errors that occurred during installation.
• Creation of Info Packages, DTP’s Process Chains and performing master and transactional data load.
• Resolution of the errors that occurred during data loads and transports
• Transport of the installed objects from development system to quality system and then to production.
• SAP HANA Table administration and database view creation.
• Data provisioning in SAP HANA with different methods.
• SAP HANA modeling and designing of Attribute views, Analytical views and Calculations views
• Creating complex SQL procedure to transfer data from legacy system to SAP HANA tables.
• Crystal report design based on SAP BW as source and also configuration of Bex query to crystal reports.
• Xcelsius Dashboard designing experience based on SAP and Non SAP source.
• Worked on QaaWS( Query as Web service).
• Universe design based on SAP BW source
• Have worked on Customer EXIT variable for implementing data restriction to User.
• Have experience on Enhancement of datasource with help of ABAP.
• Have experience to use BADI for datasource enhancement.
• Have idea to understand the standard ABAP routine of SAP given for transformation.
• Have hands on to debug the ABAP routine written in transformation.
• Trained 10+ BI Key Users BW modules.

PROJECT DETAILS:

Confidential

Responsibilities:

• Worked on the SCM, CRM and FI Area of BW Data model
• Responsible for complete FI Month End Activity in BI Area.
• Handling Offshore team for the BI Monitoring and daily production support issues.
• Worked on the Flatfile data provisioning to SAP HANA tables.
• Involved in the Designing of the Universe and also created the Webi reports based on the same.
• Worked on the SAP HANA production issues and have experience in analyzing the SAP HANA SQL procedures.

Confidential

Responsibilities:

• Handling Incidents of Production BW failures.
• Handling Incidents of BW reporting and data inconsistencies.
• Involved in Reporting performances issues related to dashboard reports.
• Involved in problem management for long running production failures issues.
• Have also worked on data load performance issues.

Confidential

Responsibilities:

• Identifying standard BW Objects (Cubes, ODS, Data source etc.) as per the reporting requirement
• Analyzing the client’s requirement, implementing and developing relevant Reports. Handling Change request forms related with reporting requirements
• Customizations - Enhancing standard Data source, cubes, ODS, transfer/update rules as per the requirement.
• Application specific data sources, generic Extraction and setting up delta mechanism for the same.
• LO Extraction - Configuration & setting up LO Cockpit data sources.
• Checked the modeling aspect for performance improvement.
• Performed data loads via process chain scheduling; automation of data loads, designing of data flows

Confidential

Responsibilities:

• Have initiated Business blue print to customer which extensively brief about the SRM content as part of BI Repots.
• Have prepared prototype for SRM business content and also designed Technical specification focus to customer business requirement.
• Have implemented Shopping cart and contract data model as per customer business requirement.
• Have implemented SRM dataflow for services created in SRM box which include creation of generic extractor and enhancement of the extractor.
• Worked on the master data extraction using standard and generic extractor.
• Have implemented data model for invoice with the use of 0FI AP 4 and 2LIS 06 INV
• Have done the enhancement for 2LIS 06 INV to populate the vendor and PO information for PO-Invoices created thru MIRO in ECC.
• Have implemented Authorization and Data security data model with use of Customer Exit and maintained all data in BI with use of DSO.
• Have implemented standard data model of Purchasing.
• Involved in Production plan activity and Production transport activity during GO LIVE.
• Have done the UAT at the customer’s place and done the gape analysis for the data model implemented in development box.
• Have designed the global roll out methodology for UK and other country.

Confidential

Responsibilities:

• Worked on development of Customer exit variable.
• Worked on Query Broadcasting with dynamic variable.
• Have developed SD management cockpit for graphical analysis.
• Analyzed report performance for statistics and implemented proposals for aggregate creation and indexing, Tuned queries using Partitioning, Aggregates and Multiproviders.
• Developed Infoset and worked on different joins as per the query requirement.
• Developed the Report and Query as per the new requirement.
• Worked on the Query performance using performance analyzer.
• Developed Open hub destination to download Employee master data to CSV file.

Confidential

Production Support

Responsibilities:

• Major emphasis on the performance tuning using following tools.
• BW statistics (Tables RSDDSTAT,RSSDAGGR etc)
• Front end settings like Query read mode, Properties of Restricted key figure and calculated key figures.
• Use of ST02, RSRV,DB02, DB03 for Index checks
• Created aggregates, indexes, compression, activation of statistics, system checks via ST03N etc
• Checked the modeling aspect for performance improvement.
• Formulated Strategy for system cleanup, Deletion of PSA and least used queries, workbooks & web templates.
• Performed data loads via process chain scheduling; automation of data loads, designing of data flows
• Fine tuned the queries for performance enhancement by creating aggregates, partitioning, Index creation etc
• Process chain Monitoring as well resolving the error occurred while data loading..
• Customer Support involving Remedy Ticket resolution.
• Monitoring TRFC Queue and IDOC Administration - BD87 and taking corrective actions.
• Performing Rollups to fill aggregates.

Confidential

Responsibilities:

• Involved in new development and providing solution for the previous problem which being occurs during implementation.
• Worked extensively on LO Cockpit extraction and also replicating datasource from one BW source system to another BW system.
• Loading master data from flat files and R/3.
• Developing and maintaining process chains of master data.
• Involved in changing of transformation as per the design of data target.
• Resolving Change Request ticket of development of BI Reports.
• Performing transport activities which involves releasing standard Bex request and assigning one, creating request for queries and its related elements, releasing it and making it available for approval.
• Handling the tickets of priority 1, 2 and 3 never missed the SLA.
• Monitoring daily process chains of master and transaction data and performing Special month end activity
• Keeping track of number of records loaded in data targets.
• Created navigational attributes depending on the drill down requirement.
• Developing well-formatted Management reports for MTD, QTD and YTD.
• Validating data consistency with data target against PSA.
• Resolved problems with many system dumps & system constraints.
• Completed data loads, executed unit test report & achieved formal sign off.
• Creation of templates and customized reports as per the customer requirement.
• Configured LO cockpit for Logistic datasource.
• BI support activities including data load monitoring, system performance check.
• Created system administration documents for core user group.
• Trained core super users for query modification & data loads in BI.
• Led the team through various project phases - planning and tracking the execution at each stage.
• Resolved various conflicts and ensured smooth completion of the project, in strict timelines and high-pressure situations

Confidential

Production support

Responsibilities:

• Involved in changing the existing data model of an info cube adding new characteristics and key figures.
• Used remedy tool for handling client raised CRs and tickets of priority 1,2 and 3.
• Involved in adding fields in transformation as per the data model changed.
• Validating Infocube and DSO (ODS) data with PSA.
• Checking delta queues and keeping track of number of records loaded daily and maintaining checklist documents.
• Created query with selections, formula and different variables user entry/default value and customer exit.
• Actively involved in Rectification of data load failure of master data & transaction data.