SUMMARY

• More than Six (6+) years of experience in SAP BW/BI as a Technical Consultant alongwith 2 years experience in SAP BOBJ. With strong SAP business user relationship.
• Experience in Identifying reporting requirements with prime end users and translating the user requirements into technical documentation and into BW data warehouse models.
• Experience in activating and enhancing standard ECC data extractors and developing customized extractors using tables, views, and function modules.
• Experience in extracting data using Flat files, Standard extractors, Customized extractors.
• Experience in writing ECC User Exits to enhance the standard extractors in FI, SD and MM and HR.
• Experience in SAP BW multidimensional Data Modeling and BW Customizing.
• Experience in developing Info Cubes, Multi providers, Aggregates and ODS/DSO objects.
• Experience in developing Transformations and DTP’s with start & end routines in BI 7.0.
• Experience in performance tuning of BW systems. Evaluated statistical performance and improved data load, query performance by using compression, aggregates, partitioning techniques.
• Created/Modified the complex BEx queries which use Exceptions, Filters, Variables, Structures, Hierarchal info objects, calculated and restricted key figures.
• Knowledge in SAP Business Objects tools like Universe, Web Intelligence, Crystal Reports, and Xcelsius.
• Experience in creating process chains and scheduling batch jobs.
• Production support experience in handling batch jobs, load failures, delta failures and system issues.
• 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).
• Strong Basis & database knowledge and created roles for different users with different security levels.
• Extensive experience in Business Analysis, GAP Analysis, Requirement Gathering, and Solution Delivery.
• Working experience of Onsite - Offshore modeling.
• Excellent communication, presentation and interpersonal skills a total team player. Self-starter with drive, initiative and a positive attitude.

TECHNICAL SKILLS

ERP: ECC 6.0, 5.0, SAP R/3 4.7, 4.6c

Business Intelligence: BI 7.0, Netweaver2004s, BW 3.5, 3.1c

Programming Languages: SQL, PL/SQL, ABAP/4.

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

Reporting Tools: BEx Analyzer, WAD,MS Office, Business Objects

Scripting Languages: XML, HTML, and VBScript

Protocols: TCP/IP, FTP, SMTP, POP and HTTP

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

PROFESSIONAL EXPERIENCE

Senior SAP BI/BO Consultant

Confidential, Los Angeles, CA

Environment: SAP BI 7.0, ECC 6.0, DB2 V9, BEx Analyzer, Windows NT, BO XI 3.1, SD

Responsibilities:

• Gathering Business Requirements from Users & Business Analysts for data modeling.
• Identified the gaps and suggested necessary enhancements for transaction data and master data extractors.
• Performed extractions from multiple source systems including SAP, (using LO, LIS, Generic extractors) XI, Ascential and flat files.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Involved in customizing extract structures for SD data sources like 2LIS 02 ITM, 2LIS 02 SCL, 2LIS 03 BF.
• Worked extensively with payroll results from cluster, headcount and Personnel actions Extractors and enhanced respective cubes & DSOs.
• Installed Time Sheet Data cubes & Multiproviders 0CATS C01, 0CATS C02, 0CATS MC1 in CATS.
• Installed Payroll and Personnel Time Management cubes 0PT C01, PY C02 & 0PY MC02. Extracted Payroll data using the Payroll Data sources.
• Worked extensively on transfer rules, update rules and user exits for transaction data.
• Creation of Info packages for scheduling data load process with Full and Delta update mode. Created transformations and DTPs for the necessary objects in development.
• Worked extensively on BEx Query Designer.
• Developed flexible queries using filters, navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized way to give detailed levels of information.
• Expertise in Reports Generation using BEx Analyzer, building Queries and saving Workbooks (Excel Work Sheets), creation of Custom Queries using conditions, exceptions, variables & structures and created aggregates for frequently used queries.
• Used RRI feature to jump between the Queries to analyze the data efficiently.
• Worked extensively on Data warehousing workbench and managed and monitored data loads with Full update and Delta mechanism.
• Handled performance tuning of queries using aggregates, table partitioning, indexing of Info Cubes.
• Performed data integrity testing by executing Bex Queries validating against the backend ECC System.
• Created Drill through queries from summarized Info Cube to detail DSO data.
• Worked effectively on BOBJ (Creating Universes, creating reports through WEB Intelligence).
• Worked on ABAP coding in BW, Start Routines, Update Rules, Transfer Rules and Customer Exit variables coding. Also Start Routine and End Routine in BI 7.0.

SAP BI/BO Consultant

Confidential, San Dimas, CA

Environment: SAP ECC 6.0, BI 7.0, BEx, BO XI 3.1

Responsibilities:

• Involved in gathering Business Requirements at ADP (Tax and financial services) from Users & Business Analysts.
• Analyzed Functional specs and created technical specs and Unit Test scripts for Client fund obligation project.
• Prepared the sizing chart for CFOP project to handle huge volumes of data and prepared blue prints.
• Involved in migrating mainframes data to BW through flat files for ADP tax services.
• Customized Business Content InfoSources, InfoCubes and activated Business Content to meet business requirements.
• Designed and created time dependent master data objects as per the project needs
• Involved in using the new functionalities of BI 7.0 like creating write-optimized DSO’s for staging raw data.
• Designed Datasources, Transformations, and DTP’s and activated the same.
• Written routines at different levels like start routines, end routines and field level routines.
• Written extraction routines using ABAP for master data, texts and hierarchies
• Created MultiProviders for specific queries of FI and SD
• Created Process chains for effective scheduling of various Daily and weekly loads.
• Modified the application-specific and generic data extractors in FI and SD.
• Modified and wrote user Exits using ABAP to fill the appended extract structure with the data and extensively involved in developing queries for populating dates.
• Extensively used BEx Analyzer to design complex queries related to Payroll, Receivables, profitability, obligation and audit reports.
• Created BEx reports with cell definitions, conditions, exceptions, replacement path variable, calculated key figure, restricted key figure and user exits
• Created complex BEx reports using different kinds of variables like Characteristic, Hierarchy, Hierarchy Node, Text and Formula.
• Activated the BEx broadcaster and information broadcasting.
• Used RRI jump queries for drilling down to other queries and ECC transactions.
• CreatedOSS Ticketsto report issues to SAP regardingBusiness Objects Integration.
• Interacted with user to gather reports requirements and designed technical and functional specifications.
• Installed Xcelsius 2008 with SAP3 on the server and handled using the Xcelsius 2008 to develop the executive Dashboards.
• Built Universes and Created Complex and Ad-Hoc Reports using Web Intelligent, Live Office, Xcelsius and CMS XI.
• Involve in building financial & budgeting reports and applying functions based on requirements.
• Managed Transport Procedure through different environments. Thoroughly examined transport log for failures and fixed them accordingly.
• Involved in activating the BI Statistics and running the statistic reports for performance issues.
• Worked in Production support and handled batch jobs, load failures, and system issues.

Senior SAP BI/BO Consultant

Confidential, Sparks, MD

Environment: SAP ECC 6.0, BI 7.0, BW 3.x, BEx, BO XI 3.1.

Responsibilities:

• Team member of SAP BI 7.0 implementation.
• Involved in gathering Business Requirements from Users & Business Analysts for designing functional and tech specs.
• Customized Business Content InfoSources, InfoCubes and activated Business Content to meet business requirements.
• Extensively involved in creating InfoCubes in the areas of HR, SD and FI modules.
• Worked extensively with payroll results from cluster, grievance, headcount and Personnel actions Extractors and developed respective cubes & DSOs.
• Assisted the Business Process Team in creating Functional Design Specs for Conversions and Interfaces
• Worked extensively in the HR functional areas of Benefits, Employee Job History, Work Unit Seniority, Disability, Payroll, Grievance, Training, Resumix, Spot Bonus, Ace Awards, PTS, Exam Interactions, Qualifications, E-Recruiting, Questionmark.
• Designed InfoSources, activated transfer and update rules, scripted extraction routines using ABAP for master data, texts and hierarchies.
• Enhanced the Info cubes by adding custom InfoObjects to reflect modified ECC business process.
• Created MultiCubes for specific queries of SD, HR and FI.
• Extracted transactional data like sales order and delivery-billing information etc data using LO cockpit extract structures.
• Created master data InfoSources for uploading master data and hierarchies.
• Modified the application-specific and generic data extractors in FI, SD and Logistics and cross-application generic extractors, and customized delta built up for the data sources.
• Modified and wrote user Exits using ABAP to fill the appended extract structure with the data and extensively involved in developing queries using filters.
• Created Process chains for effective scheduling of various processes.
• Worked in Production support and handled batch jobs, load failures, delta failures and system issues.
• Handled data migration from different SAP systems to a Single Global system.
• Extensively used BEx Analyzer to design complex queries.
• Created reports where cell definitions, conditions, exceptions and virtual key Figures were used.
• As a Business Objects Admin created rolls and groups in Central Management Console and based on the profile give access to Business user.
• Designed and Created reports using Crystal reports XI /10
• CreatedAd hocReports using End User module in Business Objects.
• Developed dashboards usingBusiness Objects Xcelsius.

SAP BW Consultant

Confidential, Detroit, MI

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

Responsibilities:

• Responsible for overall master data and transaction data.
• Developed multi-providers and created reports on them.
• Responsible for developing and maintaining Process Chains.
• Configured Reporting Agent for Exception Handling.
• Extensively involved in the enhancement of BCT Data Sources and development of Generic Data sources.
• Used both initializations with delta update and Full update methods depending on the business requirement.
• Created Info-Packages group to schedule Info-Packages to load master data.
• Prepared Dataflow Document, Technical Design Documents, Application Design Documents
• Involved in the Unit testing, System testing and Integration Testing of the BW configurations.
• Developed a number of transaction Cubes and basis cubes.

SAP BW Consultant

Confidential, Omaha, NE

Environment: SAP 4.6c, BW 3.5, BEx.

Responsibilities:

• Participated as member in pilot BW implementations team in USA and contributed towards logical data modeling of Info cubes and ODS.
• Document reporting to the needs of the business service and support organization and disseminate those requirements into a data warehouse strategy resulting in both operational and analytical reporting.
• Developed ODS and InfoCubes for sales and controlling areas like procurement, cost center, order status and sales overview.
• Designed InfoSources, activated transfer and update rules, scripted extraction routines using ABAP for master data, texts and hierarchies.
• Used LO extract structures for extracting sales order, delivery-billing information.
• Extended standard Business Contents based on client requirements using User Exit and Function Module.
• Enhanced and Modified the application-specific and generic data extractors
• Extensively involved in creating InfoCubes in the areas of SD, MM and FI modules.
• Set up source systems to load both SAP/R3 and non-SAP transaction data to BW.
• Created process chains to automate the data load and data target administration.
• Written routines (start routines, update routines) using ABAP in update rules and transfer rules to update key figures in the InfoCubes.
• Created Multiproviders, assigned user groups to the Multiproviders. Created exception evaluations for queries. Designed multiple drill-through reports from BEx Queries.
• Extensively involved in designing complex queries for open sales order analysis, Vendor performance analysis, delivery analysis, past-due sales orders, outbound shipping, and General Ledger reports.
• Created formula to calculate profits, % variance and YTD Actual.
• Created complex reports where cell definitions were created in the queries for explicit formulas.
• Used conditions and formula variables for Top NN reports and Exceptions were used as per the requirements

SAP BW Consultant

Confidential

Environment: SAP R/3 4.0B, SAP BW 3.0B, BEx.

Responsibilities:

• Involved in SAP BW implementation, support post production.
• Involved in gathering Business Requirements from Users & Business Analysts for sizing & data modeling.
• Administering through BW workbench. Involved in end to end design and construction of BW objects.
• Designed, developed and modified InfoObjects, InfoCubes, ODS Objects, InfoSources, Transfer rules, Update rules to suit the business requirements.
• Involved in creating Sales, Billing, Shipping, Finance and Profitability Analysis InfoCubes.
• Involved in creating Multicubes, Infosets based on the requirements and reporting on them using BEx.
• Extracted data from SAP R/3 using LO Cockpit, CO-PA, Generic, Business Content Extractors and from flat files.
• Enhanced extract structures using User exits in ABAP.
• Used Delta Update process for loading the data to BW from R/3 in specific intervals. Used interface DB connect to get data from external sources.
• Populated the Info Objects, ODS Objects and InfoCubes with Master data and Transactional data from SAP R/3 via Data Staging area (PSA) by creating InfoPackages.
• Created Process chains for effective scheduling of various processes.
• Wrote ABAP/4 routines to enhance Business Content Data Sources to meet the business requirements.
• Created Drill through queries from summarized InfoCube to detail ODS data.
• Transported InfoObjects, InfoCubes, Queries, update rules, Multi cubes from Development to Quality.