SUMMARY

• 7 years of SAP experience in BW3.5/BI7.0 and BOXI R3 with S.P 2 and 3 indulging in the design, development, implementation and maintenance of the SAP BW/BI Client/Server environment.
• Involved in 3 full - life cycle implementations of SAP BW projects using ASAP methodology.
• In depth understanding of SAP R/3 functionality (SD, MM, PP, FI, CO-PA), CRM & SRM, Standard Business Contents and Data Modeling (star schema, extended star schema, flat structure and multi dimensional data modeling) in Sap BI/BW.
• Expertise in SAP BW/BI components like InfoCubes, Info Sources, Data Sources, Info Objects, Info Providers, Update rules, Transfer rules, Transformations, DTP in BI 7.0, Multi Providers, Info Sets, ODS(DSO) objects, OLTP Data Extraction, User Exits, Loading(Full/Delta uploads), Scheduling, Monitoring, Process Chains and Event management, Remote Cubes, Data marts, Open Hub Service and Master Data Management. Sound knowledge of SAP LCM, Live Office, QAAWS.
• Key involvement in the implementation, configuration and Analysis of BW 3.x and 7.0 in FI/CO, FI-SL, CO-PA, FI-GL, LIS, LO, MM, SD, CRM, SRM and HR.
• Expertise in OLTP extraction from R/3 source systems like LO-Cockpit, LIS, CO-PA, BI Content and from non-SAP systems, Flat files and from Generic Data Sources.
• Experience in Upgradation of SAP from BW3.5 to BI 7.0 and migration of components of conceptual design from SAP BW3.5 to BI7.0. Maintaining the transformations and DTP’s and in migrating the new and existing queries in both BEx and WAD. Interpreting and writing complex ABAP routines.
• Coordinated with Basis team in pre-upgrade and post-upgrade tasks like preparation, Go-Live tasks, clearing delta queues, mass migration of BW transports etc.
• Well versed with SAP BEx Analyzer, BEx Browser, Query Designer, Web Application Designer, Crystal Reports, and BEx Alerts, Web reports, Xcelcius and dashboards.
• Created WEBI and Crystal reports and deployed them through Info view with BW Universe as source and created Inventory accuracy dashboards using Xcelcius.
• Experience in running Queries, Calculated and Restricted Key Figures, Structures, Prompts, Sorted inputs, Drill down, Slice and Dice, Variables, Exceptions, Conditions, Authorizations, workbooks and web templates, User Profile maintenance, InfoSet Query, Jump Analysis using RRI and Web Reporting. Hands on experience in creating and administering BI Accelerator on the high volume cubes.
• Extensively worked on Performance tuning and optimization techniques with respect to Loading and Querying performance using aggregates, Roll-ups, indexes, Partitions and Infocube Compression techniques, query pre calculation; evaluated statistical performance of OLAP using BW Statistics.
• Excellent Production Support Skills including Data loads, Reporting related Issues, Archiving, Performance Issues and Data Compression activities.
• Experience in creating Multi Provider, Multi Cubes and InfoSets as per the query needs.
• Resolved performance issues by writing stored procedures and command objects in crystal reports.
• Good Working Knowledge on reports using in Crystal Reports, Crystal Enterprise, Crystal Xcelsius, Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise.
• Experience in designing and developing the Universe and updating the existing Universes, developing canned/ad hoc reports, scheduling the processes and administering the BO activities using BO XIR3.
• Expertise in creating, organizing, publishing and scheduling reports using CMC and creating reports with Charts (Bar chart, Pie chart…etc), cross tabs and sub reports.
• Involved in implementation of HR BW (PA, Payroll, OM, TM reporting).
• Excellent production support and debugging skills, experience in resolving trouble tickets, monitoring loads, enhancements, Archiving, Performance, Data Compression activities and change requests.
• Excellent verbal and written communication skills with strong analytical and problem solving skills.

TECHNICAL SKILLS

ERP Versions: SAP R/3 - 4.7/4.6C and ECC 6.0/5.0

Net Weaver Versions: SAP BI 7.0 (NW 2004s) and SAP BW 3.5/ 3.1C/3.0, CRM 7.1

Reporting Tools: BEx Suite, WAD, Business Objects 6.5/XIR2 and XIR3, Xcelsius, Crystal ReportsWEBI reports

Interfaces: Workflow, ALE, Enhancements, BAPI, BADI, RFC, ALV

Web Technologies: HTML, XML, JavaScript, VB Script, Framework 2.0

Languages: ABAP/4, C, VB, VBAOperating Systems Microsoft Windows XP/Sever 2003/2008/Linux, UNIX

Other Tools: MS Project, MS Office Suite.

Database: Oracle 9i/10g, DB2, SQL.

PROFESSIONAL EXPERIENCE

Confidential, Irwindale, CA

SAP BW-CRM Functional

Environment: SAP CRM 7.1, SAP BI 7.0, BEx, BO Designer (XIR 3.1, WEBI (XI R 3.1), Xcelcius 2008.

Responsibilities:

• Created new fields as per Business requirements for Service Contracts (SC), Activities, Leads, Opportunities, Service Orders (SO), Service Confirmation, Customer Contacts, Marketing & Campaign.
• Provide CRM functional design solutions for customers, including full life-cycle implementation.
• Handled different types of Defects on the backend BW, BEx side as well as at the report level (Webi).
• Experienced in enhancement of the master data and transaction data sources with Z-fields and are populated using User Exits.
• Created Aggregates on Info Cubes to improve the query performance and also used Exception Aggregation.
• Checked whether all the flows are getting populated from the CRM system to BW system with correct data.
• Added new Key figures to resolve issues related to exception aggregation.
• Also made integration with DSO from different flows.
• Ran Webi reports to check correct data loads from CRM to BW and also checked the filters used in it.
• Also checked the correct mapping between Source system and BW system fields and also the custom extractor whether they are populating the data or not.
• Coordinated with Tech team if any enhancement was required to custom extractors.
• Conducted Functional Unit Testing on Multiproviders, CRM source system, BEx Query and Webi reports.
• Worked on HPQC for testing and also defect resolving.
• Configured SAP CRM products per requirements, including testing, problem solving, and debugging.
• Identified and documented business processes in CRM for professional services clients.
• Experienced with different CRM Extractors for all the flows and also coordinated with Tech team with enhancements of extractors.
• Identify and administer CRM best business practices per business standards for functional processes.
• Communicated with Business resources for business requirements and implemented them on BW side.

Confidential, IL

SAP BI-BO Consultant

Environment: SAP ECC 6.0, SAP BI 7.0, FI, ABAP/4, BEx, BO Designer (XIR 3.1, WEBI (XI R 3.1), Xcelcius 2008, Crystal reports 2008.

Responsibilities:

• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), Profitability Analysis (PA), General Ledger (GL), Special Ledger (SL) and customized them as per the client requirement.
• Developed write optimized DSO's for EDW layers and standard DSO for consolidation layers and created direct update DSO's.
• Developed transformations with start routine, update routine and end routine and involved in the creation and maintenance of DTP and Info Packages for loading data in to data targets.
• Created generic data sources with Function module extraction method.
• Experienced in enhancement of the master data and transaction data sources with Z-fields and are populated using User Exits.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
• Responsible for Configurations in Assets like, Copying reference Chart of Depreciation, made required settings for account determination, asset classes, screen layout rules, defining number ranges, valuation of assets in different depreciation areas, external asset acquisition, in-house asset acquisition, cross company code transfers, settings for depreciation runs, Asset Explorer, Settings for automatic account assignment ( FI-AA Integration).
• Configured the controlling area, cost elements, Cost centers (CO-CCA), Number ranges, Cost center hierarchy.
• Enhanced the business content data sources by appending structures, User Exits and customized delta
• Worked on Accounts payable cubes and accounts receivable cubes and enhanced the performance (Modeling, Data load) from other systems and did currency conversions for Country specific.
• Created process chains for periodic upload of master data, transactional data, and text data and scheduled and monitored the data loads with delta update and full update mechanisms.
• Created Aggregates on Info Cubes to improve the query performance.
• Involved in Query performance analysis and optimization/tuning through data model, query definition, Aggregates, BI Accelerator(TREX search and classification) indices, OLAP Cache, Database Statistics, Virtual Characteristics & Key figures, time-dependent master data, non-complex authorization & delta caching
• Created BEx queries for reporting on InfoCubes, InfoSets, ODS and MultiProvider
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Generated month to date and year to date reports for MM and FI and monthly distribution reports for Human Resources
• Created formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Created exception aggregations, cell editors, formula variables, RFK's and CKF's in the queries.
• Extensively used WAD and published reports on Enterprise portal as iView
• Extensively used calculations, variables, prompts and sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Created inventory accuracy Dash Boards (Xcelcius) and for management reports for inventory management and wages and costs report from cost center accounting
• Created advance analytics like speedometers, interactive metric trends to gauge the performance of the key business.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Implemented analytics across the organization and used tabs on company performance via flexible management dashboards and implemented index awareness.

Confidential, Los Angeles, CA

SAP BI-BO Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, FI, HR, ABAP/4, BEx, BO Designer (XIR 3.1, WEBI (XI R 3.1), Crystal reports 2008, Xcelcius 2008.

Responsibilities:

• Involved in the full life cycle implementation which includes Gap Analysis, design, development, testing, implementation and support.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Analyzed business reporting requirements that could be satisfied by Business content Info Cubes for Cost and Allocations.
• Extensively worked with General ledger, Accounts payable data sources for extraction and loading of data from FI to BW.
• Created custom Info Cubes and worked on line item dimensions and standard DSOs.
• Developed Custom data source (Generic data Source) using various HR PA and OM info types based on this project requirements.
• All the transactional data sources were generic data source built from the info types based on OM and PA requirements.
• Developed more than eighty reports in both OM and PA. Published them based on the portal.
• Created and maintained queries containing restricted and calculated key figures, filters, and conditions and structures in BEx and presented in Workbooks.
• Developed programs to populate reporting customer exit variables.
• Extensively used formula variables, conditions, exceptions, exception aggregation and Cell editors for developing complex custom reports and dashboards.
• Created iViews, pages to display BEx/web reports in Enterprise portal 7.0.
• Involved in assignment and maintenance of Roles and Authorizations to users for BI security.
• Employed Web Application Designer (WAD) to facilitate the analysis in a drill down or summarized way to give detailed levels of data.
• Created Crystal reports and dash boards using Business Objects Xcelsius.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.

Confidential, Seattle, WA

SAP BW/BI Technical Consultant

Environment: SAP ECC 6.0, SAP BW 7.0, FI, CO-PA, HR, BEx Analyzer, Query Designer, Web Application Designer, BO Designer (XIR 3.1), WEBI (XIR 3.1), Xcelcius 2008

Responsibilities:

• Involved in full life cycle implementation, right from requirement gathering, blue printing, development, testing, go-live and post go-live support.
• Held meetings with business users in order to gather business requirements and prepared business blue print based on those requirements.
• Extracted and uploaded data into InfoCubes from Data Sources like Actual Cost through delta extraction (0C0 OM CCA 9) and Internal Order through delta extraction (0C0 OM OPA 6)
• Extracted the data from HR data sources like 0HR PA OS 1, 0HR PA CM 1 (Staffing Assignments) and loaded into Infocubes 0PY C02 Payroll data, 0PABN C01 Benefits.
• Extracted data by creating Infoset Query extraction method.
• Performed LO, profitability (CO-PA) and Generic extractions throughout the project.
• Worked with functional consultant for mapping the source data (ECC) to target data source in BW.
• Created Queries by defining rows, columns and free characteristics providing drill down functionality in reporting using BEx. Worked with users to understand their reporting needs.
• Generated Export Data Sources to transform data from one InfoCube to other InfoCube.
• Scheduled Daily/Weekly/Monthly data loads.
• Managed and monitored data loads with full upload and delta mechanism.
• Created Infoset for master data to enabling querying on data.
• Created summarized reports which includes display of Plan/Actual variance measures, analysis of full cost by cost center, overdue analysis, and analysis of payment history.
• Developed and Tested Web Reports for drill down functionality including updating rules and transfer rules & verifying queries.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Monitored and implemented the solutions to the errors in the Production System.
• Worked on performance of queries and performed various tuning techniques using Compression, Aggregates and Multiproviders.
• Developed single and multiple dash boards and score cards using Business Objects.
• Created Master/detail reports, cross tabs, charts and applied slice and dice, implemented different levels of hierarchies for drill techniques.
• Involved indesigning Universeand migrating existing ad hoc 'Crystal Reports Explorer 11' to Web I.
• Defined BO Classes, Objects in the Universe and defined Cardinalities, Contexts,Joins and Aliases and resolved loops in Universes using Table aliases and contexts.
• Enabled dynamic report linking by passing Variables (prompts) between reports.
• Designing, developing and deploying using Universe Designer, Web Intelligence, Desktop Intelligence, Info View and CMC.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them.

Confidential, Indianapolis, IN

SAP BW/BI Analyst

Environment: SAP BI 7.0, BW 3.5, SAP ECC 6.0, SD, MM, ABAP/4, BEx Analyzer.

Responsibilities:

• Involved in migrating old data model BW 3.5 to new data model BI 7.0.
• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods.
• Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.
• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
• Experience in the creation of the setup tables for the LO Cockpit extraction.
• Created process chains for periodic upload of the master data as well as the transactional data
• Involved in the monitoring data transfers from source systems into BW using PSA.
• Developed reports on the MM cubes to check the price variance for materials from different vendors.
• Created reports on SD cubes for displaying sales figures and incoming orders.
• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Involved in the creation of the dash boards for sales, purchasing and delivery using Web Application Designer.
• Performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
• Performed extensive unit testing in the development environment for all the objects created.
• Worked with the security team in designing the security strategies for global front end reports and workbooks.

Confidential, San Ramon, CA

SAP BW Consultant

Environment: SAP BW 3.1 C, SAP R/3 4.7, BEx, FI-CO, SD and ABAP.

Responsibilities:

• Created Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load Master and Transactional data from SAP R/3 system into BW system.
• Performed analysis, design, development and implementation of standard/customized Info Cubes and ODS objects for FI, MM and SD modules.
• Handled accounts payable cubes (0FIAP C03), accounts receivable cubes (0FIAR C03) as a part of SAP BW implementation.
• Enhanced the Info Cubes by adding custom Info Objects to reflect modified R/3 Business Process.
• Enhanced Business Content Data Sources as per the business requirements using User-Exits.
• Design and development of IDOC interfaces for data transfer to accounting.
• Worked in creating role based security and authorization for all objects.
• Extensively used BEX Analyzer to build queries, queries with charts and worksheets to access data from BW data targets to generate reports.
• Extensively worked on Crystal Enterprise (Reporting) for Web publishing, security and administration.
• Identified the extractors on the R/3 OLTP systems and defined the Transfer structures on the source and target systems.
• Created various transfer rules with and without PSA update.
• Modified Update rules, Transfer rules, Update routines, and Transfer routines as per client requirements.
• Performed CO-PA and LO Cockpit extractions. Used LO Cockpit structures for delivery service, sales trace overview to facilitate the data extraction to BW.
• Managed and monitored several data loads. Optimized load performanceby adjusting the packet sizes.
• Published queries on the web using BEx Web Browser. Worked on Info Set queries for reporting on master data and calculated key figures.
• Created web reports through report template in WAD (Web Application designer). Extensively worked on web reporting.

Confidential, Troy, MI

SAP BW Developer

Environment: SAP BW 3.5, SAP R/ 3 4.7, business Object designer, SD, ABAP/4.

Responsibilities:

• Gathered Business Requirements from SD module and Conducted Gap Analysis to install Business Content.
• Designed & Developed custom Datasources, InfoSources, Extractor, InfoCubes and ODS to fulfill user requirements.
• Developed Transfer rules, Update rules and Start routines using ABAP to in corporate Business logic and perform data manipulation.
• Extensively worked on transporting objects between BW system environments and corresponding SAP R/3.
• Developed data loading strategies for master data, transactional data and delta uploads.
• Created process chains for data loading, delta uploading and periodical PSA deletion.
• Created Multiprovider on sales, delivery and billing cubes to assist reporting on sales, delivery and billing together.
• Used Filters and Conditions to achieve report functionality.
• Created group variables for grouping related data.
• Worked on Creating Aggregates, Compressions, Indexes, multiprovider and parallel setups for data loading to improve performance and utilize data effectively.
• Created reports using BEx Reports, Workbook, and Queries for the required sales order queries with exceptions, conditional formatting, restricted key figures and calculated key figures.
• Extensively used BEx analyzer, created queries with variables, filters. Used RRI feature to jump between the queries to analyze the data.
• Extensively worked on Query Designer and Web application designer to create Queries to perform sales, delivery and billing analysis using Restricted Key Figures, Calculated Key Figures, Variables, filters and exceptions.
• Involved in documentation and end-user training.

Confidential

SAP BW Consultant

Environment: BW 3.1C, SAP R/3 4.6C, SD, FI-CO, BEx Analyzer, Query Designer.

Responsibilities:

• Involved in the Business Process study and identifying the reporting requirements.
• Worked on Front end, Queries, BEx Analyzer and presenting the result in workbook for Reports based on InfoCubes, ODS Objects and published the Web with Drill down features.
• Query development using BEx Analyzer/Browser, Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way.
• Analyzed, Enhanced Infocubes, ODS in standard delivered Business Content in SD, MM and FI/CO with specific requirement to the client’s business process.
• Created custom cubes, MultiCube for customer and vendor cycle core returns, sales order item/quantity Sales order header for fill rates, custom ODS, Custom Info Sources.
• Worked on standard InfoSources from the Business Content for MM - Purchasing for Transactional data
• Created Aggregates, worked on Performance Tuning and Production Support.
• Worked on data extraction, LO-Cockpit, CO-PA.
• Worked on R/3 Data Extraction Enhancements.