Summary

• Over 8 years of experience in development, design and implementation of business applications which includes 7 years of SAP BI 3.5/7.0 and 1 years of Business Objects XI 3.1.
• Modeling Planning Applications using SAP BI Integrated Planning.
• Implemented 3 full life cycle BI projects for FI/CO, PSM, FM BCS, SD, HR, MM modules.
• Followed and implemented ASAP Methodologies which involves Blue Printing, Realization, Data extraction, Data modeling, data loading, Production Support, Testing, Documentation, Requirement analysis, End User documentation and Reporting.
• Involved in migration process from BW 3.5 to BI 7.0. Strong Knowledge in BW Upgrades to BI 7.0/2004s.
• Extensively built InfoObjects, InfoSources, InfoPackages, ODS, InfoCubes, Data Transfer Process, Start and End routines using data warehouse workbench.
• Performed extensive CO-PA, LIS, LO Cockpit and Generic Data Extractions.
• Configured and implemented BW reporting using BEx Analyzer/Browser. Published queries to web portals through Web Analyzer. Proficient in Query Designer, Web Application Designer, InfoSet Queries.
• Expertise in using Universe Designer over BEx queries and Info Cubes to migrate & model data from BI to BO for reporting. Excellent skills to develop reports using WEB I. Valuable knowledge of Crystal Reports.
• Proficient in Performance Tuning techniques such as Aggregates, Rollups, Indexes, Partitions and Info-Cube Compression techniques.
• Knowledge of BW security and authorizations.
• Worked extensively on distributing reports with SAP Information Broadcaster.
• Performed Pre/Post upgrade BW scripts when migrating from 3.0 to SAP NW 04\'s.
• Conducted training for end-users. Developed business process documentation.
• Strong planner and organizer with demonstrated ability to master new concepts quickly, incorporate the latest technology, and develop business solutions that increase efficiency, productivity, and profitability.
• Excellent communication, presentation, and interpersonal skills.

Technical Skills:

• Data Warehousing: SAP Net weaver 2004s BI 7.0, BW 3.X
• ERP Packages: SAP ECC 6.0, 5.0, R/3 4.7
• SAP Modules: SAP FI-CO, SD, PS and PP.
• Reporting Tools: BEx Analyzer, Crystal reports, Xcelsius 2008, Business Objects Explorer, MS Excel.
• Web Technologies: HTML, DHTML, XML, CSS.
• Programming Languages: C, C++, JAVA, MySQL, PL/SQL, Python
• Application Software: Flash, Adobe works, MS-Office Suite, Dreamweaver.
• Operating Systems: Windows 95/98/NT/2000/XP/Vista, Windows 2003 Server, MS- DOS.

Professional Experience:

Confidential,Atlanta, GA Jan 2011 – Till Present
Role: SAP BI/BW Consultant
Environment: SAP BI 7.0, ECC 6.0, BO XI 3.1, Web Intelligence, Xcelsius.

Responsibilities:

• Involved in Full Life Cycle Implementation followed by an up-gradation of clients present SAP BW 3.5 to BI 7.0 Net Weaver 2004s and Performance analysis.
• Designed the New Queries and Modified the Existing Queries (SAP BI 7.0) according to requirements and generated reports.
• Analysis of Reporting Requirements and Translation of these requirements into Multi-Dimensional Data Models using Star-Schema and Extended Star-Schema Data Modeling Techniques, with an emphasis on actual implementation in BI.
• Developed DSO objects to load Sales Order Data from the Data Source. Loaded Transactional Data into PSA and updated Data from PSA to DSO and Activated DSO Data for Reporting and Analysis.
• Interacted with the Management and Business End-Users to identify business requirements and actively involved in implementing ASAP methodology.
• Closely worked with APO team to Extract Data from APO into BI.
• Extensively documented BI Reporting and Data Requirements.
• Extensively involved in Data Extraction from Non-SAP and SAP Systems.
• Participated in Strategic Customer Meetings to review and evaluate new technical challenges that are required to improve operating efficiencies.
• Handled Performance Tuning of queries using Aggregates, Table Partitioning and Indexing of Info Cubes.
• Responsible for customizing and activating the Business Content Objects and loading the data into DSO and Info Cubes.
• Uploaded Master Data and Transactional Data to BI System.
• Used BEx Analyzer to Create Queries with Variables, Filters, Calculated Key Figures, Restricted Key Figures, Exceptions, Conditions with Charts and Worksheets to access data from BI Info Providers to Generate Reports
• Design and developed query based and Info Provider based Universe and WebI Reports.
• Reporting designed and developed using BI query designer.
• Developed Test Packages to ensure the stability of objects before and after the upgrade.
• Generated Web-I Reports using the Universe as the main Data provider and also using the personal data files provided by the users. Designed Universes for Financial billing system, Order processing and Supply chain planning.
• Build the New universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Xcelsius 2008 installed in client system as well as Development server and Production App server.
• Performance testing developed in all the application servers.
• Business user Training and Best practice developed for the client BOBJ and BI Universe, Info View, Xcelsius 2008 and QAAWS (Query as a Web Service).

Confidential,Bellevue, WA July 2009 – Nov 2010
Role: SAP BI SME
Environment: SAP BI 7.0, ECC 6.0, BO XI 3.1, Web Intelligence, and Xcelsius.

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting, Go-live and Post Go-live support.
• Understanding the business challenges and translating them into requirements and developed Analytics and Reporting Queries according to Business Requirements.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, MultiProviders, Info Sources, Info sets, Time dependent master data and also in ETL (Extraction, Transformation and Loading) activities like Extraction from Source system, Transformation rules, Data Transfer Process (DTP), Open Hub service etc. Also involved in new features of SAP BI security like Analysis authorization.
• Worked extensively on Profit Center Accounting data sources such as 0EC_PCA_1, 0EC_PCA_2.
• Implemented FI cubes such as 0FIAR_C02, 0FIAR_C03, 0FIAP_C03, and ODS such as 0FIAR_O03, and 0FIAP_O03 with proper transfer rules and update rules.
• Designed functional and Technical specifications for Implementation and Development of BO XI 3.1 over SAP BI.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC-BI CMOD, Generic Extractions and also in BI data modeling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve the query performance.
• Created BEx queries for reporting on Info Cubes, Info Sets, ODS and Multi Provider.
• Responsible for developing Analytical Reports with multiple parameter fields, multiple expressions and multiple grouping for hierarchy levels and published them using the Business Objects Enterprise XI.
• Created universes, classes and objects by retrieving the data from data sources like BW queries and defining necessary connections.
• Involved in the migration and deployment of the universes and reports across multiple domains.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Extensively Worked in Live Office to create connections between WEBI and Xcelcius Dashboards.
• Created (Master/Detail, Cross tab, Chart templates) reports using Crystal Reports.
• Performed unit testing, system integration testing, and user acceptance testing of Crystal Reports at various levels.

Confidential,Pittsburgh, PA Sept 2007 – May 2009
Role: SAP BW Lead
Environment: SAP BI 7.0, BW 3.5, ECC 6.0.

Responsibilities:

• Migrating Data Sources from BW 3.5 to BI 7.0 and maintaining Transformations and DTP’s.
• Performed GAP analysis and Requirement gathering.
• Familiar with new naming terminologies used in BI 7.0.
• Created Info Cube, Data Source, Data Store, Info Package and Transformation.
• Data extraction involving LO, AP, AR, SL and COPA critical objects and data modeling in BW.
• Involved in the design, development and extraction of the data from R/3 system and flat files in to BW system from SD and MM modules using LO Cockpit extraction methods
• Analyzed the Info Cubes and ODS objects to meet the reporting needs of the client.
• Experience in the creation of the setup tables for the LO Cockpit extraction.
• Created process chains for periodic upload of the master data as well as the transactional data.
• Extracted Production (PP) and Process Orders (PP-PI) to analyze manufacturing orders.
• Extracted data from MM inventory (material management- 2LIS_03_BF data sources), and PP (Production Planning and controlling) modules and compared with POS-DM data.
• Creating setup tables using 0LI7BW based on the document range for the LO-Cockpit extraction, performing V3 update using LBWE to get the data from the outbound queue of the R/3 system to the delta queue of the BW system.
• Performed LO-Cockpit extraction to pull data from R/3 SD modules into BW system extracting the Header and Line item data from the Sales and Distribution (SD) module (Sales Order “LIS_11_VAHDR/VAITM”, Shipping/Delivery“2LIS_12_VCHDR/VCITM”, and Billing “2LIS_13_VDHDR/VDITM”).
• Created query “Open Manufacturing Orders” that shows the status of orders that are finally delivered and to analyze target quantities.
• Created reports like confirmed quantity and item purchase orders as requested, complete purchase order quantities delivered and purchase order values.
• Involved in the monitoring data transfers from source systems into BW using PSA
• Developed reports on the MM cubes to check the price variance for materials from different vendors.
• Created reports on SD cubes for displaying sales figures and incoming orders
• Experience in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Involved in the creation of the dash boards for sales, purchasing and delivery using Web Application Designer.
• Performance tuning of queries using Aggregates, Table Partitioning, Indexing of Info Cubes.
• Used the APD (Analysis Process Designer) feature in BI to perform several look ups to tie the transaction data to specific master data attributes.

Confidential,Holland, MI Jan 2006 – Aug 2007 Role: SAP BW consultant

Description: Haworth, Inc. is a global leader in the design and manufacture of office furniture and organic workspaces, including raised access floors, moveable walls, systems furniture, seating, storage and wood case goods. Haworth serves markets in more than 120 countries through a global network of 600 dealers. The company had net sales of US$1.65 billion in 2008.

Responsibilities:

• Experienced in BI implementation lifecycle from requirements gathering, solution design, architecture, readiness assessment, customization, and rollout.
• Applied and implemented ASAP Methodologies(Project Preparation, Business Blueprint phase, Realization, Final Preparation, Go-live and Support).
• Extensively Worked on SAP NW2004s BI (Transformations & Data Transfer Process).
• Good functional knowledge of PP, PS, and FI of SAP R/3.
• Involved in Managing of Info Cubes, which involves Info Cube Content, Performance issues like Indexes, and Compression of Info Cube, Creation and Rolling up the data to the Aggregates.
• Extensively worked in Business Intelligence Info Cubes, DSO Objects, InfoSources, InfoObjects, Transformations, Extractors, InfoSources, InfoPackages, DataSources, Data Extraction, Characteristics and Key figures, Business Content, Process Chains, specific to SD, PP, PS, FI/CO and MIS.
• Expertise in creating Reports & Using Query Designer.
• Expertise in creation of BEx Analyzer Queries, Workbooks, structures, variables, Calculated Key Figures, Restricted Key Figures, and RRI reporting.
• Involved in Business Content Activation, Enhancement of data sources and writing user exits (Master data and transaction data) on R/3 and BI.
• Extensively involved in setting up of procedures for extracting data from SAP R3 by using Generic Extraction and Customizing LO Cockpit by using enhancements and writing User-Exit programs as per requirements.
• Created Process chains for Master data and transaction data loads.
• Gathered reporting requirements and designed the data flow from SAP R/3 to BW for specific functional areas like, FI-CO, PP, SD and PS.
• Uploaded master and transactional data from flat files, SAP BW and SAP R/3.
• Collaborated with the Security team to translate business requirements into BI Security roles & thorough understanding of the Roles & Templates provided by SAP in building the security in SAP BI system.
• Create variables for BW Queries.
• Error Debugging and rectification, solving issues, problems faced during data uploads.
• Involved in the preparation of End User Training documentation.
• Knowledge on Remodeling and Repartitioning of info cube.
• Develop Routines as per Functional Requirement.
• Data cleansing in PSA, Error handling using PSA.

Confidential,Detroit, MI Jun 2004 – Nov 2005
Role: SAP BW consultant
Environment: SAP BW 3.5, SD, PP, FI and MM.

Responsibilities:

• Created an Interactive Report for displaying Vendor Information based on the selection made by the corresponding Vendor Bank Details.
• Maintenance of various Data Object definitions like Tables, Data Elements, Domains. Transfer data from Legacy to SAP using SQL queries.
• Provided post Go-Live support to users, helped users in solving their problems in live environment.
• Involved in Debugging using ABAP debugger, runtime Debugging Analysis, solving problems, including research, driving to Root Cause, and creating efficient solutions.
• Developed Data Dictionary Objects such as user-defined tables, Data elements and Data structures.
• Developed an Audit report, which is required to show all the changes made in the approval tables with details related to the changes.
• Created an interactive report, which lists the customer details in the basic list.
• Created an interactive report to display Sales Order data.
• Modified standard purchase order layout set and its corresponding print program as per customer requirements.
• Modified layout out set of Sales order and the corresponding print program as per the requirements.
• Supported Users and modified the changes as required.