SUMMARY

• Extensive experience in Analysis, Design and Development of business applications, which includes SAP BI 7.0 BW 3.5/3.1C/3.0 experience.
• Participated in multiple full life cycle implementations involving design and development of BW objects, Transformations, Business Content Configuration
• Capacity planning and sizing using SAP ASAP methodologies with different requirements in different industries and gained experience in various stages of implementation from pre - implementation to production support.
• Have good functional knowledge of SAP ECC modules like SD, MM and FICO.
• Extensively worked in the customization and implementation of SAP BW based on business needs and requirements. Instrumented in upgrading BW 3.5 to BI 7.0.
• Extensively worked in ETL and WAD.
• Expertise in OLTP extractions from SAP ECC using LO Cockpit (MM/SD). Generic Extractions. Also extracted data from the flat files.
• Good background in ABAP/4 programming (User exits, expert routines, start/end routines, function modules).
• Experience in Multi Dimensional Data Modeling - Star Schema, Extended Star Schema models. Strong knowledge of SAP BW architecture and SAP BW data model.
• Hands on experience in design and development of Info Cubes, DSO, Info Objects, Info sources, OLTP Extractions (Transaction Data, Master Data, Text, Hierarchies).
• Experience in process chain management, monitoring and scheduling the batch jobs.
• Worked extensively in designing queries in Bex Query Designer and created Workbooks (Excel Work Sheets) in the BEX Analyzer using Conditions, Exceptions, filters, calculated key figures, restricted key figures Variables & Structures, Cell definitions.
• Involved in the postproduction support, which required Infocube management using Compression, Aggregates, Rollup and performance tuning.
• Extensive knowledge in creating Universes in Business Objects (BO) related to BW queries and cubes. Proficient in Crystal Reports, WEB Intelligence and Xcelsius reporting.
• Conducted training for End-users and Project Team members. Developed Business process documentation.
• CreatedOSS Ticketsto report issues to SAP regardingBusiness Objects Integration Planning.
• Have knowledge in BICS connection which is used as the connector between BexQuery and Xcelcius.
• Managed Transport Procedure through different environments. Thoroughly examined transport log for failures and fixed them accordingly.
• Used RRI jump queries for drilling down to other queries and ECC transactions.

TECHNICAL SKILLS

ERP: ECC 6.0, 4.7, 4.6C, 4.0B

Business Intelligence: SAP7.0, BW 3.5, BW 3.0, SAP R/3

Programming Languages: SQL, PL/SQL, C

Databases: Oracle 10g, DB2 V9, SQL server, MS Access, and MS-SQL Server

Reporting Tools: BEx Analyzer, WAD, Business Objects

RDBMS: MS Access, MSSQL Server 2000, Data stage, IBM DB2, Oracle 10g/9i/8i/7.3.x

Scripting Languages: VBScript, HTML,XML

Operating Systems: Windows 95, 98, 2000, XP, vista, 7 AND UNIX

Utilities: MS Word, MS Access, MS Excel, MS PowerPoint

PROFESSIONAL EXPERIENCE

Confidential - Milwaukee, WI

SAP BI BOBJ consultant

Environment: SAP ECC 6.0, BI 7.0, BW 3.5, BEx Analyzer, Web Application Designer, BO XI 3.1.

Responsibilities:

• BI BO Consultant for User requirements gathering, Business Blueprint, Realization and Testing Phases
• Participate on teams and projects to understand business needs, design and recommend solutions, and provide support on the evolving BI environment.
• Worked extensively on LO Cockpit and Generic extraction.
• Involved in BW 3.5 to BI 7.0 upgrade processes.
• Responsible for design, development and extraction from ECC Source system and flat files to BI for FICO and SD.
• Developed and Tested Web Reports for drill down functionality including updating & verifying queries.
• Extensively involved in the scheduling and monitoring using process chain in Administrative Workbench.
• Provided complete solution in BI in the following metrics analytics: Sales and Distribution, Material Management and Production Planning.
• Around 4 reports and Dashboards developed in SD, MM, and HCM.
• Involved in analysis, design and development of Sales and Billing extract for external systems.
• Provide production support and administration of BI back-end operations to ensure data is successfully extracted from source systems, transformed, loaded into the warehouse and available for business use when needed.
• Involved in the resolution of daily issues/requests, performance management, maintenance upgrades, and production migrations.
• Involved in design and development of reports in cost center analysis.
• Apply Data modeling best practice to existing BI environment to get better query performance.
• Full life cycle Implementation of Business objects was carried out successfully and integrated with SAP BI, by installing and configuring the SAP Integration Planning Kit.
• Created formulas and store procedure and different Alerts based on the conditions.
• Developed advanced Xcelsius objects on concepts like What If Analysis, Dynamic Visibility, narratives, interactive charts, hierarchies.
• Created folders and User groups and applied security access restrictions as per the user roles through CMC. Integrated Crystal Xcelsius 2008 with Business Objects Enterprise XI 3.1.
• Involved in testing and fixing issues in Universes, Reports, Objects, Conditions and LOVs List of Values.
• Developed Ad hoc reports using Business Objects.
• Used SAP BI Integration Kit to connect Business Objects and SAP BI.
• Prepared Master queries by identifying common report requirements in each cube to enable Ad-hoc reporting on Universes and Webi reporting in Business Objects XI 3.1.
• Involved in OLAP Universe life cycle management using SAP BI data sources.
• Worked on MDX query driver to build reports off SAP BI cubes, ODS & published it to BO Enterprise.
• Developed complex queries and reports using different data providers in the same report.
• Created reports usingCrystal Reportsand also using Business Objects functionalities like Queries, Drill down, @Functions, Cross Tab, Master/Detail and Formulas etc.
• Used Nested queries to jump from summarized query on a cube to detailed level ODSs.
• Created prompts for Webi reports using @prompt functions.
• Worked with manual and imported excel data as data source for embedded Xcelsius spreadsheet.
• Developed dashboards for Budget spending.
• Migrated sap security model to business objects with Business Objects authentication.
• Implementation and Integration of the Business Objects XI 3.1 with the SAP Business Intelligence 7.x & SAP ECC.
• Worked with the creation of Universes, retrieving data using Universes and creating reports using Business Objects & Web Intelligence Tools.
• Worked with Xcelsius to create the Dashboards.
• Worked with the WEBI reports and Query as Web Service on the top of Universe.
• Aware of BICS connection.
• Expertise in Unit Testing, Regression, Integration, UAT(User acceptance testing), E2E testing, Defect documentation and problem log retesting using Mercury.
• Experienced with ASAP Methodologies (Project Plan, Requirements Gathering, Gap Analysis and Project Realization).

Confidential - Federal Way, WA

SAP BI BOBJ consultant

Environment: SAP ECC 6.0, BI 7.0, BW 3.5, BEx Analyzer, Web Application Designer.

Responsibilities:

• Created ODS, Infocubes, and Multiproviders to extract data from R/3 using LO Cockpit extraction.
• Enhanced master data sources and built generic transaction extractors. (Extractor based on Function module to extract Inactive pricing conditions for Sales, Billing and Shipment cost).
• Created a custom generic extractor to flatten hierarchies for InfoObjects like Profit Center, Cost Center and also extract texts for the nodes.
• Enhanced the business content Info cubes for Sales, Billing and Pricing for extraction transformation and loading (ETL).
• Developed front-end queries in Query Designer using Restricted and Calculated Key Figures, Formula Variables, Replacement path Variables, Customer Exit Variables, User entry Variables.
• Developed custom web applications as per the requirements using Web Application Designer (WAD).
• Designed Report-to-Report Interface to analyze both Summarized and Drilled Down Reports.
• Developed drill through Queries for detailed reporting using replacement path variables.
• Created Process chains on Master/Text/Hierarchy and Transaction data loads. Scheduled process chains and V3 collector jobs using Tivoli.
• Involved in Integration, Stress and Load test, Production readiness test and multiple cut-over activities.
• Documented the Functional and Technical Specifications for the Reports developed.
• Responsible for knowledge transfer to BW developers and end users.
• Involved in Design/development/maintenance/support of Business Objects Universe, Webi reports, Crystal reports and Dashboards.
• Extracted and built hierarchies like Financial Statement items, cost centers, Material and Product and enabled reporting on them in the latest front end tools like crystal reports using text and hierarchy variables.

Confidential - Livingston, NJ

SAP BW Consultant

Environment: SAP ECC 6.0, BI 7.0, BW 3.5, BEx Analyzer, Web Application Designer.

Responsibilities:

• Involved in Query Performance SWAT analysis with SAP to resolve potential Query Performance Issues.
• Executed reports based on Stat tables to identify long running queries and DBTrans records.
• Developed blueprint / functional and technical spec on BI front-end/Producer Portals.
• Gathered information regarding the business requirements from Management and Users to design the overall layout.
• Extracted data from FI-GL, AR and AP Transaction Figures and Line Item Data Sources
• Worked extensively in creating both Static and Dynamic Reports as per the requirement.
• Used Cell-Definitions, Structures, Exceptions, Conditions, and various User Exits in the Reports developed.
• Customized and improved query navigation by structures, filtering, conditions, variables, calculated and restricted key figures, currency conversions, jump queries using RRI and navigational attributes.
• Distributed workbooks to the Users using the Bex Broadcaster, so that the users can receive the Reports through mails as per the scheduled date and time.
• Responsible for thorough data validation using different unit test cases.
• Developed ABAP routines at InfoPackage level for data manipulation and restriction
• Handled various production issues for the tickets raised.

Confidential

SAP BW consultant

Environment: SAP R/3 4.6C, BW 3.0, BEx Analyzer, Web Reports.

Responsibilities:

• Involved in Sizing and Performance Optimization of the System.
• Uploaded Master data, Transaction data and Hierarchical data into the SAP BW.
• Created and Scheduled Info-Packages for Delta Initialization and Delta data loading.
• Designed Generic Extractors and DataSources for providing Data to Infocubes, Multicubes, ODS and Aggregates.
• Developed ODS object to load transaction data from Infosources and defined update rules.
• Loaded transaction data into PSA, updated data to ODS from PSA and activated ODS for reporting.
• Loaded external hierarchies for the InfoCubes from the SAP R/3 system.
• BW Data load scheduling, monitoring and troubleshooting data extraction / load problems.
• Extensively involved in the design of extended star schema.
• Provide Documentation on Best Practices for Support and Maintain after GO-LIVE.
• Involved in all the phases of Life cycle development from requirements gathering to putting the project into production.
• Enhanced the business content Info cubes SD, FI-CO for extraction transformation and loading (ETL).