SUMMARY

• 12years of experience in SAP BI/BW and 3+ years in Business Objects environment including 1+ years of experience inSAP America.
• Extensive experience in development and implementation & leading of BI solutions from BW 1.2 to 7.0 and implemented several full life cycle BI projects involvingFI, CO - PA, SD, MM, HR areas.
• Involved in complete life cycle implementation of BI/ BO and experienced in SAP BI/ BOBJ integration&complete life cycle implementation of BI/BPC.
• Installed and Configured SAP Business Objects Enterprise XI 3.1, and Business Objects XI 3.1
• Worked with BOBJ 4.0,BI 4.1,BW7.3, and Enterprise Portal 4.0.
• Expertise in Business Objects Products (Designer, Desktop Intelligence, Web Intelligence, Info View& CMC).
• Experience inDesigning Universes, WebI Reports,and CrystalReports &Xcelciusdashboards.
• CreatedXcelsiusdashboards with data fromLive Office,QaaWS& Excel Files.
• Sound experience in gathering business requirements,gap analysisandfinalizing functional/technical specificationsandblueprint design/realization.
• In Depth knowledge of BI/BW 7.0 in areas like Data Warehousing Workbench,Data Store Objects,Info Cubes, Transformations(Start Routine, End Routine), PSA, Info Package, DTPandProcess Chains, TransportsOrganizer,Remote Cubes, MultiProviders, Data MartandOpen Hub Service.Enhanced extract structures inLO-Cockpit, COPA, FIwhich involves maintaining the extract structures, data sources, activating updates and Controlling V3 updates.
• Experienced in ABAP coding forGeneric data extractors, Customer exits, SAP Enhancements, user exit variables & Transformations.
• 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 files,and usingDB Connect&UD connectData Sources for Third party systems like SQL server from third party systems.
• Definedauthorizations, roles anduser access.
• Experiencedin query performance optimization which involved creation and maintenanceof aggregates, Indexes, Statistics and Cachingdata. Also usedBI Accelerator indexes.
• Worked extensively inBExin building complex Queries, saving it in Workbooks, along with WebReport publishing.
• 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.
• Conducted workshops and presentations to validate business requirements and solutions with the end user community, Developed business process documentation.
• Conducted training sessions for users inBExAnalyzer and also for creating queries for power users.
• Experienced in use of ASAP Methodology for BW project plans. Excellent analytical and problem Solving skills.
• Quick learning capacity and positive attitude towards new challenges.

TECHNICAL SKILLS

Data Warehouse: SAPBI 7.0, SAP BW 3.5 (SD, MM, HR, PP, FICO, COPA),Business Objects, BW 7.3

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

Database: Oracle 9i, Microsoft SQL Server, Access

Tools: Crystal Reports 2008, Xcelsius 2008, Microsoft Office, Live office, Explorer, Data Services, EP 4.0, Design Studio 1.2

Operating System: Windows, Unix/Linux

PROFESSIONAL EXPERIENCE

Confidential

BW/BOBJ Lead

Responsibilities:

• Designed Reporting Strategy forGlobal Implementation of Finance reporting
• Assisting the client for best tool selection
• Recommending best practices for BW & BOBJ implementation
• Designing the architecture for BW & BOBJ
• Driving the reporting needs from Business users
• Managed the development & testing activitiesas Onshore &Off shore lead
• Project Management using Microsoft projects&At Taskto manage development activities and resource management
• Trained the users in using Design Studio 1.2 & WebI reports
• Developed complexcustomsolutions on design studio using custom code
• Worked with SAP Tickets to resolve Design Studio issues and drive solution for work around in passing parameters from Cross tab to Webi report for RRI
• Designed &Developed Complex Design Studio Dashboards& WebI reports for FinanceFI-Gl, FI-SL,COPA& Sales
• Involved in Sizing and Architecture for BW server, Data and reporting analysis and Modeling for BW Extended Star Schema
• Supported Business Post - GO live with Month end, QuarterEnd and Year End. Worked onAgile Releases and Managed Contractors for Monthly releases

Confidential

BW/BOBJLead

Responsibilities:

• Designing the reporting strategy for SAP PBF Implementation
• Designing the architecture for BW & BOBJ
• Working with end users & functional team to gather reporting requirements
• Recommending best practices for BW & BOBJ implementation
• Assisting the client for best tool selection
• Managing both on shore & off shore developers
• Assisting the client in BI 4.0 Installation, Integration, Roles, Security & Authorizations
• Testing the Data Loads for Master Data(Attributes, Texts & Hierarchies)
• Testing the Data Loads for Transactional Data
• Developed the Blue Print, Functional Specifications
• Worked with the Business, Stake Holders on GAP Analysis
• Identified the reports needed for PBF implementation
• Identified the Sources needed for reporting
• Assisting the client in preparing reports to communicate project progress and status.
• Identifies problems and escalates to management
• Designing the reporting strategy for FI & HR.
• Define& design reporting plan from scratch, ensuring all reports are intuitive, accurate and fast
• Working with end users & functional team to gather reporting requirements
• Managed a team of 5 developers on shore & off shore.
• Implementation of BOBJ 4.1, Dashboards 6.0.5.0 & BI Launch Pad 14.0.5
• Performance tuning of BW Backend & BW Front end
• Mentors staff to overcome limitations and achieve maximum potential.
• Assigns/distributes resources for perpetual task and specific project needs
• Reviews status reports of team members across projects and addresses issues as appropriate
• Works with Director on budget forecasts and preparation
• Worked with client leads on HANA POC for Budgeting & Finance reporting
• Designed and Developed Attribute, Analytical & Calculation views for Funds & FI data
• Designed and developed BW Transient Info provider on top of HANA Views.
• Implemented HANA security by developing Analytical Privileges on Calculation views
• Tested Hierarchy loads for Attribute views

Confidential, NY

BI/ BOBJ Solution Architect

Responsibilities:

• Designed the data flow and the architecture for Spend Analytics.
• Proposed Reporting Strategy for Spend Analytics reporting
• Analyzing the current Architecture and proposed changes for Reporting and resolved performance issues
• Developed & tested the required DSO's, Cube's & Multi-providers.
• Extracted data by using DB connect to get data from external databases.
• Extracted data from oracle views using DB Connect.
• The purpose is to create Federal & State reports whichwill be sent to Federal & State governments respectively.
• Designed and validated 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.
• Designed complexBExqueries using Variables, Replacement path
• Designed universes, WEBI & Crystal reports on top ofBExqueries.
• Worked with BI 7.0 and EP 4.0
• Implemented Business Objects 4.0, from Patch 2.1 to Patch 2.6.
• Responsible for Creating/Enhancing BOBJ Universes using BWBExQueries, retrieving data from Universes and Creating Complex, Multi-dimensional and Ad-Hoc reports according to client's requirements using, Web Intelligence (WEBI).
• Worked with SAP in fixing the issues with BICS connectivity
• Performance tuning of reports(Web I, Crystal)

Confidential - San Francisco, CA

BI Solution Architect

Responsibilities:

• Extensively Worked on SAP ECC Extraction of Financial data, CO-PA and Sales & Distribution Lo-Cockpit.
• Worked on Data Modeling, 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
• Worked with BI 7.3 and BI 4.0 for publishing BI Dashboards
• 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
• Tested theBExQueries, Universes, dash boards using unit testing and integration testing
• Designedand developed the architecture for Cost Center Accounting Module.

Confidential - Chicago, IL

BI Lead Architect

Responsibilities:

• Designed and developed the architecture for Cost Center Accounting Module.
• Proposed the BI Roadmap & strategy for BW/BOBJ reporting.
• Worked on FI-GL, FI-AP,FI-AR.
• Created multipledata storeconfigurations (Dev, QA, and Prod) on every sourcedata storeso 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 FI Dashboards and published in to enterprise portal 4.0
• Created Generic Data Source for COPA - Account Based, based on the functional requirement.
• Created DSOs and otherInfo ProvidersforCOPA Data.
• Enhanced 0FI Gl 4 extractor and built custom DSOs for Balance sheet & P&L.
• Built reports on COPA, Balance sheet & Profit Statement.
• Created a Multi Provider on COPA & FIInfo Providers.
• Extracted data from Material Classification Data Sources.
• Transported Objects to QA, loaded data and validated. Moved to Production System and validated the Data.
• Created Process Chains for scheduling FI & COPA data loading.
• Responsible for the validation of workflow.
• Tested theBExQueries, Universes, dash boardsusing unit testing and integration testing.
• Involved in design & development of dashboards usingXcelsius, Universe Designer,QaaWS& WebI with BW as Data Source

Confidential - Long Island, NY

BI Solution Architect

Responsibilities:

• Involved in all phases of BI BPC integration.
• Involved in Gathering Functional and Technical requirements for SAP BI BPC Implementation.
• Gathered Functional requirements and developed business blueprint for BI BO Implementation.
• Worked on SD, MM,FIModules.
• Extraction of data from 0FI GL 12, 0FI GL 10 into BI and exporting the data to BPC using Process Chains and Function Modules.
• Extracted FI Masterdatainto BI and exported to BPC.
• Mapping ofInfo Objectsfrom BI to Dimensions in BPC using transformations.
• Created Process Chains for Automation of Master Data & Transactional Data loading into BPC.
• Created Inventory reserve report by using a generic data source on MBEW as per the business requirements.
• Worked on setup of LO Cockpit for sales data and extraction 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 for scheduling data loads.
• Created queries on FI, SD, MM data usingBEx.

Confidential - Lynchburg, VA

BI/BO Architect/ Lead

Responsibilities:

• Involved in all the phases of BOBJ implementation and SAP BI/BO Integration.
• Guided the Installation and configuration of Server/Clientcomponents 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.
• 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 inBExanalyzer 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 utilizingBExfunctionality.
• Created reports inBExQuery 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

Confidential - Philadelphia, PA

Sr. BI Consultant

Responsibilities:

• Analyzed the SAP BIW Business Content required, activated 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 datasources,and workedwith tables and function modules for these data sources.
• Managed and monitored severaldata loads with millions of records.
• Optimized loadperformance 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 VisualComposer creatediView'sand 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

Sr. BI Consultant

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, DataSources, 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 InfoCube using Data Sources.
• Developed and maintained the Info Cubes, ODS objects,Info Setsand Multi-providers.
• Created ABAP routines in transfer rules and update rules.
• Created Multi cubes 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 usingBExAnalyzer, 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 specificFunctional 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 deliverableswithin 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-SAPsystems andflat files and monitored Process Chains to run periodic loads.

Confidential - St.Louis, MO

Sr. BIConsultant

Responsibilities:

• 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 and scheduled daily and monthly data loads.
• Transported objects fromdevto pro using transporter tool in BI using Transport organizer
• Creatediviewsin WAD and assigned them in portal.
• Created User exit variables based on time period.
• Designed custom extractors in R/3 for extractingplannedorders, 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, 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 - Boston, MA

Senior BI Consultant

Responsibilities:

• Involved in the Business meetings to understand the business & requirements.
• Coordinated 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.
• Transported 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 fromSource Systems into BW.
• Solved PSA Errors with in time to make available that data for reports.
• Worked on 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

Senior BI Consultant

Responsibilities:

• Created Functional Specifications & Technical Specifications for Data Modeling.
• Activation of business content in SAP-R/3 and BW.
• Createdcustom info Objects andInfo Providers(ODS objects, info cubes and multi providers).
• Worked on Cost center accounting, general ledger and xRPM data sources.
• Created generic data sources in SAP-R/3 in HR time & Event management, & IS-Utility.
• Did user exitcoding in SAP-R/3 to populate the values for the appended fields.
• Created 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 - Detroit, Michigan

Senior BI Consultant

Responsibilities:

• 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 Qtyand 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 deliveredqtyto restrict the size of the Info Cube, using data source 2LIS 12 VCITM.
• 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 replacing 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 and assigning to users.
• Extensively did the transport of Objects into Quality & Production using STMS.
• Pricing Books - Gathering requirements and designing Info Cubes,ODSObjects, Multi Cube for Pricing Books for the parts.
• Designed Process Chains for daily extraction of data.
• Performed Alpha conversion to convert Inconsistent internal characteristic values.
• Open Hub -Created Info Spokes for Billing, Warranty, Objectives,LegacyBilling 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.
• 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

Sr. BI Consultant

Responsibilities:

• Designed and developed ODS, InfoCube,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 cleanup 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, Aurora, Ohio

Sr. 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 BOMexplosion data(StandardCost) 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 datafrom 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 andCOPA.
• 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 routinesand transfer routines.
• Defined number of queries and analyzer objects.

Confidential - Elkhart, IN

BI Analyst

Responsibilities:

• Conducted extensive requirement gathering workshops with the users in the area of Logistics.
• 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,ODSObjects and Multi cubes in the areas of Sales for complex backlog reports.
• Designed and developed custom Info sources, Info cubes,ODSObjects 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 usinginternaltables.
• 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.