OBJECTIVE:

Looking forward for challenging and rewarding Position as a SAP Consultant with state - of-art technology where my analytical, trouble shooting skills, experience in business process knowledge can be put in for the successful execution of the projects in both implementation as well as the supporting projects development assignments and be a part of the team that excels in work towards the growth of the organization and gives the satisfaction thereof.

PROFESSIONAL SUMMARY:

• SAP HANA Certified consultant with 10+ years of SAP BW, BOBJ and HANA experience. Worked as BW on HANA Consultant, SAP HANA Developer, BW & BOBJ Consultant and Sr. SAP BI Consultant for Multiple industries like Pharma, Oil & Gas, Retail Industry and Manufacturing Industries.
• Experience in Information Technology industry with SAP HANA, SAP BW (BW 7.5, 7.3, BI 7.0, BW 3.5), SAP ABAP/4, SAP BOBJ, SAP BO (4.1 and 4.2), SAP BODS, SAP ECC.
• Experience in 4 full life cycle implementations including Business Blueprinting, Design, Development, Unit Testing, Integration Testing, Documentation and end user .
• Supported all phases of a project life cycle including analysis, design, development, testing, deployment of solutions, and postproduction support/upgrade/maintenance functions.
• Completed end-to-end SAP Native HANA and BI/BW implementations providing solution across different SAP functional modules SAP APO/SD/FI-CO/AR/AP/CCA.
• Experience in SAP BI- ABAP (Start, Field, End routines, Function modules, Bex Customer Exists and data source enhancements)
• Coordinated with business/users and responsible for deployment & Go-live (Review/approve transport, lead solution architecture, help troubleshoot and coordinate any issues with basis and functional teams). Expertise in Code deployments into Production and other environments.
• Having Good Experience in BEx Query Designer, BEx Analyzer, WEBI reporting tool, IDT tool, SAP BODS, ABAP, S4 HANA CDS Views and Tableau
• Extensive experience in writing Stored Procedures in Native HANA using SQL Script
• Experience in performance tuning on Native HANA, BOBJ, SLT and BW to process more volumes of data during reporting and load time.
• Worked on upgrade activities BW (7.3 - 7.5), Native HANA (Version 1 SP 6 to SP11) and BOBJ (4.1 to 4.2).
• Experience in various tools like SOLMAN, IRIS, HP ALM and Doc Space.
• An organized professional with excellent communication and interpersonal skills.

PROFESSIONAL EXPERIENCE:

Confidential, TX

SAP Native HANA/BI-BW Onsite Global Lead

Responsibilities:

• Responsible to work in Enterprise Data Analytics Platform (EDAP) - Upstream IT Application projects where responsible to Migration data from SAP BW to Microsoft Azure Cloud platform
• Design and development of using various info providers, Info objects, routines and Transformation, Custom Data source using Function Modules, Bex Query and History and Delta loading techniques in SAP BW to meet project requirements.
• Responsible to extract master and transactional data from different legacy system and load data into SAP BW system for business decision making reporting purpose and Responsible to build the SAP BW complex interfaces to push historical and daily incremental data into downstream/Upstream systems for the EDAP (Enterprise Data Analytics Platform) Projects.
• Created custom data source using function module, table/view on ECC SD and AR module
• Enhancing the data source on ECC AR(0FI AR 4), COPA, AP(0FI AP 4), CCA and GL (0FI GL 10) data flow
• Created customer exit for the dynamic calculation prompt in the reporting section
• Responsible to understand the Enterprise Data Analytics Platform (EDAP) architecture for storing historical and incremental structural data from SAP BW and unstructured data from streaming IOT devices and for further data analysis connect to Microsoft Power BI reporting tool.
• Data provisioning from SAP BW to AWS and AZURE using file transfer techniques.
• Extensively worked on open hub and APD’s to transfer the data from BW to AZURE Data Lake/AWS.
• Performance tuning on BW transformation (Start routine and End Routine) to minimize the load time.
• Developing new Open Hubs in SAP BW to ingest data to Microsoft Azure Data Lake for storing historical structural data from SAP BW and unstructured data from live stream IOT devices and for further analysis the data in Microsoft Power BI reporting tool.
• Design and development of using various info providers, Info objects, routines and Transformation, Custom Data source using Function Modules, Bex Query and History and Delta loading techniques in SAP BW to meet project requirements.
• Create custom data source on finance module using function module.
• Worked on Microsoft Azure Data factory to push the data into Cloud Using Pipeline activity Copy Data, Data Lake Etc.
• Working knowledge in latest cutting-edge technologies Big Data using Apache Spark using Microsoft Power BI.

Confidential, SFO

SAP Native HANA/BI-BW Onsite Global Lead

Responsibilities:

• Collaborate with business users, stakeholders and subject matter experts to understand the functional and non-functional requirement Gathering & analysis.
• Analyze and prepare optimal technical architecture solutions and propose architectural alternatives and prepare the functional design and technical design specifications.
• Architecting and designing solutions using SAP BW, SAP native HANA, BW on HANA, SAP Landscape Transformation (SLT), Business Objects, Tableau and Business objects data services (BODS) in the functional areas of SAP Sales and Distribution (SD), Material management (MM), Finance and Costing (FICO), and Advance Planner and Optimizer (APO).
• Development of Data Store Objects, Info Cubes, Multi-providers, Info sets, Complex transformation routines using ABAP/4 language, Open hub’s, Process Chains, DTP’s, and Transformations using SAP BW.
• Development of Calculation views, stored procedures, Analytic Privileges, column tables and security roles for restricting user data access using SAP HANA.
• Development of Open ODS, Composite Provider, Advanced DSO’ and HANA Optimized info cubes using BW on HANA and Native HANA.
• Manage project applications for SAP BW and Native HANA, change and bug fix releases.
• Support for bug fixes and environment related issues reported. Engage with Testing and deployment teams.
• Created Dynamic Variable, calculated column, filters reports using Tableau
• Performing performance tuning on data load, report run time and availability on user reports.
• Responsible for managing Incident, Change & Defect Management.
• Work on Root Cause Analysis, Process Improvement for critical and repetitive tickets.
• Responsible for onsite / offshore coordination for all interface developments and complete the Design, Build, Test and Deploy phase successfully.

Confidential, NJ

SAP Native HANA/BI-BW,BOBJ Onsite Global Lead

Responsibilities:

• Management of overall solution design workshops and design reviews
• Responsible for understanding the business requirements, performed gap analysis, created functional, architectural designs and reviewed Data Modeling designs with functional team
• Worked on extract the data from SD data source 2LIS 11 VAITM (Order Item), 2LIS 12 VCITM (Delivery Item), 2LIS 11 VASCL (Schedule line), ZZ SSO ZSD ORDER BLOCK (custom order block) to build perfect Order proxy report.
• Worked on COPA reconciliation report using the below data source (ZZ A2R COPABAL RECON - Recon COPA Balances) and 1 CO PABTB 001 (Costing based profitability analysis)
• Worked on stored procedure in sales order model to calculate business required fields based on application tables and updated calculated fields in custom table.
• Expert in creation of Attribute Views, Analytical Views and Calculation views. Created different types of Calculation views like Dimension, Star join, Cube created Calculated Columns, Restricted Columns and Input Parameters for dynamic selections and leveraged stored procedures in Native HANA.
• Expert in finding/debug the bugs in ABAP logic and fixing the logic.
• Expert in handling high priority incidents and resolving the issues.
• Involved in performance optimization of Information views by following standard methodologies and deep understanding of modeling and joins
• Experience in analyzing the views and SQL queries using explain plan, pruning techniques, table partitioning and Viz plan tools in Native HANA
• Configured SLT replication process between SAP ECC and SAP Native HANA and Performed data transformations in SLT before loading data in SAP HANA
• Data Provisioning and replicating data from source system to HANA Database using SAP Landscape Transformation (SLT) and performing initial load, Replication, Resuming and Suspending data loads
• Experience in Importing metadata, Table definitions and develop solution in SAP BOBJ-IDT using Webi
• Developed Webi reports and extensively used Variables, Drill down, Breaks, Sections, input controls, formatting tables, cross tab representation, data sort options and calculations
• Responsible for overall coordination with Business users and SAP BI team with focus on reports delivery
• Ensuring development and implementation of adequate testing strategies

Confidential, NJ

SAP Native HANA/BI-BW Onsite Lead

Responsibilities:

• Responsible for understanding the business requirements, performed gap analysis, created functional, architectural designs and reviewed Data Modeling designs with functional team
• Created modelling for COPA report and Pricing report using Native HANA
• Build Sales order, Billing Model to show Sales order and billing related fields in report using the SLT functionality to fetch the ERP tables. Created attribute view and calculation view, calculated, restricted, currency conversion and various joins are used to build this report.
• Created of Attribute Views, Analytical Views and Calculation views. Created different types of Calculation views like Dimension, Star join, Cube and using table functions in Native Hana as per the business requirements
• Have created Calculated Columns, Restricted Columns and Input Parameters for dynamic selections and leveraged stored procedures
• Worked on different types of join conditions like Inner join, Left outer join, Referential join, Text join, Temporal join
• Worked in analyzing the views and SQL queries using explain plan and Viz plan tools in Native HANA
• Have created modelling using BODS like Used different transforms such as Query, Case, Table Comparison, Key Generation, Merge, Date Generation, Pivot transforms and functions.
• Data Provisioning and replicating data from source system to HANA Database using SAP Landscape Transformation (SLT)
• Involved in configuring SLT replication process between SAP ECC and SAP Native HANA and Performed data transformations in SLT before loading data in SAP HANA
• Design and develop solution in SAP BOBJ-IDT using SAP Analysis for Office and Webi
• Developed Webi reports and extensively used Variables, Drill down, Breaks, Sections, input controls, formatting tables, cross tab representation, data sort options and calculations
• Work closely with offshore delivery centers that will complete the bulk of the technical work
• Created stored procedures/trigger data using SQL.
• Responsible for overall coordination with Business users and SAP BI team with focus on reports delivery

Confidential, NJ

SAP HANA Consultant

Responsibilities:

• Involved in configuring SLT replication process between SAP ECC and SAP Native HANA
• Have performed table partitioning on large tables for performance optimization
• Have performed performance improvement via data transformations (rule assignment, performance option and include program to minimize the initial load/replication)
• Created procedures/trigger to delete the unwanted replicated data using SQL.
• Replicating the tables from multiple ECC and BW using DXC.
• Import and export tables using BODS.

Confidential, NJ

SAP BI/BOBJ Developer

Responsibilities:

• Interacting with clients in understanding the requirements and issues.
• Created technical design documents based on the functional requirements.
• Worked on CR/CO enhancements, OSS note creation wherever the changes are required coming through incidents.
• Worked on data warehouse workbench for defining Info Objects, Info cubes, Multiproviders, Aggregates, DSO’s and Transformations.
• Created procedures/trigger to delete the unwanted replicated data using SQL.
• Worked on Bex Analyzer, Web Analyzer, and Query designer, Cell, Filter, RKF's and CKF's.
• Extracted data from different modules of SAP R/3(APO DP & SNP) into SAP BW system.
• Development, working with workbooks, exception reporting, conditional reporting.
• Actively involved in Rectification of Load failure Errors like Master Data Loads and Transactional loads
• Created Universe and Web Intelligence, Crystal reports using BEx queries. Defined best practices to use BEx queries in Business Objects IDT.
• Used Information Design Tool to create Relational Connection, Data Foundation and Business Layer and accessed the data in HANA through Crystal Reports and Web Intelligence

Confidential

SAP BI Developer

Responsibilities:

• Developing functional and technical specifications
• Designing data model based on the client requirement
• Enhancing info objects to existing DSO, info cubes, multiprovider and queries
• Creating start, field and end routines in the transformations Created variables with user/sap exits, calculated key figures and formulas in query
• Developed LO customization, extracted structures and data sources in Sales Order management
• To facilitate the data extraction to BI enhanced the extract structured by adding new fields and populating them with the user/function exists in CMOD
• Collecting objects in transport request and moving it to quality systems
• Prepare system test cases / test plan
• Involved in performance tuning of data extractions and loads within BW.
• Collected, released and imported the BI Objects from Development to Quality boxes
• Build the reports and perform unit testing, Integration & System Testing.
• Supporting UAT in HPALM.

Confidential

SAP BI/BO Developer

Responsibilities:

• Involved in the Design and Implementation Phases and Build Test Phases, Process Design Documentation.
• Involved in Unit Testing, Data loading, Execute Workbooks, Integration Testing, and User Acceptance Test.
• Extracted data using LO Cockpit, data sources from R/3(SD) source systems.
• Worked on new data flow capabilities like DTP (Data Transfer Process), enhanced & graphical transformation capabilities.
• Worked on Real Time Info Cube and Data source object and also new and enhanced administration and monitoring features (BI Administration cockpit).
• Designed Front-end Queries using BW components like Calculate & restricted key figures, Structures, Variables, Exceptions and Conditions, Workbooks using Bex Analyzer, Bex Browse.
• Monitor and Support & Troubleshooting of Existing Data loads by using Process Chains. Participating in the Status Meeting with the Business.

Confidential, Rockwell Collins

SAP BI/BO Developer

Responsibilities:

• Extensively worked with Orders, Deliveries and Billing areas of Sales and Distribution module
• Enhanced Data source as per the user requirement and Extracted data from R/3 to BI using Logistics Extraction
• Created info objects, Data source, ODS, Info Cubes, Transformations, Info Packages and DTP’s
• Designed and developed Process chains for master data loads and Transaction data loads
• Developed/Modified reports using BEx Analyzer that had Structures, Exceptions, Conditions, Restricted Key figures, Calculated Key figures and Variables
• Performance monitoring of BW System on various levels such as reporting and data loading using the Technical content cubes.
• Implemented OSS Notes.
• Monitoring of Master Data and Transaction Data uploads via process chains
• Monitoring of Info packages and analyzing the reasons for frequent failures of Info packages
• Involved in scheduling the data to info cubes, info objects and ODS objects daily, weekly and monthly
• Manually uploading the data from PSA in case of data load failures
• Created Process chains for effective scheduling of various loading processes and scheduling Init, Delta and Full loads
• Sending the status mails for the users regarding the process chains
• Customized Bex Queries for Users Requirements