SAP BI/BO/BW

Srinivas

SAP BW/BO Technical Consultant

PROFESIONAL SUMMARY

• SAP BW/BO Consultant for nearly 6 years of professional Information

Technologyexperience In Full Life-Cycle implementations of SAP BW/BO projects using ASAP

methodology, Including Development, Enhancement and Maintenance Projects.

• Proficient in translating business needs into SAP BWData Modeling & multiple reporting

solutions.Experience in End-User trainingand preparing the training material and

presentations.

• Experienced in Dimensional Database modeling & Design with DW Concepts such as Star

schema, Snowflake Schema, Fact and dimensional tables.

• Proficient in SAP OLTP extractions of LO-Cockpit, SD, FI, MM, PP, HR, Generic

extraction, flat files & using DB Connect for legacy data.

• Well versed in reporting tools including BEx Query Designer and BEx Analyzer, using

Excel workbooks, Custom Query design, Variables, Structures, CKF, RKF,selections,

formulas, filters, conditions, exceptions, cell definitions and Ad-hoc Reports using BEx

Web Analyzer.Upgrade and Migration requirements related to BEx Query Designer, BEx

Analyzer and BEx Web Application Designer.

• Expertise in working with SAP BOBJ Platform such as UDT,IDT, Web Intelligence,

Crystal Reports 2008/2011, Crystal Reports for Enterprise, QAAWS, Live Office, Xcelsius

Designer 2008 and SAP Dashboard Designer 4.0.Expertise in creating highly formatted canned

reports and well versed with universe designing, report writing.

• Skillful in Basic understanding of ABAP Programming language related to SAP BW.

• Worked onProduction Support issues which involved debugging ABAP routines, Data

loads, Validation and trouble shooting of Transaction Data and Master Data, Change

management, Process Chains Monitoring, Transport Management, Roles & Security,

System Checks.

• Experience on ETL Tools such as BODS 4.0, to extract source data & Data profiling,

Transformations and loaded into target repository and checking the data quality of the

loaded data in the warehouse.

• Expert level knowledge and hands on experience in using SAP Business Objects Data

Quality for Data Migration, Address Cleansing and Matching in large projects.

• Worked in ETL BODSDevelopment /Template involving DI Objects like Batch Jobs,

Workflows, Dataflows, Scripts, Variables Transformations (Query, SQL, Table Comparison,

Map, Validation, Pivot, Hierarchy Flattening, Case, Merge, Row-Generation, Global / USA

Address Cleansing, Data Cleanse, Match) and Text Data Processing.

• Extensively worked with the business and data analysts in requirements gathering and to

translate business requirements into technical specifications.

• Knowledge in administration activities like creating and managing repositories, users, user

groups, working with privileges in repository manager.

• Proficient Knowledge with SAP HANA Modeling, SAP BW 7.3 on HANA, and ETL- Data

Provisioning Using BODS 4.0, & SLT. Excellent knowledge in SQL scripting and CE

functions.

• Excellent interpersonal & communication skills to work Cross-functionally with

Enterprise Team members and ensure all applications & reporting solutions are clearly integrated

and synchronized.

Technical Skills:

ERP SAP ECC, SAP R/3.

Data warehouse and SAP BW (Versions 7.4, 7.3, 7.0, 3.5),

Reporting Tools

SAP BO (Versions 4.1, 4.0 and XI 3.1).

ETL Tool SAP BODS 4.1

In-memory RDBMS SAP HANA

Languages SQL

GUI SAP GUI.

RDBMS Oracle 9i/11i, MS SQL 2005/2008, MS Access.

Operating System Windows 8/7/NT/XP.

PROFESSIONAL EXPEREINCE:

Computer Technologies(ComputerTekkInc.) Dallas, TX Jun 2013 – Present

Project: Performance KPI

(Implementation, Development & Maintenance)

Role: SAP BW/BO Developer

Computer Technologies is a Product engineering and IT consulting company providing solutions and

services to different clients involved in domains such as Manufacturing, Automotive, Industrial Equipment,

Utilities and Semiconductor companies. This was an implementation project on BI 7.0 using ERP R3 and

MS SQL Server as a source. Developed several reports like sales reports, aging reports etc.

Responsibilities:

• Worked extensively on Data warehousing workbench RSA1; (BI 7.0/BW7.3).

• Worked with business in gathering requirements, analyzed the legacy data and meet with

different stake holders to understand the source and target requirements. Identified the flow of

information by analyzing the existing systems.

• Involved in Data Migration from RDBMS and Flat files using BODS by Creating Workflows, Data

flows using Designer. Creating Workflows, Data flows using Designer. Most of the transforms

used were like the Source Lookup, Case, Merge, and Sequence Generator.

• Worked extensively on Data Profiling to assess the Data Quality and formulate the Data Cleansing

strategy.

• Analyzed the source data coming from Oracle DB & Flat Files, coordinated with data

management team in developing data migration and conversion process to ECC & BW systems

using BODS 4.0.

• Created Infocubes and MultiProviders as per the requirement and maintainedAggregates and

Rollup activities as a part of the Infocube Management.

• Extracting data from SAP R/3 by using Generic Extraction and Customizing LO Cockpit as per

requirements. Designed and developed custom data sources with the help of RS02.

• Discussion with functional team and created business specifications and data flow diagrams.

• Developed BEx Queries and defined Calculated and Restricted key figures, Structures, Variables,

Exceptions, Conditions, Filters and Formulas, for customized reporting using BEx Query Designer

BEx Analyzer & Developed several workbooks.

• Installing Business content in BW and R/3, Activated data sources in R/3 for Transaction data and

Master Data. Mapping KPIs with Standard SAP business content and analysis.

• Coordinated with SAP OLTP functional and ABAP Team for Enhancements through FM & Exits.

• Sourced HR data like Personnel and Time Management and Financial data (Payroll) into the

Infocube. Integrated several modules from the HRIS data into Infocubes.

• Understand the client requirements and developing the Reports and dashboards using business

objects tools.Building of the Universes for the reports using Business Objects Designer.

• Successfully Integrated SAP BI with SAP business objects 4.1.

• Developed Various Reports in Web intelligence to track Sales periodically.

• Organized data in reports by using filters, ranking, alters and sorts.

• Created Crystal Reports with hierarchies and Filter.

• Developed highly formatted reports using Crystal Reports 2011 on top of BEX Queries.

• Created, designed and implemented Universes, WebIntelligence, and Crystal Reports 2011.

• Defined business objects standard reports & ad-hoc reports and Created report templates for

consistency in the look and feel of the reports.

• Developed complex reports using Business Objects functionality like Slice and Dice, Drill down,

Cross Tab, Master detail and Formulas etc.

• Some Important dashboards developed on KPIs are Financial Salvage reports, Inventory Turn

Analysis, Shrink reports and analyzed in three dimensions Clubs, Regions, Zones.

• Worked with the ERP Consultants in configuring the Enterprise Structure and Employee Structure

as per client requirements as part of sourcing Personnel Administration data.

• Worked with Client Payroll Schema and its related sub schemas, as part of sourcing Payroll data.

• Maintained both the Master data and Transaction data in the Infocube created for HR.

• Created and maintained Employee Hierarchy Reports, Employee Performance Reports using

BEX Analyzer.Developed variety of reports like Employee Joining Report, Working Hours report,

Payroll reports.Generated Payroll periods, Cumulative Periods, & Absentee Quotas through

Reports (RPTQTA00).Utilized Hierarchies in the reporting to provide drilldown features.

• Maintaining Reconciliation’s to verify the data Integrity and data quality

• Implemented Process Chains for automated master data and transaction data loads of all

modules.Documentation of the project.

Environment: SAP BI 7.0/BW7.3, SAP BOBJ 4.1/ BODS 4.1, and Atos Service desk tool,Oracle

11g, MSSQL and SAP ECC ERP 6.0.

SHIRO Technologies Dallas, TX Sep 2012 – May 2013

Client: Celanese International

Global GT Project(Development & Maintenance)

Role: SAP BW/BO Developer

Celanese is a global technology and specialty materials company that engineers and manufactures a

wide variety of products essential to everyday living. As part of the SAP-ERP program, SAP-BI (Business

Intelligence) will be implemented as an Enterprise Data Warehouse. SAP-BI will follow the Enterprise

Data Warehouse approach to become single source of truth at the corporate level. Existing data marts

and Enterprise SAP will feed data to this Enterprise Data Warehouse enabling centralized reporting and

analytics for Operational, Managerial, Executive and Leadership Teams.

Responsibilities:

• Responsible for end to end Projects and support functions.

• Involved in data migration from various corporate systems and interacted with end users and

functional consultants.Creating Workflows, Data flows using Designer.

• Modified SAP BODS jobs as per the new mapping rules and business requirements.

• Worked with Business Users to determine their reporting requirements in SD and HR Area.

• (BI 7.0) Performed Data Modeling and Reporting requirement analysis and creation of queries

based on business requirements; Build Info Objects, Infocubes (Multidimensional, BW Star

schema), Data Store Objects (DSO), Multi Providers, and Infosets.

• Created custom objects according to the specification of the Functional documents.

• Involved in Business Blueprinting, Gap Analysis, Solution Designing, Data Modeling, ETL, Report

Designing and Development, Production Deployment/Support and End-User Training

• Worked along with Functional & ABAP consultants on various enhancements projects for existing

BW Reports across modules like HR – LSO, HR – ERC, HR – PA, HR –OM, HR- PD, HR –

Benefits, HR- Payroll, FI – AP, FI – AR & FI – GL.Created reports using multiple data providers.

• Extracted ECC data for Personal Management, Payroll, and Personal Administration in HR,

Delivery, Shipping Document in Sales and Distribution.

• Extensively worked on building Queries using Calculated and Restricted key figures, Structures,

Variables, Exceptions, Conditions, Filters and Formulas.

• Planning for Nightly data loads for any new Module implemented and working on various

performance initiatives to reduce loading time for timely data availability.

• Worked with Production Support team for performance Improvements of loads/Reports by

creating Aggregates, Indexes for lookup & parallel processing of loads

• Experience in improving query performance using Query Cache, RSRT debug and defining

aggregates. Improve Loading performance through DSO staging, created multiple Infocubes, BEx

query structure, aggregates, compression, PSA packet sizing, change log deletion & partitioning.

• Transforming, migrating, validating and reconciliation of data.

• Created custom Time hierarchy Year-Qtr.-Mon-Week and Year-Mon-Week in Universe using BO

Designer. Defined Aliases and Contexts to resolve the join issues in the Universe, Solved the

issues during designing such as loops, Cartesian product due to fan trap and chasm traps.

• Developed Drill down, Link Report reports, sub reports, used various Charts and Graphs like Bar

Chart (Side By Side, Stacked), Line graphs, Pie Charts using Web Intelligence Reporting Tool.

• Implemented dynamic charts and graphs in dashboards to improve look and feel using Xcelsius.

• Responsible for scheduling reports as email attachments in xls or pdf formats.

• Trained Business Users to create BEX& BO reports.

Environment: SAP BI 7.0/BW7.3, SAP BOBJ suite 3.x/4.0, BODS 4.0, and Service desk tool.

Pacific Sunwear, Parsippany, NJ Nov 2011 – Aug 2012

Project:Planner-Reward for Excellence– (Implementation &Support)

Web Intelligent Reporting, Crystal Reports 2008, BEx Explorer, and BEx Analyzer

Role: SAP BW/BO Developer

Pacific Sunwear is a United States-based retail clothing brand rooted in the youth oriented culture and

lifestyle of California. The company sells lifestyle apparel, along with footwear and accessories designed

for teens and young adults. The company operated over 800 stores in all 50 states.

Responsibilities:

• Extensively worked with the business and data analysts in requirements gathering and to

translate business requirements into technical specifications.

• Coordinating with end-users and business analysts to understand the scope of business

requirements, user expectations, and ensure the accuracy of reporting specifications

• Created reports using multiple data providers.

• Involved in different phrases of the project like analyzing requirement, planning, execution and

Maintenance. Worked with Flat files systems to load data into SAP BI.

• Extensively worked with PSA in Monitoring the Data Transfer from source systems into BI

• Uploaded master and transactional data from flat files and SAP as the OLTP source worked

extensively on administration workbench (RSA1).

• Created the customized objects using BEx Query Designer according to the business

requirement and Functional Specifications.Worked on BEx Query Designer & BEx Analyzer by

defining Variables, Conditions, Filters, Exceptions, Calculated key figure, restricted key figures.

• Created users, groups and access rights using Central Management Console.

• Generated the Business Objects reports involving complex queries, sub queries, Unions and

Intersection.Generated various reports on Daily, Weekly, Monthly and Yearly basis

• Created complex Universes, Linked with existing Universes from Data marts. Resolved loops, &

created complex Reports, using BO Functionalities like Slice and Dice, Drill Down, Variables,

Filters, Breaks, Alerts, cross tabs and other features.

• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert

those into user interfaces like excel files, PowerPoint representations for better understanding.

• Developed various Reports for Area wise, Regional, National, and Response Analysis using

Crystal Reports / Business Objects. Business users to use Web Intelligence to create ad-hoc

reports as well as view existing published reports.

• Tested about 80 Business Objects full Client reports in the BO / Crystal environment.

• Generating and scheduling standard and Ad-hoc reports using BO and Crystal Reports.

• Worked closely with technical peers to insure successful integration of developed applications.

• Participated in developing the Relational Model (Logical & Physical) and in documentation of

technical methods of development as well as business related information regarding the design

process. Created various validation reports between BW systems and BOBJ system.

Environment: BI 7.0, Business Objects 4.0, Web Intelligence, Crystal Reports 2011, Oracle 9i, & MS

SQL.

Lumbini Elite Solutions & Services Jan 2011 to Oct 2011

Client: Tyco, USA

Project:(Global)KPI Product Performance (Development & Enhancement, Support)

Role: SAP BI/BO Technical Consultant

Responsibilities

• Worked extensively on Data Warehousing workbench.

• Redesigned custom cubes to improve reporting performance.

• Coordinated with SAP OLTP functional and ABAP Team for Enhancements through FM &Exits.

• Customizing and activation the Business Content Objects and Loading the data into data targets.

• Used BEx Query Designer to develop reports and facilitate data analysis using CKFs, RKFs, free

characteristics, Exceptions, Conditions, Filters, Jump targets (RRI), Structures, formulas and

Variables.

• Understanding the reporting requirements from client’s perspective and interacted with Functional

Consultants in developing BEx query, Web Intelligent reports, Crystal Reports 2008.

• Worked with Xcelsius for creating simple dashboards and simple crystal reports and convert

those into user interfaces like excel files, PowerPoint representations for better understanding.

• Created cross tabs, Charts, folding, filters, prompts, alerters and variables in designing reports.

• Worked on SAP Business Objects Data Quality XI to do address profiling, parsing,

standardization, cleansing, matching for master data such as org structure, customer and

vendors.

• Post completion of SAP BI configuration based on SAP BI as source creating Universes on top of

BI queries and developing the BO dashboards, WEBI reports and placing all this reports in

corporate dashboard and presenting these dashboards through info view to the management

• Integrated all the data in BW using Infosets and MultiProviders to create reports as per

requirement.

• Maintaining Reconciliation’s to verify the data in SAP R3 and SAP BW on monthly and quarterly

Basis.

• Worked on generic extraction using Table/View to extract data from SAP R3 ERP system.

• Error Handling on Extraction, Data loading and end user issues on Reporting.

• Daily Discussions with Team lead, Team members and Modeling as per the requirements.

Environment: SAP BI 7.0/BW3.5, SAP ECC 6.0, BO XI 3.1

Circle Consulting Pvt. Ltd., Feb 2010 to Dec 2010

Client: ALFALAVAL Bangalore India

Project: (Implementation & Maintenance)

Web Intelligent Reporting, Crystal Reports 2008, Xcelsius dashboard design

Role: SAP BI/BO Technical Consultant

Responsibilities:

• Handling BW in SAP ERP Applications.Activated, Installed and Extended Business Contents

based on Gap Analysis established on user requirements.

• Worked on all advanced reporting features in WEBi XI like Drill Down, Drill Up, Breaks, Scope of

Analysis, Ranking and report level variable based filtering to create complex reports.

• Worked on DWH Workbench: Data Model - Designing & testing of Info Objects, Infocubes, Data

Store Objects (DSO), MultiProviders, Infosets and Open Hub Services.

• Created the customized objects according to the Functional Specifications.

• Worked in keeping DSO as staging layer before transferring the contents to the Info Cube.

• Making all the reporting data targets filled with the Master data and Transaction data correctly.

• Updating the data load status and sending the status of the loads every hour.

• Worked extensively on generic extraction, standard LO extractors, Installed relevant SAP

business content. Used LO Data sources for extracting sales order, delivery billing information

and scheduled data extractions in LO cockpit.

• Done data cleansing using the data quality transformations like country id, address cleanse, data

cleanse available in sap data services.

• Used BEx Query Designer to develop reports and facilitate data analysis using filters, navigational

attributes, calculated and restricted key figures.

• Communicated with ABAP Team for Enhancements through user Exits in BEx Query Designer.

• Handling Change request, data load details and designed Process Chains to trigger Multiple Data

Loads.

• Applied and corrected variable context corrections for reports in Desktop Intelligence Tool.

Environment: SAP BI 7.0, SAP ECC 6.0, BO XI 3.1

Nelgo Solutions Pvt Ltd,May 2009 to Jan 2010

Richardson Texas and Bangalore India

Functional Analyst

Responsibilities:

• Design, Review & understanding of technical specification / functional specification.

• Development of BW Objects as per the technical specification by adhering to Quality Standards.

• Design and development of Freight Costs visibility reports in BW. This involved requirement

analysis from the client, design of ODS, Cube, reports etc.

• Created the objects according to the technical specs.Used BEX Analyzer for normal Query

Designing.Generated pending PO and PR report.

• Detected/resolved data Cardinality and loops, checked integrity of Universes.

• Authorization functions include configuration of hierarchy and authorization with variables,

authorization Info Cube, allocation of roles and authorization objects.

• Worked on data source enhancements and generic extractors to meet the business needs

• Created transfer rules and update rules including routines for currency conversion.

• Created revenue margin variance reports with complex restrictions on characteristics and

calculations on key figures based on business requirements.

• Resolution & recommendation of table sizes, parameters, table spaces, partition break ups, and

errors.Transported BW objects and BEX objects to Quality and Production boxes.

• Basis functions include monitoring and supervising check DBA, archive logs, parameters settings

in R/3 and BW, and performance tune-ups.

• Performed Unit Test in Development and SIT in Quality box

• Applied changes to the reports developed by other vendors based on the QA defects and the user

requirements.

Environment: SAP BI 7.0, SAP ECC 6.0, BO XI 3.1, Microsoft Dynamics Suite, MSSQL 2005

Contact this candidate