SUMMARY:

• Over 15 years of I.T. experience in Analyzing, Designing, Implementing Supporting the Applications.
• Over 8 Years of SAP experience which includes 7 years of SAP BW/BI experience and 1 year of ABAP experience.
• Worked as a SAP BW/BI Consultant with strong hands-on experience in BW/BI front-end and back-end development with a deep understanding of the SAP BW/BI tools and techniques.
• Upgrade experience from BW 3.x to BI 7.0.
• Strong knowledge in SAP FI, SD, MM, QM, LO, LIS, CO-PA functional areas.
• BW - Backend: Expertise in Creating InfoCubes, Multi-Providers, Info Sets, DSO Object, Transformations, APD's, Generic Extractors, Info Packages etc using AWB.
• Expertise in Creating Process Chains and automating the load processes.
• BW Reporting: Expertise in Design and Development of Queries, Reports and Workbooks using BEx, Query Designer Web Analyzer.
• Expertise in Creating Roles and Authorization Objects for BW Security.
• Expertise in creating Data Marts, Open Hub Services, Aggregates.
• BO Reporting: Expertise in creating the reports and dashboards using WEBi, WEBi Rich and Xcelsius.
• Possessing excellent communication and presentation skills. Time bound, result oriented, team player.

TECHNICAL SKILLS:

PROFESSSIONAL EXPERIENCE:

Confidential

Sr. SAP BW Consultant

Role Responsibilities:

• Prepared the design and data modeling for the Global P L reports.
• Identified the existing objects to leverage the existing BW application.
• Created a multi-provider on top of Summary, Plan, Budget FI cubes.
• Created a custom ALM Cube to store the Book values, Write-down values for the assets.
• Created ODS objects to load the Listings, EUCS and Tracker data.
• Enhance the custom GL extractor to bring in additional required fields into BW
• Created the Process Chains to automate the loads with an event trigger.
• Designed the workbook the BEX reports as per the user requirements.
• Created an authorization variable and an authorization role for the new Global P L Reports.
• Added ABAP code to the user exit for the variables in the report.
• Managed and trained the analysts to create the simple reports.
• Trained the users to use the new workbook and to trigger the loads with an even trigger.

Environment: SAP BW 3.5, BI 7.0, SAP ECC 6.0, FI-CO, SQL Server, Windows NT, ABAP/4, and BEx Analyzer

Confidential

SAP BW Consultant

Role Responsibilities:

• Implemented Material Prices ODS, Work in Process ODS, Order Material view InfoCube as part of the Supply Chain Management SCM implementation.
• Designed and developed the staging DSO's and Cubes and Multi-Providers for P3 and KIT parts availability reports in SCM.
• Designed and developed MCOP Rework metrics.
• Designed and developed Cadence metrics for Shop Floor.
• Implemented QM Quality Management Logistics cockpit.
• Enhanced QM LO Cockpit extractors based on the user requirements.
• Created the Infospokes using Openhub to spoke out the data to the different departments in RMS.
• Developed the Process Chains to run the data loads.
• Developed APD's based on queries to capture MRP snapshots.
• Developed Custom Cubes and Custom multi-providers.
• Enhanced the Material Master Data Object and the added ABAP code to the Customer Exit to enhance MM extractor.
• Developed Universes based on BW queries as the sources.
• Created WEBi reports Inventory Turns Dash boards using Xcelsius.
• Created Factory Cadence Dash boards using Xcelsius.

Environment: SAP BW 3.5, BI 7.0, SAP R/3 4.7, FI-CO, SD, MM, QM, SCM, PP, PS, Oracle 8.0, Windows NT, ABAP/4, and BEx Analyzer, WEBi, Xcelsius

Confidential

SAP BW Consultant

Role Responsibilities:

• Designed and developed the multiple BW infocubes and multi-providers to analyze Service Tickets, Interactions, Complaints Issue Paths.
• Built the custom extractors and enhanced the business content data sources on CRM and built the ODS objects and infosets on ODS objects.
• Activated the BW statistics cubes and the business content reports for the performance tuning.
• Consolidate regional reporting systems into a single analytics system, reducing duplication of efforts and resources.
• Created reports using BEx and Web Application Designer and published the reports into the roles.
• Extensively worked on the performance tuning tasks including the partitioning the cubes, creating the indexes and aggregates based on the Stats.
• Created the Process Chains, meta chains and automated the load process based on the business needs.
• Created Authorization Objects the authorization roles to limit the users to access the sensitive data.
• Configured Report Broadcasting, Alert Notification, Exception Reporting.

Environment: SAP BW 3.5, SAP ECC 4.0, CRM, Oracle 8.0, Windows NT, ABAP/4, BEx Analyzer Web Analyzer.

Confidential

SAP BW Analyst

Responsibilities

• Involved in designing and developing of the Billing, variable costs at company code and sales budget ODS from flat files.
• Involved in extracting the data using Extractors for Sales shipping allocation, Sales Shipping allocation item, sales order header data, sales order schedule line and sales order item to build an initial order ODS.
• Involved in extracting the data from extractors sales document order delivery into Delivery ODS.
• Defined Order ODS From Delivery ODS and Initial order ODS.
• From Order ODS, Billing, Variable costs at company code and sales budget ODS had build the order processing info cube.
• Building Order processing with Market segmentation.
• Developed Queries required for segmentation.
• Used Broadcasting tool for broadcasting the queries

Financial KPIs:

• Helped in developing Key Performance Indicators KPIs to produce financial metrics for Financial Shared Services within Payables, Receivables, Inventory Tracking and Financial close

Environment: SAP BW 3.5, SAP R/3 4.7, SD, FI, COPA, Oracle 8.0, Windows NT, ABAP/4, and BEx Analyzer

Confidential

Senior Programmer Analyst

Role Responsibilities:

• Application developed to replicate current Motorola benefits processes under the ACS client. The following benefits were administered under the new client: EDI Claims processing, Medical insurance for HAP, Basic, HMO HMO IL and Humana only , and Global plans Dental insurance Health Reimbursement Accounts Dependent Care Accounts COBRA benefits elected after the divestiture date Wellness benefits
• Developed a new daily data feed from Altipro ACS HR System . Developed application to allocate costs associated with benefit payments to a new group sector that is defined for ACS. A new banking institution Wells Fargo and components are developed for ACS for claim payments.
• Changed the existing print processes to uniquely identify each client to the print vendor, so that the print vendor may flash logos and custom data on checks, EOB's and letters.
• Designing, developing and testing various batch and on-line programs. Worked with subsystems like Claims Adjudication with eligibility verification, Accounts Receivable / Cash Control, Drug Rebate, Prior Authorization, Third Party Liability to name a few.
• Modifying the front-end screens per the changing requirements. Adding new functionality to the existing screens.
• Developed System test plans.

Confidential

Senior Programmer Analyst

CAIS billing system is mainly written in COBOL, DB2 JCL and is maintained on OS/390 system. The system has both on-line and batch functionality. CAIS online screens that are developed using CICS provide on-line functions that are used to take new service orders, cancel existing service orders and maintain service orders. The billing system generates monthly bills. There are four billing cycles in each month.