Profile summary:
Has 9+ years of experience in SAP BI/BW and 3+ years in Business Objects environment including 1+ years of experience in SAP America.
Has extensive experience in development and implementation of BI solutions from BW 1.2 to 7.0 and implemented several full life cycle BI projects involving FI-CO, CO-PA, SD, MM, HR areas.
Involved in complete life cycle implementation of BI/ BO.
Involved in complete life cycle implementation of BI/BPC.
Installed and Configured SAP BusinessObjects Enterprise XI 3.1, and BusinessObjects XI 3.1
Worked with BOBJ 4.0
Worked with BW 7.3
Worked with .net SDK
Expertise in Business Objects Products (Designer, Desktop Intelligence, Web Intelligence, Info View & CMC).
Experience in Designing Universes, WebI Reports, Crystal Reports.
Created Xcelcius dashboards with data from Live Office, QaaWS & Excel Files.
Experience in BO Server Installation & Configuration.
Experience in SAP BI BOBJ Integration .
Sound experience in gathering business requirements, gap analysis and finalizing functional/ technical specifications and blueprint design/realization.
In Depth knowledge of BI/BW 7.0 in areas like Data Warehousing Workbench, Data Store Objects, Info Cubes, Transformation(Start Routine, End Routine),PSA, Info Package, Data Transfer Process and Process Chains, Transports Organizer, Remote Cubes, Mutliproviders, Data Mart and Open Hub Service.
Enhanced extract structures in LO-Cockpit, COPA, FI which involves maintaining the extract structures, data sources, activating updates and Controlling V3 updates.
Experienced in coding for Generic data extractors, Customer exits and SAP Enhancements.
Installed, activated and customized Business Content as per user’s requirement.
Loading master data/texts , Hierarchies & transaction data from R/3 system from application specific data sources.
Experience in loading Flat file from third party systems to DSOs & Info Providers.
Defined authorizations, user profiles and access.
Experienced in query performance optimization which involved creation and maintenance of aggregates and statistics.
Worked Extensively in BEx Analyzer in building Queries, saving it in Workbooks (Excel work Sheets), along with Web Report publishing and Queries using BEx Explorer and Info Set Queries.
Expertise in front-end Business Warehouse Components like Queries, Calculated Key figures, restricted key figures, Structures, Variables, Exceptions, conditions, RRI, Jump queries ,WAD and Visual Composer etc.
Conducted workshops and presentations to validate business requirements and solutions with the end user community, Developed business process documentation.
Conducted training sessions for users in BW reporting, security, Info Cube design and data extraction.
Experienced in use of ASAP Methodology for BW project plans and Accelerators. Excellent analytical and problem Solving skills. Quick learning capacity and positive attitude towards new challenges.

TECHNICAL EXPERIENCE:

Data Warehouse:

SAP BI 7.0, SAP BW 3.5 (SD, MM, HR, PP, FICO, COPA),Business Objects

Languages:

ABAP, C, C++, HTML,XML,PL/SQL

DataBase

Oracle 9i, Microsoft SQL Server 2005, Access

Tools:

Crystal Reports 2008, Xcelcius 2008, Microsoft Office 2003-2007, Live office, Explorer,Data Services

Operating System:

Windows, Unix/Linux

PROFESSIONAL EXPERIENCE:

Confidential,NY DEC 2011 Present BI Architect
Designed the data flow and the architecture for Spend Analytics .
Developed & Tested the required DSO’s, Cube’s & Multiproviders.
Extracted data by using DB connect to get data from external databases.
Extracted data from oracle views using DB Connect.
The project is called Aggregate Spend Analytics, The purpose is to create Federal & State reports which will be sent to Federal & State governments respectively.
Created Generic Extractors in ECC.
Worked on User Exits and populated values for appended fields in the custom extractors.
Worked on Start, End & Expert Routines for transformation Logic and for reading the data within BI
Created process chains for automation of data loading.
Created complex BEx queries using Variables, Replacement path
Created universes, WEBI & Crystal reports on top of Bex queries .
Implemented Business Objects 4.0, from Patch 2.1 to Patch 2.6. Worked with SAP
Responsible for Creating/Enhancing BOBJ Universes using BW Bex Query’s, retrieving data from Universes and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client\'s requirements using, Web Intelligence (WEBI).

Confidential,SFO SEP 2011 NOV 2011 BI Architect/Lead
Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
Worked on Data Modelling, Data Extraction, Data transformation, Data Loading, Scheduling jobs, Monitoring data loads and Reporting.
Handled performance tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
Involved in transportation of objects to target systems and handled transport related issues
Designed Universes and classes by Business Objects XI 3.1 enterprise tool and build all the objects required for WebI reporting which performed selecting, joining tables, cross tab, ranking, and alerter functions
Testedthe BEx Queries, Universes, dash boards using unit testing and integration testing
Designed and developed the architecture for Cost Center Accounting Module.
Worked on FI-Gl, FI-AP,FI-AR
Created Bex reports, Webi Reports .

Confidential,IL Jan 2011 Aug 2011 BI Architect/Lead
Testedthe BEx Queries, Universes, dash boards using unit testing and integration testing

Experienced in design & development of Dashboards using Xcelsius
Created Xcelsiusdashboard using universe designer, qaaws & webi. with BW as Data SOurce
Designed and developed the architecture for Cost Center Accounting Module.
Worked on FI-Gl, FI-AP,FI-AR
Created multiple datastore configurations (Dev, QA, and Prod) on every source datastore so that the work flow isn\'t affected when loading the batch job in different environments
Worked on Gathering functional requirements for FI & COPA from the Business.
Created Generic Data Source for COPA Account Based ,based on the functional requirement.
Created Dso’s for COPA Data Source and Info Providers and created a Bex report based on the functional requirement.
Enhanced 0FI_Gl_4 extractor and built custom Dso’s for Balance sheet & P&L.
Built reports on COPA , Balance sheet & Profit Statement.
Created a Multi Provider for COPA & FI Info Providers .
Extracted data from Material Classification Data Sources.
Transported Objects to QA, Loaded data in QA and Validated and to Production System and validated the Data.
Created Process Chains for FI & COPA Loading.

Confidential, NY Jan 2010 Dec 2010
BI Architect
Involved in all phases of BI BPC integration.
Involved in Gathering Functional and Technical requirements for SAP BI BPC Implementation.
Gathering Functional requirement and developing business blueprint for BI BO Implementation.
Writing and optimizing SQL queries and Complex Data Modeling
Monitoring, maintaining and optimizing database and ETL processes
Worked on SD, MM, FI Modules.
Extraction of data from 0fi_Gl_12, 0FI_Gl_10 into BI and exporting the data to BPC using Process Chains and Function Modules.
Extraction of FI Master data in to BI and exporting into BPC.
Mapping of InfO objects from BI to Dimensions in BPC using transformations .
Created Process Chains for Automation of Master Data & Transactional Data loading into BPC.
Worked on Creating Inventory reserve report by creating data source on MBEW as per the client requirements.
Transported the objects for ECC & BI.
Worked on setup of LO Cockpit for sales data and extracting to BI.
Involved in extracting FICO and COPA data from SAP R/3 to SAP BI.
Worked extensively on change requests (CR).
Interacted with the client & involved in enhancements and cut-over.
Extensively worked on designing process chains.
Created queries on FI,SD,MM data using Bex.
Activation of business content in SAP-R/3 and BW.
Creating custom info Objects.
Creating info providers (ODS objects, info cubes and multi providers).

Confidential,VA Dec 2008 Nov 2009
BI BO Architect/ Lead
Responsibilities
Involved in all the phases of SAP BI / BOBJ Integration.
Guided the Installation and configuration of Server/Client components of BO Enterprise tools (BO Enterprise XI 3.1), and SAP BI/BOBJ integration kit.
Created, designed and implemented Universes, WebI, Crystal Reports, and Xcelcius Dashboards.
Gathered and analyzed business requirements and translated them to functional requirements.
Designed and created ad hoc reports for business users using WebI.
Interacted and collaborated with business users in design of high level dashboards using Xcelcius.
change requests (CR).
Extensively worked on designing process chains.
Interacted with the client & involved in enhancements and cut-over.
Enhanced the existing master and transaction data extractors in SAP R/3.
Involved extracting master data to 0COSTCENTER, 0MATERIAL, 0PLANT, 0COSTELMENT, 0CUSTOMER, and 0CUST_SALES etc.,
Involved in extracting FICO and COPA data from SAP R/3 to SAP BI.
Written ABAP code at user exits in SAP R/3.
Created Multi providers and enhance reporting flexibilities.
Extracted and enhanced data sources from various SAP modules: GL, AP, CO-PA. Data Sources 0FI_GL_4, 0FI_GL_6, 0FI_AP_4, 0CO_OM_CCA_9 and etc..,
Developed flexible queries using filters, navigational attributes, variables in BEx analyzer to facilitate data analysis in a drill down or summarized way to give detailed level of information.
Involved in production Outage and Cutover periods.
Design and configure BW queries and workbooks utilizing BEx functionality.
Created reports in BEx Query Designer.
Supported data load monitoring team.
Provided End user support and guidance to use reports.
Involved in handling TT’s raised in Remedy during the failure of process chains in BWP system

SAP Internal Project PA Feb 2008 Sep 2008

Responsibilities
Analyzing the SAP BIW Business Content required, activating the business content components
Created Generic Data Sources using database Views on Tables
Worked with Logistic and FI data sources 0FI_AR_04 and 0FI_AP_04, developed generic data sources, worked with tables and function modules for these data sources
Managed and monitored several data loads with millions of records. Optimized load performance by adjusting the packet sizes and resolved the errors and inconsistencies during the data loads
Developed ABAP user exits in SAP R/3 for appended fields in the extract structure
Using Visual Composer created iviews and assigning them in portal
Transporting the objects from DEV to QA and DEV to Production using transport organizer.
Worked extensively on Trouble Tickets

Confidential, NY Dec 2007 Feb 2008 BI Architect/Lead
Responsibilities
Activation of Business Content data sources for 0FI_Gl_04, 0FI_GL_06, 0FI_GL_07
Worked on Restricted Key Figures, RRI Calculated Key Figures, Exceptions, Conditions, Variables and Filters
Extensive work done on Process Chains as well as performance enhancing Aggregate tables and system settings and parameters to speed up loading as well as reading of data
Involved in consistency check in aggregates and Attribute Change run.
Extended business content data sources and worked with user exit coding
Involved in the design of the Process. Development of required backend development such as Info Providers (Cubes, DSO, and Master Data Objects), Transformations, DTPs, Open Hub.
Installed 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 as per the client requirements.
Created and maintained Info Cubes, Operational Data Store, PSA, Info Objects, Info Areas, Multi Providers, Info Sources, Data Sources, and Info Packages.
Extensively involved in setting up of procedures for extracting data from SAP R/3by using Generic Extraction and customizing LO Cockpit by using enhancements.
Extracted transaction data for sales from R/3 on a daily basis and master data for customers and vendors on a weekly basis used delta initializations and delta loads.
Extracted data from SAP R/3 using Generic extraction techniques and LO cockpit and loaded into Sales Order Info Cube using Data Sources.
Developed and maintained the Info Cubes, ODS objects, Infosets and Multiproviders.
Created ABAP routines in transfer rules and update rules.
Created MultiCubes for Customer and Vendor Cycle Core Returns, Sales Order Item Quantity, Sales Order Header for Fill rates.
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.
Developed flexible queries using filters, navigational attributes in BEX analyzer to facilitate data analysis in a drill down/summarized way to give detailed levels of information.
Gathered reporting requirement and Designed Data flow from SAP R/3 to BW for specific Functional areas like Material Management and Sales Distribution.
Developed various Sales and Distribution reports as Sales overview, orders, deliveries, service level orders and purchase orders
Created technical analysis deliverables, test plans and other technical specification deliverables within the standard project lifecycle.
Created Aggregates, Compressions, Partitions and Indexes to improved query performance
Scheduled jobs for loading data into Info Cubes, ODS objects from SAP R/3, non SAP systems and flat files and monitored Process Chains to run periodic loads.

Confidential,MO Sep 2007 Dec 2007

Responsibilities
Requirements gathering, data modeling, planning/scheduling data extraction from source systems, interacting with users for customized and standard reports, gap analysis and associated solutions
Involved in extracting FICO and COPA data from SAP R/3 to SAP BI.
Created Complex Queries using user exit variables
Created WAD reports using Web Application Designer and assigning into portal
Created process Chains
Transported objects from dev to pro using transporter tool in BI using Transport organizer
Creating iviews in WAD and assigning them in portal
User exit coding for variables
Designed custom extractors in R/3 for extracting Planned orders, Purchase requisitions and Demand planning data
Worked on the complex extraction logic for sales information integration with accounting information
SD implementation: worked extensively on sales extractors 2LIS_11_VAHDR, 2LIS_11_VAITM &
2LIS_12_VCHDR,2LIS_12_VCITM and 2LIS_13_VDHDR, 2LIS_13_VDITM & 2LIS_13_VDKON
Implemented 0FI_GL_4 extractors based on BKPF and BSEG tables and to capture accounting document level details enhanced extractor by adding additional fields.
Based on business requirement implemented SAP notes to run data load minute by minute.

Confidential,MA Nov 2006 July 2007 BI Lead
Responsibilities
Involved in the Business meetings to understand the business & requirements.
Coordinating with the functional team to prepare the specifications for the requirements.
Closely associated with Data Modeling and data administration team. Conducted several meetings to discuss the issues with schema design.
Involved in collecting data from Business owners, Business users. Analyze the data for DSS and report generation.
Transporting the Objects from Development to Quality to Production once the testing finished.
Extensively involved in the loadings like Daily, Weekly and Monthly for Deltas
Actively involved in monitoring the Data Extraction from Source Systems into BW
Solved PSA Errors with in time to make available that data for reports
Custom Info cubes Creation, Defining Info cube Data Structures, Assigning Characteristics to Dimensions, Defining Update Rules for Info cubes, Joining of Info cubes

Confidential,El Centro, CA. Feb 2006 Oct 2006 Senior BI Consultant
Responsibilities
Functional Specifications
Technical Specification
Data modeling with other team members
Activation of business content in SAP-R/3 and BW
Creating custom info Objects
Creating info providers (ODS objects, info cubes and multi providers)
Cost center accounting, general ledger and xRPM data sources
Creating generic data sources in SAP-R/3 in HR time & Event management
Creating generic data sources in SAP-R/3 in IS-Utility
Using exit coding in SAP-R/3 to populate the values for the appended fields
Transfer rules and Update rules
Mapping tables to populate the values in info providers using Update rules
Data extraction from SAP-R/3
Flat file data extraction (transactional and master data)
Developing queries, CKFs, RKFs, variables using Business Explorer
Collecting the transportable objects using transport connection tool in BW
Transported the objects from Dev system to Q/A system

Confidential,Michigan Feb 2004 Dec 2005 Senior BI Consultant
Responsibilities
Implementations of BW (ET - 2000)

Phase 1
Warehousing - Created a generic data sources on tables LTAK (WM transfer order header), LTAP (WM transfer order Item), LTBK (transfer requirement header), LTBP (transfer requirement Item). Created ODS for Item level data and Info cube for Header level data.
Purchasing - 2LIS_02_SCL- Created an ODS and Info cube extracted the data from Purchase at schedule line
Created update routines for Ordered Qty, Goods Received Qty, Invoiced Qty and respective Values.
Inventory -2LIS_03_BF- Created a ODS and Info cube, initialized the stock using 2LIS_40_S278.
Extensively involved in Master data loading and transaction loading.
Created number of custom queries, Variables using customer exit and replacement path for MTD & YTD calculations, calculated Key figures, restricted key figures, RRI and structures

Phase 2
Billing - Extracted the Billing at Item level data (2LIS_13_VDITM) into ODS and Info Cube. Manipulated the data in Update routines to match the custom requirements of the client.
Sales - Extracted the data using 2LIS_11_VAITM (Sales at Item level) and created ODS and Info cube.
Shipping - Created Info Cube and extracted to be delivered qty to restrict the size of the Info Cube, using data source 2LIS_12_VCITM.
MultiProviders (Billing, Warranty, Objectives, Historical Data, external data & stock, nonstock)
Designed MultiProviders on Billing, Warranty, and Objectives & Historical Data to produce Parts Statistical Reports, which are to be used extensively by
the Field Account Executives. These reports have replaced the Field laptop Application that was laborious and time consuming.
Warranty - Using DB Connect extracted warranty information on weekly basis from the view created in Business Objects.
Web Reporting - Designed the Web Template. Released multiple queries in single template and assigned them to the roles in PFCG.
Authorizations - Involved in the creation of roles and authorizations.
Production support - Creation of User Ids, assignment of roles and authorizations.
Transports - Extensively did the transport of Objects into Quality & Production using STMS.
Training - Conducted Training for the end Users at the depots.

Phase 3
Pricing Books – Gathering requirements and designing Info Cubes, ODS Objects, Multi Cube for Pricing Books for the parts.
Process Chains - Designed Process Chains for daily extraction of data.
Alpha conversion - Performed Alpha conversion to convert Inconsistent internal characteristic values.
Open Hub - Created Info Spokes for Billing, Warranty, Objectives, Legacy Billing and exported the Data to SAP R/3 to publish the reports to dealers through the existing portal (Parts on Command) which is connected to the source system.
Hierarchies Created Hierarchies for customer, warehouse movements and the data loaded by flat file.
Production Support – Providing production support and attending to extraction problems.

Confidential, FL Jan 2003 Dec 2003 Senior BI Consultant
Responsibilities
Designed and developed ODS, Info cube , Multi cube for Cost Center Plan & Allocations and Statistical Key Figures
Designed and developed ODS and Info cube for General Ledger Profit Center Accounting
Created Custom Cubes and ODS for Sales Order, Delivery and Billing.
Enhancement of Data Sources ( 2LIS_11_VAITM, 2LIS_11_VASCL, 2LIS_12_VDITM & 2LIS_13_VCITM ) .
Extracted Order, Delivery and Billing data using queued delta from R/3 System.
Validated loaded data against R/3 and LIS data target ( S260, S261, S262 ) information.
Created Process Chains for daily delta loads and for clean up operations of PSA.
Created Partitioning, Aggregates and Indexes as a performance tuning measures.
Web Templates Developed queries, Charts & Web Templates for Cost center, Profit center for Product lines like Polyethylene, Polypropylene, Aromatics and Logistics which replaced existing Executive Dash Board.
Created Pre-calculated web templates to improve the query retrieval time, RRI and Exception reporting

Confidential, Ohio Mar 2002 Dec 2002
Senior BI Consultant

Responsibilities
Process Chains - Designed Process Chains for daily extraction of data.
Sales - Extracted the data using 2LIS_11_VAITM (Sales at Item level) and created ODS and Info cube
BOM - Extracted BOM explosion data ( Standard Cost) generically to compare with the selling price.
Worked with the info cubes in SD, MM and FI
Worked with Business content and custom cubes in SD and MM and Inventory. Activated all the data sources in the source system using RSA5.
Designed and developed multiple level ODS objects and cubes in SD and MM areas.
Designed and developed custom cubes in Inventory and loaded data with flat files.
Worked with logistics Cockpit to load the data from Logistics using V3 update concept and bypassed the usage of standard info structures
Appended the extract structures and used the user exit coding to populate the values for the appended fields, using the commercial pricing values instead of exchange rate type in the Inventory values.
Worked with virtual key figures in the query using the user exit coding and replaced the same functionality of the info structures.
Worked with the SPL and COPA cubes in FI.
Designed and developed the data sources for SPL and COPA .
Worked with RRI (Report to Report interface) between ODS object and info cube.
Data handling: Worked with huge volume of data
Developed number of custom Info objects of type characteristics and key figures
Developed number of update routines and transfer routines
Defined number of queries and analyzer objects

Confidential,Mar 2001 Feb 2002 Senior BI Consultant
Responsibilities
Conducted extensive requirement gathering workshops with the users in the area of Logistics areas
Prepared the Blue print, data flow diagrams, and detailed design documents for the BW data providers.
Installed standard business content extractors, Configured Logistics cockpit extractors, developed custom extractors and implemented custom enhancements using customer exists on R/3.
Designed and developed custom extractor and Info provider for COPA and designed complex queries.
Designed and developed data source, Info source and Info Provider for Inventory.
Designed custom extractors in R/3 for extracting Planned orders, Purchase requisitions and Demand planning data.
Designed custom extractors in R/3 for extracting Sales, Shipping & Billing.
Designed and developed custom Info sources, Info cubes, ODS Objects and Multi cubes in the areas of Sales for complex backlog reports.
Designed and developed custom Info sources, Info cubes, ODS Objects and Multi cubes in the areas of Demand Management, PP and MM areas
Implemented custom transformations in the transfer/update rules using formulas and ABAP routines. Improved the load performances by caching the lookup data in start routines using Internal tables.
Designed and developed the Data loading processes using Process Chains and Info packages.
Developed complex Queries using Calculated key figures, Restricted Key figures, formula variables, and Customer Exit variables.
Involved in knowledge transfer and User training.