SUMMARY

• SAP BW certified consultant with more than 10 years of experience which includes Technical and Functional Consultant role played.
• Expertise in various versions of SAP BW / BI with multiple implementation experience and SEM/BPS/IP Integration experience.
• Functional experience and exposure to various modules and new dimension tools such as FI/CO, COPA, SAP CRM, APO, HR, SD, MM, PP, SAP SCM and APD.
• Involved in various phases of the project such as design, development, deployment and support, has played numerous number of roles ranging from a Sr. Developer to Architect
• Deep knowledge as Techno - Functional in customization and adapting SAP Best Practices Scenarios in the Blue Print.(BI.7,BW3.5,3.0B,3.0A) and created Technical Specifications from Functional Specifications.
• Strong Knowledge and experience in Data Modeling for Design, Development of standard and custom BW solutions including extractors, info providers, data providers (DSOs), info sources, info objects, and info packages.
• Extensively worked in Data Extraction from Multiple SAP and Non SAP (Legacy) Systems using Business Content, LO,LIS,CO-PA,FI-AR,FI-AP,FI-GL, Flat File, Generic Extraction Methods.
• Good knowledge in POSDM extraction.
• Strong Hands-on experience in large-scale Data Warehousing projects Expertise in using Business Objects Suite products like Designer, CMC, Desk I, Info view, Broadcast Agent, Web Intelligence, Performance Management, Crystal Reports, X-Celsius and Live Office.
• Good knowledge of BW security design concepts.
• Extensively worked on SAP BEx query designer, Analyzer and WAD.
• Experience in working with all the new feature of BI 7.0 including DTP’s, APD’s and Info Packages for scheduling and monitoring the data loads.
• Extensively involved in management consulting business and hands on experience in implementation of integrated business systems.
• SAP R/3 and BW application strong knowledge in the financial business process area.
• Good understanding and design skills for the BW data architecture.
• Excellent skills in understanding of multidimensional modeling.
• Strong experience in configuration of SAP BW Info Cubes, ODS, Info Sources and different types of extractors.
• Has extensively worked with Accelerated SAP Methodology in Implementations.
• Good working knowledge in CRM, QTC and PTP.
• Extensively worked with ABAP Programs, Routines in Transfer Rules, Update Rules, Transformations and Start Routines.
• Enhanced Datasources where ever required and Created Generic Data Sources if standard Datasources are not available to meet the requirements as per functional specifications.
• Expert in batch schedules using process chains for data loading. Hands on experience in Performance tuning Techniques for overall system performance (Aggregates, Cube Compression, Line Item Dimension, Indexing) for Improving the Reporting.
• Good experience in developing queries and other options for data access like BEx reports, Web reporting, Report-to-report interfaces, Operational Data Store reporting, master data reporting, Open Hubs and 3rd party tools.
• Strong Communication, Analytical, Presentation skill with ability to work in a team and Individually

TECHNICAL SKILLS

ERP: SAP BI7.0, SAP BW 3.5/3.1C/3.0B, SAP R/3 4.6C/4.7/ECC 5.0

Languages: ABAP4, SQL

OLAP Tool: SAP Business Explorer (BEx) Analyzer, Web reporting

RDBMS: Oracle 9i/8i, SQL Server

Operating System: Windows 95/NT/2000/XP

PROFESSIONAL EXPERIENCE

Confidential, TX

SAP BI Architect

Environment: NW 2004s, BI 7.3, SAP ERP ECC.6, Enterprise Portal.

Responsibilities:

• Conducting analysis of systems specifications in SAP FI, CO, PCM, P2P, PP, MN, SRM and HR applications and preparing the design flow in SAP BI for the same.
• Developed data flow diagrams and flow charts. Gathers information from system users, functional experts, and business analysts.
• Developed Macro Design's (data models, information flows, data integration, and functional reporting design) related to the SAP BW.
• Upgrade BI 3.5 to BI 7.3 version.
• Reviewing designs and finalizing the final data flow in BI.
• Working with offshore team for the development of PCM, FI, CO, P2P, SRM, PP, MN and HR applications and clarifying issues.
• Did lot of changes for existing flows in PCM, Finance in General Ledger, Accounts Receivables and Accounts Payable applications, resulting improved efficiency.
• Migrated data flows for PP & SRM application.
• Worked on APD tool for data mining.
• Using APD has been pushed to 3 rd party system as well.
• Did customer credit score analysis using APD.
• Did changes in data flow for Production Planning as per Enterprise data warehouse concepts like introducing SPO’s and reducing number of DSO’s where ever possible.
• Provided couple of Production reports to users such as below
• Breakdown Analysis
• Preventative Maintenance reports
• Maintenance Cost per unit
• Review Equipment activity
• Fuel Consumption per unit measure
• Schedule vs Complete
• Provided reports in SRM like shopping cart status (BB- BW SC2), shopping cart for Product (BBP BW SC3) and shopping carts for cost center (BBP BW SC4).
• Conducting Technical Unit Testing, Function Unit Testing and User Acceptance Testing.
• Taking responsibility to move the objects and do data loads for the same in Production system.
• Indexed on multiple InfoCubes, HybridProviders and Semantic Partitioned Objects to improve query performance.

Confidential, Minneapolis, MN.

SAP BI Architect

Environment: NW 2004s, BI 7.0, SAP HANA, SAP ERP ECC.5, SAP SEM and Enterprise Portal.

Responsibilities:

• Conducting analysis of systems specifications in SAP FI, MM, QM, PP, P2P and APO applications and preparing the design flow in SAP BI for the same.
• Gathering the requirement process and conducted Current State Gap analysis.
• Developed data flow diagrams and flow charts. Gathers information from system users, functional experts, and business analysts.
• Developed Macro Design's (data models, information flows, data integration, and functional reporting design) related to the SAP BW.
• Handling multiple analytic reporting and assignments concurrently, Prepares system and programming documentation.
• Developed design according to requirements specifications and conducts unit testing.
• As a Data Modeler preparing the functional design documents by conducting meeting with business users.
• Created BW Accelerator indexes on top of InfoProvider’s.
• Updated BW Accelerator indexes where ever required.
• Executing Queries with BW Accelerator.
• Working with various business analysts and come up with good global designs for BW implementation to integrate with different systems like Informatics and APO.
• Responsible for Design, Development and Implementation of customized MultiProviders, Infosets, InfoCubes and Data Store Objects.
• Worked for “Interface which provides a snapshot of the required work order consumption data to Factory works” for purpose of comparison reporting.
• Interface to reconcile the inventory between Kardex system and SAP. This interface is required in order to facilitate inventory reconciliation and will allow for inventory discrepancies to be promptly addressed.
• Provided report to satisfy Russia Statutory of “Account Correspondence”.
• A business requirement submitted to be able to report their detailed sales activity on a gross margin basis. The level of detail include customer, Company Code, product number, fiscal period, plant, profit center and product hierarchy.
• Cryocath business requires a Warranty & Contract Report which lists the customer who have a warranties and contracts expire, to communicate to sales reps and service technicians and to know whether or not to bill a customer for service and repair activities.
• Extracted data from Informatica system into BI.
• Worked on different reports on PP area like survivability, mean time to reports and men time between reports.
• Worked on APO demand planning history design flow in BW to pull from ECC and send it to APO system.
• Worked on MM/P2P below reports.
• Purchase Order Status.
• Purchase Order details
• Supplier Overview
• Contract for Product
• Contract for Supplier
• How many PO items are there for certain Material Groups
• Vendor Evaluation
• Complete prioritized enhancements for existing SEM IP layouts and associated elements for financial planning.
• Improve reconciliation of data in planning cubes during plan cycles.
• Worked on administration tasks like BW Accelerator Monitor (RSDDBIAMON2) and TREX Admin Tool (TREXADMIN).
• Index on semantically portioned objects by using BW Accelerator.
• Index on Master data by BW Accelerator.
• Provided different reports in Demand planning by using BEx and BO tools.
• Designed data flow for vendor and statutory reports like getting license number with HSA code for the last two weeks for plant, material type and material combination.
• Worked on few reports of GTS system data to bring into SAP BI.
• Designed data flow for FI reports like cost of material consumed vs. produced materials.
• Worked on data modeling for %Scrap, Material completed quantity, order quantity, assembly scrap and component scrap.
• Involved in design and develop the Dashboard, Universe and required reports.
• Created Webi reports and deployed them through Info View.
• Involved in Complex reports development using Web intelligence (WEBI XI) and complex full client Business Objects Reports were developed and published in corporate documents under various categories.
• Doing co-ordination with offshore team and clarifying the issues raised by them.
• Used Solution Manager for handling the transports.
• Conducting Technical Unit Testing, Function Unit Testing and User Acceptance Testing.

Confidential, Reston, VA.

SAP BI Data Modeler

Environment: SAP BI, SAP ERP ECC.5 and BEx tools.

Responsibilities:

• Contribution-Identified the functional derivations for the new developments in FI-Accounts Receivables, Accounts Payable and Billing (FI-AR, FI-AP, SD, MM) applications.
• As a Lead consultant preparing the functional design documents by conducting meeting with business users.
• Responsible for creation of design Documents for Info providers, Queries and process chains in order to meet the client requirements.
• Ensure that customer needs are identified and that appropriate, cost effective solutions are provided to the satisfaction of customers on schedule, within budget and to the appropriate quality
• Designed project model based on the requirements.
• Installed business content objects of Finance Module like Accounts Receivable (AR) payment history and billing.
• Enhanced the Accounts Receivable Line items data source and info providers.
• Created reports in AR & AP like Aging Period, Open items, Vendor and Customer Information Overview.
• Created Reports in Accounts Receivable & Payable applications like Bouncing and Credit Memo Reports.
• Created reports in Billing like Reconciliation at Flight Level, Class, Bill code level, invoiced quantity vs. Payment Amounts.
• Worked closely with Informatica team to get data from third party system to BI system.
• Provided reports in P2P such as Goods Receipt Variances, Average time to Vendor, Delivery quantity variances, Vendor Service Level and Procurement Values per Supplier/DUNS.
• Experience working with Crystal, Xcelsius to display summary-level business data in a rich and intuitive format.
• Involved in using Crystal, Xcelsius to Transform Microsoft Excel spreadsheet data into interactive flash media files for the upper level management.
• Created Dashboards using data in Live Office Excel Spreadsheet using connectors and Webi reports.
• Data Cleansing, data mining has been done by using APD.
• After basic data clean did statistical measures like standard deviations, correlation and visualization by using APD tool.
• Created unit test scenarios to check the data validity.
• Collected, released and imported the Objects from Development to Quality and Production Systems.
• Worked on the mapping of the source systems from one client to another client.
• Managing and resolving errors in transports from development to quality system.
• Provided assistance and created curriculum, guides, checklists and courses.
• Created test plans, scripts and scenarios for Unit Testing and User Acceptance Testing.
• Coordinated and managed User Acceptance Testing.
• Supported end users for the existing applications as well. to the power users.
• Words in BPS in building financial planning applications in BPS.
• BW /BI Consultant responsible for Preparation of Data flows, functional feasibility analysis, Post go live support, activity execution, Quality Assurance to improve performance of the system.

Confidential, Reedsburg,WI.

Sr. SAP BI Consultant

Environment: SAP BI.7, Net weaver 04’s, SAP R/3 4.6C and BEx Analyzer.

Responsibilities:

• Developed Plan and Actual Cubes for SEM and Integration Planning for FIGL, PCA, CCA, COPA and P2P.
• Responsible for driving the review and approval of the operational, analytical, dashboard and external reporting requirements.
• Involved in design of Integration Planning (IP).
• Created Real-Time Info-provider's for creating Planning Application based on this Info-provider's.
• Created Aggregation Levelfor User Level Planning: for example CFO, Regional Manager, Supervisor, etc. Individual Aggregation Level will have to be created respective user depending on respective user requirement.
• Create Filter to limit the scope of planning to the specific range of dataset.
• Created Planning Functions that can be executed automatically using Front-End of planning Application.
• Developed dashboards for high level management.
• Involved in unit and FUT, Conducted Integration testing for the 3.5 and BI.7 System for History.
• Worked with Data Monitor tool for Monitoring data loads which are scheduled by the different process chains.
• Error Debugging and rectification, solving issues and problems faced during Data uploads.
• Data cleansing for PSA data and loading PSA data to DSO objects. Staged data in DSO before transferring to the info cubes.
• Resolving tickets as per the priority by trouble shooting and analyzing.
• Updating the information for reports availability period to the end users based on the status of data loads.
• Provided production support/ fixes to the errors.
• Corrected problems and recommend solutions to problems for permanent fix.
• Created adhoc process chains for managing the data loads.
• Involved in Increasing the Load performance of the BW system while loading.

Confidential

SAP BI Lead Consultant

Environment: SAP BI.7, Net weaver 04’s, SAP ECC.5 and Bex tools.

Responsibilities:

• Design and developing the technical specification based on the Functional Specifications, interacting with the users to get to know the exact requirements, determining the gaps and suggest them the changes where required and then develop the objects as per the evolved specifications.
• Worked collaboratively with Project managers to develop work plans and to realize stated milestones/deliverables on time and within the budget.
• Setup Integration of settings between BI and CRM and APO applications.
• Set up configurations for CRM Customer Interaction Center Analysis to BW.
• Set up configuration in BW with CRM Lead Analysis, CRM Activity Management, CRM- Opportunities analysis, Lead Management, service quality analysis and Sales order Complaints.
• Identified the functional derivations for the new developments in FI.
• Designed the derivation logic for the new developments along with History data.
• Identified and transferred master and transactional data sources from CRM.
• Worked extensively on following objects
• CRM Service ticket analysis
• Service ticket aging report
• Service ticket Monthly and daily
• Complaints analysis
• Complaints aging
• Quick Close analysis
• Built and developed the infrastructure for the EDW (Cubes, DSO’S and Transformations).
• Identified and developed new Queries, Views in BI.
• Responsible for Design, Development and Implementation of customized Info Cubes, Data Store Objects.
• Identified Info Cubes, DSO’s, data sources, info sources, reports and Installed from Business content.
• Modeling the data flow mechanism between the 1st level (staging area) DSO’s to the 2nd level DSO’s with complex transformations.
• Created Process Chains for automation and performance Improvement
• Provided analysis on the following reports by using Bex tools
• Cumulative Failure Rate
• Annualized Service Event Rate
• Revenue Report
• Forecast report.
• Conducted Unit and Integration testing
• Coordinated and managed User Acceptance Testing.
• Direct contact with client for the change of objects, which differ from expectation.

Confidential

SAP BW Consultant

Environment: SAP R/3 4.6C (SD, MM, PP, FI, CO-CCA, CO-PCA) BW / BPS Windows 2000/NT

Responsibilities:

• Contribution-Interacted with the management, conducted workshops and personal interviews to collect the requirements during initial stages of projects/task for understanding business process and end-users reporting requirements.
• Fielding questions concerning the data content, definition and structure.
• Worked closely with the process team to design Functional Specifications document and created Technical Specifications for the same.
• Support the Procurement Business with the provision of functional specifications and technical specifications for systems, ensuring compliance with guidelines.
• Involved in design of Planning for business planning applications.
• Created Aggregation Levelfor User Level Planning: for example CFO, Regional Manager, Supervisor, etc. Individual Aggregation Level will have to be created respective user depending on respective user requirement.
• Create Filter to limit the scope of planning to the specific range of dataset.
• Created Planning Functions that can be executed automatically using Front-End of planning Application.
• Activated Sales Cubes 0SD C01, 0SD C02, 0SD C03, 0SD C05 from Business Content and customized to meet the requirements.
• Worked extensively on Standard Data-sources with LO Customizing Cockpit for extracting Sales, Delivery, Billing, Purchase and Customer.
• Activated Operational Data Store Objects and Cubes by the extraction of data from R/3 using 2LIS 11 VAITM, 2LIS 12 VCITM and 2LIS 13 VDITM extractors.
• Worked on reports of Costs of raw materials, operating supplies, Wage costs and External services.
• Worked on creating Aggregates and providing fixed values for Info objects as per requirement, Data Marts, Info cube Compression.
• Created MultiProviders on sales and delivery cubes to assist reporting on sales and delivery together.
• Created reports on incoming order data for specific customers, Quotation Success Rate per Sales Area, Delivery Service Analysis, Service Level analysis by quantity and item level.
• Request creation and maintenance for object transportation.

Confidential

BW Consultant

Environment: SAP R/3 4.7 BW 3.5 Windows 2000/NT.

Responsibilities:

• Identified the scope of Implementation as per the client requirements.
• Interacted with the management, conducted workshops and personal interviews to collect the requirements during different stages of projects/task for understanding business process and end-users reporting requirements.
• Created Technical Document from Functional Document.
• Produced front-end prototypes during the Blueprint phase based on an understanding of business needs to help finalize requirements.
• Data modeling in terms of assisting the client IT group to finalize the structure of various BI objects.
• Identified and Installed Cubes, ODS, data sources and info sources from Business Content.
• Created data source by using generic extraction in order to bring the data from different tables based on the business logic the data from R/3 to BI.
• Developing & implementing some of the most complex business rules by means of update rules/start routines.
• Identified the reports and Installed from Business content.
• Extracted data from R/3 using 2LIS 02 ITM, 2LIS 02 HDR and 2LIS 02 SCL.
• Activated Info Cube's 0PUR C01 cube 0AF C01 and other cubes for like Purchasing Group, Service level purchase orders / Quantities/ Delivery schedule lines and Vendor evaluations.
• Enhanced Datasources and extracted data from R/3 using 2LIS 11 VAITM, 2LIS 12 VCITM, 2LIS 13 VDITM, 2LIS 03 BX and 2LIS 03 BF.
• Created and changed Cubes, ODS’S, Info objects with Transfer Rules and Updates rules as per requirements
• Created Process Chains for automation and performance Improvement
• Conducted Unit and Integration testing.
• The Account Receivables Data is captured at Company code, Credit Control Area, Customer, Chart of accounts, G/L Account, Document type, Posting Key, Fiscal year, posting period wise.
• The Account Receivables Data from R/3 system will pass through the PSA and will be stored in YOAR O03 at document level and finally in the cube YCAR C03 at aggregated level.
• Developed front-end reports using BEx Analyzer, used Restricted and Calculated Key Figures, Variables, Exceptions, and Conditions.
• Direct contact with client for the change of objects, which differ from expectation.
• Collecting the various Objects into transport Requests and release them from Development System to Quality environment.
• Coordinated with Basis team for transportation of objects to Quality system as per Landscape.
• Maintained high utilization in the Project.

Confidential

Associate BW Consultant

Environment: SAP R/3 4.6C BW 3.0A Windows 2000/NT

Responsibilities:

• Extensively interacted with user to identify and gather requirements and map to object development.
• Set up configuration in BW in SD, PP and MM applications.
• Provided reporting in sales and procurement to planning.
• Worked in extracting and mapping data from SAP Systems into BW, configuring standard OLTP data extractors on R/3, created transfer rules, defined Info sources thus generating Communication Structures.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Customizing LO Cockpit as per requirements.
• Worked on Sales Order Info sources 2LIS 11 VAHDR, 2LIS 11 VAITM, 2LIS 02 HDR, 2LIS 02 S013 and 2LIS 02 ITM.
• Worked on Sales delivery Info sources 2LIS 12 VCHDR, 2LIS 12 VCITM.
• Created Update Rules to create and built Info Cubes developed routines (Transfer, Update and Start Routines) Mapped, Scheduled and Monitored data Extractions from LO cockpits from R/3 systems.
• Extracted transaction data for sales from R/3 on a daily basis and master data for customers and vendors on a weekly basis used delta initializations and delta loads.
• Stored data from R/3 tables into ODS objects through PSA to perform detailed level reporting.
• Created Multi provider on sales and delivery cubes to assist reporting on sales and delivery together.
• Experienced on creating Aggregates and providing fixed values for Info objects as per requirement, Data Marts, Info cube Compression.
• Worked extensively on BEx Analyzer for queries creation and changes.
• Ensured timely and good quality delivery of the project, which was well appreciated by the client.
• Monitoring data loads and applying fixes for issues.
• Involved in improving data load performance.

Confidential

ABAP Developer

Environment: SAP R/3 4.6Windows 2000/NT

Responsibilities:

• Developed material master details report. Inputting material and plant as Select-options and material type as parameter. The output shows Material Number, Storage Location, and Unit of Measure and description in addition to group totals
• Developed a report, to get all the sales that took place during month for a plant
• Designed and coded a BDC program to migrate material master data from Legacy system to SAP R/3 system
• Modified Layout set for Purchase order
• Created material master details report. Inputting plant as select-option and material type as parameter. Output list will have total quality ay material group and plant
• Created a report to display the number trucks which have been dispatched based on transporter
• Generated a drill down report that displays the sales order information based on customer.
• Generated an interactive report on purchase information. This in the first level provides the general purchase order numbers, which on selected provides the detailed information of the purchase transaction. Also this provides vendor information on selecting the corresponding vendor number.
• Generated report for purchase details issued per vendor. Various selections can be made apart from the vendor number such as purchasing organization, document type, corresponding plant, material number and material group.