SUMMARY:

• SAP expert with 8+ years of IT experience, including SAP HANA, BW/4HANA, BW ON HANA, ABAP and Data Services.
• SAP HANA experience includes the S/4 HANA Architecture, HANA Studio, WEB IDE, Data Migration (SLT, SDA, SDI,BODS), Data - Modeling, Reporting, Security, performance tuning.
• Experience in Designing new solutions using SAP BW on HANA or Native HANA to deliver capabilities meeting business functional requirements and Defining the BW on HANA, Native HANA and S/4 HANA architecture to design new data flows and data integration scenarios
• Experience with SAP HANA programming including SQL (DDL, DML, DB views, Synonyms, Indexes, Temporary column tables, table types, Partitioning), SQL script (Procedures, functions, Sequence, DB triggers) and CE-functions and Virtual Data Model (VDM), Core Data Services (CDS)
• Experience in Information Models such as Attribute Views, Analytic views, Calculation Views (Graphical & SQL Script based), Hierarchies and Decision Tables.
• Have a good understanding of different joins and unions like Inner, Left Outer, Right Outer, Referential, Text joins and sizing, scoping, high availability, and delta merge
• Hands on experience with Enterprise Data Environment, SAP BI Tools including BW, building reports using Query Designer/BEX, ABAP routines in Transformations, start routine, end routine, Expert routine, SAP HANA Expert script.
• Strong experience in SAP ABAP/4 Programming, Table Dictionary, Function modules and Programs.
• Hands-on experience working with standard and custom SAP BW Extractors, SAP BW on HANA features such as advanced DSOs, composite providers, Open ODS views, exposing BW models as HANA views, mixed scenarios, HANA Analysis process in BW and LSA ++ best practice and performance optimization concepts.
• Expertise in Test Models, Unit, Functional, integration and Regression testing all the modules to make sure it is working as expected and data is going through appropriate transformation steps and bug fixes.
• Experience in working with users, and business systems analysts to define the solution design architecture, functional specifications and technical specifications. Strong experience with on site-offshore model.
• Experienced in Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cube Creation, Info-Source, Multi-Cubes, ODS object creation.
• Experience in Background Scheduling and Monitoring of Data Loads.
• Experience on Transport Management System in R/3, ECC and BI.
• Knowledge in Business objects universe designing, Business Objects Desktop Intelligence, Business Objects Web Intelligence, Business View Manager, Info view, CMC and Business Objects Enterprise
• Expertise in performance tuning using Aggregates, Rollup, collapse, Partition, Compression and query cache maintenance.
• Involved in presentations, end-user training and documentation.
• Excellent Communication and interpersonal skills and the knowledge attained through the involvement in different projects make me suitable for adapting to any work environment and building good relationship with customer.
• Possess Strong analytic skills, with ability to follow project standards.
• Expertise in data extraction procedures for non-SAP systems such as third party systems like Teradata, My SQL, Oracle.
• Expertise of various data design models - Entity Relationship (ER), Multi-Dimensional/Star Schema and Extended Star Schema models
• Experienced in Data-Modeling, Data Extraction, Generic Extraction, Data Loading (Full /Delta Up-Load), Scheduling, Monitoring, Info-cube Creation, Info-Source, Multi-Cubes, ODS object creation.
• Involved Generating Reports with Multi providers, Info Cubes and DSO Objects Using BEx Query Designer.

TECHNICAL SKILLS:

SAP HANA: Native HANA 2.0, S/4 HANA 1709/1610, HANA Live

SAP BI/BW: BW/4HANA, BW ON HANA 7.4, BW 7.0/3.5

Data Provisioning: SLT, SDA, SDI, Data Services

Reporting Tools: Tableau, Lumira, Webi, BO-Explorer, AO, IDT and Design Studio, Predictive Analytics

ERP: SAP ECC, SAP R/3

Databases: HANA, Oracle, DB2, SQL, Tera Data

Project Management: Microsoft Suite (Project, Visio, MS Office, PowerPoint, Excel)

Programming Languages: ABAP, SQL, PL/SQL, HTML, CSS, Java Script,C,C++

Others: SharePoint

PROFESSIONAL EXPERIENCE:

Zimmer Biomet - WARSAW, IN

Duration:

Role Played:

SAP BW for HANA Consultant

Responsibilities:

• Involved in multiple implementations of SAP Native HANA, BW/4HANA, S/4 HANA Live which includes Analysis, requirements gathering, development, reporting, Go-live and Post Go-live support
• Extensively worked on SAP HANA Modeling - HANA Calculation views (Graphical & Scripted), HANA CDS Views, analytical Privileges and Column store views
• Tuned and Optimized SQL Queries using Execution Plan and SQL Trace
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Developed SAP BW/4 HANA Advanced DSOs (ADSO), Open ODS Views, Composite Providers, Open Hub Destinations
• Worked on performance optimization for Queries & HANA views to handle process more volume of data during reporting
• Created SAP HANA information models for master data and transaction data through graphical and SQL Scripting. Performed Rank, Counter, YTD, MTD, and QTD using SQL scripted views. Created input variables and populated dynamically through Stored procedures
• Created SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script methods
• Extensively worked in developing enterprise and solution on HANA by extracting data from multiple SAP systems using SLT and extracting data from non-SAP systems using Data Services.
• Extensively involved in Cutover activities like prepare the transport list in order, migrate the objects from Quality to Production, validating all the objects whether they imported properly or not, do the follow up with respective teams to fix the issues while migrating, and do the data loads in Production system.
• Co-ordinated for sign-off from Business users and support team. Migrated objects to production and provided production support.

Confidential, Dallas, TX

SAP BW on HANA Consultant

Responsibilities:

• Extensively involved in converting the Functional Specifications into Technical Requirement Document
• Created ADSOs, Composite Providers, Transformations, DTPs and Info packages as per the business requirement.
• Extensively involved in creating the Formulas, Start Routine and End Routine based on the requirement.
• Extensively involved in transport the objects from Development to Quality and from Quality to Production.
• Activated the LO Cockpit Data Sources like, Material movements, Invoice verification, Sales and Purchasing as per the business requirement.
• Done the set up tables load for Material movements (2LIS 03 BF) and Invoice verification (2LIS 06 INV).
• Created Generic Data sources based on Views and Flat File Data sources as per the requirement.
• Extensively involved in Cutover activities like prepare the transport list in order, migrate the objects from Quality to Production, validating all the objects whether they imported properly or not, do the follow up with respective teams to fix the issues while migrating, and do the data loads in Production system.
• Extensively involved in performance tuning by partitioning based on the 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.
• Involved in data extraction, data cleansing, data mapping, data harmonization, data enrichment, data consolidation, data loading and data reconciliation.
• Perform review of the Technical Designs, ETL Code and Unit Test Plan.
• Extremely familiar with different type of nodes like Projection, Join, Union, Aggregation and Rank in calculation views.
• Created the Base level calculation views for Master Data and Transactional Data.
• Created the Star views as per the business requirement.
• Created the calculated columns, restricted columns and done the filtering data at Projection Level based on the requirement.
• Created the Input Parameters, Variables and Union Node pruning by using Decision table to improve the performance.
• Involved in doing the Currency conversion and UOM conversion based on the business requirement.
• Involved in fixing the high, medium and low priority defects.
• Hand over the objects to the offshore team.
• Coordinated with the Business users in User Acceptance Test and get the sign-off.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• BW Ops team is responsible for fixing any batch job failures escalated by Bristlecone level 1 support. Escalate to Platform Config or other teams if necessary.
• Create and execute works plans as necessary (Sometimes help monitoring other teams’ work plans)
• Executing on-demand load requests from business
• ECCS
• PO Commitment (once a year)
• Sales Authorize Freeze calendar update (Once a year) recovery of missing EBS (temporary task until fixed)
• Execute Finance Month End job tasks
• Aggregates rebuild monthly tasks (monthly)
• North America COPA loads (monthly)
• FI Material Ledger DC Shipments
• Manage invalid char handling procedure.
• Adding Info objects to DSO, Infoset and Multi providers.
• Have Done Unit testing document and submitted to Customer for Validation.
• Involved in “UPGRADATION PROJECT”.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Monitoring Data load activities and recovered failures in Dev, Quality system as a part of unit testing.
• Preparing the process documents for each and every enhancement.
• Involving in solving high-prioritized tickets regarding extractions, performance issues and data load failures.
• Working on process chains to automate the Deleting indexes in Info cubes, Process of info packages, creating indexes, ODS activation, further updating, PSA request deletion and Attribute change run so on.
• Using open hub to export data from BI to External systems (flat file, table, 3rd party tool).
• Involving in Unit testing, Integration testing, Regression testing and User acceptance tests.
• Enhancing the existing reports as per the new requirement.
• Monitoring the daily loads to various data targets in the system.
• Monitoring the process chains on the basis of daily, weekly & monthly.
• Manual loading and rolling up the data into data targets.
• Maintaining the logs for each manual load.
• Creating aggregates to improve the query response.
• Performance tuning of queries using aggregates, indexing of Info cubes.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Extensively involved in installing the business content info objects, cubes, transformations.
• Created Info Objects, Key figures, DSO’s, Cubes and Multiprovider as per the Specifications.
• Extensively Involved in Setting up the LO Data sources for Sales and Distribution and Material management from SAP to BI.
• Involved in enhancing the data sources and write the ABAP Code to populate those fields.
• Created Start Routines, Field level Routines, End routines and Formulas in Transformations.
• Created the process chains to load Daily deltas from SAP for Master and Transaction Data and automated the same.
• Extensively involved in transporting the objects to Quality system.
• Used Multiprovider and Info sets to design complex queries.
• Created Calculated Key figures, Restricted Key figures, formulas and Structures as per the report requirements
• Experienced in creating formula variables, conditions, exceptions, exception aggregation, cell editors, customer exit variables and structures for developing complex custom reports.
• Do the testing for SD, MM and FI.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Extensively involved in creating the Technical Specifications and Functional Specifications.
• Extensively involved in installing the business content objects as per the requirement.
• Created the Info Objects, DSOs CUBEs and MultiProviders as per the Technical Specifications.
• Extensively Involved in Setting up the LO Data sources for Purchasing and Material management from SAP to BI.
• Involved in enhancing the data sources and write the ABAP Code to populate those fields.
• Extensively involved in creating the Generic Data Source with Tables and View as per the requirement.
• Created Start Routines, Field level Routines, and Formulas in Transformations.
• Involved in migrate the objects from BW3.5 to BI7.0
• Extensively involved in loading the data from Flat File Source System.
• Extensively involved in transporting the objects to Production system.
• Involved in creating the Reports as per the User Requirement by using the BEX Query Designer.
• Extensively involved in creating the different type of variables as per the requirement.
• Created the Currency Translation Type for converting the different types of currencies into the Group Currency.
• Extensively involved in do the Performance Tuning by using the Portioning, Aggregates and compression.
• Involved in Creating the Dash Boards by using the WAD.
• Created the New Selections and New Formulas as per the requirement.
• Created Calculated Keyfigures, Restricted Keyfigures as per the report requirement.
• Created the reports by using the Variable Offset values.

Confidential

SAP BI Consultant

Environment: BI 7.0

Responsibilities:

• Involved in handling the high, medium and low priority incidents.
• Involved in transport the objects from development to quality to production by using CHARM process
• Extensively involved in creating the Technical Specifications.
• Involved in upload the technical specifications to the solution manager.
• Involved in some enhancements for break fix the issues.
• Involved in Broadcast the reports to the particular users.
• Involved in creating the mercury test cases.
• Involved in creating the dashboards by using the Visual Composer.
• Extensively involved in creating the cube, info objects, Infosources, Transformations, and Data Transfer Processes.
• Involved in enhance the Master data objects and the process chains.
• Extensively involved in define the cell definitions, and the selections and the formulas in the report level.
• Extensively involved in creating the new reports based on the Functional Specifications which are provided by the users.
• Extensively involved in enhance the reports as per the user requirements.
• Created the CHARMS for transport the objects from Development to Quality
• Involved in update the Functional Specifications as per the user requirement and upload into the Solution Manager.
• Involved in enhance the existing cubes and multiproviders as per the requirement.
• Created Start Routines, Field level Routines, and Formulas in Transformations.
• Involved in Migrate the objects from BW3.5 to BI7.0
• Involved in creating the reports and connect the reports through RRI based on the user requirement.
• Involved in creating the APD (Analysis Process Designer).
• Involved in remodeling the data model as per the requirement.
• Held training for fresher’s.