PROFESSIONAL SUMMARY

• Over 8 years of Extensive Experience in SAP BW/BI 3.5/7.0/7.3
• Experienced in SAP BI/BW full life cycle implementation on various modules and marked experience in configuration and solving of module-level issues in FICO, FI-SL, CO-PA, FI-SL, MM, SD, QM.
• In-depth Understanding of SAP BW 3.x/7.0/7.3 and Net Weaver 2004/7.0/7.3 Architecture with the abilityto design, develop and implement business intelligence solutions to support specific business requirements
• Expertise in BW Extraction, BW Customizing and data modeling, BEX Web based Reporting.
• Worked extensively on SAP functional modules like FI/CO: Accounting, Controlling, Profitability and Business Planning.SD/CRM: Order flow, Customer Analysis, Services, Marketing and FI-AA: Asset accounting, Customer/Vendor Analysis, FI-AR.
• Extensive knowledge of SAP BW/BI components. Adept at creating Info Cubes, Data storage objects, Remote Cubes, Transactional Cubes, Info Source, Info Package, Data Source, Data Marts, Info Objects, Transfer rules, Update rules, transformations and communication structures.
• Worked on Multi Providers, Hierarchies, Routines, Process Chains and Event management.
• Experienced in Extraction, Transformation, and Loading of data into BW constructs PSA, DSO, Cubes and expertise in data extraction procedures for non-SAP systems such as third party systems.
• Expertise in data extraction from Flat files and SAP R/3 SD/MM/FI/CO using standard and generic extractors.
• Expertise at creating data source connections via SAPI, DB Connect and flat files so as to load data into SAP BW system
• Hands on experience in troubleshooting upload failures from source to target.
• Experienced in creating info package to create process chains and scheduling of data loading with Full/Initialization/Delta upload method.
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business needs
• Skilled in implementing Data Warehousing and Business Intelligence solutions.
• Hands on experience in HANA modeling. Created multiple schemas and table definitions. Experience in creating Attribute views, analytical view and calculated views. Experience in applying privileges.
• Experienced in SAP BW on HANAand migrating standard SAP Models to In-memory optimized models and Performance testing.
• Experienced in loading data from tables in HANA Database to BW data marts.
• Strong experience with OLAP reporting in BW. Adept in creating queries with Bex Query Designer and in developing reports and analysis using BEx analyzer.
• Expertise in naming standards, writing modeling guidelines, developing user training material and training users on utilizing, training and administering BW queries.
• Marked experience in generating customized queries using Restricted and calculated key figures, Variables, Conditions, Exceptions and Report Filters.
• Adept at writing ABAP coding for custom extractors, user exits, transfer and update rules.
• Worked on performance tuning by using delta loads, process chains and creating aggregates, carried out day-to-day monitoring, fixing loads etc.
• Hands on experience in Business Objects 3.x/4.0/4.1 and worked on webi,crystal and dash board reports.

SYSTEM PROFICIENCY:

Professional Experience:

Confidential

Role:SAP BW BI Consultant

Environment: SAP BI 7.3, SAP ECC 6.0, Business Objects 4.1,SD,FI-CO,MM,QM,ABAP, BEx query Designer.

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.
• Responsible for developing BI data models and designs, configuring custom and delivered BI content, analyzing BI reporting requirements, developing detailed reporting specifications.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, Infoset, 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 new features of SAP BI security like Analysis authorization.
• Involved in postproduction support activities in monitoring the daily data loads, fix report issues, and reconciliation issues.
• Worked extensively with LO Cockpit structures such as 2LIS 13 VDHDR, 2LIS 03 BX and 2LIS 03 BF.
• Extensively worked in LO-Cockpit Extraction to load sales, purchasing and inventory data.
• Worked on FI - GL, FI-AR, FI- AP, FI- AA, COPA data sources for extraction and loading of data from FI to BW.
• Created many complex and customized SD Order to Cash OTC reports which specific business requirements.
• Extracted data from standard Business Content sales, PO and Inventory extractors and custom-built extractors depending on requirements.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
• Defined Transformations created DTP's and Info package for scheduling loads to data targets.
• Created Process Chains and Meta-Chains for periodic upload of Text data, Master data and Transactional data, and Monitored data loads with full update and delta mechanisms.
• Actualized various types of BEx query variables including User exit, Replacement Path, Text and formula variables. Created calculated and Restricted Key Figures, Structures, Conditions, Filters and Cell Definitions within queries, maintained Query settings and tuning.
• Developed many complex ABAP enhancements like User Exit Functions, ABAP enhancements in ECC Generic Extractions and also in BI data modeling like Start Routines and End Routines.
• Created Aggregates on Info Cubes to improve the query performance.
• Complex Queries in Sales- Billing reports, Delivery reports etc.
• Involved in monitoring the performance of the system and reporting which includes performing OLAP Cache, Aggregates, Indexes, Archiving the non-cumulative info cubes, Partitioning, etc.
• Created intermediate write optimized DSO Structures and APD's in BI7.0 to improve performance while loading AP data.
• Performed performance tuning of queries using indices, aggregates, compression and partition.
• Extensively used Restricted and Calculated Key Figures, Replacement path Variables, Customer Exit Variables , calculations, variables, prompts, sorted inputs, drill down, slice and dice, alerts for creating business objects reports.
• Extensively worked in Business objects reporting, in the context of developing the Universe using the Universe Designer and the Analytics using Xcelsius, WebI and Crystal Reports.
• Created seven new complex BEx queries for Xcelsius Dashboards.

Confidential

Role: SAP BW consultant

Environments: SAP BI 7.3, SAP ECC 6.0,BPS,ABAP, APO, SD, HR, FI-CO, BEx

Responsibilities:

• Involved in Full Life Cycle implementation which includes Gap Analysis, design, development, testing, implementation and support in SAP BW for FI, SD and MM modules.
• Designed functional and technical specifications for implementation of SAP BW 7.3 and implemented BI 4.0.
• Performed data extraction and data staging using LO-Cockpit and extended the structures using user exits to support the business needs.
• OLTP extractions from ECC 6.0 using Generic Extraction, Business content Extraction.
• Created Data Sources via RSO2 in ECC 6.0 for master and transactional data.
• Worked on FI-AP Accounts Payable, FI-AA Asset Accounting, FI-AR Accounts Receivable, CO-OM-CCA Cost Center Accounting, Costs and Allocations.
• Worked on Standard Line Item data source OFI GL 4 General Ledger line item , OFI AR 4 Accounts Receivable AR Line Item , OFI AP 4 Accounts Payable AP Line Item .
• Worked extensively with Administrative Workbench for creating and customizing Info Objects, Info Cubes, DSO, Multi Providers, Info Sources, and applying Transformation rules.
• Developed custom Infocubes for IP Planning.
• Developed custom InfoCubes for General Ledger and Plan data Balance sheet and profit loss , actual and plan data for Profitability Analysis.
• Customized and maintained datasources such as billing, Sales Order and Delivery Order for the SD module and Profitability Analysis Actual Data.
• Configured and involved in troubleshooting custom IP applications using the BEx toolset including BEx Query Designer, BEx Analyzer, and BEx Web Application Designer.
• Worked with ABAP team for creating custom FOX code for planning functions using various program elements of FOX.
• Created variables to parameterize queries, planning functions, filters, and characteristic relationships.
• Worked on evaluating the Bex data using test cases.
• Created reports using BEx Analyzer and WAD that include Plan/Actual revenue comparison, Order and sales value by sales representatives, Vendor delivery efficiency, Incoming Orders, Sales-order stock reporting, Balance sheet and Profit Loss using filters, restricted and calculated Key Figures, variables, formulas, exceptions and conditions.
• Created Delivery, Billing DSO objects and used DSO objects to update Custom Info Cubes.
• Managed and monitored several data loads, captured the errors and corrected the bugs and applied several OSS notes for the errors encountered while loading the data.
• Designed and activated process chain at various levels with varied processes which involves scheduling data in Info Packages, Reading data from PSA and updating corresponding data targets, Activating DSO data from data load, Deleting / Generating Indexes, Deleting requests.
• Involved with performance tuning of queries by maintaining BIA Index, Rollup, compression of Info Cubes and maintenance of OLAP CACHE for specific queries using the reporting agent and transaction RSRT.
• Worked Extensively on BEX Query Designer for creating queries with conditions, exceptions, calculated key figures, variables.
• Created queries using BI reporting variables, navigational attributes using filters and published them to Enterprise Portal.
• Created monthly and Quarterly Breakdowns, Profit Loss Reports.
• Worked on maintaining assigning user authorizations for working on Explorer using T-Code RSDDTPS.
• Involved in support role of maintaining BI system and troubleshoot the user problems and Debugging Extractors / Handling issues.
• Involved in the upgrade of BO XIR3 3.1 to BO 4.0.
• Created BICS Connection using IDT in SAP BI 4.0.
• Developed Webi reports using BICS for generating reports against SAP BW Bex Queries.
• Created multiple Ad-hoc/canned reports using Business Objects Web Intelligence Web I Rich Client published them to enterprise portal.
• Developed WebI reports for Customer aging Data, cost center, internal order and AP/AR accounting.
• Generated reports in WebI by enabling query stripping to enhance the performance by reducing the response time.
• Involved in working with data synchronization options like Merge Dimensions, Extended Merge Dimensions to fetch data from two BEx queries.
• Created Web I reports with Complex Calculations to get Alerts for Xcelsius Dashboards.
• Created crosstab data in WebI and developed the web services URL for the WebI report that can be directly used in the Dashboard Designer.
• Created Analysis reports as per business requirements over Bex queries and Converted Bex Workbooks into Analysis Workbooks using advanced analysis for office.
• Created Dynamic Xcelsius Dashboards using QAAWS, Live Office and BI services.
• Created Xcelsius dashboards over SAP BW query BEx with filters, Label based menus, Flash Variable connections, SWF loader, Tabsets, According menus, List Builder, List Views, Sliders, Fish Eye menu, Play Selectors, Grids Etc.
• Created a dynamic Xcelsius dashboard for stock monitoring and billing.
• Worked on explorer creating information spaces for displaying ad-hoc reports using excel data for end users.
• As a part of Production support involved in monitoring load failures, Delta loads, and monitoring the performance of the system.
• Identified the bottlenecks, operational dependencies and production systems impact through team meetings and coordinated with Project manager and offshore Team to develop an efficient solution.
• Environment: SAPBW NetWeaver7.3, SAP ECC 6.0, SD, MM, FI, BEx, Business Objects XI 3.x /4.0 sp5, QAAWS, WebI, Explorer, Advanced analysis for office and Xcelsius 2008.

Confidential

Role :SAP BIConsultant

Environment: SAP BW 3.5, SAP R/3, SD, MM.

Responsibilities:

• Involved in full life cycle implementation using ASAP methodology which includes Gap Analysis, Requirement gathering, Blue printing, Development, Testing, Reporting, Go-Live and Post Go-Live Support.
• Dealt with standard business content of Sales Overview cube, CRM activity items cube.
• Created, modified and activated Info Areas, Info sets Info-Objects, DSOs, Info-Cubes and Multi-Cubes according to the reporting requirements.
• Wrote ABAP code in Start Routines, Update rules, Transfer Rules and Transformation to update Characteristics and Key Figures in the Info Cubes.
• Extensively worked on the performance tuning tasks including the partitioning the cubes, creating the indexes and aggregates based on the Stats.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to Info-Cubes and ODS.
• Custom extractors were created using ABAP routines.
• Used the Business Content Sales Overview Info Cube 0SD CO3, for overall Sales Analysis. The transaction data is loaded for Sales Order/Delivery using LO-Cock Pit.
• Customized Remote cubes, Multi cubes.
• Integrated BO environment over SAP BI using SAP integration kit.
• Extensively Worked in Defining Complex Bex Queries including Structures, Variables, and Jump Queries in SAP BI 7.0 Environment.
• Extensively involved in monitoring the extractors, data loads and reports before going into production and transporting the BW objects from Development to quality and finally to productions.
• Good knowledge in using Universe Designer over BEx queries and Info cubes to migrate model data from BI to BO for reporting.
• Developed reports using WebI and also designed graphs.
• Defined solid number of Web I reports over the OLAP universes.
• Extensively worked in Business objects reporting in the context of developing the Universe using the Universe Designer Tool and the Analytics using WebI and crystal Reports.
• End to end design and development of Crystal Reports comprising of summary.
• Worked on the WAD Web Application Designer to create specific templates based on the business requirements of the user.
• Environment: SAP Net weaver 04s BI 7.0 , ECC 5.0, CRM 4.0 Business Objects XI 3.1, BEx Query Designer/Analyzer and Web I Reports.

Confidential

Role :Sr SAP BI/BO Consultant

Environment: NW 2004S/BI 7.0/ECC 5.0/CRM 4.0/BO XI 3.1/BEx/MM/SD/FI/CO/PP/HR

Responsibilities:

• As a senior BI/BO consultant, I was involved in a full life cycle implementation in Net weaver 04s BI 7.0 .
• Discussion with functional team to discuss end user requirement.
• Extensively worked on Modeling, Customize Info Cubes, Multi Providers, Start Routines, Business Content, Generic data extraction, Data Loading Full/Delta Up-Load , Scheduling, Monitoring Performance tuning and extracting.
• Installed Business Content for, CRM, HR, Sales and Financial Info Cubes to meet with user requirements.
• Extensively worked on Generation of Data sources, activation of Data Sources, Transferring Master Data to Characteristics and Transaction data from ECC systems to Info Cubes in BI. Responsible for loading Plan/Actual Master data Texts, Attributes and Hierarchies /Transaction data from ECC Data Sources and from Flat Files.
• Extensively worked on customizing CRM data Sources.
• Regarding Logistics Extraction Cockpit, Maintained extract structures for Sales Distribution generated data sources activated the extract structures for the above modules. Scheduled data uploads in cockpit.
• Used the Business Content Sales Overview Info Cube 0SD CO3, for overall Sales Analysis. The transaction data is loaded for Sales Order/Delivery using LO-Cock Pit.
• Extensively involved in Activating Business Content for Standard Info Cubes, and Info Objects of SD and HR-Payroll Modules as per the Client Requirements.
• Modified existing queries on various Info Cubes related to SD and HR-Payroll. Extensively worked on Query building, Filtering, Free Characteristics, Restricted Key Figures and Variables, Query variants using BEx Analyzer.
• Extensively worked on BO XI 3.1 for reporting purposes.
• Designed Dynamic dashboards using Xcelsius Enterprise over SAP BI 7.0.
• Designed and Developed BO reports for Budget Input Application using Webi.
• Worked with BEx to generate Queries and embedding them into Workbooks and also published the queries onto the web using Free Characteristics, RRI-Jump Queries, Calculated and Restricted Key figures, Filters, Variables and Exceptions.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as IViews.
• Worked with BEx Broadcaster to schedule monthly sales reports as e-mail to the users.
• Build Transactional and Master Process Chains for periodic upload of data.

Confidential

Role :SAP BW/BI Consultant

Environments:SAP BW 3.5, SAP R/3, SD, MM

Responsibilities:

• 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.
• Worked on ETL Extraction, transformation and loading activities like Extraction from Source system, Transformation rules, Data Transfer Process DTP , Open Hub service etc.
• Extracted data from the finance modules like AR, AP and GL and enhanced the standard data sources 0FI AP 04, 0FI AR 04 to meet the client requirement.
• Loading of transaction data to the business content Info Cube from Info Sources like 2LIS 11 VASCL, 2LIS 11VAHDR for sales, 2LIS 13 VDHDR, 2LIS 13 VDITM for billing, 2LIS 12 VCHDR for order.
• Designed, built, tested, documented, and maintained data extractors, transformations, DTPs, process chains, DSO Objects, Info cubes, and Multi-Cubes coding in start routines and end routines.
• 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.
• Used ABAP code to write start routines, update routines, end routines in transformations to facilitate reports for Purchase Price Variance, Inventory Accuracy.
• 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.
• Developed flexible queries using filters and navigational attributes in BEx Analyzer to facilitate data analysis in a drill down or summarized fashion and also created Calculated and Restricted Key Figures, Structures, Conditions and Cell Definitions within queries, maintained Query settings and tuning wherever necessary.
• Created new Universes and fine-tuned existing ones by resolving join problems, setting up aggregate awareness, defining hierarchies, cascading LOV, Functions and more.
• Created reports, cross-tab reports using Webi rich client by utilizing prompts, alerteretc and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• 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.
• Extensively used the wizard in WAD and published the reports on Enterprise Portal as iView.
• Performed extensive unit testing in the development environment for all the objects created.
• Worked with the security team in designing the security strategies for global front end reports and workbooks.

Confidential

Responsibilities:

• Expertise in solving tickets related to various BW areas viz. Extraction/Data Loadings, reports and data validations of BW against source data.
• Expertise in implementing various tasks to add value to business.
• Worked on Inventory cubes for business content DS. Analyzed the requirements to implement Snapshot scenario for cumulative key figures. Worked on 2LIS 03 BX and 2LIS 03 BF Data Sources.
• Provided complete solution in BW in the following metrics analytics: Material and Production Planning, Sales and Distribution SD , Delivery, Inventory Stock and Goods Movement, Billing.
• Involved in complex query building using customer exits, SAP exits, and pre-calculated value sets, restricted key figures, calculated key figures.
• Extensive experience in enhancing the whole data model viz. Data source, Info Source, Info Cube and other Objects.
• Good acumen in solving data load problems.
• Performed Currency conversion update and Unit conversion update on monthly basis.
• Prepared Technical, Functional and Component specifications documents as per the business requirements.
• Installed standard business content for PP ,MM module and customized the reports according to user requirements.
• Worked Extensively in BEx Analyzer Query Designer in building Queries, saving it in Workbooks Excel workbook .Created Standard/ Custom queries using Bex Query Designer and WAD, created Calculated Key Figures, Restricted Key Figures, Structures, Variables, Exceptions, Conditions.
• Developed web reports using web items also designed graphs.
• Developed project summary, project activity and committed cost reports using query designer and web application designer WAD based on WBS elements and published them on BI Portals.

Confidential

Responsibilities:

• Installed the Business Content as well as created Info sources, Info objects, Info cubes, ODS Objects, Transfer/update rule process chains.
• Designed Info cubes with daily and Monthly Granularity, extraction from PSA.
• Setup Flat file extraction for legacy data, Assigning Data Sources to the Info Source, Defining Transfer Structure, and Metadata maintenance for the Info Source and Source system. Configuring Metadata in the Administration Workbench for replication and Updating of Data Source from the source system.
• Designed and implemented data migration from Legacy system to SAP R/3 using BDC.
• Developed routines to implement complex pricing requirements not handled by standard SAP.
• Work included studying the source data in external system and subsequently identifying and mapping the corresponding Transaction, Programs, Screens and Fields in the SAP system.
• Created required data elements and also created indexes for performance.
• Also created Maintenance Screens for Updating Data.
• Developed a BDC to upload the Sales order details from the Flat file which has the Structure like Header, Customer and Item details by using Session method.
• Modified an enhancement with automatically updates parts on the concerned equipment master when serialized parts used on a service Order are confirmed.
• Modified an Interface program using BAPI required to create or update SAP master and classification data for all the equipments created from IKE-configuration stating tables.
• Developed an Inbound Interface that receives customer-related data from legacy systems and posts it to the customer table in SAP using custom IDOC.
• Worked on testing of user defined reports, dialog programs and BDC screens while transferring data from legacy systems to SAP.