Sales Data

Senior SAP BI/BOBJ Consultant

Saritha Vatti

*************@*****.***

Phone # 949-***-****

7+ years of experience in SAP Business Objects & Business Intelligence environment with expertise in Business Objects Enterprise

Involved in 2 full life cycle SAP BW Implementations which includes Data Analysis, Data Modeling, Data Extraction/Uploading and Reporting.

Experienced with ASAP Methodology including project preparation, gathering requirement, business blue print, realization, post user support and end user documentation and training under deadlines.

Extensive experience in business processes across the following modules: FICO, MM, SD, SEM,HR.

Worked on Universe design, WebI, Crystal reports and Xcelsius Dashboards.

Worked on Liveoffice and QWAAS connections.

Good experience in extracting data from SAP & non-SAP systems. Sophisticated skills to work on Flat File Extraction, Generic DataSources, BI Content DataSources, Full, Initial and Delta Extraction Management. Working with SAP Netweaver2004s (BI 7.0) and extensively used DTP’s & Transformations.

Performed Data Extraction from SAP R/3 (MM,SD,FI) flat files, and BW using extraction structures such as LO Cockpit, FI -GL,AP,AR and Generic Data Extractors.

Worked with complex multi-dimensional data models, including InfoCubes, DSOs and MultiProviders, Master Data, InfoObjects, InfoSources, transformations, process chains and batch scheduling.

Worked on transformations using routines like Start routine, End routine and Field routines using ABAP.

Worked on Open Hub service and APD.

Improved data load and query performance by using BI Accelerator (BIA).

Worked on Front-end environment: Business Explorer (BEx), BEx Analyzer, Creating queries, Workbooks, Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions, RRI, Ad-hoc Queries and WAD.

Expertise in creation of Standard reports, Cross-tab reports, Sub Reports and Drilldown Reports using Crystal Reports.

Experienced in creating BO Xcelsius dashboards and KPI’s to large scale multi layer reports.

Good understanding of Portal security roles (Enterprise Portal), Information Broadcasting, and publishing reports on the web.

Expertise in Unit testing, Integration testing and User Acceptance testing.

Strong Problem Solving and Analytical skills and abilities to make Balanced & Independent Decisions.

Good Team Player, Strong Interpersonal, Organizational and Communication skills combined with self motivation, Initiative and Project Management Attributes.

EDUCATION:

Master’s in Information Technology, Madras University, India, 2003.

Bachelor of computer Application from Osmania University, India, 2001

TECHNICAL SKILLS

ReportingTools : BEx Analyzer, BusinessObjects (XI2.1,3.1,4.0), Crystal reports,Xcelsius2008.

ERP Packages : SAP Net weaver 2004s BI 7.0, BW 3.5, SAP R/3 ECC 6.0, 5.0, 4.7.

SAP Module : ABAP/4, FICO, Logistics (SD, MM, PP) CRM, SRM, QM, HCM.

Database : SQL Server 2000/2005, Oracle 8i/9i/10g, MySQL, IBM, DB2.

Testing : HPQC(10.0)

PROFESSIONAL SUMMARY:

Client: Oakley, Lake Forest, CA. Apr2012-till date

Role: Senior SAP BI/BO Consultant.

Environment: SAP BW7.0, ECC 6.0, ABAP, BEx Query designer, BO(4.0), WEBI, Xcelsius 2008,

HPQC.

Responsibilities :

Worked with end users to gather business requirements and transformed them into a data model using extended star schema model.

Worked with functional consultants for mapping the source data (ECC) to target data source in BW and developed reports in FI,SD and MM modules.

Worked on HP Quality Center to manage testing assets, business components, test execution, Defect management (reporting, tracking and analysis) Tested all the tests in BW environment for Data Center Migration.

Involved in developing custom reports and enhancements in existing reports according to user requirements.

Created custom InfoCubes, DSOs and Multiproviders as per the business requirement.

Worked on start routines, end routines and field routine for transformations.

Extensively worked on sales data extractors (LO Cockpit) to develop the sales and billing reports.

Worked on creating generic data sources with delta functionality using tables and Function Module.

Worked with FIGL Extractors using with delta options.

Created process chains to automate the periodic upload of transactional data, scheduled and monitored the data loads with delta updates.

Worked extensively on structures, formulas, filters, variables, conditions in the creation of reports in Bex query designer.

Developed flexible queries in BEx Analyzer using filters and navigational attributes to facilitate data analysis in a summarized way.

Extensively worked on Compression, Aggregates, Roll up, Table Partitioning and reporting related issues.

Created WEBI reports and formatted Crystal reports and deployed them through info view with BW universe as source.

Created Universes, Classes and Objects to develop the BOBJ reports.

Worked on testing objects in BOBJ like connectivity, authentication of servers, performance testing, new developments for reports in new HP server environment.

Documented all developments.

Provided production support and user training.

Client: Newport Corp, Irvine, CA Jan2011-Mar2012

Role: SAP BI Techno-Functional Consultant

Environnent : SAP ECC 6.0, SAP BI 7.0,ABAP/4, BEx Analyzer, Query Designer, WAD,BO designer ( 3.1), WEBI ( 3.1), Xcelsius 2008,HPQC.

Responsibilities :

Worked with functional consultants for mapping the source data (ECC) to target data source in BW and handled FI and SD modules.

Created Info Objects, InfoCubes, DSO’s developed transformations as per business requirement.

Customized primary LO Cockpit structures and set the extraction process using LO cockpit and V3 updates.

Created generic data sources with ability of delta functionality using tables and Function Modules using ABAP.

Worked with Business Content (FI) Extractors using with delta options.

Created process chains for periodic upload of transactional data, scheduled and monitored the data loads with delta update and resolved Production Support tickets.

Extensively used formulas, variables, drill down, slice and dice in the creation of reports.

Query development using the BEx Analyzer, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.

Worked on Compression, Indexes, Aggregates, Roll up and Table Partitioning to improve load and query performance.

Worked on User Exits for Enhancement of Extract Structure.

Created Classes and Objects in BOBJ by retrieving the data from Data Sources like BW queries and defining necessary connections.

Created WEBI reports and formatted Crystal reports and deployed them through info view with BW universe as source.

Created Standard reports, Cross-tab Reports, Sub Reports and Drill Down Reports using Crystal Reports and published it onto the BI Platform.

Worked on Monthly and Weekly summary/Detail Scorecards which gives metric wise data.

Worked on complex sales Dashboards, Visualization dashboards in Xcelsius and WEBI reports.

Client: Carhartt, Detroit, MI Mar2010-Dec2010

Role: SAP BI Techno-Functional Consultant

Environnent : SAP ECC 6.0, SAP BI 7.0,ABAP/4, BEx Analyzer, Query Designer, WAD,BO designer ( 3.1), WEBI ( 3.1), Xcelsius 2008,HPQC.

Responsibilities:

Interaction with business personnel and users for gathering business requirements & identifying standard business content including preparing a plan for customizations.

Developed enhancements, InfoObjects, InfoCubes, DSO, Queries, Multi Providers and Custom Multi providers in BW implementation phases. Created and unit tested BW internal objects (InfoObjects, ODS, InfoCubes) in MM, SD modules.

Developed custom defined Infocube and DSO like ZPUR_T01 and ZPUR_C01 for purchasing cost history.

Worked extensively on LO structures for extracting sales order, delivery, billing and purchase information.

Involved in Modeling/Designing and implementing data warehouse solutions using SAP BI 7.0 using with SAP ECC for Materiel Management.

Worked with transformations routines like Start routine, End routine and Characteristic routine.

Created and maintained Process chains to automate data loads and monitored.

Worked with Query designer to develop query using structures, formulas, selections, CKF and RKF.

Worked with Business Objects XI 3.1 Enterprise Suite (Desktop Intelligence, Web Intelligence and Dashboard Manager)

Created WebI reports with Complex Calculations to get Alerts for Xcelsius Dashboards.

Worked In creating Variables, Prompts in WebI.

Filters and conditions were applied to the query to have different views of the same query.

Worked with different variable processing types like Manual Input, Replacement path, custom variables like User Exit.

Monitoring and implementing the solutions to the errors in the Production System.

Client: Corbis, Seattle, WA. Apr2009 to Feb 2010

Role: SAP BW Developer

Environment: SAP ECC 6.0, SAP BI 7.0, BEx Analyzer, Query Designer.

Responsibilities:

Involved in Modeling/Designing and implementing data warehouse using SAPBI 7.0 with SAP ECC for FI (GL, AP, AR) and HR (PY, PA and Benefits).

Involved in complete Life Cycle Implementation of FI/CO and HR Modules.

Prepared Business Blue Print Documents (Process Scenario Document, Process Design documents, Functional Specification) and performed GAP analysis according to ASAP methodology.

Activated BI Business Content objects, Implemented MultiProviders, DSO, Basic and Real Time InfoCubes.

Worked on Standard Line item DataSource like General Ledger line item, Accounts receivable Line Item, Accounts Payable Line Item and Payroll, benefits datasource for HR.

Extracted data using Initial and delta uploads from ECC to BW.

Migrated 3.x Transactional DataSources and worked extensively with Transformations and DTPs.

Created Process chains and Meta Chains to automate daily data loads from ECC.

Created Test Matrices and supported Unit testing, integration testing and user acceptance testing of the solution.

Discussed and Identified Roles and Profiles to meet Authorization requirements in order to restrict confidential data to end-users. Developed BI Security matrix and worked closely with security team to build BI Security model in BI 7.0.

Involved in Transportation of all BI Objects like: InfoObjects, Update/Transfer rules, InfoCubes, DSO objects, Transformations, Queries, Query elements and process chains into receiving system and fixed transport bugs.

Prepared Go-Live Cut over tasks and provided end user training.

Involved in resolving the issues in Production support.

Client: Phillips, Boston, MA. Jun2008-Mar2009

Role: SAP BI/BW Consultant.

Environment: SAP BI/BW 3.5/7.0, SAP ECC 6.0, BEx Analyzer, Query Designer, WAD.

Responsibilities:

Designed cubes to accept multiple InfoSources. Extracted meta data, master data and transaction data.

Used SD Sales overview Infocube (0SD_C03) Delivery Service (0SD_C05), Customer (0SD_C01).

Used LO extract structures for extracting sales order, delivery-billing information.

Extracted data from SAP ECC using LO Cockpit and worked on enhancing the extract structures based on the Client Specs.

Worked extensively on BEx Analyzer. Created queries using BW-Reporting Variables, Navigational attributes and Filters and variables.

Designed and implemented BW reports against MultiProviders, InfoCubes and jumps (RRI) to ODS’s.

Developed Classical and interactive reports for various shipment costs for the Greenlee Logistics Modules.

Performed Meta data transfers, extracted data and reconciled the InfoCubes.

Involved in Data Extraction Using LO Cockpit for Sales Data using DataSource.

Extended InfoSources wrote transfer rules and update rules and loaded cubes.

Worked on Data Modeling for custom InfoCubes in Purchasing and legacy Spend and legacy commitments InfoCubes.

Developed queries in Query builder and set up the authorization profiles for the users.

Worked on User Exits for Enhancement of Extract Structure.

Involved in production support to solve the issues in production.

Developed Documentation on Business Explorer and Reporting for the End User.

Client: MeadWestvaco, Richmond, VA Apr2007-May2008

Role: SAP-BW Consultant

Environment: SAP BI7.0/BW 3.5, ABAP/4, BEx Analyzer, Query Designer, WAD.

Responsibilities:

Configuration and implementation of BW, interacted with the management and users to identify Business requirements. Discussed with client's business personnel and users to decide on scope of project and to identify Business requirements.

Participated in Data Modeling and development of Multi Dimension Models by consolidating business objects (InfoObjects) involved.

Created InfoObjects, DataSources, InfoSources, Data targets, InfoPackages and InfoCubes for standard SAP master (Customers, Materials) and Transactional data (sales order, shipping and billing dataSources).

Extensively worked in extractions for purchasing and Sales, LIS extraction and others using V3 update.

Developed ODS for purchase contracts and to load sales order data.

Developed reports on InfoCubes/ODS objects using BEx Analyzer/Explorer to facilitate summarization of data.

Created Custom reports: Sales Order orders according to sales organization, distribution channels, Sales Billing, Material Management, Shipping labels, Account payable, Account receivable, Purchasing, Inventory and Warehouse related reports etc.

Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting, report-to-report interface using query jumps.

Publishing the reports using BEx Web Browser, worked on InfoSet queries.

Created BEx Workbooks by adding formats, buttons, Macros.

Experienced working with Variables.

Client: Caritor, Chennai, India. May2005-Nov2006

Role: BW Developer

Environment: SAP BW 3.5, OLTP, WAD, BEx Analyzer, Query Designer.

Responsibilities:

Installation of business content, activating the data sources. Developed a number of transfer routines. Worked extensively on Administrator workbench (AWB), modified transfer structures, update rules.

Supported to Modified standard business content and created custom Info Source/Data Source, ODS and Infocubes.

Created InfoObjects, InfoSources and Source Systems to load data into InfoCubes using Transfer and Update rules.

Assisted to create Aggregates and Cubes for performance and efficient utilization of data.

Performed Delta Upload Management with OLTP extraction.

Created ODS objects for data staging in BW.

Uploaded Master data, Transaction data from flat files into the SAP BW.

Developed front-end queries and reports using BEx query designer, BEx Analyzer.

Extensively used BEx Analyzer to build queries and workbooks to access data from BW data targets.

Created web reports through report template in WAD (Web Application designer).

Contact this candidate