PROFESSIONAL SUMMARY:

• 8+ 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) 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.
• Expertise in SAP UI5, SAP FIORI/UX, OData, NW Portal, HTML5,CSS3, JavaScript, JQuery, Bootstrap, JSON, XML, SMP, Cordova, Mobility, HCP, REST, GIT and SAP Net Weaver Gateway Service Builder
• Strong working experience in data analysis, design, development, implementation and testing of data warehousing using data conversions, data extraction, data transformation and data loading (ETL).
• Expertise in data extraction procedures for non-SAP systems such as third party systems like Teradata, My SQL, Oracle. 
• Developed Test cases and actively participated in creation of Test Plan.
• Extensively worked on FI-GL, LO Cockpit, CO-PA,Generic Data Source, DB Connect customization and extraction.
• Worked on to Design & Development of SAP BPC 10.1/10.0 Planning and Consolidation Project. 
• Worked on Transformation and Conversion Files for the BPC Load Process. 
• 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
• Experience in using local & global classes with concepts of OOPS like inheritance, polymorphism etc. 
• Interfaces - Developed and enhanced interfaces using ALE/EDI IDocs interfaces, web services, ABAP proxies, BAPI’s and file based interfaces.
• 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.
• Expertise at creating data source connections via SAPI, DB Connect and flat files so as to load data into SAP BW system
• Experience in installing BW over HANA servers.
• Good Knowledge on BW 7.4 and its new features like Hybrid Providers, Semantic Partitioning Objects, Advanced DSO,Composite Provider,HANA Views, HANA Optimized Cubes.
• Experience in SAP HANA development, migration, optimization and support for mixed approach with Native and SAP BW on Hana solutions.
• Implementation of stored procedures to retrieve data from HANA database schema 
• Building of XSJS/XSODATA APIs Creating Calculation Views, Analytical & Attribute views 
• Customization of Fiori Apps for HCM Creating of tiles, Catalogs, roles, target mapping and semantic objects 
•  Fiori Launchpad Administration 
• Experience in data provisioning with SLT, BODS, DXC and SMQI.
• Expertise in ETL techniques and proficient in loading techniques such as Full load, Delta load and also in data modeling.
• Conducted and performed Performance tuning Techniques (Aggregates, Process chains, Cube Compression, Line Item Dimension, and Indexing) for Improving the Reporting.
• Expertise in BEx Analyzer, Web Application Designer, Info-Set queries. Experience with Front-end Business Warehouse Components, which involved constructing custom queries using Variables, Structures, Conditions and Exceptions, Restricted and Calculated Key Figures. Expertise in publishing queries to web portals through Web Analyzer.
• Expertise in Business Explorer Suite - BEx Query Designer, BEx Analyzer and BEx Web Analyzer
• Expertise in working on crystal reports and Analysis for Office.
• Analyzed production Reports and improved performance.
• Expertise in Business Objects 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).
• Well versed with Business Objects 4.x, Architecture, Administration/ CMC, Clustering BO Servers & SAP BW-BO Integration.
• 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 complex filters such as pre-defined conditions, report filters, prompts and drill filters.
• Had strong experience in creating reports using WebI over BEx queries and universes by incorporating prompts, element linking, Drilldowns, merging dimensions, purging data, Combined queries, filters, Fold and unfold mechanisms also with creating report level filters for dynamic data filtering.
• 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.
• Good knowledge on Business Objects BI 4.0 Advanced Analysis edition for OLAP connected to a BW OLAP connection.
• Hands on experience with creation and deployment of Design Studio Dashboards on multiple data sources like SAP BW BEx queries, using .unx universes.
• 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.
• Wide experience in interacting with end-users to gather and document the reporting requirements and giving training 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

SYSTEMS PROFIENCY:

Operating System: Confidential Windows XP/ 2000/98/2003/ NT, Unix, Linux

ERP: SAP R/3 4.6C, 4.7 EE, ECC 6.0,S4 HANA

Data Warehousing: SAP BW 3.5, BI 7.0, BI 7.3,BI 7.4,7.5

BI Platform: Business Objects XI 3.0/3.5/R2/R3/BI 4.0/4.1

Reporting Tool: BEX,Web Intelligence, Crystal Reports, Design Studio, Dashboards, Live Office, Advance Analysis For OLAP/Office, Desktop Intelligence (Deski),Web Application Designer (WAD),SAPLumira (Desktop/Edge/Server/Cloud),

Languages: ABAP/4, OOPS ABAP, SQL, PL/SQL, C,C++

Data Base: MS Access, MS SQL Server, MS Oracle

Application Software: MS PowerPoint, MS project, MS Excel

PROFESSIONAL EXPERIENCE:

Confidential, Montvale, NJ

SAP BW 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. Extended non cumulative handling for Advanced DataStore Objects with delta calculation.Conversion of existing MultiProvider and “old” CompositeProvider.
• Extensively worked on Data design and Data modeling using Extended Star Schema.
• Worked extensively on Vistex Data sources such as /IRM/LIS RM GCRITM, /IRM/LIS RM IPBBITM.
• Worked on various Vistex Modules such as Claims , Billbacks , Sales Rebates and Agreements.
• Extensively worked on HR Datasource like 0HR PY 1, 0HR PP REC 52.
• Installed the BI Content for the HR such as infocubes 0PY C02, 0PY PP2.
• Created hierarchical, multilevel aggregations such as Organizational units, Cost centers, Age of employees.
• Configuration and customization. Preparing the technical specifications, technical developments for implementation of UI5/Fiori, checking feasibility whether user expectations will able to fulfill or not.
• Developed Custom application using SAP UI5 by consuming Odata ABAP service with MVC. 
•  Developed multiple OData services and provided to the front end to consume on UI5/Fiori. 
• Worked on OData with different classes and methods to develop services.
• Defined customer-specific hierarchies such as hierarchy to display the seniority structure at your enterprise.
• Extracted Line Item data from GL, AR and AP.
• Extracted of SCM using 2LIS 02 HDR
• Worked extensively on Data Modeling design like creating Info Objects, Info Cubes, DSO, Adavanced 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.
• Native HANA XS application development to read tables in HANA database using HANA Studio 
• Involved in postproduction support activities in monitoring the daily data loads , fix report issues, and reconciliation issues.
• Extensively worked in LO-Cockpit Extraction to load sales, purchasing, inventory & Utility data.
• 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.
• 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 a design plan & responsible for transition of data from SQL DB to BW.
• 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 intermediate write optimized DSO Structures and APD’s in BI7.4 to improve performance while loading AP data.
• 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.
• Sound Skills in developing SQL Scripts, PL/SQL Stored Procedures, Triggers, Functions and Packages
• Extensive experience on production support and troubleshoot/test issues with existing reports and cubes. 
• 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.
• Complex Queries in Sales- Billing reports, Delivery reports etc using Design Studio.
• Created Aggregates on Info Cubes to improve the query performance.
• 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 using BEx Browser and BEx Analyzer to build queries, queries and worksheets to access the data from BW data targets.
• Responsible for Developing QA/UA Test Plan, Test strategy, Schedule, resource allocation and approach for testing.
• Involved in Unit, QAT, UAT and data quality testing.
• Extensively worked in Business objects reporting, in the context of developing the Universe using the IDT and the Analytics using Xcelsius, WebI and Crystal Reports.
• 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.
• Built WebI reports Provided OLAP functionality and worked extensively with data warehousing.
• Created the Web Intelligence Report and used Events for Daily/Weekly /Monthly Scheduling of 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
• Implemented SAP Fiori applications in MM (Approve PO, Order from Requisitions, Track Purchase Order), SD (Check Price and Availability, Track Sales Order), and custom application to review and submit PM Notifications.
• 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
• Graphical and Script based Creation of Hierarchies, Variables and Input parameters.
• 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 on SAP BPC Planning, 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.
• •Perform review of the Technical Designs, ETL Code and Unit Test Plan.
• Worked with the infrastructure team to define reference architecture of the various reporting tools.
• Work with downstream application users to gather reporting/data requirements.

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.
• Reviewed the developments done by Offshore and also explaining the data models to Offshore
• 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 with Business Explorer (BEx) and publishing the reports on Web using Web Reporting tools.
• 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.
• Redesigned the existing complex dashboard (non-functional) into simple and functional dashboards.
• 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.
• Extracted Line Item data from GL, AR and AP.
• 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 Training Portal Administrators about Xcelsius Model and How to Configure Xcelsius with different Methods to connect to universe (Using Live Office, QAAWS).
• Involved in writing the High-level and Detail-level documentation of the project.
• Involved in Business requirements gathering and Preparation of Technical Specifications documents and Training guides.

Confidential

SAP BI BOBJ Developer

Responsibilities:

• Involved in end-to-end design and development of COPA data sources, transformations, DSO’s etc for O-I global implementation project (APAC, EU, LA).
• Involved in end-to-end design and development of COPA dataflow for NA region and loaded data through Flat files.
• As a technical lead I did Lead projects from a development standpoint to ensure that projects are completed on time. Architect solutions from a technical standpoint to make sure that we build the right reporting solutions. Worked on Integration between Business Objects and SAP Business Warehouse Sustainable Long term Strategy around multiple tools and multiple delivery mechanisms.
• 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.
• Involved in complete Sales Order Reporting function, complete with Orders, Order Items, and various Key Figures.
• 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.
• Created Query to report on Cost Center Detail that provides Cost Center manager an overview of the planned costs and Variance for the selected cost center.
• 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
• Responsible for solving the production issues raised by the business users.
• Enhancing the BW info objects
• Created Customer fact sheet Dashboard for Business needs and automated the dashboard using live office.
• Managed the Servers, Server Groups, Folders, Objects, Universes and Connections from Central Management Console (CMC) and CMS.
• 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.
• Prepared the requirements traceability matrix to ensure that all the business requirements are traced to system requirements and all system requirements are traced to one or more test cases
• 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.