SUMMARY

• Over 8 Years of experience in SAP BI/BW/BO Full Life cycle implementations on different modules, and experience working with SD, FI/CO, SCM, MM, SRM and CRM.
• Experienced in all activities of full life cycle implementation including project management, requirement analysis, data modeling, design, specification development, reporting, Web publishing, portal integration, performance tuning, testing, documentation and maintenance.
• Excellent communication, interpersonal and analytical skills with ability to manage and work effectively to meet deadlines in fast paced environment.
• Business analyst experience interacting with end users, functional/technical experts and management to identifying, analyze and developing the reports that meet the business needs. Strong knowledge of business/process data flow in organizations and experienced in data modeling concepts.
• Extensively worked in various SAP functional modules including but not limited to FI/CO: Accounting, Controlling, Profitability and Business Planning. SD/CRM: Order flow, Customer Analysis, Services, Marketing. SCM/MM: Purchasing, Inventory, Event Management.
• Expertise in data modeling especially in creating infoareas, characteristic infoobjects, Keyfigure infoobjects, different types of infocubes such as basic cubes, remote cubes, SAP cubes and virtual cubes,
• Created different DSOs such as standard DSOs, Write optimized DSOs, Infosources, transfer rules, update rules, transformations, infopackages, DTPs.
• Experienced in creating Multiproviders, Infosets, Start Routines, End Routines.
• Expertise in data extraction strategies for non - SAP systems such as third party systems.
• Expertise in non-SAP data exchange utilizing the datamarts, Open Hub, Infospokes, XI functionalities.
• Expertise in ABAP coding for custom extractors, user exits, variables, update rules, start routines, transfer rules, function modules.
• Performed extraction on FI and SD data using Standard extraction, generic extraction, enhanced extraction structures followed by creating appends in order to add new fields.
• Performed LO cockpit extraction on various SD datasources and moved the data to infocubes and DSOs.
• Extracted data using LO and Generic extractors & initialized delta and Uploaded master data from R/3 systems by V3 updates.
• Experienced with BI reporting using Business Objects, Xcelsius, BEx Analyzer, Query Designer, Report Designer, Web Application Designer (WAD) and Crystal Reports.
• Expertise in BEx, building queries with use of restricted/calculated key figures, complex structures, customized variables, conditions/exceptions to provide reports for various business user groups.
• Experienced in web publishing of BO/BEx reports, customized web templates, dashboard designing, integration of Enterprise Portal, security models for reporting and Information Broadcasting.
• Worked on creating reports using Crystal Reports and also using Business Objects functionalities like Queries, Drill down, Cross Tab, Master/Detail and Formulas etc.
• Expertise in working with Universe Design Tool by creating connections with BEx and creating a Universe over the connection
• Experienced in working with Information Designing Tool (IDT) by connecting it with BICS connections with BEx.
• Worked on WebI Rich Client and online WebI Launch Pad by connecting it with BEx, Universes, IDT and QAAWS and created different types of tables such as horizontal table, vertical table, cross tables and split tables, charts such as column charts, column chart with dual value, combined column and line chart, line chart, 3D chart stacked column chart, dual axis line chart, Pie chart, donut charts etc, different variables such as dimension variable, measure variable and detail variable, filters, filter bars, drill ups and drill downs and published them through web services.
• Expertise in dashboards with dynamic visibility, created filters, combo boxes
• Experienced in creating single or multi line chart for showing tendency over a period of time particularly used in revenue history using Xcelsius 2008.
• Experience in upgrade strategy, project planning, landscape design, test strategy and execution.
• Experience in developing technical documentation, training material and providing end-user training.
• Experienced with delta loads, process chains, performance tuning, creating aggregates, assigning roles & authorizations, day-to-day monitoring, fixing loads etc
• Experience in BI enterprise reporting with SAP NetWeaver BEx Query designer, Web Application Designer, SAP Netweaver Visual Composer, Analysis Process Designer, WEBI, Xcelsius and Dash Boards

TECHNICAL SKILLS

Data Warehouse: BI 7.0, BW 3.5, 3.1C

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

ERP Packages: SAP ECC 6.0, 5.0, 4.7, 4.6c, R3

SAP Modules: BW 3.x, 7.0, 7.3, SD, MM, FI/CO, HR, CRM, SEM-BPS

Reporting Tools: BEx Reporting, Web Application Designer, Business Explorer Report, Designer, Business Objects (XI R2.1,3.1,4.0)

PROFESSIONAL EXPERIENCE

Confidential, Marietta OH

Sr. SAP BI/ BO Team Lead

Responsibilities:

• Involved in full life cycle implementation of BOBJ Xcelsius Dashboards.
• Worked closely with business to help them come up with their desired visualizations.
• Developed 3 dashboards (Executive, Production and CAPEX and Plant Maintenance) using best dashboard design practices.
• The dashboards were trendy with several components like play selector, fish eye menu and SWF loader.
• Created Xcelsius dashboards using Query as a Web Service (QAAWS) and Live Office.
• Expertise in creating reports using Business Objects WebI, WebI Rich Client, and Dashboards.
• Designed and developed highly complex interactive Dashboards using Xcelsius 2008.
• Built Dashboards with high volume of data and cross-tab data upon latest instance of scheduled WEBI reports using Live Office connections.
• Built Dashboards with high variation of data using QAAWS and BI Web Services.
• Designed Bex quires suitable for the Dashboard Design.
• Installed Xcelsius 2011 with SAP3 on the server and handled using Xcelcius to develop executive Dashboards, Dynamic visibility.
• Created Dashboards using line, column and pie charts, filters list view.
• Created reports in WebI rich client by importing the queries from BEx, exported them to different places using QAAWS (Query AS A Web Service), BIWS (Business Intelligence Web Services Direct connections) and Live office.
• Created UNX direct connections using query browser.

Environment:, BO 4.0,, ECC 6.0, ABAP/4, BEx Analyzer, Query designer, WAD, BO Designer, WEBI, IDT, Xcelsius 2011, FI- CO, PM,PP and SD.

Confidential, White Plains, NY.

Sr. SAP BI/ BO Developer

Responsibilities:

• Involved in full life cycle implementation of BI using ASAP methodology (accelerated SAP methodology) and Post Go-live support.
• Customized Purchasing and Inventory cubes and developed custom objects for purchase requisitions and MRP data.
• Developed start routine, end routine, expert routine by incorporating ABAP code.
• Created extractions using Lo-cockpit extractors using datasources 2LIS 11 VAITM, 2LIS 12VCITM, 2LIS 13 VDITM from on the SD side of ECC system and moved data to infocubes and DSOs in BI system
• Responsible for statistical update (Initialization) of MM application setup tables and configuring the delta extraction for logistics extractors on datasources 2LIS 02 S012 Purchasing and 2LIS 02 S174 Serivces..
• Created queries using variables restricted key figures, filters, exceptions, conditions and free characteristics.
• Generated reports on Info Cubes, Info Sets, ODS and Multi Provider using BEx queries.
• Expertise in creating reports using Business Objects WebI, WebI Rich Client, Dash Board and Crystal reports using different Data Sources.
• Involved in Creating, Updating and maintaining existing Universes based on changes in user requirements and changes in data and exported to CMC and CCM.
• Involved in creating new and modified existing Hierarchies in the universes to meet Drill Analysis needs of the user’s.
• Developed Web Intelligence reports making use of several Queries (Union, Intersection, Minus).
• Created reports in WebI rich client by importing the queries from BEx, Universes and Exported them to different places using QAAWS (Query AS A Web Service) and BIWS (Business Intelligence Web Services)
• Used Information Design Tool (IDT) and created BICS connections.
• Used Prompts, Conditions to restrict the data returned by Query and used Filters to restrict the unwanted data from the report.
• Installed Xcelsius 2008 with SAP3 on the server and handled using Xcelcius to develop executive Dashboards, Dynamic visibility.
• Created Dashboards using line, column and pie charts, filters list view.
• Global User training on Strategic and Operational BI reporting.
• Created migration of data sources from BI 3.5 to BI 7.0
• Improved performance during extraction by working on SAP BW Accelerator.

Environment: BW 3.5, BI7.0, BO 4.0, BO 3.1, ECC 6.0, ABAP/4, Crystal Reports 10.0, BEx Analyzer, Query designer, WAD, BO Designer, WEBI, IDT, Xcelsius 2008, FI- CO, CRM, SCM, MM, SD.

Confidential, Houston, Tx.

SAP BW consultant

Responsibilities:

• Involved in the implementation of Plant Maintenance and Finance data sources in BI.
• Managed and monitored data loads with Full update and Delta update
• Involved in extraction of data from datasources like 0PM PRM PLCS 1Plant Maintainance and Planned costs 0PM OM OPA 2 Maintenance Orders: Actual Costs by Means of Delta Extract from PM and 0FI AA 004 investment support 0FI AA 005 FI-AA: ACQUISITIONS from FI and moving it to DSOs.
• Extracted data from SAP R/3 using LO Cockpit, Generic and Business Content Extractors.
• Created Data Transfer Process(DTP) to schedule the update in BI 7.0.
• Used the new functionality BEx Information Broadcasting available in BI in SAP Net weaver 2004.
• Developed flexible queries using filters and navigational attributes to facilitate data analysis in a drill down or summarized way to give detailed levels of information, required in areas of SD and MM. Worked on Currency conversion as per user requirements.
• Involved in creation of Filters, @prompts and setup Hierarchies for Multidimensional Analysis.
• Involved in Installation and Configuration of all products of Business Objects.
• Creating, developing, maintaining and testing the Universe for running the queries against the Database.
• Generated analytical reports using Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae features.
• Exported the Universe to CMC Repository for making available to Business Objects users and Web Intelligence users.
• Creating the Reports using the Universes as the main Data providers and writing the complex queries including Sub Queries.
• Performed server management tasks and created groups in CCM and CMC
• Applied sections, Breaks, Calculation, Report Filters and Query Filters and displayed the information in different Blocks.
• Published the reports in Portals from WAD by sending them in iViews
• Experienced in formatting various changes in WAD like converting Bar graph to line graph during the upgrade
• Involved in Up gradation of the system from 3.5 to BI 7.0, migrated BW 3.5 data sources to BI 7.0 data sources.
• Worked with Business Objects Data Services (BODS) in SAP BI staging process.
• Evaluated statistical performance on OLAP using BW Statistics
• Maintained Process chains to automate and schedule the background performance tuning jobs of BW query using Indices, aggregates, Compression, Achieving and Partition.

Environment: SAP BW 3.5, BI 7.0, SAP R/3 ECC 6.0, SD, MM, PM, FI-CO

Confidential, El Paso, TX

SAP BW/BO Technical Consultant

Responsibilities:

• Actively involved in extracting required data from the Data Source of PSA to ODS
• Created master data Info Sources for uploading master data and hierarchies
• Activated and customized profit centre accounting cubes, accounts payable cubes and accounts receivable cubes
• Actively involved in Data source enhancements, generic extractors, user Exits and customized delta built up for the data sources, V3 Updates, controlled by pull/push principle from OLAP system
• Created Extract Structure, Transfer Structure, Replication of Data Sources. Created and maintained Transfer Rules for Communication structure and later by defining Update rules
• Created Xcelsius dashboards using Query as a Web Service (QAAWS) and Live Office.
• Designed and developed highly complex interactive Dashboards using Xcelsius 2008.
• Built Dashboards with high volume of data and cross-tab data upon latest instance of scheduled WEBI reports using Live Office connections.
• Built Dashboards with high variation of data using QAAWS and BI Web Services.
• Created Data Extraction programs for generating reports using ABAP/4. Created ABAP routines for Transfer Rules and Update Rules

Environment: SAP BW 3.5,BW 7.0,BO 3.1, SAP R/3 4.7b, FI, CO-PA

Confidential, St Louis, MO

SAP BW Consultant

Responsibilities:

• Performed functional migration of SAP BW3.5 to SAP BI7.0.
• Worked in the Design, development and extraction of the data from R/3 system and flat files in to BW system from SCM and CRM modules using LO Cockpit extraction method.
• Created Data Transfer Process (DTP) to transfer data within BI from one persistent object to another object.
• Performed migration of emulated data source.
• Generated Transformations from Transfer rules and update rules in the process of Migration of data flow from 3.5 to 7.0.
• Implemented Start and End routines within Transformations.
• Enhanced Infocube with remodeling concept to make changes, without having to reload data.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Generated Queries using new BEx Query Designer.
• Worked with BEx Report Designer to create formatted reports.
• Actively worked in designing, formatting and delivering financial statements, using Crystal Reports
• Launched BEx Report to the Web and generated PDF file.
• Experienced in using BEx Information Broadcasting to distribute the right information to the right people at the right time.
• Experience working with New Integrated planning module.
• Published reports on Enterprise portal as iviews.

Environment: R/3 4.7, BW 3.5, BI 7.0, WAD, BEx Analyzer, CRM, SCM, MM, SD

Confidential

SAP BW Consultant

Responsibilities:

• Interacted with Subject Matter Experts for studying their business requirements.
• Actively involved in the complete life cycle implementation of SAP BW.
• Analyzed business reporting requirements that could be satisfied with SAP business content and installed the documented objects.
• Analyzed, designed and developed Extraction, Transformation, data acquisition, and real time data acquisition processes for a data warehousing and Data Migrations projects
• Analyzed Info Cubes and improved the performance by creating aggregates, using BI accelerator Index and regularly tuning the data models for info objects and queries.
• Responsible for job schedules for loading Master data (Texts, Attributes and Hierarchies).
• Attached newly developed objects to Requests and Tasks and Transport them to QA and Production system.
• Configured, enhanced and extracted data from SAP (using COPA, LO and Generic extractor) and non-SAP systems.
• Defined specifications for frequency and mode of data transfers and setup of batch jobs for Info package by coordinating with basis and system admin teams.
• Uploaded data to BW from source systems in specific intervals using delta update mechanisms.
• Developed flexible queries using filters in BEx analyzer to facilitate data analysis
• Created and maintained Report-to-Report interface (RRI).
• Created Web templates using Web Application Designer WAD.
• Involved in creating I-views for web templates.

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer, WAD, SCM, PP, MM, QM, SD, FICO

Confidential

Software Engineer

Responsibilities:

• Set up the logistics customizing cockpit by maintaining the extract structures and data sources, activating the update, setting up V3 update for SD documents: sales, delivery and billing orders.
• Worked in Logistics data providers, SD and Logistics Info cubes, DSO, multi providers according business needs in SAP BI.
• Extracted and uploaded data into infocubes from data sources like 2LIS 12 VCHDR- Delivery Header data, 2LIS 12 VCITM- Delivery Item Data, 2LIS 12 VCSCL- Schedule Line Delivery, 2LIS 11 VAHDR- Sales document Header data, 2LIS 11 VAITM- Sales document Item data, and 2LIS 11 VCSCL- Sales document Schedule line and customized them using Update Rules. Created DSOs, Info Cubes and Multi- provider for queries. Created Billing Documents, Deliveries Reports, orders deliveries and sales quantities reports, on Sales Overview and Deliveries Info Cubes.
• Developed and documented high level technical design model for the OTC reporting project, using Microsoft Visio.
• Generated reports for the Manufacturer to notify the delivery date and the details of material based on sales order.
• Generated reports to list the detail information of consignment Issue/returns.
• Created reports in SD. using BEx query designer, Web Application Designer (BEx-WAD).

Environment: BW 3.5, BI7.0, ECC 6.0, BEx Analyzer, Query Designer, BEx Broadcaster, WAD, SD

Confidential

Software Engineer

Responsibilities:

• Design and Development of Custom Infocubes, ODS objects, Multi Providers, Infosets and master data objects.
• Developed Custom ODS objects that captures the erroneous data.
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Created update rules with necessary update routines and start routines.
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results.
• Created Scheduling plans for data load to use Process chains in order to load Master Data and Transactional Data from SD into BW.
• Worked on system tools for tuning like RSRV, ST05.
• Extensively used BEx Analyzer to build queries and worksheets to access data from BW data targets.

Environment: SAP R/3 4.6, BW 3.1c, 3.5, BEx Analyzer, SD