SUMMARY

• Extensive hands - on experience in designing and leading multiple SAP BW implementations and maintenance
• 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 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
• 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
• 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
• 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

ETL Tools: SAP BODS, SQOOP

Databases: SAP HANA, ORACLE

Programming Languages: SAP ABAP, JAVA, C#

Web Technologies: Java Script, HTML, CSS

PROFESSIONAL EXPERIENCE

Confidential, CO

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 approach
• Analyzed Data intensive reports to be migrated to HANA from ECC system and identified tables to be replicated
• 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

Confidential, CO

SAP BW/BO/HANA Lead

Responsibilities:

• Achieved response time of less TEMPthan 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
• 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 teh defined steps.
• Escalation handling (internal and external) while conducting teh team meetings and periodic reviews with client teams.
• Worked in Database Migration and HANA Studio Modeler.
• Involved in Architecting teh 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 teh Software Update Manager (SUM)
• Involved in gathering reporting requirements from Business users and documenting teh 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 teh performance of data processing by creating complex SQL procedures in HANA and triggered teh 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.

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Escalation handling (internal and external) while conducting teh team meetings and periodic reviews with Client team.
• Involved in designing & implementing many modeling techniques like (Reporting Date - Snapshot reporting), (Performance tuning in teh Transformations - by using Start routine), (Reposting of wrong data for teh 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 teh provider between Last day of teh month & other days).
• Estimation of user, resource requirements and timelines, milestones, user approvals, and proper documentation of all reports.
• Working noledge of Extracting teh 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 teh 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 teh Timestamp Delta mechanism with Coupled Extraction using teh Timestamp Table - BWOM2 TIMEST and also using teh control table BWIF AEDAT in R/3 System.
• Worked with monitoring teh Temporary storage of standard DTP when data loading to Target.
• Developed teh Infosets with Inner join, Left outer join and Temporal Join with Derived Key date.
• Worked with teh users for defining teh reporting needs and halped 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 teh Performance of teh BEx queries and improving teh query performance by analyzing teh Cardinality of teh Dimensions of teh Info cube by using teh Function Module - RSDEW INFOCUBE DESIGN.
• Involved in reducing teh Cardinality of teh Dimension by Redesigning teh Dimensions of an Info Cube, identified teh Line Item Dimensions and also suggested for Partitioning as most of teh time of teh 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 teh Business rules and also performed currency translation at teh transformations by using teh function modules CONVERT TO FOREIGN CURRENCY, maintaining teh exchange rates in TCURR tables in SAP BI by replicating all teh Global setting for ECC 6.0.
• Extensively involved in writing Variable Customer Exits - by using teh Enhancement RSR00001 - Function Exit - EXIT SAPLRRS0 001
• Involved in customizing teh Data Source / Extractors by using teh 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 teh BW Systems.
• Involved in Designing Info cubes, DSO objects and also teh 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 teh Interfaces like (Myself Connection, SAP Connections, DB Connect)
• Involved in building Demo objects for teh End users and Power users to gather functional requirements and present teh reporting Flexibility in SAP BW 7.3 by using all teh 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 teh Customized / Generic extractors using Function module and DB view.
• Extensively worked with Performance tuning techniques Like - Analyzing teh BW statistics by using teh Technical content BEx Queries (Utilization OLAP report per query, Utilization OLAP report per Info Cube),
• Involved in customizing teh process chains by using teh 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 teh 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 teh data based on teh 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 teh consistency in teh entire Schema.
• Involved in Debugging teh Update rules and transfer rules.
• Involved in providing L2, L3 & Maintenance support for BW-ABAP applications.
• IM(Incident) tickets and Tivoli management tool used - BMC REMEDY Tool
• Handled loading issues
• Monitoring of Data loads using Process chains.
• Monitoring of System and loading performance
• Consistency checks and Data Validations
• Deleting data in PSA to free teh Tablespaces
• Converting Info package Groups to Process chains
• Ticket Handling of different priority
• Suggested teh process improvements by performing teh structural changes in teh process chains to provide permanent solutions.
• Involved in Validated data consistency in reporting with Data Target against PSA after loading them to data targets.
• Solved many Data Mismatch tickets by doing Back fills.
• Involved in Debugging Update Routines, Start routines, Transfer Routines.
• Involved in performing Production Support activities like Ticket Analysis report, Resource Utilization Report, Time sheet maintenance of teh support team.
• Involved in maintaining lot of documentation for all teh Support Activities

Confidential

SAP BI/ABAP Developer

Responsibilities:

• Involved from teh stage of Inception to teh Go-live and Production support
• Involved in teh architecting teh solution from identifying teh areas required for teh dashboard building
• Discussions with teh Project board members, Basis and teh Enterprise Portal teams, ECC Teams, Business Users in order to identify teh landscape required, understand teh requirements and put forth teh solution
• Design being teh core of dis project, lead teh team with teh design data flow, creation of Mapping documents between BI and ECC
• Involved in teh 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 teh 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 teh Detailed reports
• Helped teh Project in generating 500+ Technical work hours of development in enhancing teh Data Warehousing System of teh client and performance tuning.
• Enabling teh Live Cache and Broadcasting settings for teh queries where teh analysis of large amount of data is required by teh key users.
• Scheduling teh jobs and checking teh extractor jobs in R/3 system as well as BI/BW System.
• Supporting of teh Order to Delivery Quality Management Application which includes extraction of teh data from SD, MM, WM and FICO systems into teh back end BI system and tan reporting teh output in Crystal Reports.
• Development of custom tools in ABAP to increase teh stability of teh SAP BI System.
• Development of Inactive objects tracker in BW using ABAP to find out teh inactive objects in production after teh transports.
• Worked together with teh JAVA team in teh development of a RFC Function Module which sends teh current details of a Process chain whenever teh chain is given as input to teh function module. A monitoring dashboard TEMPhas been designed in teh 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 teh 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 teh client requirement.
• Appending extra fields to teh database tables on teh ECC side and created custom enhancements to populate teh data in teh extract structure.
• Implementing teh LO extraction, CO-PA extraction.
• Designing, implementing and extracting teh 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 teh VB Code in teh backend.
• Creating and configuring roles in teh BO from SAP.
• Migrating teh workflows from 3.X to 7.0.
• Creating teh Broadcasting settings in teh queries.
• Integration of teh scheduling of instances in BO Reports with teh process chains in BW.
• Creating Openhubs
• Activation of teh standard content of teh SAP BW system as per teh client requirement and thereby reducing teh implementation time for reports