SUMMARY

• 9+ years of extensive experience as a SAP BI/BW (7.5,7.4,7.3, 7.0, 3.5, 3.1C, 3.0B) and BO (Xi3.1, 4.0,4.1,4.2) consultant, which includes experience in SAP HANA as a techno - functional consultant playing various key roles in Design, development, Production support and reporting techniques across modules S4 HANA,FI/CO,IP, CRM,HR,SCM, SD, PP, MM,CPM, WM and Vistex.
• Expertise in implementing 3 Complete Life-Cycle Implementation of SAP BW/BI which dealt with Blue Print, Realization, Data Modeling, Data Extraction, Data Loading (Full / Delta Up-loads), Scheduling, Monitoring, support packs implementation, BEx Analyzer, Query Designer, Web Applications Designer, Testing, Go Live & Production support, End user documentation and 1 full life cycle implementation of BO XI 3.x and BI 4.1,4.2.
• Identified the issues and troubleshoot them during the Migration of 7.3 to 7.5. Also Migrated the BW to HEC from on premises.
• Extensively worked on FI-GL, LO Cockpit, CO-PA,Generic Data Source, DB Connect customization and extraction.Extensively worked on Vistex datadources customization and extraction.
• Expertise in creating designs of custom extractors for modules like CRM, SD, MM, PP, Vistex and FICO using ABAP.
• Solid experience on BW 7.5 and its new features like Hybrid Providers, Advanced DSO, Composite Provider, HANA Views, HANA Optimized Cubes.
• Solid experience in construction of customized Info Objects, Basis Info Cubes, Remote Cubes, Transactional Cubes, Virtual cubes, Multi Providers, Info sets, ODS/DSO objects, Advanced DSO and Composite Provider.
• Expertise in Transformations, DTPs, Update rules. Transfer Rules, Hierarchies, Routines, and Process Chains.
• Experience in SAP HANA development, migration, optimization and support for mixed approach with Native and SAP BW on Hana solutions.
• Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Expertise in publishing queries to web portals through Web Analyzer.
• Expertise in Business Objects 4.2/4.1/4.0/XI 3.1/3.0/XI R2 (Designer, CCM, CMC, Info View, BI Launchpad, Desktop Intelligence, Web Intelligence, Xcelcius 2008 (Dashboards), Crystal Reports, Universe design tool, Information design tool, Live office, Advance analysis edition for office/OLAP, Design studio, QAAWS).
• Experience in Creating Universes (.UNX and .UNV) and Connections (Universe connections and BICS connections) using Business Objects Universe Design Tool, Information Design tool(IDT) for Web Intelligence (WebI) query and report making by connecting through BEx queries.
• Expertise in creating Xcelsius Dashboards by using Selectors, Filter Rows, According Menu, Check Boxes, List Builder, List view, Single Values, Maps, Charts, Dynamic Visibility, Alerts.
• Hands-on experience with Advanced Analysis Office edition, created Analysis reports over BEx queries and Converted BEx Workbooks into Analysis Workbooks.
• Expertise in Business Objects BI 4.2 Advanced Analysis edition for OLAP connected to a BW OLAP connection.
• Expertise in working on design studio creating dashboards using various components such as background Filters, cascading filters, Filter Panel, creating score cards using pop up window & apply flexible formatting using components such as images, hyperlinks etc.
• Strong experience in the integration of BODS with SAP modules and Non-SAP data sources.
• Experience in using BODS as an external system for ETL between ECC and BI.
• Strong experience in cleansing the data using Data Quality transforms, Creating Work flows, Data flows, Abap data flows, File Formats, Scripts and Data stores.
• Wide experience in interacting with end-users to gather and document the reporting requirements and givingtraining to the end users. Identified and defined problems, evaluated alternatives and implemented effective solutions.
• Excellent analytical, time management, interpersonal skills and a good team player with excellent oral and written communication skills.

PROFESSIONAL EXPERIENCE

Confidential, Indianapolis, IN

SAP BI/BO HANA Consultant

Responsibilities:

• Excellent in documenting Business Requirements, Technical Designs, Unit Test plans, System Test plans, User Acceptance test plans and User Training manuals.
• Built SAP Business Objects BI 4.2 clustered environment infrastructure with SSO using LDAP authentication.
• Installed and Configured Business Objects BI 4.1/4.2 Server Installations on UNIX/AIX 7.1.
• Designed XI3.1/BI4.1/4.2 enterprise security across various environments.
• Created PDF reports and scheduled to generate PDF's every week.
• Participated in meetings, reviews, and user group discussions as well as communicating with business groups.
• Developed Reports using WEBI against SAP (Universe & OLAP connection) and non-SAP data sources.
• Developed several Crystal Reports in an Oracle server environment utilizing complex functions and sub reports to evaluate business processes
• Evaluated and Developed Reports using SAP Lumira.
• Work with the Business management to ensure Business Objects are appropriately utilized for all required management and adhoc reporting, as well as data extracts for shared data agreements.
• Followed Business Objects best practices and methodologies in scaling and configuring the cluster environment. Evaluate system capacity to meet near- and long-term processing requirements.
• Interact with Business users and project stake holders in planning content upgrade/migration using SDLC guidelines.
• Setting up planning structures and looking at modeling aspects of Integrated Planning(IP).
• Customized planning functions for integration with Web tools and WebDynPro programs
• Setup a planning query that is ready for input using the BEx Query Designer
• Designed and Tested planning functions via Planning Sequences.
• Analyze and understanding the code in Data stage and implement the same in SAP BODS.
• Migrated Code from IBM Data stage to SAP BODS.
• Load the data from Data stage and BODS and compare the both sets and match data BODS data to Data stage output data.
• Debugging execution errors using SAP Data Services logs (trace, Monitor, and error) and by examining the target data.

Confidential, Montvale, NJ

SAP BI/BO HANA Consultant

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.
• Extensively worked on SAP BW 7.5, Advanced Data Store Objects with delta calculation. Conversion of existing MultiProvider and “old” Composite Provider.
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Advanced DSO, Composite Provider, 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.
• Extensively worked in LO-Cockpit Extraction to load sales, purchasing, inventory & Utility data. Expertise in creating designs of custom extractors for modules like CRM, SD, MM, PP, Vistex and FICO using ABAP.
• Worked on CRM,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.
• 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.
• Performed performance tuning of queries using indices, aggregates, compression and partition.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies.
• Involved in enhancements of Data Services Jobs, HANA Models and applying Patches on HANA. Created procedures in HANA Database.
• 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.
• 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.
• Worked extensively on Reporting Environment usingBExBrowser andBExAnalyzer to build queries, queries and worksheets to access the data from BW data targets.
• Extensively worked in Business objects reporting 4.2/4.1/4.0, in the context of developing the Universe using the IDT and the Analytics using Xcelsius, WebI and Crystal Reports.
• Worked on Designing and Building of Universes, creation of Classes and Objects using Universe Design Tool.
• Also used the Information Design Tool (IDT) to create Universe by creating Connection, Data Foundation and Business Layer
• Defined Hierarchies in IDT to provide the users with Drill down option in reports and Predefined Conditions to use in Business Objects.
• Extensively used various features like Joins, Alias and Contexts in IDT to overcome various traps (Chasm, Fan) and Loops.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created WebI reports using Business Objects functionalities like Queries, Slice and Dice, Drill down, Cross Tab, Master/Detail and Formulas
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing. Experience in developing BEx queries using Query Designer over BW Info Cubes/DSO's and Multi Providers/Composite Providers. CreatedWebIReports on top of BEX Queries.
• Created Universes using IDT on top of HANA calculation and analytical views and developedWEBI reports and dashboards
• Created theWeb Intelligence Reportand usedEventsforDaily/Weekly /Monthly Schedulingof the reports.
• Created Cross-tab reports using Web Intelligence by utilizing prompts, merge etc and provided Executive Summary report of Managers and representative performances to Directors as dash boards in Xcelsius bound to Live Office using prompts.
• Created WebI reports & Crystal reports and deployed them through BI Launchpad with Universe as Source.
• Created reports from multiple sources & functionalities like slice & dice, drill down in Crystal Reports. Developed WebI and crystal reports on top of OLAP Universes, and created dashboards using Xcelsius.
• Successfully created and deployed Design Studio Dashboards on multiple data sources like SAP BW Bex queries & universes
• Extensively worked on Align, Distribute, Maximize and Hide components to give more professional look for web applications in design studio.
• Used Cascading style sheet (CSS) to modify a component for design studio application.
• Enhanced chart appearances with additional properties in design studio.
• Implemented Background processing of data sources in Design Studio to enhance the performance for complex dashboards.
• Created links between the two design studio dashboards and passed parameters from the source dashboard to the destination dashboard using Design Studio Variables.
• Created drill downs to WebI reports from design studio dashboards and passed parameters from the Dashboard to the WebI reports using Open Doc Calls.

Confidential, West Palm, FL

SAP BW/BO Developer

Responsibilities:

• Involved in data migration and conversion activities that include, extraction, transformation, migration, validation and reconciliation of data.
• Involved in information gather phase. Designed and implemented SAP HANA data modeling using Attribute View, Analytic View, and Calculation View.
• Fiori& HANA developer to support best practices implementation in Demo System for S4HANA.
• Extensively worked on migration of standard Info cube and DSOs to HANA-Optimized Info Cubes and DSOs by using Tcode 'RSMIGRHANADB'.
• Worked on Advanced DSO, Open ODS View, Composite providers & Transient providers.
• Proficient in importing HANA models into BW system.
• Extensively worked on Attribute Views (Standard, Time and Derived), Analytic and Calculation Views
• Worked with Transient Providers, Hybrid Providers and Operational Data Provisioning.
• Excellent knowledge on Data Replication Techniques using SLT, DXC and SDA.
• Proficient in SLT configuration and replication of tables by using various replication techniques.
• Involved in importing the BW models from SAP BW HANA to the HANA Studio.
• Involved in SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.
• Provide guidance to internal IT key users to design and develop data loaders/templates to fit the business requirements.
• Identify problematic areas and conduct research to determine the best course of action to correct data.
• Worked onSAPBPCPlanning, Budgeting and Forecasting Implementation - Data Load, Manual Planning via Input Form, Manual Forecast via Input Form, Automated Planning via Script Logic.
• Proactively identify project risks and create feasible solutions. Escalate cross-functional issues and identify SMEs required for resolution.
• Involved in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Involved in supporting the data migration strategy and processes to enable efficient and effective deployment data conversion.
• Worked with MDM data which will allow the client to resolve issues with the quality of data, maintain consistent classification and identification of data, and data-reconciliation issues.
• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Performed data modelling and developed Analytical views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.

Confidential, St. Louis, MO

SAP BW DEVELOPER

Responsibilities:

• Understood the business and gathered the requirements from the business and functional users.
• Coordinating development with the Offshore/Onsite development teams.
• Involved in designing operational reports and monitoring reports.
• Worked on different kinds of Extractors like LO-Cockpit, CO-PA and Generic extractors in order to configure the data sources in BW Back end.
• Created Multi-providers over the info cubes and used them in BEx queries according to the requirements.
• Responsible for defining the BEx Queries used in BO environment.
• Involved in creating Single Sign On between SAP enterprise portal and BI and BO systems.
• Extensively worked on customizing Sales data sources like Sales Item, Contract Item.
• Extensively worked in defining Complex BEx Queries including Structures, Variables, and Jump Queries in SAP BI 7.0 Environment.
• Created Queries in the Query Designer by using Attributes, Variables, Filters, Calculated key figures, Restricted key figures, different conditions and exceptions.
• Worked on BO Explorer in order to analyze the required business information.
• Designed, developed and managed Universes in Business Objects Designer for generating reports against SAP BW.
• Created many WEBI reports over OLAP universes.
• Designed Complex Web I reports including Combined Queries and Drill down reports.
• Worked on Creating WEBI reports using Prompts, filters, Variables and various Manual cell Calculations.
• Extensive experience in working on IDT (Information Design Tool).
• Created BICS Connection using IDT in SAP BI 4.0.
• Created Dynamic Xcelsius Dashboards using QAAWS, Live Office and BI services.
• As a BO Admin, extensively worked in gathering the business needs and converting them into technical specifications.
• Created crosstab data in WebI and developed the WEB Services for the WebI report that can be directly used in the Dashboard Designer.
• Worked on almost all the dashboard components in order to design dashboards.
• Created many Variables and Prompts in BOBJ according to the end user requirements. Extensive experience in working with data synchronization options like Merge Dimensions, Extended Merge Dimensions in BI 4.0 to fetch data from two Universes.
• Created Advance Analysis reports over BEx queries and BW info cubes.
• Responsible for delivery of Business Objects Reports environment on time.
• Identifying the risks and issues from team meetings and coordinating with Project manager.

Confidential, Cincinnati, OH

SAP BI BOBJ Developer

Responsibilities:

• Involved in full life cycle implementation, which includes Gap Analysis, Requirements gathering, Blue printing, Development, Testing, Reporting.
• Extensively worked on Data design and Data modeling using Extended Star Schema.
• As a part of the production support, involved in the debugging and monitoring load failures, update routines, transfer routines, process chains, scheduling data loads, solving the high priority tickets like delta loads, planning ECC outage for filling up of setup tables.
• Extensively worked on Query building, filtering, free Characteristics, RRI-Jump queries, Restricted Key Figures and variables, Calculated Key Figures, Conditions, and Exceptions using BEX Analyzer.
• Worked on BEx Analyzer, BEx Browser and WAD (Web Application Designer) tools to generate reports related SD, MM, and PP.
• Successfully implemented transports of BOBJ in SAP BI environment.
• Developed Universes using SAP BI/BW Queries as Source Data.
• Created BICS connections using IDT in BI 4.0 and also used this connection to get the data from BEx queries.
• Maintained and tested universes for supporting ad hoc queries and reports according to the business requirements.
• Created WEBI reports & Crystal reports and deployed them through Info View with Universe as Source.
• Worked on Hierarchy Levels and Developed hierarchies to support drill down reports.
• Extensive experience in creating reports with Charts (bar chart, Pie chart…etc), Cross-tabs and Sub reports.
• Created 4 Xcelsius Dashboards over SAP BI 4.0.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.

Confidential

SAP BI BOBJ Developer

Responsibilities:

• Worked from the functional/business requirements to design and develop BW objects (install standard objects, enhance existing objects, and create custom objects) like info objects, business content, info sources, data targets, transfer rules, update rules, etc. Provide support and maintenance of the existing BW and APO environments (development, quality assurance and production).
• Worked in Web Application Designer (WAD) to generate Production Planning reports and publish them on to the Portal.
• Exacted data from 0CO PC ACT 1, to find out Actual Costing / Material Ledger / Costs and generated reports Actual Costs in Current Year, Actual Prices for Cumulated Inventory and Actual Prices for Material in all Currencies.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects Universes and Reports.
• Designed Process Chains for Daily Master data loading and transaction data loading from ECC to BI.
• Created the Process Chains, Meta chains and automated the load process based on the business needs.
• Extensively worked on BEx Analyzer and WAD to create Queries, Variables, Structures, Exceptions, Conditions, Calculated Key Figures, Restricted Key Figures, Formula Variable, Replacement Path, Customer/User Exits, Tables and Charts.
• Implemented Process Chain to schedule automatic data loads and apply business rules for loading data to InfoCubes and ODS.
• Involved in migrating the reports and the universes from DEV to UAT and Prod and vice versa and creating .biar backup files of the production data. Created Reports on CRM, POS, Sales and Orders, Plan, AR, Inventory Modules of SAP BW.
• Designed universes using SAP BW Info Cubes.
• Created best practices document for universe development and Webi reports against SAP BW
• Worked with UD Connect to bring in receivables data from non-sap systems.
• Worked extensively on start routines, field routines and end routines.

Confidential

SAP BW Developer

Responsibilities:

• Design and Development of Custom Info cubes, ODS objects, Multi Providers, Info sets and master data objects
• Development and Enhancement of Info sources, Transfer rules and update rules.
• Created and activated Communication Structure, Transfer Structure, Transfer Routines, Update Rules (both ODS and Info Cube level). Built and loaded cubes and validated results.
• Used Delta update to load data into SAP BW.
• Used Direct Update DSO in the process of APD (Analysis Process Designer).
• Worked on loads and scheduling with Process Chains.
• Developed test cases and conducted Unit Testing.
• Worked on developing the flow and had taken entire responsibility of Deployment.
• Worked on fixing issues which have occurred after deployment in the SAP BI end.
• To be involved in deployment of support packs in various SAP Source Systems.