PROFESSIONAL SUMMARY:

• 4+ years of IT consulting experience which includes Native HANA, BW/4HANA, BW ON HANA, S/4 HANA, PLANNING, BUSINESS OBJECTS, BODS, ABAP and Tableau.
• Experience in 3 full life cycle implementations, Significant contributions to all project lifecycle phases, from blueprint and design to configuration, functional design, requirement analysis/definition/determination, test execution, issue resolution,, go - live assistance and post implementation support. Hands-on experience with HANA modeling.
• Experience in SAP HANA 1.0 SP12 Modeling, Data provisioning (BODS, SAP Landscape Transformation (SLT), DXC, and SDA).
• Experience in Advanced HANA Data-modeling using SQL Script, SQL CE functions, SQL Script Scalar/Table Functions, SQL Script Procedures, Advanced Joins (/Temporal/Text), Hierarchies.
• Experience in creating HANA Models on virtual tables using HANA Smart Data Access technology from Hadoop and Oracle databases.
• 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
• Worked on HANA XS applications and building HANA Native modeling objects such as Information Models, Stored Procedures, OData Services, XSJS/XSODATA API services.
• Design, build and deploy the provisioning of SAP data into SAP HANA platform to support real time report replacing BW extractors.
• Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and Multi providers.
• Designed queries in BEx Query Designer and created workbooks in the BEx Analyzer using conditions, structures, calculated and restricted key figures, character variables, formula variables and text variables
• Good Functional knowledge of SAP ECC modules like Sales & Distribution, Materials Management and SAP Finance etc.
• Strong skills in assigning work to both onsite and offshore teams and get it done by limited time and resources.
• Experience in data extraction from flat files, CRM and SAP R/3(SD/MM/FI/CO) using extract structures such as LIS, LO-Cockpit, COPA, FI-GL as well as from other database sources using DB Connect.
• 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
• Strong skills in the transport management and planning go-live.
• Extensively involved in the Performance Tuning of Queries using BIA, Aggregates, table partitioning, Indexing, Compression and query cache maintenance.
• Custom Apps Development using UI5, JavaScript, JQuery and MVC frameworks on SAP Web IDE.
• Experienced as a User Interface/Front End Developer in developing applications. Mapping of frontend UI with Entity/entity set of OData service.
• Worked on creation of Admin page using SAPUI5 and connected with backend SAP system using ODATA services in the frontend UI5 layer for customer maintenance.
• Extensively worked on defining the scope of a client engagement in statements of work and facilitating a smooth client on-boarding process.
• Successfully involved in delivering projects with Zero Defect Deliveries under strict delivery timelines.
• Excellent Communication, Interpersonal skills, Problem solving abilities

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, Data Services

Reporting Tools: Tableau, Webi, FIORI, AO, Design Studio And 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 SUMMARY:

Confidential, WARSAW, IN

SAP HANA/BOBJ Consultant

Responsibilities:

• Involved in multiple scenario implementations of SAP Native HANA, BW/HANA, S/4 HANA Live which includes Analysis, requirements gathering, development, reporting, Go-live and Post Go-live support
• 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
• Worked on SLT configuration of solution and specific data migrations within SLT (Data Services)
• Extensively worked on troubleshooting the triggers and the process of loading in SLT.
• Further investigated the reason behind the stuck triggers and came to a permanent resolution.
• Extensively worked on SAP HANA Modeling - HANA Calculation views (Graphical & Scripted), analytical Privileges and Column store views
• 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
• Worked on HANA XS applications and building HANA Native modeling objects such as Information Models, Stored Procedures, OData Services, XSJS/XSODATA API services.
• Created Procedure and XSJS to display the MPN, CPN counts and corresponding Spend and Savings calculations for each quarter for each supplier and Commodity Manager.
• Created SAP HANA information models such as Packages, Attribute Views, Analytic Views, and Calculation Views with graphical and script methods
• Worked independently to develop a Sales report comparison of MTD and YTD values current year Vs. Previous year.
• Co-ordinated for sign-off from Business users and involved in Cutover Activities and support team. Migrated objects to production and provided production support.

Environment: SAP BW 7.4/SP08, SAP ECC 6.0, SAP SLT, HANA 1.0 SP12

Confidential

SAP HANA Consultant

Responsibilities:

• Gathered and analyzed the requirement to replicate the ECC content in HANA using data provisioning.
• Worked on deliveries related to configuration.
• Translated business requirements into a technical design document.
• Worked on Incidents, Change Order and Service Requests.
• Configured for Daily, Monthly and Yearly loading activities.
• Worked on the reporting requirements related to Water Consumption Report, Open Record requests, Security Alarm requests, Sales Statistics Report etc.
• Worked extensively on BI related ABAP work e.g. Start routine, End routine and enhancing the extractor to achieve the business logic.
• Performed Unit Testing and System integration testing for the deliverables.
• Maintained business intelligence products such as reports, dash boards, Lumira, universes, explorer views, HANA, ETL, portal linkage day-to-day to ensure availability.
• Developed some Web reports with SAP BO Design Studio on the Customer Receivables and open order requests on disconnection objects.
• Monitored and tuned business intelligence product performance - report, plan, schedule, coordinate, communicate, execute, signify, attest, and test adjustments accordingly.
• Worked on transporting deliverables to quality and later to production system.
• Worked on building financial reports and generated the reports useful for company's financial audit (GL/AR/AP).
• Coordinated with end-users for their work support and work on component testing.
• Worked on EHP 6 upgrade for SAP system landscape and performed the testing of the reports and BI configuration during the post upgraded period.
• Worked on Data warehouse, ETL and software development methodologies.
• Was an active contributor in the Proof of concept on SAP HANA.
• 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.
• Worked on integration with backend SAP SoH for data extraction and process chain design.
• Loaded Data into the SAP HANA Database using SLT Replication and BODS. Bringing Data from ECC, Oracle and Flat files, also implemented ABAP Data Flows in BODS.

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, SAPHANA, BODS

Confidential

SAP BODS/BW Consultant

Responsibilities:

• Interacted with business end users to gather requirements.
• Prepare High Level ETL design - Process Flow, Source to target mappings, design of data standardization, de-duplication and Cleansing modules for subscriber, data validations, plan for historical data analysis and modification.
• Extracted data from legacy systems to ECC 6.0(SAP R/3) using Data integrator as the ETL tool.
• Used Data cleanse and Address cleanse transforms to correct the Customer Master data extracted from file formats.
• Implemented the application of the Data Cleanse Transform on Customer and Vendor Master data to identify and parse the data to confirm to company standards.
• Used the Data Cleanse Transform on first name, last name, title, phone no, mail id, firm name, etc. and used Match Transform to correct.
• Designed the ETL processes using Data Integrator to load data from multiple databases like Oracle, My SQL, XML, Flat Files (Fixed Width) to staging database and from staging to the target Data Warehouse.
• Data flows were designed by incorporating cleansing transforms on collaboration with match transform with set priorities to consolidate Master data.
• Extracted data from legacy systems to BW system with SAP BODI as ETL.
• Used global Address Cleanse transform and USA Regulatory address cleanse transform to parse, correct, complete, and standardized the address components to de-duplicate the address data.
• Designed, developed, implemented and documented complex Batch jobs and Real time jobs to extract data from deferent data sources.
• Transform the data and load the data to specified destinations using Data Integrator (ETL)
• Configured Custom cubes, Transfer rules, Transfer Structures, Update Rules, DSO, Cubes, Aggregates, queries and workbooks.
• Designed Universe on SAP BW Queries & Info Cubes and developed Webi reports.
• Published and scheduled batch jobs and real time services via web services using Data Integrator Administrator.
• Developed complex BEx queries for inventory, Head count reporting and KPI reporting.
• Created Webi and Analysis tools for Excel reporting in deploying the inventory and KPI reporting.

Environment: SAP BI 7.0, BW 3.5, ECC 6.0, Bex, BODS