SUMMARY

• Over 8 years of experience in Information Technology industry with SAP BW 3.5, BI 7.0,BI 7.3 , SAP ABAP,SAP R/3 ,SAP ECC in SD/MM/FI/CO/HR modules .
• Expertise in the functional and technical areas of SAP BI 7.0 with full cycle implementations using ASAP methodology
• Expertise in the technical capabilities of BI 7.0 BI 7.3 Transformations, DTPs, BI Accelerator, etc.
• Experience in Data modeling using InfoCube, MultiProvider, ODS, Transfer rules, Update rules, InfoSet, InfoSources, DataSources, Transfer Routines, Update Routines and Start Routines.
• Extensively worked with ABAP on Transformations with complex start/end routines , Update Rules, Transfer Rules and User Exits.
• Experience in Installation of Business Content Objects.
• Experience in construction of customized InfoObjects, InfoCubes,RemoteCubes and ODS/DSO objects
• Designed and developed queries for reporting using BEx Analyzer, Query Designer and Web Application Designer
• Created web reports using WAD and saved them as i-views to leverage SAP-Enterprise Portals.
• Developed Update and Transfer Routines in BW to implement business rules and conversions while extracting data from R/3
• Expertise and intensively worked on SAP BW Security and Authorizations
• Extensively worked on pre and Post Up gradation activities for BW 3.5, BI 7.0 BI7.3
• Expert in creating Process Chains for Automation of process and Better Performance
• Enhanced Data Sources and Created Generic Data Sources as part of Extraction.
• Conducted and performed Performance tuning Techniques Aggregates, Cube Compression, Line Item Dimension, and Indexing for Improving the Reporting.
• Used and created Info Spokes for OPEN HUB services
• Extensively worked in Data Extraction from Multiple SAP and Non SAP Legacy Systems using Business Content ,LO,LIS,CO-PA,FI-SL, Flat File, Generic Extraction Methods for legacy data.
• Extensively involved in BI Production Support in handling daily batch jobs, load failures, delta failures, Performance issues, BIA issues, System issues, reporting issues, locking issues, resource bottleneck issues.
• Solid experience in Front-end BW queries, workbooks and templates, RRI, Calculated and restricted key figures, Variables, Information Broadcasting and publishing reports in the Portal.
• Attended in house training and Have good knowledge on SAP HANA.
• Proficient in coordinating and managing the activities between on-shore and off-shore teams.
• Excellent Communication, Interpersonal skills, Problem solving abilities and effectiveness in working independently or as a team player

TECHNICAL SKILLS:

• SAP BW Versions: 7.3/7.1/3.5.
• SAP CRM Versions: 5.0.
• SAP R/3 Versions: ECC, 4.7, 4.6C.
• Business Objects: Business Objects XI 3.1, Designer, Web Intelligence rich client, Desktop Intelligence, Info View, Xcelsius 2008.
• Databases: Oracle 9.i/8.i.
• BW reporting: BEX Analyzer 3.x and 7.0 , Query Designer 3.x and 7.0 , WAD 3.x and 7.0 and SAP Portal.
• ERP Packages: SAP SD, MM, FI/CO, HR and CRM modules
• Operating Systems: Windows 2000/XP/NT.

PROFESSIONAL EXPERIENCE

Confidential

Senior SAP BW Consultant

Environment: SAP ECC 6.0, SAP BI7.3, Bex Designer, WAD, BO 4.0

Responsibilities:

• Project involves migrating applications from SAP BW3.5 to SAP BI7.3. Use SAP BW to extract data and build dashboards in Xcelsius, and build and modify existing reports and simultaneously create and design reports using SAP BOBJ.
• Upgraded from BW 3.5 to BI 7.3 Technical Upgrade and Dash Board implementation.
• Interacted with the management and business Decision-makers to identify business requirements. Documented reporting needs of the Business Service and Support Organization and disseminated those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Successfully executed the BI Upgrade strategy from BW 3.5 to BI 7.3 including Pre-Upgrade and Post Upgrade tasks collecting system objects, Security .

Upgrade Activities:

• Involved in the Pre Upgrade Activities 3.5 to BI 2004s .
• Running of Reports for activation of all the Objects.
• Running RSRV for the Consistency Check for Master and Transactional Data.
• Running the Report RSUPGRCHECK Report for Checking the Consistency Check.
• Involved in the post Upgrade activities BI 2004s .
• Involved in the Base Line Testing
• Migrated Library Items from 3.5 and from 3.5 to 7.3.
• Emptying the Queues SM13 LBWQ by running the V3 Jobs.
• Deleting the Data from the Set Up Tables
• Running the Process Chains to fetch Data and Emptying the RSA7.
• Resolved many issues around the Upgrade. Created OSS messages for Upgrade issue.
• Conducted the User Training on the New Bex Features. Installed and configured the BI Admin Cockpit. Successfully deployed the New Analysis Authorization.
• Worked closely with the Corporate Consultants in providing Functional Specifications to enhance the current and develop new ODS and InfoCubes. Defined Custom Cubes and MultiProviders for the business scenarios along with aggregates.
• Responsible for developing High level Data flow and revising the Gap Analysis.
• Used Hierarchies in the reporting to provide drill down features. Designed and developed reports with filters and free characteristics.
• Worked on Custom extractors using function module for BOM extraction

Confidential

Senior SAP BW Consultant and Lead

Environment: SAP ECC 6.0, SAP BI, Bex Designer, WAD

Responsibilities:

• Worked on Confidential project for Patch and plug in upgrades, which involved preparation of all clients for upgrade, post upgrade testing.
• Was responsible for the change management process and moving the objects to production.
• Developed Standard Test case template for Pre and Post Upgrade process in upgrade. Tested Sandbox and development environments as per test cases in upgrade process from the business users.
• Perform test support patches and OSS Notes for Upgrade.
• Involved in creation/approval of transports between D-Q-P systems.
• Created test environment, test plans, test data involving Business users in the UAT/Integration testing
• Created training documentation/power point presentations for the Business Users
• Created process chains for data loads and used and applied logic on info packages for building pseudo deltas.
• Administered the user's roles and privileges in Central Management Console.
• Scheduling the documents and distributing them using CMC and monitoring them.
• Creating aggregates and indices for better query performance
• Configured SAP BW and source systems
• Evaluated statistical performance and made recommendations to basis support for optimization

Confidential

Role : Senior SAP BW Consultant

P L, Balance Sheet and Cash Flow Reports:

• Documented the Design, Development, Testing activities following the client's requirements.
• Transported the Objects across the Systems. Performed Cut-over Tasks. Created necessary Aggregates to improve the Reporting Performance and automated the rollups in Process Chains.
• Performed The Unit Testing of the Development Work And Documented the Results. Interacted With Users/Functional Team during Integration Testing.
• Created and modified Bex Queries for Cash Flow, Balance sheets, P L, Vendor Spend Analysis, Natural Accounts reports, etc., with all Bex features including Filters, Conditions, Exceptions, Variables, Calculated Restricted Key Figures. Created Web Templates on top of the Bex Queries and coordinated with Portal Team for update on the Intranet.
• Created Process Chains to Automate the Data Loads.
• Extracted data from ECC and File Source Systems. Enhanced FI Data sources suitably with additional custom fields as per the Design for reporting. Created Generic Data Sources for Extracting Data from Ztables and master data based on table/view and function module. Extracted data into BI and validated it.
• As per the Model/Design, I have activated Business Content wherever possible.Created necessary Custom Infoobjects, DSOs, Infocubes, Multiproviders, Tranformations, DTPs and Infopackages etc., based on the Data Models.
• Gathered Requirements by interacting with Users Performed GAP Analysis, Created Data Modeling, Created Functional Technical Documents for P L, Cash flow, Balance sheet etc., as per the Requirements.
• Supported the system after Go-live and addressed issues. Resolved Help Desk Tickets

Confidential

SAP BW Consultant BW-BO integration, Enhancements and Production Support, BW Upgrade

Environment : SAP BW 3.5, BI 7.0,SAP R/3, ABAP/4, BEx, Query Designer, WAD and Portal, Universe Designer, Desktop Intelligence DESKI , Web Intelligence WEBI .

Requirement: Design, Development Enhancements, Queries Reports Cutover Activities

• Enhancements to Standard Data Sources
• Data Loading to Inventory Targets
• Unit Testing Automating the Loads
• Designing Development of BEx Queries Reports

Responsibilities

• Post Production support, which involves daily monitoring of data loads via process chains, trouble shooting and correcting the known errors and escalating the unknown to the SAP support team.
• Maintaining Reconciliation's for Finance and Inventory data to verify the data in SAP R/3 and SAP BW are same or not after the month end data loads as a part of month end activities.
• Actively involved in transition Phase to take Knowledge transfer and prepared SMTD document for SAP-BW system.
• Actively and regularly involved in Load Monitoring of Daily, weekly, and Monthly, Data Loads using Process Chains.
• Maintaining the queue related to the system generated tickets and customer generated tickets.
• Maintaining Work History for all the tickets until it is closed down.
• Handling Customer generated tickets and interacting with users for getting clarifications, giving effective solutions to SIR's assigned involving report and data issues.
• Interacting with different teams for the delay of schedule loads and re-schedule the loads when the file is arrived by control m team
• Analyzed and Corrected production problems as they occur in the SAP BW system
• Preparing status reports on Data Load monitoring of daily, weekly and monthly loads
• Enhancing the Standard Data Sources across functional areas as per the Business Requirements
• Enhancements to User Exit variables for Queries
• Design Development of BEx Queries across all Functional Areas
• Design Development of Workbooks and publishing them as per Business Roles
• Extensively coordinated with the Security teams to design implement Analysis Authorization for various Reports
• Enabling some of the Business Content Characteristics as Authorization Relevant
• Conducting the Train the Trainer Session for the Business Users

BW-BO Integration:

Business Objects Responsibilities:

• Involved in SAP BI BO integration and Migration of BI Bex Queries into BO.
• Created OLAP universes on Info cubes, Multi Providers and BEx Queries using Universe Designer.
• Designed and developed Xcelsius Dashboards using Universe Query as a Web service , Web reports Live Office , BI queries BICS and also used Open Document to drill down from Dash board to detail level of reports created using Web Intelligence.
• Involved in performance tuning of various WEBI reports in BOBJ side.

Confidential

Senior SAP BW Consultant

Environment : SAP BI 7/BW 3.5, NW2004s, SAP R/3 4.6C/4.7, ABAP/4, BEx, WAD

Requirement: End to End Implementation

• Global Regional Master Data Design, Development Deployment
• Designing Building Inventory Reports

Responsibilities:

• Involved in discussion with Business End Users for getting the Requirements
• Design Development of POC Proof of Concept for the Requirements
• Designing Developing Regional Flavor Master Data
• Re-aligning Master Data with Regional Global Flavors
• Enabling Enhancing Standard Data Sources for Inventory 2LIS 03 BX, 2LIS 03 BF, 2LIS 03 UM
• Enabling Enhancing PO Line Items Data Source 2LIS 02 ITM
• Enabling Enhancing Invoice Verification Data Source 2LIS 06 INV
• Designed Built Staging DSO's for Staging data across all the functional areas
• Designed Built Functional DSO's for Functional based requirement
• Designed Build Integration Layer with a Cube's Multiprovider
• Designed Build Reporting Layer as per User defined Queries Reports as per the Requirement
• Designing Developing various Test Case Scenarios also performing End to End testing across all the Targets
• Consolidating various Transports created for Development, Transporting Requests to QA and also Validating all the Objects Once transports are successfully imported to QA
• Productionizing the Developments
• Performing the Data Loads for various Targets as per the dependencies
• Design Creation of Process Chains to Automate the Data Loads
• Designed built Bex Queries involving Calculated Restricted Key Figures, Exceptions, Variables, Replacement Path Query Variables, Formula key figures etc.
• Designed, Developed Formatted the Final Reports as per the Business Requirements
• Conducted Train the Trainer session for End Users
• Extensively worked on designing developing new Universes on top of BI Objects like Info cubes Queries

Confidential

SAP BI consultant

Environment: SAP BI, SD,HR,FI

Responsibilities:

• Project preparation phase, gathering user requirements and data modeling using ERM and MDM concepts.
• Participated in Gap Analysis and enhanced the Business Content to fulfill the requirements.
• Customized and activated the Purchasing Data, Purchasing Groups and Inventory Management Info Cubes.
• Data extraction using LIS extraction and OLTP/generic data extraction for 2LIS 02 ITM Purchase Items and 2LIS 02 SCL Purchase Schedule Line .
• Data extraction from 2LIS 04 P ARBPL into 0PP C03 and 2LIS 04 P MATNR into Custom-build cube using LO Cockpit LBWE .
• Extracted data from FI-SL, 0FI AP 4 and 0FI AR 4.
• Extracted data from Organization Management, Personal Administration, Pay Role and activated HR related business content in BW
• Extracted data from SAP R/3 FI, CO modules into BW and created necessary objects in BW for data staging, transfer, and analysis.
• Extended 0employee attr to include the employees reports to manager, Address, Weekly hours, Weeks per year, teacher reference number, pension membership, salary protection code, pay method, CRB cleared status, continuous service date
• Worked extensively on BEx Query Designer. Developed flexible queries using filters, Navigational attributes in BEx Query Designer to facilitate data analysis in a drilldown Way to give detailed level of information.
• Extraction using LIS, LO Execution Cockpit and V3 updates.
• Involved in configuring and creation of DataSources, InfoSources to extract data from various Flat Files and SAP R/3 systems.
• Uploaded Master and Transactional data from Flat Files and R/3 Source System.
• Scheduled and Monitored data loads into BW from R/3 involving Delta Initialization and Delta Upload.
• Troubleshooting of BW data extraction / load problems.
• Incorporated Transfer rules for InfoCubes and customized update rules using ABAP/4.
• Activated the Business Content related to 0BBP C01 Procurement Cube .
• Activated the Business Content related to CO-PA.
• Activated the Business Content related to Project system Controlling info cube 0PS CO4 and Involved in configuration of Project system controlling with BW system.
• Evaluated Business Content for Inventory Management and activated the relevant Business Content Objects.
• Generated reports using BEx Business Explorer with exceptions, conditional formatting restricted, calculated key figures, Currency translation keys and RRI Query Jump Targets as per the requirements of the query.
• Used the variables in BEx Analyzer and published the reports and Created web reports through report template in WAD Web Application designer .
• Created queries on 0FIAR C03, 0FIAR C02.
• Created Reports on Organization Management ODSs and Authorized to Particular End User.
• Customized Business content reports of 0PA C01 as per the Requirement of the End users.
• HR reports Include Comparison 4 quarters previous year, Percentage Distribution of Entries, leaving rate, Average Head count, Net Entry Rate, Number of Entries, Head Count full-/part time Staff
• Created new queries with Variables, Calculated Key figures to the SAP BW.
• Published reports on web using Web Application Designer.
• Responsible for Performance tuning of the interfaces and reports in the Production and development environnent
• Applied the OSS notes as required

Environment: SAP BW 7 SAP ECC, BEx, ABAP/4, Oracle 8i, Windows 2000

Confidential

Senior SAP BI Consultant

Networks, our largest subsidiary, are involved in the planning, construction, operation, and maintenance of our transmission and distribution network. Confidential is a holding company with four operating subsidiaries. It emerged from the restructuring of Confidential as the owner and operator of the wires operations formerly provided by the provincially owned utility. The company employs approximately 4,000 full-time staff across the province. Confidential. owns and operates Ontario's 28,600 km high-voltage transmission system. The system transports electricity to 67 large industrial customers, 55 local distribution companies, and its own low-voltage distribution business.

Responsibilities:

• Involved in Developing the Technical Specifications requirements and also converting the Functional specs into Technical Specs.
• Worked on loading Master data and transaction data from flat file and SAP R/3.
• Created Info Objects, DSO objects, Info Cubes, Multi Providers, Transformation and Data transfer process.
• Worked with Multi Provider to combine several Data targets info Cube, DSO, Info Object to generate a Consolidated Report from Multiple Data targets.
• Customized and maintained Data Sources such as Billing 2LIS 13 VDHDR , Sales Order 2LIS 11 VAHDR , and Delivery Order 2LIS 12 VCHDR for the SD module and Purchasing Order Item 2LIS 02 ITM for MM
• Exclusively involved in BEx Reports and WAD Reports like Analysis Reports and Operational Reports.
• Extensively worked on Unit Testing to writing test Scenarios.
• Extensively worked on performance tuning to fine tune the Query performance and Data load performance.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing. Tuned queries using Partitioning, Aggregates and Multi providers.
• Good knowledge on necessary settings of inventory management, purchasing, process keys and moment types involved.

Environment: SAP BI 7.0, ECC 6.0, BEx, ABAP/4, Windows Xp

Confidential

SAP BI Consultant

Responsibilities:

• Interacted with business end users to gather requirements and transformed them into a data model with the concept of Extended Star schema.
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the necessary objects.
• Identified data sources based on end-user reporting requirements, and created Info Cubes, extracted data from CO module.
• Extensively used BEx analyzer, created queries with variables, filters, calculated key figures, restricted key figures, exceptions, conditions etc. Developed Report Report Interface for all the Cost Center Accounting CCA queries to drilldown from CUBE level to ODS level and then to R/3 level.
• Used Transport connection to move objects from development to quality environments. Worked with Transport organizer to migrate the newly developed queries, process chains to Test client for testing and then migrated to production.
• Attended Weekly status meetings and documented each stage of the Implementation.

Environment: SAP BW3.5,R/3, BEx, ABAP/4, Windows Xp

Confidential

Senior SAP BW Consultant

Responsibilities:

• Worked in prod support team as well as development team.
• Provided consultation for other projects that needed BW expertise.
• As Team member involved in modeling part of BW Objects.
• Prepared technical specifications for HR Time Audit report Jump Functionality.
• Compiled the test cases for User Acceptance testing of the BW objects.
• Tested the BW Objects in Development and Testing environments as per the test sets.

Production Support and Enhancements.

• Prepared Technical Specification for all the Enhancements related to HCM and SD modules.
• Enhanced HCM, SD data sources and build custom build reports as per the user requirement.
• Configuring the dataflow InfoObject, ODS, Infocube and MultiProvider .
• Prepared Technical Specification for all Break fix Enhancements for Production Support Issues.
• Prepared Test sets for User Acceptance testing of all the Enhancements and Break fix Enhancements for production support.
• Extensively worked on the production support issues in Personnel Administration and Organization Management Modules of HR.
• Resolved Production support issues related to Purchasing Data Cube and Purchasing Group Cube.
• Resolved Production support severity-2 3 issues related to Head Count Cube, Timesheet Data Total Cube, Time Sheet Data Approved Cube and Payroll Cube.
• Resolved BW job failures in HR and FI Cubes.
• Scheduling Monitoring of Process chains Master Data Transactional Data .
• On Call support and updating the Severity's of requests in Service Center.
• Allotting the Production Issues to the Cube Owners.
• Attended Weekly status meetings and documented each stage of the Enhancement.

Environment: SAP BW 3.5C, R/3 4.7, BEx, ABAP/4, Windows Xp

Confidential

SAP BW Consultant

Responsibilities:

• Configured, Developed and scheduled Business Content data extraction from SAP R/3 Source System and data load procedures.
• Data extraction from 2LIS 04 P ARBPL into 0PP C03 and 2LIS 04 P MATNR into Custom-build cube using LO Cockpit LBWE .
• Extended standard extract structures and user exit on SAP R/3 side.
• Performed analysis, design, development and implementation of standard / customized InfoCubes and ODS Objects for FI, MM and SD modules.
• Configured and Created a Custom InfoCube on Billing and Delivery Details.
• Created an ODS for Billing Historical Data which will be fed from the Flat File.
• Configured and Created Update rules, Transfer Rules, Update Routines, and Transfer Routines as per client requirements.
• BW standard Business Content installation, data modeling and configuring and designing InfoCubes with various aggregate levels.
• Extracted data from R/3 and Flat file Creating InfoPackages Event Scheduling Monitor settings.
• Used BEX Analyzer for normal Query Designing.
• Created Queries for TOP 50 customers, Top 50 Products, Net sales, Daily Sales etc.
• Involved on Configuration and Creation of Custom MultiCube for Billing and Delivery details.
• Monitoring the Data loads and correcting the Failed Data Requests and Resubmitting the data.

Environment: SAP R/3 4.6C, SAP BW 3.5C

Confidential

SAP ABAP Consultant

Responsibilities:

• Developed a report for creation/deletion of partner profiles for customer partner type 'KU' . In this case inbound and outbound parameters of a reference customer are copied to the target customers.
• Developed a report for creation/deletion of partner profiles for vendor partner type 'LI' . In this case inbound and outbound parameters of a reference vendor are copied to the target vendors.
• Developed a report for Attribute Value Testing for characteristic values of size and packaging of given set of articles.
• Developed a tool for validating the Customer PO texts for given Sales order s .
• Developed an ALV report to replicate the functionality of a normal standard report program with Dispute/Case Management functionality. Its major features include Custom Transaction Code, A wide selection criteria with dynamic selection capability, F4 help for all the selection criteria, An ALV report with save, export to excel and print options.
• Developed an ALV report to match the Factory 856 and the Forwarder 856 transmissions on carton quantities. If the number matches the user from the report can trigger the goods receipt for the inbound delivery. In the case of a mismatch the user will either correct the problem manually or request a resending of EDI messages from the factory and/or forwarder.
• Developed an ALV report to display list of all customers in a certain zip code with sales reps, partners and product line.
• Developed an ALV report produce a report of customers created within a date range

Environment: SAP NW2004s, R/3 ECC-5, Windows Xp.

Confidential

Responsibilities:

• Involved in identifying to fix the defects and Change Requests raised.
• Involved in development of
• Reports
• Dialog programming