Data Sap

Srinivas

SAP BW/BO Technical Consultant

PROFESIONAL SUMMARY

• SAP BW/BO Consultant for nearly 6 years of professional IT experience which includes

SAP BW3.5/BI7.0/BW7.3 in SD, MM, FI applications, SAP BOBI 4.0and SAP BODS 4.0.

• Proficient 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.

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

Crystal Reports 2008/2011, QAWS, Live Office, Xcelsius Designer and SAP Dashboard

Designer.

• Involved in Full Life-Cycle implementations of multiple SAP BW/BO projects using ASAP

Methodology, Including Development, Enhancement and Maintenance Projects.

• Proficient in translating business needs into Data Modeling and multiple reporting solutions.

Experience in End-User training for SAP solutions and preparing the training material and

presentations.

• Experienced SAP BW/BI and SAP BOBJ Tools focused on Implementation of Data

Warehousing Solution which includes Requirements gathering, Data Modeling, and Data Flow

Strategy, Blue printing/specifications, Development/Testing, Reporting/Information Presentation,

Post Go-Live Support/Maintenance manuals, test cases & test results.

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

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

files & using DB Connect for legacy data.

• 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.

• Evaluated performance using BW Statistics for optimization. Improved data load & Query

performance by using BW Accelerator (BWA), Compression, Aggregates and Indexes.

• Worked on Production 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.

• 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 Package: SAP R/3 - 4.7 Enterprise, ECC 6.0. SD, MM, FICO

Data Ware Housing: SAP (BI 7.0), SAP BW 3.5, BW 7.3/7.4

ETL SAP BODS 4.0, SLT, DXC

Reporting Tools: SAP BEx Query Designer, BEx Report Designer, BEx Analyzer (SAP BO XI

3.1, BO 4.0) UDT, IDT, Crystal Reports 2008/2011, Crystal Reports for

Enterprise.Web intelligence 4.0, Xcelsius 2008/Dashboard Designer 4.0. Live

Office. MS Office

Databases: SAPHANA 1.0 SP8,DB2, MSSQL Server 2000/2005/2008,& Oracle database

Operating Systems: Windows NT/XP/7, Windows 2000/2003/2008

PROFESSIONAL EXPEREINCE:

Computer Technologies, Dallas, TX Jun 2013 – Present

Project: PerformanceKPI

(Implementation, Development & Maintenance)

Role: SAP BW/BI 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).

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

modules.

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

flows using Designer.

• Created and maintained Aggregates and Rollup activities as a part of the Infocube Management.

• Performed LO-Extraction for loading data from SAP R/3 to SAP BW.

• 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.

• Daily Discussions with Team members for developing BEx Reports as per the requirement.

• 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.

• Utilized Hierarchies in the reporting to provide drilldown features.

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

and Master Data.

• Experience in SAP HANA Data Provisioning and using SAP LT Replication Server (SLT) and

SAP Business Objects Data Services.Analyze the types of business tools and transforms to be

applied.

• Designing the HANA Information Models like Attribute Views, Analytical Views and Calculation

Views.Experience with the SAP BW system on the top of SAP HANA data base, WEBi Reports

on the top of HANA models

• 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.

• 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).

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

• Documentation of the project.

Environment: SAP BI 7.0/7.3, SAP BOBJ 4.0/BODS 4.0, and Atos Service desk tool,SAP HANA 1.0,

SLT, 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 Techno-Functional Analyst

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.

• Responsible for stabilization of the BI system.

• 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.

• 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.

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

• Trained people to use and create reports.

• Worked on BODS ETL to Migrate data from Non-SAP and ECC ERP System.

• 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.

Environment: SAP BI 7.0, SAP BOBJ suite 3.x/4.0, BODS 4.0, and REMEDY 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 BI/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

• 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.

• 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.

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, SAP ECC 6.0, BO XI 3.1

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

Client: ALFALAVAL

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.

• 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.

• 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.

• Involved in Documentation of the project.

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

Nelgo Solutions Pvt Ltd,May 2009 to Jan 2010

Richardson TX and Bangalore India

Functional Analyst

Responsibilities:

• Worked on roles and authorizations in SAP BI.

• 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.

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

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

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

Contact this candidate