SUMMARY

• Extensive hands - on experience in designing and leading multiple SAP BW implementations and maintenance
• Worked as member of Data Management Organization Team as a Business Objects Data Services Specialist. I was responsible for Data Services design, development, testing and support
• Involved in multiple BW on HANA migration from Sizing to Cutover phase
• Optimized existing data flows for BW on HANA(Project Transformation) adhering to LSA++ architecture using new breed of Infoprovider, and promoted virtual data layer aggressively among team
• Implemented Standalone HANA(Native) Data mart scenarios involving Massive data loads(Scale-out approach)
• Extensively worked with HANA views( Analytic/Attribute/Calculation Graphical/Scripted) involving Big data sets In-Memory while achieving record response times with optimized data moments among various HANA engines
• Worked with SAP HANA SQL, SDA, AFL, PAL libraries, HANA Live Models
• Involved in implementations multiple BODS projects and monitoring/troubleshooting of batch jobs
• Implemented SLT(1:1,1:N scenarios) configurations, transformations and involved in up gradations
• Worked with HANA Side-car scenarios and Implemented ECC Business accelerators, RDA approach for ERP applications, ADBC Calls for faster execution of performance intensive ECC reports
• Strong SQL Skills and Designed and implemented SAP HANA Stored procedures with Error/Exception handling supporting SAPUI5 Applications
• Implemented SAP HANA SDA approach and integrated big-data technologies HADOOP stack with SAP HANA.
• Authored multiple SAP HANA best practices and promoted SAP HANA as enterprise wide data warehouse aggressively within Enterprise reporting teams
• Extensive experience with SAP Technologies ABAP, Webdynpro
• Know-How of SAP ERP Finance & Controlling, Logistics, Human Resources Business Processes, important Table relations
• Worked with multiple Industry solutions, Manufacturing, Logistics, IS-Utilities, CRM, CR&B, Retail
• Have good understanding, exposure to Big-data technologies Hive, Spark, Flume, SQOOP
• Extensive working experience with SAP BEx toolkit, SAP Business Objects WEBi, Design Studio, Tableau, SAP IDT
• Worked on SAP HANA XS, HANA Cloud Platform, SAP UI5, XSJS, and BODS
• Deep Understanding of Enterprise wide reporting eco-system and Overview of major ETL, warehouse technologies is my strength
• Involved in gathering Business requirements, getting sign-offs from business, coping up with project deadlines and undertaking training sessions for business users

TECHNICAL SKILLS

SAP NetWeaver Products: SAP ECC, SAP SLT

Warehouse Technologies: SAP BW 7.X, HIVE

Business Intelligence Products: SAP BOBI WEBI, IDT, SAP Bex toolkit, D3.JS, Design Studio, Explorer

ETL Tools: SAP BODS, SQOOP

Databases: SAP HANA, ORACLE

Programming Languages: SAP ABAP, JAVA, C#, Python, R

Web Technologies: Java Script, HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential

SAP BI/BO/HANA Architect

Responsibilities:

• Involved in BW 7.4 migration and Migration onto HANA Appliance
• Been a single point of contact for BW, HANA and DesignStudio Development
• Designed, implemented and oversaw onshore/offshore teams coordinating BW/HANA modelling and DesignStudio development
• Re-engineered existing BW data flows to optimize for HANA. Extensively worked with Composite, virtual provider by combining data from HANA models with existing BW modelsHANA Models, BO toolkit integration
• Implemented fine tuning, troubleshooting of Applications and transported models across landscape
• Designed and Implemented HANA Data Models(Analytic /Attribute/Scripted/ Calculation views)
• Built complex HANA combining multiple column views into a single calculation view while promoting parallelism and data moments across engines
• Built Department wide Interactive FMLA Health Score cards DesignStudio Application
• Built Department wide Headcount Dashboard application using DesignStudio
• Built Enterprise wide Business Revenue Dashboards DesignStudio application
• Extensively worked with complex Dashboards spanning multiple Pages, Tabs and involving various visualizations, filters and scripting actions, Cross Tabs
• Consumed HANA, Bex variables, Global variables in DesignStudio applications and built interactivity into applications
• Extensively worked with Branding team and created Templates for DesignStudio for uniform & rich user-experience across applications
• Designed and implemented Adhoc, Canned reports with WEBi, Explorer, Analysis for Office based on HANA modelsHANA HADOOP integration
• Implemented Smart Data Access to integrate multiple HANA appliances existing in Landscape
• Analyzed existing HADOOP eco-system and architected solutions integrating HANA an HADOOP while implementing Modern Data Architecture(MDA)
• Analyzed ETL options available, BODS, SQOOP and SDA while provisioning data from HADOOP and made recommendations
• Designed and implemented HANA Information Management strategy, security models
• Implemented HIVE models for transforming data before loading into HANA

Confidential

Sr SAP BI/HANA Lead

Responsibilities:

• Worked on POC for SAP Business Suite Accelerator
• Implemented RDA(Re-directed Database Approach) approach to re-direct ECC SQL statements to HANA Database
• Identified data intensive programs in ECC system and thoroughly analyzed performance, tables accessed
• Configured SLT to replicate required tables in HANA Database
• Developed cockpit to create XML document with given input parameters
• Successfully achieved performance improvement for ECC reports upon implementing RDA approachSAP HANA standalone Scenario
• Analyzed Data intensive reports to be migrated to HANA from ECC system and identified tables to be replicated
• Designing an optimized solution to deliver successful HANA POC Project with HANA Cloud Integration
• Participated in SLT Sizing and Configured SLT connection
• Performed initial loads of large transparent tables by using indices on logging tables and scheduling parallel jobs
• Troubleshot SLT connection issues, analyzed performance considerations and sizing of replicated tables
• Enhanced source data by adding time stamp data in SLT using ABAP
• Designed Data Models and created Attribute, Analytic and Calculation views for Inventory Management Reporting
• Implemented required SAP Notes for Secondary Database connection for coordinated with SAP SLT team
• Implemented ADBC calls from ECC to consume models exposed form HANA
• Implemented procedures using SQLScript for Database operations of Product Movement (SAPUI5) application
• Translated ABAP data processing logic into HANA Procedures to push data intensive operations to HANA
• Performed Unit Testing, Stress Testing and documented result
• Interacted with key Business partners for gathering reporting requirements and implemented Adhoc, Canned reports using WEBi, SAP Lumira, Tableau, Analysis for office, Design studio while using multiple visualizations like bars, charts, cross tabs, filters, prompts
• Worked with SAP HANA LIVE Virtual Data Models
• Provisioned user, roles using data base procedures instead of creating manually
• Worked heavily with SAP HANA Predictive Analytic Library(PAL) and AFLProvisioning data via SAP BODS
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems.
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse, Address Cleanse and Match
• Used Business Objects Data Services cleansing transformations extensively for de-duplication, Standardization and address parsing.
• Imported and converted data from SAP ECC, Legacy, or other external systems or data sources into SAP BW utilizing ETL techniques
• Worked on SAP tables, doing data conversion, moving data from source to loading table and then to staging table and then target database.
• Extensively worked on creating CDC’s workflows for Sub ledgers stuff AP/AR/IC/PA and Sales order table on Daily and History Oracle CDC Tables.

Confidential

SAP BW/BO/HANA Lead

Responsibilities

• Achieved response time of less than 5 seconds on WEBI reports for a change on ECC side
• Configured SLT for 1:N replication scenario for real time data replication and Implemented Enhancements to Source data
• Implemented complex data flows using BODS performing transformations, mapping and look up operations
• Participated in requirement gathering sessions and developed Business Objects Data Services jobs specifications on excel sheetsbased on information acquired from analysis of source data, user requirements, Business rules and Enterprise standards.
• Used Business Objects Data Services for ETL extraction, transformation and loading data from heterogeneous source systems.
• Used various transformations like Case, Map Operation, Merge, Query, Row Generation, SQL, Validation, Data Cleanse,Address Cleanse and Match.
• Used SAP Business Objects and Data Services as an external system for ETL(Extraction,Transformation and Load)between ECC and BI.
• Actively involved in source system data profiling and estimating load on source load during peak load times
• Designed and Developed Attribute, Analytic, Calculation views for Order-To-Cash Business Process
• Developed DataBase Procedures with optimized performance
• Implemented innovative methods to reduce load on ECC system due to Logging mechanism while replicating
• Implemented Reconciliation of data across SAP ECC and SAP ECC using Solution Manager
• Performed Stress with high data loads system, Unit testing of models, regression testing during HANA upgrades
• Extensively used CTS+ system for better version management and proposed usage of content node to avoid issues with transports
• Implemented Dynamic Analytic Privileges based on user master data using HANA Procedures
• Implemented procedures for archiving data from HANA system
• Closely worked with SAP CSA group and Implemented required SAP Notes

Confidential

SAP BI/HANA Lead

Responsibilities:

• Analyzed existing BW environment for issues related to readiness of environment for migration to HANA.
• Extensively involved in Pre and Post Migration process and actively followed the defined steps.
• Escalation handling (internal and external) while conducting the team meetings and periodic reviews with client teams.
• Worked in Database Migration and HANA Studio Modeler.
• Involved in Architecting the entire BI-HANA solution with mixed approach data Flow design involving SAP ECC and other legacy systems as source systems and using BW powered by HANA as Enterprise Data warehousing application by utilizing existing extractors to load transactional data into DSO objects to formulate Analytical views, Attribute views and Calculation views (Using HANA Studio/Modeler Perspective) exposed to frontend layer implemented with SAP BO.
• Estimation of user, resource requirements and create plans, timelines, milestones, user approvals, and proper documentation of all kind of specifications.
• Good understanding in Database migration option (DMO) of the Software Update Manager (SUM)
• Involved in gathering reporting requirements from Business users and documenting the same in form of FD’s. (Functional Specs)
• Involved in migrating existing standard InfoCubes, DSO’s and SPO’s to HANA-Optimized InfoCubes, DSO’s and SPO’s respectively.
• In order to improve the performance of data processing by creating complex SQL procedures in HANA and triggered the same from ABAP Programs.
• Involved in consuming HANA models in BW by publishing them as Transient providers.
• Exporting and Importing of HANA models using HANA Lifecycle management.
• Extensively worked on creating Dimensional Data Model for New Business from Operational Data Sources
• The data migration included identifying various databases where the information lay scattered, understanding the complex business rules that need to be implemented and planning the data transformation methodology
• Created Jobs, Workflows and Data Flows according to their Business and implemented their business logic with SAP BODS
• Extensively involved in Data cleansing and standardizing using USA and Multi-Plug-in transforms in Data Quality using SAP BODS

Confidential

SAP BI/ABAP Developer

Responsibilities

• Escalation handling (internal and external) while conducting the team meetings and periodic reviews with Client team.
• Involved in designing & implementing many modeling techniques like (Reporting Date - Snapshot reporting), (Performance tuning in the Transformations - by using Start routine), (Reposting of wrong data for the Standard cubes with power loops), (Delete Overlapping selections data with DTP), (Mapping Tables & Administration Tables), (Inserting data into Info Cubes through ABAP/4 after loading), (Choosing the provider between Last day of the month & other days).
• Estimation of user, resource requirements and timelines, milestones, user approvals, and proper documentation of all reports.
• Working knowledge of Extracting the data using DB connect as a Source system connection in BW 7.3.
• Worked on Universes in BO reporting.
• Worked with different types of Transformations like Direct assignment, Routine, Formula, Initial, Read Master Data and Constant.
• Worked with Start Routine, End Routine, Expert Routine, Multiple Update Groups and also Temporary storage of standard DTP.
• Extracted Data for FI using the following Business content extractors like - 0FI GL 1, 0FI GL 4, 0FI AR 1, 0FI AR 4, 0FI AP 1 and 0FI AP 4 and also enabling the Timestamp Delta mechanism with Coupled Extraction using the Timestamp Table - BWOM2 TIMEST and also using the control table BWIF AEDAT in R/3 System.
• Worked with monitoring the Temporary storage of standard DTP when data loading to Target.
• Developed the Infosets with Inner join, Left outer join and Temporal Join with Derived Key date.
• Worked with the users for defining the reporting needs and helped design/develop flexible queries and pre-calculated reports using BEx reporting features like variables, exception and conditions in Sales and Purchasing areas.
• Created SAP BI reports which include Plan/Actual revenue comparison, Order and sales value by sales representatives and Vendor delivery efficiency.
• Analyzed report performance for statistics and implemented proposals for aggregate creations and indexing, Tuned queries using Partitioning, Aggregates and Multi-providers.
• Involved in Analyzing the Performance of the BEx queries and improving the query performance by analyzing the Cardinality of the Dimensions of the Info cube by using the Function Module - RSDEW INFOCUBE DESIGN.
• Involved in reducing the Cardinality of the Dimension by Redesigning the Dimensions of an Info Cube, identified the Line Item Dimensions and also suggested for Partitioning as most of the time of the query is spent on DB time.
• Involved in creating input ready queries and provided web based & excel based input layers for planning for Market, Regional & Central planners.
• Extensive use of ABAP/4 for Transformations (Start Routine, End Routine, Expert routine), Dynamic file selection, Dynamic DTP Selections, Variable customer exit, Custom extractors.
• Involved in implementing Update routines, Transfer Routines, Start Routines, End Routines and Expert Routines in order to implement the Business rules and also performed currency translation at the transformations by using the function modules CONVERT TO FOREIGN CURRENCY, maintaining the exchange rates in TCURR tables in SAP BI by replicating all the Global setting for ECC 6.0.
• Extensively involved in writing Variable Customer Exits - by using the Enhancement RSR00001 - Function Exit - EXIT SAPLRRS0 001
• Involved in customizing the Data Source / Extractors by using the enhancement RSAP0001 - by using different function exits / components - EXIT SAPLRSAP 001 - EXIT SAPLRSAP 002 - EXIT SAPLRSAP 003
• Proposed & implemented a BW based tool called “Inactive object Tracker” to stabilize the BW Systems.
• Involved in Designing Info cubes, DSO objects and also the data flow for different source applications / interfaces
• Extracted data from different source system based on different technology (Mainframes, Oracle databases, SAP R/3, Java) by using the Interfaces like (Myself Connection, SAP Connections, DB Connect)
• Involved in building Demo objects for the End users and Power users to gather functional requirements and present the reporting Flexibility in SAP BW 7.3 by using all the BEx components like BEx Query Designer, BEx Analyzer, BEx WAD, BEx Report Designer, BEx Web Analyzer and Visual Composer.
• Involved in Extracting Logistics Data (SD, MM (Purchasing & Inventory)) using LO extractors - With different update modes (Direct Delta, Queued Delta & Un-serialized V3 update).
• Involved in building the Customized / Generic extractors using Function module and DB view.
• Extensively worked with Performance tuning techniques Like –Analyzing the BW statistics by using the Technical content BEx Queries (Utilization OLAP report per query, Utilization OLAP report per Info Cube),
• Involved in customizing the process chains by using the ABAP/4 program process types.
• Involved in creating BEx workbooks (7.x) by using BEx Analyzer (Used BEx Macros)
• Involved in creating web reports by using different web items and integrating them to EP.
• Involved in creating Universe on top of BEx queries and published the universe to BOE and designed Webi reports and saved into Info view.
• Involved in extracting data from SAP R/3 for Cost Center Accounting data by using custom extractors.
• Involved in extracting Purchase Requisitions, Purchase Order & Invoices for analyzing the data based on the MG Departments & Buyers.
• Implemented OSS notes for query failures
• Created own Process types for implementing process chains.
• Involved in performance Tuning aspects like Aggregation, Compression, partitioning, OLAP cache, indices, Line item dimension, Read mode of query, Repair of objects in RSRV to check the consistency in the entire Schema.
• Involved in Debugging the Update rules and transfer rules.

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Upgrading of SAP BI from 3.5 to BI 7.0
• Involved in End-To-End Implementation of SAP BI for SAP CRM, SAP IS Utilities.
• Worked on UK OFWAT Regulatory Reporting Analysis for DG7 Measures, DG2, DG3, Water Regulatory and Pollution Incidents.
• Developed Generic Extractor using Views and function module.
• Enhancing datasource at SAP CRM to populate the data and extract it to SAP BI
• Extraction from different source systems, SAP ECC 6.0, SAP CRM 5.0, Flat File
• Enhancements in the BeX reports
• Worked on Integrated Planning function.
• Integrating with EP and Publishing reports in Portal.
• Establishing & monitoring the processes for changes management.
• Manage knowledge transfer process and induction plans.
• Client coordination and to liaise with different stakeholders for the project. Handover documentation towards managed operations.
• End to end responsible for the Architecture process to define, design, and build information flows.

Confidential

SAP BI/ABAP Developer

Responsibilities

• Involved from the stage of Inception to the Go-live and Production support
• Involved in the architecting the solution from identifying the areas required for the dashboard building
• Discussions with the Project board members, Basis and the Enterprise Portal teams, ECC Teams, Business Users in order to identify the landscape required, understand the requirements and put forth the solution
• Design being the core of this project, lead the team with the design data flow, creation of Mapping documents between BI and ECC
• Involved in the creation of Functional specification, Technical specification documents
• Implemented SAP Best Practice methodology taking care of both present and future needs into consideration
• Implemented Notifications, Inspection Lot from Quality Management module
• Created Multiprovider based on the Notifications, Inspection Lot, Audit Management, Purchasing data infoprovider
• Created Infocubes for Material Movement and Material Prices using standard datasources 2LIS 03 BF, 2LIS 03 BX, 0CO PC ACT 5
• Extensive use of Hyperlinks functionality in WebI for implementing RRI or Jump functionality from Summary reports to the Detailed reports
• Helped the Project in generating 500+ Technical work hours of development in enhancing the Data Warehousing System of the client and performance tuning.
• Enabling the Live Cache and Broadcasting settings for the queries where the analysis of large amount of data is required by the key users.
• Scheduling the jobs and checking the extractor jobs in R/3 system as well as BI/BW System.
• Supporting of the Order to Delivery Quality Management Application which includes extraction of the data from SD, MM, WM and FICO systems into the back end BI system and then reporting the output in Crystal Reports.
• Development of custom tools in ABAP to increase the stability of the SAP BI System.
• Development of Inactive objects tracker in BW using ABAP to find out the inactive objects in production after the transports.
• Worked together with the JAVA team in the development of a RFC Function Module which sends the current details of a Process chain whenever the chain is given as input to the function module. A monitoring dashboard has been designed in the Java front end.

Confidential

SAP BI/ABAP

Responsibilities:

• Creating Info Objects, DSOs, Info Cubes (with efficient Star Schema), Multi Provider, and Process Chains.
• Scheduling and monitoring data uploads and identifying and resolving issues related to the upload of data
• Loading data SAP/Non-SAP source system.
• Maintaining and creating transfer rules, Update rules and communication structures.
• Creating Rules, Start routines, End routines and expert routines.
• Loading and maintaining of Hierarchies.
• Creating Enhancements on ECC depending on the client requirement.
• Appending extra fields to the database tables on the ECC side and created custom enhancements to populate the data in the extract structure.
• Implementing the LO extraction, CO-PA extraction.
• Designing, implementing and extracting the Inventory management data from R/3.
• Creating ALV Reports on BW data in SAP APO.
• Working in developing and enhancing of BO WebI Reports, SAP Netweaver Portal, Universe Designing and query designing.
• Designing user defined Workbooks by changing the VB Code in the backend.
• Creating and configuring roles in the BO from SAP.
• Migrating the workflows from 3.X to 7.0.
• Creating the Broadcasting settings in the queries.
• Integration of the scheduling of instances in BO Reports with the process chains in BW.
• Creating Openhubs
• Activation of the standard content of the SAP BW system as per the client requirement and thereby reducing the implementation time for reports

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Created Universes based on BW queries, BW infocubes; Involved in extensive testing of universes and reports
• Involved in performance tuning of Business Objects reports by tuning the SQL
• Created reports in WEBI of Business Objects
• Worked on trouble shooting of migration issues in reports and universes
• Extensively created Business Objects reports like matrix reports, tables and pie charts.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors, etc
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects, etc.
• Defined documentation standards including the creation of Entity relationship diagram (ERD) for universes.
• Created SAP OLAP Universes, Web Intelligence(WebI) reports
• Involved in Adding of new Objects to the existing Universe as per end users request.
• Prompts were used in reports as well as at the Universe level to create interactive reports for the users.
• Exported the Universes to the Repository for making resources available to the end users.
• Created Summary-level business reports for easy analysis and easy decision making
• Lead a team of 6people, involved in design discussions, involved in leveraging the advantages of BOBJ’s over BI reports, training the team in BOBJ Universes, Web Intelligence (WebI), communication with stakeholders from different teams, Status meetings with the Business Users
• Created documents for training the entire team and the end-users

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Prepared technical spec for Smart forms for Invoice list, Invoice form, Prepayment form
• Contract confirmation Quote Confirmation
• Designed & developed on Enhancements for VA01, VELO transaction
• Designed & developed various objects in APO module
• Developed an inbound IDOC which will create multiple customer invoices for multiple Company codes & multiple Customers and populate the data in the IDOC which is useful in processing LOCKBOX and EBS
• Prepared technical specs on interfaces which are triggered using Proxies BAPI
• Prepared technical specs for a Report which is used for uploading flat file data and generating a interactive report
• Prepared a technical spec for a complex report for generating Retail profile & loss report
• Developed on inbound interface which triggers using proxies
• Handled lot of issues in UAT FAT & Hypercare