Summary

• SAP BW/BOBJ consultant with 4 years experience in SAP BI 7.0, BW 3.5, BO Xi 3.1, CRYSTAL REPORTS, and XcelSius, and confident that would be a Great Addition to the teams and has the ability to help Client Succeed.
• 2 SAP BW full lifecycle implementations including data modeling, extractions, data staging, loadings, transformations, and reporting.
• Extensive experience working with extractors for SD, MM, FI/CO, PP, HR, SCM, SRM, and CRM.
• Strong expertise in ETL techniques (extracting, cleaning, conforming, and delivering data).
• Extracted data from OLTP using LO Cockpit, BI Content, and Generic datasource methodologies.
• Extracted data from Flat files.
• Expertise in transporting objects from Development, Quality Assurance to Production environment in 3-tier landscape for SAP BW and BOBJ.
• Strong understanding of Life Cycle Manager.
• Modeled Infocube and ODS objects, and installed Business Content objects.
• Developed Update Rules, Transfer Rules and ABAP user exits for transaction & master data in start/end and update routines.
• Experience in creating Infopackages to create Process Chains and Scheduling of data loading with Full/Initialization/Delta uploads method.
• Experience in Data Validation and Verification in BW and ECC.
• Experience in Monitoring Data with Data Monitor and PSA.
• Strong expertise in BEx Design tools (BEx Query Designer, BEx Report Designer, BEx Web Application Designer), BEx Reporting tools, General BEx features and Information Broad Casting.
• Expertise in creating complex Queries to generate reports using Query Developer.
• Expertise in using Variables, Conditions, and Exceptions.
• Worked with both classic and advanced InfoSets.
• Experience in Data Maintenance and Performance Tuning.
• Worked with Aggregates and MultiProviders.
• Strong knowledge of SAP BW Accelerator (BWA).
• Expertise in using Open Hub Service for exporting data from BW server to flat files.
• Expertise in SAP Integration Kit for Business Objects applications with SAP BW.
• Strong knowledge of Business Objects Xi 3.1.
• Created Universes with Designer on top of BW queries.
• Created ad hoc reports with Desk Intelligence and Web Intelligence.
• Created dashboards and scorecards with Xcelsius.
• Proficient with different live data connection options - Query as a Web Service (QAAWS), Live Office, XML, and web service.
• Hands on knowledge of standard reporting with Crystal Reports 2008.
• Strong knowledge of Security permissions, authorization objects and roles within SAP BW and BOBJ, including SAP Authentication.
• Strong knowledge of all phases of a projects life cycle including requirement gathering, Design, Implementation, and Troubleshooting scenarios (ASAP Methodology).
• Have strong analytical, troubleshooting, and problem solving abilities.

Technical Skills

ERP:
SAP R/3, SAP ECC, SAP BW 3.5, BI 7.0, Business Objects Xi 3.0, 3.1
Reporting Tools:
BEx Reporting, Web Intelligence, Xcelsius 2008, Crystal Reports 2008, ArcGIS, Excel, QAAWS, Live Office
Operating Systems:
Windows Server 2000, 2003, Vista, XP
Language:
SQL, PL/SQL
Databases:
SQL Server, Access
Data Integration:
SAP Integration Kit, APOS Solution for ESRI GIS, Data Integrator, Rapid Marts, Portal

Professional Experience

Confidential,Columbus, OH, 9/2008-11/2009
Role: SAP BW/BOBJ Consultant

Environment: SAP BI 7.0, Business Objects XI r3 (Designer, Deski, Webi, CMS,CMC), Crystal Reports 2008, Xcelsius 2008, ECC, SD, MM, PP, CRM, SRM. Interacted with the different Business Users for requirement analysis. Analyzed the end user requirement with the existing system generated documents. Extracted data from SAP R/3 using LO Cockpit, Generic Extractions and data from flat files. Gained strong understanding of SD (bookings, billings, backlog, overall Order Management process, Complex Pricing Structure), CRM (Service Management, Service Orders, Contract Management, IBase) and Customer Master Management business functions as they relate to analytics and SAP BW. Enhanced existing BW data models, Extractors, Transformations and Reports to observe the impact due to functional design changes in ECC (Order-to-Cash, Pre-Post Order processing, Customer Master Design, Contract Management and Pricing Model ) Analyzed and Designed new data models using SAP BI 7.0 objects i.e. MultiProviders, Infocubes, InfoObjects, Data Store Objects, Extractors, Transformations, Start Routines, End Routines and DTP\'s to meet new reporting requirements. Conducted performance tuning of complex data loads and data conversion processes using advance BI 7.0 functionality to improved response times. Used BW Accelerator for query performance.

• Built and deployed universes on top of BW queries.
• Synchronized data with merged dimension.

Extensively used the Webi and Deski functionalities such as Slice and Dice, Drill Down, Hierarchies, and Ranking to analyze data and create reports. Exported universes to the Repository for making resources available to the users. Shared documents with other users using Life Office. Created and published queries with QAAWS. Created dashboards and scorecards with Xcelsius.

Confidential,Renton, WA, 5/2007-6/2008
Role: SAP BW Consultant
Environment: SAP BI 7.0, ECC, BEx Analyzer, Business Objects Xi, Webi, Deski, Xcelsius, PP,MM,SD, SRM

• Participated in efforts to implement and support an operational SAP BW system to satisfy business requirements and enhance or customize where necessary.
• Performed End-to-End BW Configurations and Customizations from Extraction, Staging, Loading, Performance, Transports, Reporting using BEx Analyzer and Webi.
• Designed and developed extractors, DSOs, cubes and reports for PP, MM, SD, SRM modules.

Performed data extractions from SAP ECC using LO Cockpit, Generic Extractions, and from flat files.

• Worked with others as appropriate to develop and manage SAP BW implementations, upgrades and related test plans across the organization.
• Participated in the creation of BW development standards while adhering to policies, methodologies, standards, and guidelines.
• Proactively and effectively communicated potential problems, recommended solutions and progress.

Built InfoCubes, DSO, and Universes for business units to allow user access to reporting data. Employed Aggregates, partitioning, and indexing techniques to improve performance.

• Developed reports with Webi and Deski.
• Developed dashboard with Xcelsius.
• Participated in quality reviews and other external evaluation of all SAP BW design, development, and testing efforts.

Confidential,WA, 9/2006-2/2007
Role: SAP Reporting Specialist
Environment: SAP BW 3.5, BI 7.0, SAP ECC, BEx Analyzer, SAP R/3, FI-AR, FI-AP

• Participated in efforts to gather requirements analysis.
• Performed End-to-End BW Configurations and Customizations from Extraction, Staging, Loading, Performance, Transports, Reporting using BEx Analyzer.
• Provided firstline functional support for SAP FI module. Responsibilities included configuration of GL, AR and AP, evaluating and reviewing testing and implementation.
• Created FI-SL extractor using Totals Table in ECC for extraction and loading into BW.
• Created staging ODS and Analysis InfoCube for FI-SL.
• Configured Transfer Structure, Transfer Rules & associated start routines, transfer routines, and update routines.
• Setup Partitioning, Indexing, Statistics and activation, Cube Compression, Archiving ODS & Cube data, Creating Aggregates, and Reporting Agent functions.
• Configured Generic Extraction.
• Created Process Chain and event management for Automation Process.
• Performed Query Reporting, Graphical presentation, Web publishing.
• Performed all SAP component, assembly, and integration testing required and documents the results of all testing in accordance with Program procedures and standards.
• Conducted Training for Core Team members.
• Participated in the creation of SAP BW development standards while adhering to policies, methodologies, standards, and guidelines.

Confidential,Seattle, WA 7/2005-12/2005
Role: GIS Specialist
Environment: ArcGIS, Network Analyst extension, Spatial Analyst extension, ArcToolbox,
Arc Editor, ArcSDE, Excel, MS Access, AutoCAD, Windows XP

• Prepared legacy reforestation maps
• Designed Excel tracking logs for progress report
• Scanned, georeferenced and digitized maps
• Created relational tables.
• Used Aerial Photos and LiDAR imagery to edit existing restoration thinning, old growth, and streams.
• Created linear referencing system for road data.
• Created topology.
• Wrote formal metadata documentation

Confidential,UK, 8/1998 -1/2002
Role: GIS Analyst
Environment: SAP R/3, SAP BW 3.0, ArcView, Microstation, Techbase, CorelDraw, Excel,
ER Mapper, Windows 2000

• Worked with the user community and Administrators in IT to successfully implement applications.
• Participated in integrating Business Intelligence and Geographic Information System including data modeling, requirements gathering, data analysis, and documentation.
• Developed data layers.
• Used data schemas to develop reports including thematic maps, graphs, and charts.
• Performed spatial and statistical analysis.
• Conducted software implementation, maintenance, and training of new users.
• Scanned, Georeferenced and Digitized maps.
• Created and maintained GIS tables for geological, geophysical, and geochemical data.
• Created presentation posters.
• Created Drillhole Cross sections.
• Provided user support functions including map production and software troubleshooting.
• Participated in analysis and interpretation of assays.
• Maintained tenements polygons.
• Used plotters to print maps.

Education

BA in Information Systems.