SUMMARY

• 7+ years of SAP Business Information Warehouse (BW), and SAP Business Objects (BO) experience which includes 2 Life Cycle Implementations in SD, MM, HCM, FI, CO - CCA.
• Has extensive experience in working with multiple projects encompassing multi-cultural teams from diverse geographical regions.
• Experience working for corporations across diversified industry verticals includes Pharmaceutical, Retail, Manufacturing.
• Proficient in OLTP extractions of SAP LO-Cockpit, SD, FI, MM, HCM, CO-CCA, and APO, generic extraction, flat files & using DB Connect for legacy data.
• Experience in integrating and supporting BW with APO in Demand Planning (DP) and Supply Network Planning (SNP).
• Extensively worked in designing and configuring back-end components including Extractors, InfoObjects, Hierarchies, InfoSources, Update Rules, Transfer Rules, Transformations, InfoCubes, MultiCubes, ODS/DSO, InfoSets, InfoPackages, and Data Transfer Process (DTP).
• Expertise in DataSource Enhancement, User Exits, Loading, Scheduling, Monitoring, Process Chains, Open Hub Service, Authorizations, User Profile Maintenance, Reporting Agent, Enterprise Portal Integration, Information Broadcasting and alert monitor.
• Proficient in writing ABAP User exits for transaction data and complex routines in start routine, end routine and update routines.
• Expertise in creating and maintaining Process Chains and Meta Chains for automating data loads.
• Evaluated statistical performance using BW Statistics for optimization. Improved data load and query performance by using BI Accelerator (BIA), Compression, Aggregates, Indexes, optimizing Data packet size.
• Expertise in Production Support issues which involved debugging ABAP routines, Data loads, Validation and trouble shooting of Transaction Data and Master Data, Change management, Process Chains Monitoring, Transport Management, Roles & Security, System Checks.
• Expertise in working with BEx Analyzer in building Queries. Extensively created Calculated Key Figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Extensively worked on publishing reports to roles and portal, broadcasting workbooks, reports to end-users. Experience in providing the security using Authorizations for various requirements.
• Extensively worked on Business Objects (BO) integration with BW for reporting requirements.
• Experienced in Business objects universe designing (OLAP Universes), Business Objects Web Intelligence (WebI), Business View Manager, InfoView, and Business Objects Enterprise (BOE).
• Hands on experience in creating BO Xcelsius dashboards and KPI’s to large-scale multi layer reports.
• Involved in End-User training on Navigating reports, Post Go-Live maintenance manuals, Web Application Designer, Portals.
• Documented functional specifications, technical specifications, test cases, test results and production support documents.
• Excellent Documentation, communication, verbal, and problem solving skills. Proficient skills to communicate effectively with Team members, developers, clients and end users in a diverse environment.

TECHNICAL SKILLS

Data warehouse: BI 7.0, BW 3.5

Operating Systems: Windows 9x/2000/XP/Vista, 7, MS-DOS

Language: C, C++, Java, SQL, PL/SQL, ABAP/4

MS Office Tools: Word, Excel, PowerPoint

ERP Packages: SAP ECC 6.0, R/3 4.7

SAP Modules: SD, MM, FI, CO, PCA, HCM, PP, SCM, CRM, SEM-BPS

Web: HTML, XML, Dream Weaver

Reporting Tools: BEx Reporting, Web Application Designer (WAD), Business Objects (XI)

PROFESSIONAL EXPERIENCE

Confidential, Orange, CT

SAP BI/BO

Environment: s: SAP BI 7.0, SAP ECC 6.0, SD, MM, FI, BEx Analyzer, Business Objects (XI).

Responsibilities:

• Actively interacted and scheduled meetings with the business users to gather the reporting requirements, performed gap analysis and developed design documents.
• Collaborated with SD, MM and FI functional consultants to resolve business and configuration issues.
• Responsible for development and extraction of data from ECC source system into BI from SD, MM and FI modules.
• Extracted Standard DataSources 2LIS 02 HDR, 2LIS 02 ITM, 2LIS 02 SCL from the Business Content using LO- Cockpit extraction methods for Transactional data and enhanced them to meet the reporting requirements. Performed LO - Cockpit extraction for Sales Order, Sales Delivery, and Billings.
• Responsible for implementing FI-GL using Business Content DataSources and Cubes to deliver the Balance Reports.
• Extensively created custom cubes and DataStore objects by enhancing the business content also developed Write Optimized DSO’s for EDW layers and Standard DSO for Consolidation Layers.
• Created Generic DataSource in the ECC source system to facilitate Inventory Accuracy Rate reports like Quantity Difference, Quantity Count.
• Built User exits for all the applicable applications using CMOD to populate the data from the respective application tables.
• Responsible for Data Modeling to correct the models for a better loading of data. Created Line Item Dimensions, Secondary Indexes on DSO, Number ranges for the dimensions to enhance load performances.
• Created Analysis Process Designer (APD) to extract pricing data into CSV file format for further analysis by using data transformations.
• Expertise in using ABAP and ABAP Objects.
• Developed complex ABAP routines to split single records from sales source data to multiple records in the target by creating Internal table to the meet the requirement. Created Update Routines and End routines to count the instances of Quantity differences and Time concatenation etc in Inventory Accuracy report.
• Created and Maintained DTP and InfoPackage for Loading. Created, Maintained and Monitored Process Chains for periodic loads of Master data and Transaction data from ECC system to Data Targets using various process categories and process types.
• Performed automated deletion of PSA and Change Log tables using Process Chains to improve the Data Management.
• Proposed and installed BW Statistics to monitor the Load and query performance on cubes and enhanced the performance by building aggregates on required objects. Injected BW statistics event in the process chain for Data collection.
• Implemented Compression and Partition techniques for cubes to improve the query response time. Proposed archiving strategy for future based on Time characteristics.
• Worked on the implementation of BI Accelerator. Involved in identifying cubes for BIA, Creating indexes and performing BIA index reorganization.
• Created reports from purchasing data sources like Purchase Orders Quantities, Purchase Order Values, Open/Closed Purchase Orders, % of confirming PO, Amount outstanding, and Confirmed Quantity.
• Developed sales reports like Order to Cash (OTC), Weekly Deliveries, Sales Values, Top Customers, and Incoming Orders.
• Developed BEx queries for reporting on InfoCubes, InfoSets, ODS and Multi Provider by defining Structures, Variables, Formulas, Exceptions, Selections, Navigational Attributes, Conditions providing drill down functionality in reporting.
• Responsible for the development of various Test Cases/Scenarios and validation of BI reports at various stages of testing such as Unit Test to validate data load, report testing and delta verification and detailed Integration Testing for various test case scenarios.
• Performed Functional Testing to test the system settings and custom developments, to make sure that the development or configuration works as designed and the data is accurate.
• Created BI OLAP universes over BEx queries using Universe Designer, published the reports on the web using Web Application Designer (WAD).
• Extensively worked on formatting Business Objects reports to meet the user’s requirements using Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Contexts, Alerts.
• Extensively Worked with SAP Live Office to create connections between WEBI and Xcelsius Dashboards. Worked on INFOVIEW to create Web Intelligence Reports over BO Universes.
• Worked with Transport connector for transporting the BW objects and reports between Development, Test and Production systems.
• Worked extensively on various Production support issues and administration of BI back-end operations by raising tickets to SAP OSS (Online support system) to the ensure data is successfully extracted from source systems and reported correctly.
• Trained Super Users to develop ad-hoc queries in BI Query Designer. The training included creating queries from various sources such as InfoSets, MultiCubes, creating and restricting CKF’s and RKF’s, use of aggregations and creating input parameters among other items.

Confidential, Houston, TX

SAP BI/BO Consultant

Environment: s: SAP BI 7.0, SAP ECC 6.0, FI, SD, MM, HCM, BEx, Business Objects (XI).

Responsibilities:

• Involved in full cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Activated Business Content for Accounts payable (AP), Accounts Receivable (AR), General Ledger (GL), Cost Center Accounting (CO-CCA), Purchasing and customized them as per the client requirements.
• Responsible for loading time dependent and time independent master data and hierarchies. Responsible for data extraction, reconciliation and reporting of FI data in BI.
• Developed InfoSpokes using Open Hub service to extract data from BW into .CSV format.
• Created custom InfoCubes for company wide Sales, Delivery, Billing and Purchasing with various aggregate periods (business day of the year, business day of the month etc.)
• Worked on Dimension Management and Application management such as creation, maintenance, additions and deletions.
• Migrated DataSources from 3.x to 7.0. Modified the business content update and transfer rules to transformation rules.
• Created Start routines and End routines using ABAP in transformations to update characteristics and key figures in the InfoCubes to facilitate various reporting requirements like the Price Purchase Variance and Foreign Exchange Exposure reports.
• Performed Remodeling on already existing InfoCubes to add new key figures and characteristics.
• Designed process chains for daily master data loading, transactional data loading from ECC.
• Reviewed system statistics and other measures to identify the need for aggregates, indexes, compression and other performance improvement techniques.
• Responsible for compression and partition of certain cubes for enhanced performance. Proposed archiving strategy for future based on Time characteristics.
• Improved query performance and data load using OLAP cache.
• Created Price Purchase Variance (PPV) and Foreign Exchange Exposure (FX) reports. Created FI reports “Overdue analysis (Aging report)” “Payment History”, “Due date for net payment”.
• Generated Cost Center “Internal Order” report which provides an overview of the incurred costs and consumption quantities on an internal order group during the reporting timeframe and the fiscal year. Also developed reports such as Actual costs, Plan/Actual, Target/Actual.
• Created Variables, Restricted Key figures, Calculated Key Figures, Filters in the BW Queries. Built code for specific User exit variables and replacement path variables to capture the requirement for Year-to-date, Quarter-to-date and Month-to-date.
• Created BW OLAP Universes on top of BW Queries to access the BW data in Business Objects. Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports.
• Created WEBI reports and crystal reports and deployed them through info view with BW universe as source.
• Designed and developed Business Objects Universe for Aging report.
• Published IViews for WAD templates and embedded in the portal in the respective business roles.
• Performed Referential Integrity Check for both the Master Data and Transaction Data at DTP and transformation levels.
• Designed dashboards using Xcelcius and developed detailed level reports using WEBI. Exported XML output for BW queries as a source for Xcelcius dashboards.
• Worked in coordination with the basis team to Transport (DEV to PROD) the objects.
• Created necessary documentation throughout the project implementation. Conducted User Training for end users about the navigation features possible in the reports.

Confidential, FL

SAP BW consultant

Environment: s: SAP BI, SAP ECC 6.0, APO, HCM, FI, BEx.

Responsibilities:

• Installed the Business Content for Accounts Payable, Cost center Accounting (CO-CA), HCM and Customized them as per Client Requirement.
• Main responsibilities include Development, Enhancement, User Problems, Process Chain and Job Monitoring activities. The major supported SAP modules were FI, SD, APO, and HCM.
• Loaded the data from R/3 to BW and used Initialization with delta update and full update methods for extracting Sales Order and Delivery Information.
• Developed user exits to populate data into enhanced data sources using CMOD.
• Created custom cubes and activated transfer structure, transfer rules, communication structure and update rules (both ODS and InfoCube level).
• Created ABAP Routines in transfer rules and update rules for updating the Characteristics and Keyfigures according to the requirements.
• Extensively worked on integrating and supporting BW with APO in Demand Planning and Supply Network Planning.
• Extensively Worked on extracting HCM data sources to develop the data model for Organizational Management (OM) and Personal Administration (PA), where using this data model reports were developed for the Business users.
• Created process chains to automate the scheduling of data extraction. Monitored data loads.
• Developed Error DTP’s on Standard DTP for Error Stack.
• Involved in Performance enhancement features such as Cube Repartitioning, Indexing, Remodeling, maintaining Aggregates, Rollups and cube Compression. Responsible for enhancing the performance of system by addressing time consuming loads by fine tuning code or system parameters based on situation.
• Created HCM reports for the scenarios like Average head count, Number of fixed-term employees at the end of month or quarter, Age distribution, Average service years, Gender ratio %, Starters % (YTD), Leavers % (YTD).
• Designed and developed various financial reports and later also customized the report using Report designer. The reports were based on the FI-GL Income statement, Balance sheet, Cash flow and Assets Management.
• Created report in Demand Planning Forecast Deconstruction which allows the business users to break down the forecast by size and distribution center.
• Developed Activity vs Non Activity Forecast reports for business users which is to determine if the activity based forecast increases the statistical forecasting accuracy.
• Extensively worked on providing support for weekly Demand Planning cycles with data loads in BW box of APO.
• Extensively created Formula Variables, Conditions, Exceptions, Exception Aggregation, Cell editors, Customer Exit Variables and Structures for developing complex custom reports.
• Extensively involved in conducting and monitoring test results for Unit testing and Functional testing of several user exits and routines.
• Involved in various post-go live activities and responsible for production support activities and monitoring regular data loads and failures. Monitored daily batch jobs and fixing data inconsistency issues in coordination with scheduling team and SAP Basis.

Confidential, WV

SAP BW consultant

Environment: s: SAP BW 3.5, SAP R/3, SD, MM, HCM, PP, FI.

Responsibilities:

• Responsible for design, development and extraction from R/3 source system and Flat file to BW.
• Extracted the data using LO Cockpit Extraction from the DataSources 2LIS 11 VAITM, 2LIS 11 V ITM, 2LIS 12 VCITM, 2LIS 13 VDITM to populate the Custom InfoCubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Configured Logistic cockpit extractors for sales, billings and purchasing modules and enhanced them to capture the additional information not part of the extractor.
• Handled assignments where the responsibility was to activate standard InfoCubes and create custom cubes.
• Designed custom cubes and Operational DataSources, developed delta management functionality and optimal use of update rules keeping query performance in view.
• Worked on HCM Personal Administration, to report on Head Count, Personal Actions, Recruitments and Salary Distribution by cost center etc.
• Implemented HCM payroll administration using business content.
• Enhanced Master DataSources for Employee to get additional data like base location, University, highest level of qualification to suit the business reporting requirements.
• Used delta update mechanisms for uploading the data to BW from R/3 in specific intervals.
• Created reports for FI module like sales and profit, Reconciling data in CO-PA, Purchase price variances (PPV).
• Developed InfoSpokes using Open Hub service to support retraction of the data from BW InfoProviders to SAP R/3 to create internal orders.
• Other areas of work include activation of BW Statistics cubes, extensive work on custom-built hierarchies.
• Worked on BEx Query Designer in designing queries using Filters, Variables, Navigational Attributes and Structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Worked with Web Application Designer (WAD) for creating web templates for FI, PP modules. Created complex web templates, used interactive charts, and tables.
• Created Drill tHCMough queries from summarized InfoCube to detail ODS data.
• Worked extensively on reporting for the extracted data and involved in creating role based security and authorization for all objects.
• Solved issues/tickets regarding Queries/workbooks. Used different techniques to resolve issues about queries and query output and satisfied the end users with the output results.

Confidential, IL

SAP BW Developer

Environment: s: SAP BW 3.5, SAP R/3, SD, MM.

Responsibilities:

• Involved in the Data Modeling process for Sales Arena by identifying Characteristics for dimension tables and Key figures for the Fact Table and defined the display and navigational attributes for the BW Extended Star Schema.
• Maintained extract structures for Purchasing, Inventory and Sales & Distribution. Generated data sources & activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Designed and developed custom ODS objects, InfoCubes for Inventory data and activated Update rules for these data targets.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies) for Materials and Sales arenas.
• Extracted the data using logistics from Sales and Billing DataSources to populate the Custom InfoCubes that evaluates quantities and values for sales orders, deliveries and returns, and invoices.
• Worked on Inventory cubes for business content DS. Analyzed the requirements to implement Snapshot scenario for cumulative key figures. Worked on 2LIS 03 BX and 2LIS 03 BF DataSources.
• Statistical Data upload to LIS info structures S260, S261, S262 & S263 for S&D module within SAP R/3 OLTP.
• Created InfoPackages with Full Loads, Delta loads, Initialization with/without data transfer etc. Tested the data loadings, delta loads and verified data with R/3 side.
• Worked on creating start routines and end routines in update rules to ensure proper loading of data.
• Created Purchase order control report, this report will show the statuses of Purchase orders and Sales orders in particular the third party purchase orders and sales orders.
• Developed an interactive report to list the purchase orders details for a vendor that has interactive drill down options to give the details of vendor from vendor master.
• Designed making extensive use of the ODS capabilities, delta management functionality and optimal use of update rules keeping query performance in view.
• Extensively worked on InfoCube maintenance like Compression and Roll- ups.
• Worked on BEx Query Designer in designing queries using filters, variables, navigational attributes and structures to facilitate flexible, detailed drill down data analysis to required level of information.
• Created variables for Currency Conversion Types and used variable offsets for comparing data between periods and for value ranges
• Created reports which display sales order and line items, which needed to be delivered on a particular date.
• Created variables with user/sap exits, calculated key figures, formulas and structures in query development, working with workbooks, exception reporting, conditional reporting.
• Extensively involved in production support issues involving data loading, monitoring, and batch issues.

Confidential

SAP BW Developer

Environment: s: SAP BW 3.0, SAP R/3, Oracle 8i, SD, FI, MM.

Responsibilities:

• Extracted the standard Business Content as well as worked on creating InfoSources, InfoObjects, InfoCubes, ODS Objects, Transfer/update rule process chains.
• Installed business content DataSources for Sales, Billing, Purchasing and Finance reports.
• Performed Logistics Cockpit configuration and customization for sales order overview and extended the extract structures using user exits to meet the necessary business requirements.
• Uploaded master and transactional data from flat files and SAP as the OLTP source. Worked extensively on administration workbench (RSA1).
• Documented and implemented ABAP developments, drill-down reports, BDC programs, custom transactions, etc for SD, MM and FI modules.
• Created regional Sales Summary cube to Sales, Delivery and billed items information. Used LIS extractors to pull the data from SAP R3 production system.
• Used ODS to stage the data before transferring the ODS contents to the InfoCube, performed ODS reporting to give details of delivery items and schedule line items. Designed InfoCubes with daily and Monthly Granularity, extraction from PSA.
• Extensively built queries on InfoCubes, ODS Objects, MultiProviders, InfoSets using BEx Analyzer and Web Application Designer (WAD).
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries. Created aggregates on top of the cubes to improve the query response.
• Maintain the list of all the activities for all the tickets until it is closed down. Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Designed and implemented configuration changes for both load performance and query performance optimization.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains. Actively Involved in Rectification of Load Failure errors like Master Data Loads, Transaction Loads.

Confidential

SAP BW Developer

Environment: s: SAP BW 3.0, SAP R/3, SD, Flat files

Responsibilities:

• Understood the Client requirement, prepared the technical specification of the report requirements.
• Installed the Business Content as well as created Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Designed Info cubes with daily and Monthly Granularity, extraction from PSA.
• Extensively involved in debugging ABAP Routines.
• Developed routines to implement complex pricing requirements not handled by standard SAP.
• Configured use of restricted key figures, variables, exceptions and calculated key figures in queries.
• Improved the query performance by creating aggregates.
• Worked on Query development Templates and Workbooks in BEx Analyzer.
• Created interactive reports in SD module by extracting the information on delivery and invoice status, shipping details and partner function details.
• Extensively used BEx Analyzer, created queries with Variables, restricted key figures, calculated key figures, conditions, exceptions etc.,
• Designed documentation for queries using BEx Analyzer Reporting tool for presentations.
• Extensively involved in the job scheduling and monitoring of info packages using SAP BW Administrator Workbench.