Summary

• BW/BI Consultant with 4 years of overall SAP experience including 3 years BW.
• Extensive experience in BW.BI Modeling/Extraction, ODS Design and Development, Info cubes, Info objects, Multi-providers and Info sets.
• Experience Scheduling and Monitoring of Data Loads, Transfer Rules, Update Rules, DTP (7.0), Aggregates and Rollups, BEX/Web Query Design.
• Experience in Systems Study and Gap Analysis.
• Installing and Configuring BOBJ, setting up OLAP Universes on top of BEX for Webi,
• Well Knowledge and head on academic experience for creating fancy dashboard on Xcelsius
• Experience in planning, execution and control of project milestones. Development, configuring, analysis, Co-ordination, testing and technical support of SAP-BASIS (releases through 4.7 – ECC 6.0).
• Goal oriented, Team player with good communication and presentation skills
• Strong knowledge of Business/Process dataflow in organizations particularly in the Sales and Distribution module.

Experience

BW /BI Technical Consultant Mar2007-Aug09
Confidential,

Responsibilities included

• Interaction with Business Analysts to gather requirements.
• Complete design & Development of BW / BI objects - Write Optimized ODS’s, Transactional ODS, Development of Start Routines, subroutine Pools & User Exit Code.
• Development of Integrated Objects – Sales Order & Billing Integrated OBJ, Sales Orders & Delivery Integrated OBJ.
• Enhanced Extractor on R/3 side with new fields.
• Created Generic Extractors.
• Talk with the end users to gather the requirements
• Develop functional spec based on the requirements.
• Report/Query creation using BEX/BOBJ
• Installation and Configuration of BOBJ and WEBI
• Configure Universe setup data center for Business intelligence
• Make changes/rework based on change control process.
• Attended team meetings to discuss the milestones of the project
• Developed necessary documents to release the objects for production.
• Member of development team to ensure smooth transition of the projects to go-live
• Design and development of Staging Layer and master data objects
• Creation and managing master data object
• Creation and managing Staging layer objects
• Creating of process chains to load data into various objects
• Manage batch jobs
• Daily production issues & Manage/enhance existing Legacy BW architecture
• Setting up a Business Intelligence Client in NetWeaver 2004s/7.0
• Creating RFC Connection and Logical system.
• Install BI Content (SAP-PI) and Support Package as needed.
• Customize the IMG for Business Intelligence Prospective.(LO Cockpit)
• Good understanding of various types of errors while transporting around System Landscape

BW / BI Technical Consultant Jan 2005 – Feb2007
Confidential, Midland, MI

• Implemented user exits in SAP System for data collection
• Designed Web Dashboard with email notifications on critical exception thresholds. Result was a robust decision support environment.
• Financial Accounting Analysis
• Implemented Financial Accounting Analysis
• Designed Customer Credit Management Cockpit
• Developed DSO report to report by Sales Man, by Company and Time Line DSO report with RIR interface to Line Items
• Conversion Project from Access to BW/BI
• Implemented Conversion of Access Report Inventory System to BW/BI. Responsible for Reverse Engineering approach to analyze the current system, design the datasources, infoobjects, extract structures, Extraction function module and Infocube for final reporting.
• InfoCube Design and Development - Bex Reporting
• Designed, developed and documented the star schema model for the custom infocubes.
• Designed/developed/enhanced custom infocubes for Shipment Volumes and Costs, purchasing data, Logistics, Inventory, vendor evaluation etc.
• Designed/developed infocubes for Finance such as cost center expenses, profit center revenue & expense, functional area general ledger and profitability detail cube etc.
• Developed queries to validate the data in the BW system for the different levels of characteristics
• Generated BW reports for monthly sales order & status, fixed assets activity by period/month and Inventory based on production date etc.
• Designed and documented test plans for data validation between R/3 & BW /BI
• Coded transfer routines and Update routines using ABAP
• Created queries on the cubes and ODS
• Replicated data sources of R/3 and assigned source system for activation.
• Activated Business Content Info Object Catalogs, Infocube and Multiproviders.
• Aggregate data in the update rules for performance improvement.
• Created the process chains for the data loads and where scheduled to run daily

Confidential,Basis admin support. Feb 04 to Nov 09

• Responsible for system administration and support of technical architecture, including
• Basis support of SAP ECC6 and BW/BI in LINUX 10 , Windows platforms,
• providing excellent system reliability, performance, high availability and overall
• Optimized systems.
• Provide administration Support, Performance monitoring &tuning, Problem analysis & resolution, and other activities required maintain system integrity and maximize Uptime.
• Imported and maintained startup/default/instance profiles.
• Install Support pack on sandbox and test then apply on production system.
• Installed BI 7.0 and performed SAP ABAP + Java double-stack and Support Package Stack upgrades using tools such as JSPM (Java Support Package Manager).
• Setting up the BI Administrator Cockpit
• Install BI Content Support Package
• Activate the new technical content in SAP NetWeaver BI .Use automatic installation report (transaction SPRO)
• Creating and Setting up a Business Intelligence Client in NetWeaver 2004s/7.0
• Set up ABAP part of the BI system to integrated with the NetWeaver 7.0 Portal
• Install Add on BI Administration 1.0” Business Package for SAP NetWeaver 7.0 Portal
• SICF and activate web services
• Set up Infocube, Define info area and infoObeject catalog
• Set up of Source System in BI/BW (RSA1)
• Configure Transport management System across System landscape.
• Handle daily request for transport change request
• Monitor for batch processes jobs
• Checking system consistency Tracking log’s
• Monitoring Background jobs, batch jobs s and daily back and follow up.
• Work extensively on SAP Basis for performance analysis and memory management

Training

• Business Object (Ongoing)
• BW BI Reporting (3.5, 7.0)
• BW BI Modeling (3.5,7.0)
• SAP BASIS 2004s

Education

• Computer Science,
• BrainBench Certified
• Microsoft Certified System Engineer