SUMMARY

• Having 9 Years of Work experience in Implementation Projects in SAP BI 7.0/7.3/7.5 on HANA, SAP BO XI R3/4.1/4.2 and Lumira 2.0/SQL/SSRS/SSAS.
• Highly - motivated Business Analyst who has worked on a wide range of projects in United Kingdom, Australia & India
• Finished 5 full life cycle implementations end to end.
• Expertise in BW Modelling
• Experience in BI Architecture, Extended Star-Schema, Multi-Dimensional Modeling, Data Flow Strategy, Defining Dimensions, Info Cube, Multi Provider, Info Sets, Data Source, Info Source, DSO, Extraction through Function Modules; CMOD enhancements .
• Extensively Involved in BW-BO integration, create, maintain and deploy OLAP universes.
• Experience in End-to-End BW Configurations and Customizations from Extraction, Staging, Documentation, Loading, Transports, Reporting through BEx Analyzer and Performance.
• Experience in production support, data loads, validation and trouble shooting of transaction data and master data, change management, transport management, roles and security, system checks, performance tuning and process chains.
• Evaluated statistical performance using BW Statistics and suggested recommendations for performance optimization. Improved data load and query performance by doing compression, creating aggregates, Indexes.
• Expertise in Central Management Console (CMC), InfoView, BI Launchpad, Life Cycle Manager, Crystal Publishing Wizard, Import Wizard, LCM, Web Intelligence Rich Client, Business View Manager, UDT & IDT
• Experience in SAP BO Installation & Administration
• Experience in Relational Connections using IDT
• Active team player and as an individual with Excellent Communication, Interpersonal skills, self-motivated fast learner, good listener and having strong analytical and programming skills.
• Creating and executing simple BODS jobs.
• Trained SAP BO tools to business power and end users.

TECHNICAL SKILLS

ERP: SAP R/3 (ECC6.0)

Business Intelligence Tools: SAP BI 7.0/7.3/7.5 and Hana Studio

Operating System: Windows, Linux

Reporting Tools: Business Objects Enterprise BI 4.1/4.2 / BOE XI 3.1

Visualization Tools: Lumira 2.0

MS BI Tools: SQL Server Analysis Services (SSAS)& Server Reporting Services (SSRS)

PROFESSIONAL EXPERIENCE

Confidential

SAP BO/ BI Consultant

Environment: SAP BO 4.2 SP 5 and SAP BI 7.5 on HANA,SSAS & SSRS

Responsibilities:

• Understand the project requirements.
• Responsible for interacting with the customers to understand the functionally of the business and provide the feasible solution for their reporting.
• Responsible to write business requirements and solution design.
• Guide the team for build and testing activities
• Project Implementation
• SAP BO Administration

Confidential

SAP BO/ BI Consultant

Environment: SAP BO 4.1 SP 5, BO 4.2, BI 7.1, SQL Server, SAP BI

Responsibilities:

• Understand the project requirements.
• Responsible for interacting with the customers to understand the functionally of the business and provide the feasible solution for their reporting.
• Responsible to write TS and design documents.
• Worked on build and testing activities
• Change requests based on customer requirements
• SAP BO Administration
• Changes in existing BI data model

Confidential

SAP BI/ BO Consultant

Environment: SAP BI 7.3/BO 4.0/BODS

Responsibilities:

• Understand the existing system and find the way to integrate it with SAP BW
• Responsible for interacting with the customers to understand the functionally of the business and provide the feasible solution for their reporting.
• Responsible to introduce SAP BO tools to business users and provide SAP BO training to power and end users.
• Worked on Administrator workbench like customizing info objects, and created Info Cubes, DSO’S loading of data to targets by using Transformations and DTP.
• Responsible to create reporting layers in SAP BW for BO reporting.
• To Improving the Query response time for Queries which are created on DSO’s and to improve the lookup performances created indexes on DSO’s
• Creating SAP BODS jobs to pull data from third party systems.

Confidential

SAP BI/ BO Consultant

Environment: SAP BI 7.3/BO 4.0

Responsibilities:

• Responsible for interacting with the customers, Functional specification, Technical specification and Business requirement development
• Support Business objects environments.
• Worked on Administrator workbench like customizing info objects, and created Info Cubes, DSO’S loading of data to targets by using Transformations and DTP.
• Responsible for Creating and maintaining various user groups and their security in CMC
• Responsible for maintaining and creating business layers in top of relational connections and WebI reports.
• To Improving the Query response time for Queries which are created on DSO’s and to improve the lookup performances created indexes on DSO’s
• Created custom Master Data Extractors for Attributes and Text Data.
• Involved in creation of BEx Queries, Workbooks and used variables, Calculated Key figures, restricted key figures

Confidential

SAP BI/ BO Consultant

Environment: SAP BI 7.0/BO XI 3 / 4.0/ ECC 6.0

Responsibilities:

• Responsible for interacting with the customers, Functional specification, Technical specification and Business requirement development
• Accomplished a full life cycle implementation in BI 7.0 which includes Data Modeling, Data Extraction, Transformation, Loading, Scheduling jobs, Monitoring data loads.
• Handling New development of backend objects required for Reporting like ODS, Cube, MP and info source / Transfer & update rules with entire ETL process
• Building of complex queries and performance optimization for the same.
• Worked extensively with BEx Query Designer, BEx Analyzer for developing reports, analysis, and Web reporting.
• Enhanced BI objects that include InfoObjects, DataSources, Transformations, DTP, DSO, Info Cubes, Multiproviders, Infoset and Open Hub.
• Created reports of kind, Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Details reports.
• Creation of reports like, reports by product, reports by supplier, reports by period, demographic reports. Working with database connections, SQL joins, cardinalities, loops, aliases, views, parsing of objects and hierarchies.
• Created reports using the Universes

Confidential

SAP BI/ BO Consultant

Environment: SAP BI 7.0/BO XI 3 / 4.0/ ECC 6.0

Responsibilities:

• Handling New development of backend objects required for Reporting like ODS, Cube, MP and info source / Transfer & update rules with entire ETL process
• Created Custom Data source/Info cubes/Info objects for accommodating the global data available across the organization.
• Created BEx reports with Exceptions, Variables, Restricted and Calculated Key figures for detailed level reporting.
• Involved in performance tuning of queries by maintaining Aggregates, Compression, partition and Indexing of Infocubes.
• Involved in Testing Phases Like Unit Test, Product Testing, Regression Testing and UAT
• Interacting with the Onsite People to understand the functionality with respect to the developments and Feasibility Study.