Professional Experience

Around * years of experience in Business Intelligence and Business Objects (BOBJ) as a technical consultant playing various key roles in Design, Development, Upgrade and Support Projects.

Worked across different versions of Business Object tool- BI 4.2,BI4.1,BO XI 3.1/R2/R1/ 6.5.1, SAP BW on Windows and UNIX Environments.

Extensive experience and understanding of Data Warehousing, Star Schema, Snow Flake Schema, Dimensional Modeling, Entity-Relationship Modeling, OLTP and OLAP concepts.

Worked as Team Lead for creation of frameworks for reporting, dashboards, delivery, scheduling and object retention policies for complex information systems

Promote content from development to test to pre-production to production environments using promotion management and Rev Track after testing and user signoff.

Experience in business objects administrative activities including creating User groups, restricting documents to certain group of user, Promotion management, setting the access levels and others identical tasks.

Responsible for setting the standards and following the best practices in writing codes, test scripts/cases and technical specification documentation.

Expert in Information Design Tool (IDT) and have worked extensively creating data foundation and Business layer on database like HANA and Oracle.

Setup row level or column level security on universe to restrict data access to certain users or user groups.

Experience in BOBJ 4.0/4.1 building universe on top of Cube/DSO using Universe design tool.

Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges and Stored Procedures.

Worked with SAP engineers to troubleshoot product defects effectively and request hot fixes for critical product bugs.

Enable auditing features on each of the business objects servers in production to analyze or track the usage of reports and other actions.

Highly worked on implementing automated bursting of Reports via Publication services

Performed Proof of Concept and worked on Translation Management in Business Object Tool to provide the multilingual reporting service.

Proficient and extensive knowledge on dashboard designing tools like QlikSense /Qlikview/Tableau/Lumira.

Proficient in creating Explorer Reports, OLAP Analysis Report on HANA Analytical View, OLAP Analysis On Bex query and Info Cube.

Worked on creating Hyperlink Reports by parameterizing URLs with the OpenDocument syntax.

Business objects upgrade experience, includes 3.1 to 4.0 and 4.0 to 4.1 to 4.2.

Expert Level knowledge in creating Universe based WEBI BOBJ 4.2 using advanced features including Database Delegated (Smart Measures), Hyperlinks, Delegate Search, Data Tracking, Input Controls, hierarchies and drilling in BO, Merged Dimension Feature to combine Universes and creating a single document on the same..

Created Custom events, File Events and Scheduled Events in CMC for event based Scheduling of the Reports.

Experience in Production Support, resolving severity tickets using a Connect Now ticket management tool and Defect Resolution/CR through HPALM Tool.

Provide technical support, guidance and documentation to end users; provide immediate fixes remotely on critical issues

Attended Qlikview Developer Class room Training. Created data models and App design using QlikView. Extracted data through multiple data sources in QlikView and generated QVDs as required.

Experience in SQL, PL/SQL and very good exposure to Oracle 11g/10g/9i

Educational Qualification

Bachelor of Engineering (BE) in Electrical, Mahakal Institute of Technology, INDIA.

Certification: Data Science Toolbox (Coursera) License Number: ZWR27PEUSHGA

Project Experience Summary

Project Name & Description

Technologies

Role

Period

Team Size

KPMG Professional Services HANA Project

SAP Business Object, SAP HANA, Qlik Sense

SAP Business Object Lead

June 2016 -Present

20

ABC BW Onsite Consulting

SAP Business Object, SAP HANA, Qlik Sense, Tableau.

SAP Business Object Consultant

Jan 2013- April 2016

15

ABC BW Offshore Consulting

SAP Business Object, SAP BI

SAP Business developer

Jan 2012-December 2012

20

Genworth- Offshore

SAP Business Object,

SAP Business developer

December 2011

6

BOSSI –Bombay Stock Exchange online Surveillance System Integration-Onsite

SAP BOBJ, PLSQL, UNIX Shell Scripting, Operations,

Business Object Reporting developer, Operation Support.

Aug 2009- Nov 2012

20

Role: SAP BO LEAD Consultant

Client: KPMG Ltd, NJ (USA)

Duration: June 2016- Present

Project Description:

KPMG is one of the world’s leading professional services firms and the fastest growing Big Four accounting firm in the United States.

TCS is involved in SAP Implementation in various countries. By understanding the business requirements and providing optimal solutions that suits them.

This Project involves the implementation of HANA Reporting and dissolving the legacy BW system for the faster reporting experience.

Responsibilities:

This Project involves the HANA implementation over legacy BW system.

Managed entire project lifecycle (BO) - requirements gathering through implementation including: preparing the functional, scope, mapping documents and high level and low level design specification documents

SAP BO Team lead for creation of frameworks for reporting, dashboards, delivery and scheduling.

Involved in Creating Relational database connection, Data foundation layer, Business layer on top of HANA Views.

Extensively Worked on SAP HANA Modeler (HANA Design Studio), Designing Schemas, Creating Packages, Attribute View, Analytical View, Calculation view, Analytic Privileges and Stored Procedures.

Created various reports with functionalities like Cross tab, Embedded Summary, Charts, Graphs, and sub reports.

Worked in setting up row level or column level security on universe to restrict data access to certain users or user groups for different member firms.

Created various Linked and Unlinked Sub Reports and managed the parameters accordingly.

Extensively worked on migration reports using Promotion management and transporting objects between BO three tier landscapes through Promotion via CTS and Rev Trac.

Configured and enabled the SSO using the Windows AD Authentication.

Involved in assigning Business Objects Authentications and Authorizations, Creating/Administrating Users & Groups, designated their Security Levels in CMC, assigned Roles, & Access Levels on the Applications and folders.

Created the Test cases, Test Strategies and executed the Unit Testing and the UAT for the Entire environment.

Lead the POC for QlikView/QlikSense on HANA Views.

Defect resolution through the HPALM Tool.

Role: SAP BO/ BI on HANA Consultant

Client: AmerisourceBergen Corporation, PA (USA)

Duration: January 2013- April 2016

Project Description:

AmerisourceBergen Corporation (ABC) is a leading distributor of pharmaceutical products and services supporting the hospital systems/acute care market, alternative care facilities, and independent community pharmacies.

ABC has now embarked upon a Business Transformation initiative whereby it plans to replace its existing legacy systems with SAP Enterprise Resource Planning (ERP) systems. TCS provides software services towards implementation of a module in the SAP ERP initiative. SAP Business Object Team provides towards various self-servicing reporting, Complex reporting for the day to day Requirements. Requires us solutions includes Analysis, Design, Development, Testing, Enhancements and Documentation.

Responsibilities:

Involved in gathering business requirements from user and understanding the business logic.

Worked as a Team Lead for Business Object reporting, Involved in Onsite –Offshore Support Module coordination to ensure 24/7 support.

Responsible for understanding end user requirement and involved in preparing project plan.

Handled the Conversion of reports based on legacy BW to HANA BW System.

Created HANA views for the material master tables for master data reporting, Sales Distribution/Pricing catalogue Contract Compliance exception Report.

Lead the POC on Translation Management in Business object to provide the multilingual reporting services globally.

Experience working with Information Design Tool for building Business layer on top of HANA views and Universe on top of Cube/DSO.

Worked on the issues in Business layer on HANA Views such as Key And text display for the PLACEHOLDER variable on Views.

Developed Audit reports for the BO Repository by using/Modifying Audit universe.

Involved in end to end development of Business Object reports.

Designed, developed, maintained and tested universes for supporting ad hoc queries and canned reports according to the business requirements.

Developed Dashboards on Qlik Sense/Qlik View/Lumira/Tableu.

Designed the BEx Queries in the BW Environment.

Developed WEBI Reports on UNX, UNV, BICS, Excel as a datasource

Developed Explorer Reports on HANA to handle huge amount of data anlaysis., also developed OLAP analysis and hyperlink reports.

Developed WEBI reports for Visualization of data including Pie Charts, Line charts, Graphs.

Implemented automated bursting of Reports via Publication services

Created Complex Reports by combining two or more universe through Merged Dimension Functionality to avoid any Backend flow changes

Provides Estimates for design, test and implementation phases, ensuring Quality and accuracy is maintained.

Created detailed standard documentation containing all technical steps and prepared end users training documentations, also provided training to users for the self-servicing functionality of business object reports.

Involved in Modifying and Performance tuning of the Existing Reports.

Organized data in the report Inserting Filters, Sorting, Ranking and highlighting data.

Maintained Technical Design Documents for Universes and Reports.

Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).

Developing Custom solutions for the issues/defects encountered by business users.

Creating Custom events, File Events and Scheduled Events in CMC for event based Scheduling of the Reports, creating Notifications for all the Scheduled reports for their success and failure.

Defect Prevention activities using CHARM.

Experience with CHARM change management tool to follow the Process involved in migrating objects from lower landscape to higher.

Experience with MAXIMO and Connect now ticket management tool for the efficient support structure.

Role: SAP BO/ BI on HANA Consultant

Client: AmerisourceBergen Corporation, PA (USA) - Offshore Consulting

Duration: January 2012-January 2013

Project Description:

AmerisourceBergen Corporation (ABC) is a leading distributor of pharmaceutical products and services supporting the hospital systems/acute care market, alternative care facilities, and independent community pharmacies.

ABC has now embarked upon a Business Transformation initiative whereby it plans to replace its existing legacy systems with SAP Enterprise Resource Planning (ERP) systems. TCS provides software services towards implementation of a module in the SAP ERP initiative. SAP Business Object Team provides towards various self-servicing reporting, Complex reporting for the day to day Requirements. Requires us solutions includes Analysis, Design, Development, Testing, Enhancements and Documentation.

Responsibilities:

Analysis & Study of Business Requirements, Technical & Functional Specifications.

Creating Universes and Webi Reports in Business Objects.

Migrating Reports/Universes/Connections from One Environment to another Environment.

Creating the Technical Design Documents for Universes and Reports.

Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).

Solving queries/issues raised by users.

Resource Management and Onsite-Offshore coordination.

Doing Impact analysis of the new requirement or change request on the existing programs initiated by the client.

Developing suitable solutions, alternatives and options.

Constructing or Changing the Reports/Universes as per requirements provided by the clients

Developing Custom solutions for the issues/defects encountered by business users.

Providing Estimation/Efforts for the various Change Requests and New Development Activities.

Communicating with Client.

Defect Prevention activities using HPQC(HP Quality Control).

Role: SAP BO HANA Consultant

Client: Genworth

Duration: December 2011-January 2012

Project Description:

Conversion of deski reports to WEBi Reports with the help of the conversion tool.

Responsibilities:

Worked on Deski to Webi Conversion tool.

Converted all the DESKi reports to Webi Reports.

Resolved the issues encountered during the conversion and the functionalities which was not able to get convert to WEBI Reports.

Role: SAP BO HANA Consultant

Client: Bombay Stock Exchange

Duration: Aug 2009-Nov2011

Project Description:

Bombay Stock Exchange is the world's 10th largest stock market by market capitalization. Wipro InfoTech has implemented Bombay stock Exchange Online surveillance System integration is an application in which the online surveillance front end( JAVA based) and Business object for the online reporting purpose was inbuilt for the user to analyze the Market . Project name BOSSI (Bombay Stock Exchange online Surveillance system Integration).

Responsibilities:

Involved in collecting requirements, Interacted with prospective clients to gather their analytical requirements.

Responsible for understanding end user requirement and involved in preparing project plan.

Analyzing the requirement and preparing the execution plan.

Created Online Surveillance report on Oracle Timesten server.

Preparing Reports as per client requirement. (Tools Used – BO 6.5) on Stored Procedure.

Resolving current issues related to Reports

Creation of Tables/Packages/Procedures/Views(Tools Used- SQL Navigator & TOAD).

Created shell scripts to load data from file to table.

Performance tuning of SQL Procedures.

Support in daily Operation of Bombay stock exchange and United stock exchange.

Analyzed SEBI Business Requirements and created Materialized Views for the Reporting need.

Created BO reports for the United Stock exchange Currency Module.

Created new repository, Users In BO 6.5

Experienced DB2 BO reporting.

Solving queries/issues raised by users.

Creating the Technical Design Documents for Universes and Reports.

Developing testing strategies for efficient and error free testing (like preparing Unit Test plans and doing Unit Test reviews).

Vi

Contact this candidate