SUMMARY

• Over 8+ years of experience in SAP Business Warehousing (BW 7.3/ BI 7.0/BW 3.5) and SAP Business Objects 4.0/XI 3.1
• Strong knowledge of BW/BI Architecture in design, development and configuration of Info Cubes, Data Store Objects (DSO/ODS), Info packages,Multi providers, Transformation, Data Transfer Process (DTP), Data Source, Info Source, Info Objects, Info Sets, PSA.
• Strong expertise in Data integration, Data modeling, Extraction, Transformations and Loading functionalities.
• Experienced in customization of standard business content provided by SAP and also proficient in the enhancement of data sources using Customer exits according to the requirement.
• Hands on experience in full life cycle implementation of BW 7.3, BI 7.0, and BW 3.5 which includes Data modeling, Data Extraction, Data Loading (Full/Delta Up - Loads), scheduling, monitoring, BExAnalyzer, Query Designer, Application Designer, Testing, Go-live and Production support.
• Comprehensive knowledge on data extraction from SAP R/3(FI-CO, MM, SD) using different Extractors such as LO Cockpit and CO-PA
• Experience in extracting data from OLTP and Flat Files.
• Experienced in writing Start routines, End routines, Field Routines using ABAP.
• Experience in transporting the Business Warehousing Objects from Development to Quality and Productions. Knowledge of Transport Connection to collect objects for transport.
• Experience and good knowledge in the migration of data sources and content from SAP BW 3.5 to SAP BW 7.3 maintaining the Transformations and DTP’s.
• Proficient in implementing BW processes like Aggregates, creating Error DTP, Rollups, Compression, Partitioning and Re-partitioning.
• Experience in the configuration and implementation of the Process Chains for the regular data loads and scheduling and monitoring the data loads.
• Strong Experience in transporting the BW objects from Development system to Quality system by using STMS.
• Experienced in SAP BW front end tools BEX Analyzer, Query Designer and Web Application Designer (WAD).
• Experience with Calculated Key Figures, Restricted Key figures, Structures, Characteristic Variables, Text variables, Exceptions and Conditions.
• Strong experience in Business Objects and Proficient in Business Objects tools: Universe Designer, Desktop Intelligence tool, Information Design Tool, Web Intelligence Rich Client, Info View, BI Launch Pad, Crystal Reports, Dashboards/Xcelsius, Query As A Web Service, Report Conversion tool, Import Wizard and Live Office.
• Experience in Design, Development and Deployment of Business Objects Solutions for corporate reporting requirements and experienced in building Universes, running queries and developing reports.
• Proficient in generating Xcelsius Dashboards using the components like Charts, Selectors, Maps.

TECHNICAL SKILLS

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

ETL Tools: SAP BW 7.3/BI 7.0,BW 3.5 SAP BO 4.0/XI 3.1

Reporting: BEx Analyzer, BEx Reporting (BW 7.3/BI 7.0/BW 3.5), Web Intelligence Rich Client, Information Designer Tool, Desktop Intelligence, Info View, CMC (Central Management Console)

Database: SQL Server, Oracle 9i

Internet Technologies: HTML, PHP

Packages: MS Office

Programming Languages: C, C++, ABAP/4

Operating Systems: Windows 98/XP/Vista/7, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Sr. SAP BI Consultant

Environment: SAP BW 7.3, SAP ECC 6.0,SAP BPC 10.0

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.
• Involved in implementation for SAP BW/BI back-end and front-end which included Data modeling, Generic/Custom Extraction, Data Loading, Scheduling, Monitoring.
• Involved in gathering user requirements, functional requirements, analyze, design, implementation, testing, and training with Clients.
• Generated export data sources on Business Area (0BUS AREA), Functional Area (0FUNCARE), Profit Center (0PROFTCTR) and loaded hierarchies from LHBW to VPS BW.
• Generated export data sources on BCS (ZBCS CD2C, ZBCS CD2P, ZBCS CD2O) InfoCubesand loaded the data from LHBW to VPS BW.
• Created start routines, end routines and field routines in the system using ABAP.
• Maintained variables in the TVARVC table and used the same variables in the routines.
• Loaded data from external systems to BW using data services.
• Triggered DM Packages to load data from BW to BPC.
• Monitor the data loads (daily/weekly/monthly) from source systemsby means of process chains.
• Involved in performance enhancement features such as cube partitioning, aggregates and compression.
• Prepared test scripts to validate the data between BW and BPC.
• Actively involved in PSA and change log deletions for reducing the table space issues.
• Created documents for the developed objects according to the user requirement specifications for support testing and for further guidance.

Confidential, Manchester, CT

Sr. SAP BI Consultant

Environment: SAP BW 7.3, SAP ECC 6.0, BO 4.0

Responsibilities:

• Worked on Data modeling, Data extraction, Generic/Custom Extraction, Data Loading, Scheduling and Monitoring.
• Involved in full life cycle implementation, which includes Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Worked on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, time-dependent master data and also worked on ETL (Extraction, transformation and loading) activities like Extraction from Source system, Transformation rules and Data Transfer Process (DTP).
• Worked on MM, SD and loaded the data from ECC to BW and used initialization with delta update and full update methods.
• Extracted data from MM modules and uploaded the data into the procurement cubes via 2LIS 02 HDR, 2LIS 02 ITM and 2LIS 02 SCL and activated the appropriate Business Content cube.
• Extensively worked on data sources 2LIS 11 VAITM, 2LIS 11 VAHDR, for sales orders, and 2LIS 11 VASTI for order item status.
• Created and activated transformations (both DSO and InfoCube level) and wrote start routine and end routines.
• Involved in scheduling the data loads, debugging and monitoring load failures, process chains, solving the tickets like delta loads.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Worked on performance tuning and trouble shooting of BW issues, connector issues and reporting errors.
• Created start routines, end routines, field routines and expert routines by using ABAP as per the business requirement.
• Extensively worked on Query building, filtering, free Characteristics, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BExAnalyzer.
• Worked on query development and formatting techniques in BEx Query Designer.
• Directly used SAP BEx queries to build a WebI documents by using BICS connection.
• Experience in using IDT (Information Design Tool) used to design the Universe on more than one relational database. Also created queries using IDT.
• Extensive experience with WebI in creating queries and reports that further used in the Dashboard Designer.
• Developed Interactive reports and dashboards using Xcelcius and WebI reports.
• Sound knowledge over Dashboard Designer components.

Confidential, Clayton, MO

Sr. SAP BI Consultant

Environment: SAP BW 7.0, SAP ECC 6.0, BO 4.0

Responsibilities:

• Worked on BW Production support issues based on severity, Analyzing the issue and providing solutions accordingly.
• Created various reconciliation reports to reconcile the ECC, BI and Variances Data in the single report using custom extractors.
• Developed BO Web Intelligence reports (Ex-Brew and Ex-Dealer) by using BICS.
• Technically involved in the responsibilities of security/authentication on the folder level for the Web Intelligence reports.
• Scheduled Web Intelligence reports using Central Management Console (CMC) for the management team daily.
• Loaded data from external system CAS to BW using DBCONNECT.
• Installed BI Content and enhancements based on business needs.
• Identified the needs for data staging layers in BI.
• Created expert routines in BW to load data from propagation layer to transformation layer.
• Responsible for job schedules for loading Master Data (Texts, Attributes and Hierarchies) for Materials and Transaction Data into the corresponding DSO Objects and InfoCubes.
• Monitored Process chains and fixed the issues daily.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Validated the source to target data by using the sql test scripts.
• Have worked on doing testing during BO 3.1 to BO 4.0 Migration.
• Created BICS connection using IDT tool to broadcast Bex query for reporting purpose.
• Worked on Performance tuning of Webi reports and BW backend design.
• Conducted End User training on BO Web Intelligence upon request from HR.

Confidential, WA

Sr. SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, BO 3.X

Responsibilities:

• Involved in the design, development and implementation of the Info Objects, Data Sources, Info Sources, Data targets, Info Packages and Info Providers to load Master and Transactional data from SAP R/3 system into BW system.
• Performed analysis, design, development and implementation of standard/customized InfoCubes and DSO objects.
• Created Transformation, Data Transfer Process, Update rules, and Transfer rules.
• Created and scheduled Process Chain for loading Master Data and Transaction Data and monitored the loads.
• Developed reports using Bex Query Designer, using restricted key figures, calculated key figures, filter and formula as per the requirement of the query.
• Worked on Cutover Activities (TCO & ACO) on monthly and quarterly basis which involves execution of cookbooks during the cutover activity.
• Worked on front end level, created Web Templates according to the user requirements.
• Worked on SIR (System Investigation Request), CR (Change Request) tickets.
• Involved in extraction of full, delta loads and resolved data load related issues.
• BIA Monitoring and BIA Index Maintenance for necessary cube.
• Prepared Technical Specification documents as per the functional specification.
• Monitoring process chains and fixing data load issues.
• Prepared Unit test script documents for the UAT.
• Created Incident tickets, Interaction tickets and change tickets in SM7.
• Good experience in creating Universes over the Bex queries using Universe Designer.
• Created many Variables and Prompts in BOBJ according to the user requirement.
• Extensive experience in working with Infoview in creating and maintaining the WEBI reports.

Confidential, Framingham, MA

SAP BI Consultant

Environment: SAP BI 7.0, SAP ECC 6.0, SQL SERVER 2008, QLIK VIEW

Responsibilities:

• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, unit testing(UAT) to Go live production support.
• Converted all Sql server tables and fields names from lower case to upper case and also reduced the length of fields to 16.
• Created views in Sql server, based on that views designed cubes in SAP BW and loaded data from Sql server to SAP BW using DBCONNECT.
• Worked withinfopackages, transformations and DTP to load the data.
• Activating the business content according to the functional requirements.
• Write ABAP routines to convert Sql server date format (Char) to BW date format (YYYYMMDD).
• Created generic datasource by using table (TCURR) and loaded exchange rates data from SAP R/3 to BW.
• Created custom InfoCube, DSO, Multiprovider, InfoSet, InfoObjects and DTP.
• Created Process chains to load last month and current month data daily.
• Monitoring process chains and fixing data load issues.
• Prepared Unit test script documents for the UAT.
• Participated in transporting the BW objects from development server to testing server for unit testing and regression testing.
• Maintained Reconciliation’s to verify the data in SAP BW and QLIK VIEW are same or not after the data loads.

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/34.7, BO 3.X

Responsibilities:

• Created generic extraction by using View and functional module to extract data from SAP R/3 to BW.
• Extensively worked on enhancing the standard data sources as per client requirement.
• Activated and utilized the business content according to the functional requirements.
• Involved in gathering business requirements, GAP Analysis, design and development of technical specifications.
• Extensively involved in setting up procedures for extracting the data from sap R/3 by using LO-Cockpit extractions and used initialization with delta update and full update.
• Created custom InfoCube, ODS, Multiprovider, Infoset andInfoObjects.
• Involved in solving performance-related issues and also involved in Creation of Aggregates to optimize.
• Monitoring process chains and fixing data load issues.
• Involved in resolving the Tickets (Incident & Change request).
• Maintained Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Maintained Aggregates, Rollup and compressed Infocubes to improve the query performance.
• Activating the business content according to the functional requirements.
• Developed front-end queries and reports using BExAnalyzer, BEx Browser, and Info set Query, BEx Web Reporting tool and Web Application Designer.
• Created reports with Restricted Key Figures, Calculated Key Figures, Exceptions, Conditions, Variables and Filters.
• Worked extensively on Web application designer to set up the template to test the web printing options.
• Extensively worked in SAP Live Office to create connections between WEBI and Xcelsius Dashboards.
• Sound Knowledge over Xcelsius Dashboard Components.

Confidential

SAP BW Consultant

Environment: SAP BW 3.5, SAP R/3 4.7

Responsibilities:

• Involved in gathering the requirements from users and Data Modeling.
• Interfaced with Business Analysts and performed Gap Analysis.
• Configuration of BW by identifying the Info Objects, Info Sources, Info Cubes, ODS from Business Contents.
• Developed ODS objects to support Delta Upload.
• Extracted data from Flat files to InfoCubes.
• Scheduled InfoPackage for loading Master Data and Transaction Data and Monitoring.
• Defined Process Chains for the data loads and scheduled accordingly.
• Data loading was monitored and failed data packets were analyzed and if possible manually edited in PSA (mostly for invalid characters) and re-loaded.
• Enhance standard data source for master data attribute and transaction data.
• Participated in transporting the BW objects from development server to testing server for unit testing.
• Involved in resolving the Tickets like SR, MR&CR.
• Prepared Unit test scripts documents.
• Involved in System checks whenever required.
• Maintained Reconciliation’s to verify the data in SAP R3 and SAP BW are same or not after the data loads.
• Maintained Aggregates, Rollup and compressed InfoCubes to improve the query performance.
• Scheduling and Monitoring background jobs.
• Analysing short dumps using ST22.
• Coordinating with on-site team lead and updating day to day activities.