SUMMARY

• Having over 7 years of experience as SAP BW/BI/BOBJ Functional Consultant, indulging in development, design, testing, implementation and maintenance of the SAP BW/BI Server environment.
• Expertise in gathering requirements, understanding, analysis, and implementation on Business Intelligence platform based on user requirements.
• Involved in 3 Full Life Cycles includes One Net weaver 04s (BI 7.0) implementations, One Upgrade Project from BW 3.5 to BI 7.0 and 1 full cycle implementations of BO Xl 3.x and BI 4.0.
• Expertise in creating Generic Extractors.
• Expertise with Multi - Dimensional Model and Star Schema in SAP BW and Administration of BI/BW development workbench (RSA1).
• Extensive Knowledge on Master data Management (MDM).
• Extensive Knowledge in Business objects.
• Designed and created Info Objects, Multiproviders, Data sources, Info sources, Process chains, transformations, data transfer process, BEx Query Designer, BEx Analyzer, Views and Work Books.
• Experienced in Configuring BW Publisher for SAP Integration.
• Hands on Experience on various components of BEx reporting environment viz. Analyzer, Browser, and Web Application Designer.
• Developed Advanced Analysis reports over BEx queries and BW info cubes.
• Expertise in working with BEx in building Queries. Extensively created Calculated Key figures, Restricted Key Figures, Formula Variables, Conditions, Exceptions, Aggregations, Cell editors, and Customer Exit Variables.
• Created dashboards directly over Universes using Query Browser in SAP BI 4.0
• Defined Universes based on SAP BW Info Cubes.
• Having Sound ABAP knowledge.
• Designed and deployed/integrated BO environment over SAP BI.
• Experienced working on designing Business Objects Reports on OLAP cubes.
• Experienced in using BEx Query Designer for OLAP reporting and Enterprise reporting.
• Extensively used Calculations, Variables, Prompts and Sorted inputs, Drill down, slice and dice, Alerts for creating Business Objects reports.
• Configured BICS connection in SAP BI 4.0 Information Design tool.
• Experienced in using Query As a Web service (QAAWS), Live Office, and XML to retrieve the data from the universe objects.
• Strong Knowledge on SAP Data Services, BO Data Federator.
• Sound Knowledge over SAP LCM, LIVE OFFICE, QAAWS.
• Created and executed Process Chains to load the data into DSO and info cubes and Multi providers built up queries for reporting in BEx - Analyzer.
• Performance Tuning in BI/BW by creating Aggregates for frequently used queries, creating Secondary Indexes, Partitioning and Compression on Info cubes.
• Expertise in Data Extraction from back-end Business Warehouse Component Extractors like LO-Cockpit, CO-PA, and Generic Extractors.
• Expertise in creating, organizing, publishing and scheduling reports using CMC and creating reports with Charts (Bar, Pie etc), cross tabs and sub reports.
• Well versed across all packaged Xcelsius components.
• Extensive experience in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using, Xcelsius, Web and Crystal.
• Effective skills to build reports in Business Objects.
• Expertise in creating Xcelsius Dynamic Dashboards using SAP BI data/BEx Queries.
• Valuable knowledge on Xcelsius Dashboard components like Charts, Selectors (Filters, label based menus), Canvas Containers.
• Interacted with the client and expertise on enhancements and cut-over.
• Worked with SAP solutions centre in resolving the issues and bugs.
• Experience in working with onsite and offshore model.
• Good Interpersonal and communication skills, technically competent and enthusiastic team player.

TECHNICAL SKILLS

Languages: SQL, ABAP/4, C

Databases: Oracle 8.x/9.x, MS SQL Server 2000, MS Access.

Operating Systems: Windows (98/NT/XP/Vista), UNIX (Sun Solaris, AIX), LINUX, MS DOS

Reporting Tools: Business Analyzer, Business Explorer, Business Objects, BEx Browser, Web Application Designer, Dashboard designer and Web I.

Data-Warehousing Tools: SAP BI 7.0 in NW 2004’s, BW 3.5 and 3.1C.

SAP Modules: FI/CO, Logistics (SD, MM, PP) CRM and SRM.

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Sr.SAP BI/BO CONSULTANT

Responsibilities:

• Involved in implementing one complete life cycle of the project from requirement gathering to end user support using the ASAP methodology and was involved in the update project from BW 3.5 to BI 7.0..
• Involved in designing AD Hoc reports, Operational reports and credit underwriting and monitoring reports.
• Worked extensively on Input controls, fold and unfold properties, Data connections.
• Published the reports using CMC and scheduling the reports to the specific users on daily, weekly, monthly basis.
• Defined Universes over Existing BEx queries.
• Maintained and tested Universes for supporting ad hoc queries and reports according to the business requirements.
• Involved in creating User training document for the end users and the power users in BOBJ and giving training to the end users.
• Responsible for defining the BEx queries used in BO environment.
• Expertise on Transformations, rules, DTP’s and Info Packages.
• Enhancing the BWS Info Objects.
• Customized the Existing Info Cubes, DSO’s as per the business needs.
• Designed hierarchies in Universe for various reports and created user objects with calculations in universe.
• Created multiple Flash variables in Xcelsius and used them to pass data from one dashboard to other.
• Created Dynamic Xcelsius Dashboards, using QAAWS, Live office and BI services.
• Created Web I reports over Multiple Queries.
• Created Open documents URL’s, enabling users to jump from Web I to crystal.
• Extensively worked on Linking Web I reports with Crystal Reports using Open Doc Functions.
• Created Generic Extractors from Table and also enhanced the Generic Data source as per the client’s requirement.
• Defined Drill Down web I reports with complex formatting.
• Performance tuning of Business Objects universes and Web I reports.
• Sound Knowledge in defining Customer Exit Variables.
• Experience in using IDT (Information Design Tool) used to design the Universe on more than one relational database.
• Also created queries using IDT. Created crosstab data in Web I and developed the WEB Services for the Web I report that can be directly used in the Dashboard Designer.
• Managed the Servers, Servers Groups, Folders, Objects, Universes and Connections from Central Management Console (CMS) and CMS.
• Sound knowledge over Dashboard Designer components.
• Responsible for delivery of Business Objects Reports environment on time.
• Identified the risks and issues from team meetings and coordinating with Project manager.
• Responsible for end user training to work on reports.

Environment: Business Objects XI R3.1 (SP4), SAP BW 3.5, BO 4.0, XCELSIUS 2008, SAP BI 7.0, BIWS, WEBI, BCA, CMC, SAP BW,ECC 6.0,Access 2000, Windows XP.

Confidential, Washington DC

Sr. SAP Business objects / Xcelsius Developer

Responsibilities:

• Involved in complete life cycle of the project from gathering, analyzing, and documenting business requirements and data specifications from Business Objects universes and Reports.
• As a BO admin, extensively worked in gathering the business needs and converting them into technical specifications.
• Created the reports using Business Objects functionality’s like Queries, Slice, and Dice, Drill Down, Cross Tab and Formulae’s etc.
• Maintained tested Universes for supporting ad hoc queries and reports according to the business requirements.
• Worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc.
• Successfully Integrated SAP BO with SAP EP with SSO authentication.
• Created 5 Xcelsius Dynamic dashboards over SAP BI.
• Created best practices document for universe development and Webi reports against SAP BW.
• Responsible for solving the production issues raised by the business users.
• Worked extensively in creating both Static and Dynamic Reports as per the requirement.
• Importing and Exporting the Universes to repository to make it accessible to end users.
• Transmigrating Universe in different environments like Development to Production.
• Extensively Worked in Combination Queries.
• Created Web I reports over Multiple Queries.
• Extensive experience in working with data synchronization options like Merge Dimensions, Extended Merge dimensions in BOBJ to fetch the data from two Universes.
• Extracted Data from SQL and Oracle data sources by SAP Data Integrator.
• Created Web I reports with Complex Calculations to get alerts for Xcelsius Dashboards.
• Extensively Worked in SAP Live Office to create connections between Web I and Xcelsius Dashboards.
• Customized the dataflow architecture into SAP BI from R3.
• Worked on remote cubes, hierarchies, transfer rules and update rules.
• Successfully implemented Transports of BOBJ in SAP BI environment.
• Worked in extracting data from R3 into financial cubes and Logistics (sales) Extraction.
• User exits and transfer routines were written to support complex needs.
• Worked Extensively in Extracting data into SAP BO from SAP BI and Oracle Databases.
• Linked different Web I from dashboards to Info view.
• Developed multiple Dashboards so that the user can navigate from one dashboard to the other.
• Involved in gathering Dashboard requirements from High Level Executives.
• Preparing test cases for the created Web I and dashboard reports that in corporate application business rules for QA team to perform testing before rolling to production.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.

Environment: Business Objects XI R3.1 (sp2) Enterprise, Performance Manager, Dashboard Manager, XCELSIUS 2008, SAP BI 7.0, ECC 6.0 QAAWS, WEBI, SQL Server 2005,Oracle 10g, ActiveX, Microsoft Visio, Access 2000, Windows XP.

Confidential, Milwaukee, WI

Sr. SAP BOBJ Consultant

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Actively interacted and scheduled meetings with the business users to gather the reporting requirements, performed gap analysis and developed design documents.
• Involved in developing Inventory data model to provide BW reporting capabilities on Inventory data and designed queries on Material Movement, Material Prices and Material Consumption.
• Developed transformations with Start routine and End routine and involved in the creation and maintenance of DTP and Info Packages for loading data into data targets.
• Created Generic Data Source using Info set to satisfy the user requirements and maintain availability of specific data for reporting purposes.
• Used Open Hub Destination to store data from SAP BI to local databases for ad-hoc reporting purpose of ERP super users.
• Performed performance tuning using Aggregates and Partitioning of Info Cubes.
• Worked on BEx queries using BEx Query Designer and created Calculated Key Figures, Restricted Key Figures, Structures, Variables, Aggregations, Exceptions, Conditions and Customer Exits.
• Involved in various post-go live activities and responsible for production support activities and monitoring regular data loads and failures.
• Developed Business Objects Universes using SAP BI Queries as Source Data.
• Converted the Desktop Intelligence reports to Web Intelligence Reports.
• Created an Xcelsius dashboard using Live office.
• Organized follow up meetings with various departments on the project plan and deliverables.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOVs List of Values

Environment: Business Objects XI R3.1 (sp2) Enterprise, Performance Manager, Dashboard Manager, XCELSIUS 2008, SAP BI 7.0, ECC 6.0 QAAWS, WEBI, SQL Server 2005,Oracle 10g, ActiveX, Microsoft Visio, Access 2000, Windows XP.

Confidential, Cincinnati, OH

Sr. SAP BI/BW Consultant

Roles & Responsibilities:

• Implemented SAP BW/BI 7.0 for SD, MM, HR and FI/COPA modules and expert in designing data flow from R/3 to BW/BI system.
• Worked extensively on standard and custom defined LO extractors. Used LO extract structures and data sources in sales material management to facilitate the data extraction to BW/BI system.
• Extracted the data from Production orders and Process orders to analyze manufacturing orders.
• Expert in Data modeling techniques like Transformations, DTP’S, Data migration, ODS objects and structuring the info cubes as per the requirements.
• Created and maintained COPA data sources. Created report for Profitability Analysis (CO-PA) based on the fiscal year.
• Performed detailed analysis to improve the Performance of Cubes using BW Statistics, Aggregates and Involved in Production Support.
• Generated and maintained aggregates and rollup activities on SD Info cubes as part of the Info Cube Management. Modified existing queries on various Info Cubes related to SD and HR-Payroll.
• Modified existing queries on various Info cubes related to SD and HR-payroll.
• Created and maintained Info Spokes through Open Hub Services (OHS) to export data from the data targets to external logical source.
• Used aggregates, compression and partition techniques to improve the query performance.
• Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Query variants using BEx Analyzer.
• Created reports like Confined Quantity and Item Purchase Orders, Purchase Order quantities delivered, Purchase order values.
• Wrote reports in SD Open sales Order report, which covers all organization levels, delivery status, shipping figures in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.

Environment: SAP ECC 6.0, SAP BI 7.0, BEx Analyzer, FI/CO, SD, MM, HR, CRM, SRM.

Confidential, Wilson, NC

SAP Senior BW Consultant

Responsibilities:

• Designed and developed multiple BW info cubes and multi-providers to analyze Service Process, Activities, leads and opportunities.
• Designed Technical documents based on business requirements in SD, MM, Financial Management and Controlling and QM modules.
• Extensively involved in setting up of procedures for extracting data from SAP R/3 by using Generic Extraction and customizing LO Cockpit by using enhancements.
• Create Multi Cubes for customer and Vendor cycle core Returns, sales order header for Fill rates.
• Developed various Sales and distribution reports as Sales Overview, Orders, Deliveries, service level orders and Purchase orders.
• Create Aggregates, Compressions, Partitions and Indexes to improved query performance.
• Worked on business content Installation of Info objects, Data sources, Info Sources, and Data Targets as per the business requirements.
• Upgraded, enhanced and supported activities from BW 3.5 to BI 7.0 in Nw2004’s.
• Extracted Purchasing Requisitions and Purchase Orders data (MM) using LO-Cockpit extraction.
• Enhanced the Master data and Transaction data sources with Z-fields and populated data using ABAP User Exits.
• Designed a data model and Universe to enable the write back and retrieve functionality using Xcelsius and Web Services.
• Reviewed the developments carried out by the team members and organized conference calls between onsite and offshore team to report the tasks.
• Maintained the Remedy Tool and updated as the Bug fixing was done to maintain the standards of the Project.

Environment: SAP R/3 4.6C, SAP BW 3.5B, BEx, AFS, FI-CO, SD, IM,MM, CO-PA, AS/400, Oracle 8i, Windows 2000.

Confidential

SAP BW Consultant

Responsibilities:

• Activated Business Content for Standard Info cubes, Info Sources & Info Objects of SD and MM Modules as per the Client Requirements
• Created Info Objects, Info cubes, and Info packages and developed Transfer structure, Communication Structures, Update rules and Transfer rules for Info Sources and ODS objects.
• Design support of star schema to emulate existing operational business rules and provide multidimensional access to business information.
• Created and maintained Universes using BO Designer.
• Worked on Multiproviders, Info cubes, DSO, Transformation and DTP. Created many RKFs, CKFs and variables in BEx according to the requirement.
• Managed and review projects and Internal Orders using CO-PA Order.
• Created technical analysis deliverables, test plans, and other technical specification deliverables within the standard project lifecycle.
• Extensively involved in setting up of procedures for extracting data from SAP R/3by using Generic Extraction and customizing LO Cockpit by using enhancements.
• Created custom queries and defined Calculated Key Figures, Restricted Key Figures, Text Variables.
• For customized reporting using BEx Analyzer, Designed and developed several workbooks and global Views.
• Created Aggregate Tables and Short Cut Joins to improve the query Performance.
• Worked on Enterprise Reporting in crystal Reports.
• Interacted with business users to analyze the requirements of reports.

Environment: SAP R/3 4.6C, SAP BW 3.5B, Crystal Reports, FI-CO, SD, MM, Oracle 8i, Windows 2000.