SUMMARY

• 7+ years of experience in SAP Business Objects & Business Intelligence environment wif 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 wif 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 wif 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 wif 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 wif self motivation, Initiative and Project Management Attributes.

TECHNICAL SKILLS

Reporting Tools: 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 EXPERIENCE

Confidential, Lake Forest, CA

Senior SAP BI/BO Consultant

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

Responsibilities:

• Worked wif end users to gather business requirements and transformed them into a data model using extended star schema model.
• Worked wif 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 wif delta functionality using tables and Function Module.
• Worked wif FIGL Extractors using wif delta options.
• Created process chains to automate the periodic upload of transactional data, scheduled and monitored the data loads wif 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 wif BW universe as source.
• Created Universes, Classes and Objects to develop the BOBJ reports.
• Worked on testing objects in BOBJ like connectivity, autantication of servers, performance testing, new developments for reports in new HP server environment.
• Documented all developments.
• Provided production support and user training.

Confidential, Irvine, CA

SAP BI Techno-Functional Consultant

Environment: 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 wif 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 wif ability of delta functionality using tables and Function Modules using ABAP.
• Worked wif Business Content (FI) Extractors using wif delta options.
• Created process chains for periodic upload of transactional data, scheduled and monitored the data loads wif 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 wif 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.

Confidential, Detroit, MI

SAP BI Techno-Functional Consultant

Environment: 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 wif 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 wif SAP ECC for Materiel Management.
• Worked wif transformations routines like Start routine, End routine and Characteristic routine.
• Created and maintained Process chains to automate data loads and monitored.
• Worked wif Query designer to develop query using structures, formulas, selections, CKF and RKF.
• Worked wif Business Objects XI 3.1 Enterprise Suite (Desktop Intelligence, Web Intelligence and Dashboard Manager)
• Created WebI reports wif Complex Calculations to get Alerts for Xcelsius Dashboards.
• Worked In creating Variables, Prompts in WebI.
• Filters and conditions were applied to the query to has different views of the same query.
• Worked wif 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.

Confidential, Seattle, WA

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

Confidential, Boston, MA

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.

Confidential, Richmond, VA

SAP-BW Consultant

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

Responsibilities:

• Configuration and implementation of BW, interacted wif the management and users to identify Business requirements. Discussed wif 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 wif Variables.

Confidential

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