SUMMARY

• Around 9 years of experience in SAP Business Warehouse & 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 teh following modules: FI,COPA, 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.
• 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.
• 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

ReportingTools: BEx Analyzer, Business Objects Webi (XI2.1,3.1,4.0,4.1), Crystal reports,Xcelsius2008,Dashboard Designer.

ERP Packages: SAP Net weaver 2004s BI 7.3, 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: HP Quality Center(10.0)

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Senior SAP BI Developer

Environment: SAP BI( 4.0 & 4.1), BI Launchpad, WebI, Dashboard Designer, SAP BW 7.3, ECC 6.0, Bex query designer, BEx Analyzer, HPQC.

Responsibilities:

• Worked wif end users to gather business requirements and transformed them into a dynamic reports and delivered them to teh business.
• Worked on documentation of teh Functional and technical requirements document specifying teh business requirements, report layouts and delivery mechanisms.
• Developed teh financial reports like Profit and loss statements reports, SGA reports, MPCP and budgeting reports in BI launch pad using BEx query as data source.
• Developed additional functionality by enhancing WebI reports using more formatting capability.
• Developed flexible queries in BEx Analyzer using filters and navigational attributes to facilitate data analysis in a summarized way.
• Worked wif Business Content (FIGL) Extractors and COPA extractors using wif delta options to load teh data into teh cube.
• Involved in testing to test teh BEx query’s for users for data validation when migrating teh data from old system to new system.
• Created WebI reports for finance and non-finance (Sales, Inventory) reports and delivered to teh business users.
• Worked wif creating prompts, filters and variables in WebI reports as per teh business needs.
• Worked extensively wif Input controls, Drill down options, Hierarchies in WebI.
• Worked on more formatting options on charts, Dynamic linking options and Element linking.
• Created powerful and interactive Dashboards for more visualization for easy to analyze teh business needs.
• Worked on IDT connections, Business layer, consolidated layer and multi-source SAP BEx and other Universes as per business needs.
• Worked closely wif BO administrator for creating users, Role and authorizations.

Confidential, San Dimas, CA

Sr. SAP BI & ABAP Consultant

Environment: SAP BW7.3, ECC 6.0, ABAP, BEx Query designer, BEx Analyzer, BO(4.0), WEBI, Dashboard, HPQC.

Responsibilities:

• Understanding teh business challenges and translating them into requirements and developed and reporting Queries according to Business Requirements.
• Extensively worked on SAP BW and ECC as a source system for generating reports using BEx Query Designer and BEx analyzer.
• Worked and build extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Datasource, Info sets, Time dependent master data and also ETL activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Worked on APD to generate a report from a Bex Query.
• Created custom data sources using Table/Views and Functional modules extractors for CDHDR and CDPOS change records for Business partner and Insurance object.
• Involved in creating custom program to perform extract logic and populated data into Z Table.
• Worked on GL summary reports, extracted GL data using FLGL extractors wif delta options.
• Created Transformations and wrote ABAP routines in start routines, end routines to populate teh fields that were not provided by teh Source Systems and modified existing data to meet teh Business Requirements.
• Created ad hoc Webi reports using BW as data source as per teh user requirements.
• Worked on IDT connections, Business layer, Consolidated layer and multi-source SAP BEx and other Universes as per business needs.
• Worked wif creating prompts, filters and variables in WebI reports.
• Created a combination charts and Pie charts as per teh business user requirements.
• Created powerful and interactive Dashboards for more visualization.
• Tested teh BW developed objects and worked on Unit testing and Integrated testing
• Involved in UAT testing and provided user training and also involved in BW team meetings.
• Documented teh development and reporting objects and presented to teh end users.

Confidential, Lake Forest, CA

Senior SAP BI/BO Consultant

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

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 teh 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 teh tests in BW environment for Data Center Migration.
• Created custom InfoCubes, DSOs and Multiproviders as per teh business requirement.
• Worked on start routines, end routines and field routine for transformations.
• Extensively worked on sales data extractors (LO Cockpit) to develop teh 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 teh periodic upload of transactional data, scheduled and monitored teh data loads wif delta updates.
• Developed flexible queries in BEx Analyzer using filters and navigational attributes to facilitate data analysis in a summarized way.
• 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 teh BOBJ reports.
• Developed dashboards for more visualization, at a glance and interactive presentation.
• Worked on testing objects in BOBJ like connectivity, autantication of servers, performance testing, new developments for reports in new HP server environment.
• Provided production support and user training.

Confidential, Irvine, CA

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 wif functional consultants for mapping teh 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 teh extraction process using LO cockpit and V3 updates.
• Created generic data sources wif ability of delta functionality using tables and Function Modules using ABAP.
• Created process chains for periodic upload of transactional data, scheduled and monitored teh data loads wif delta update and resolved Production Support tickets.
• Extensively used formulas, variables, drill down, slice and dice in teh creation of reports.
• Query development using teh 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 teh 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, Drill Down Reports using Crystal Reports and published it onto teh BI Platform.
• Worked on complex sales Dashboards, Visualization dashboards in Xcelsius and WEBI reports.

Confidential, Detroit, MI

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 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.
• Filters and conditions were applied to teh query to have different views of teh same query.
• Monitoring and implementing teh solutions to teh errors in teh 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.
• 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 teh solution.
• 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 teh 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 teh extract structures based on teh 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.
• 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 teh authorization profiles for teh users.
• Worked on User Exits for Enhancement of Extract Structure.
• Involved in production support to solve teh issues in production.

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 teh 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.
• Extensively worked in extractions for purchasing and Sales, LIS extraction and others using V3 update.
• 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.
• 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 teh 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 teh SAP BW.
• Developed front-end queries and reports using BEx query designer, BEx Analyzer.