• Participated in Development, Documentation, Requirement analysis, End user documentation, Data extraction, Data modeling, Reporting and Production Support.• Created stories and Dashboard on SAP Analytics Cloud using HANA views.• Created Technical specifications and standard modeling documents for Native HANA.• Worked with the CDC team in preparing, cleansing and loading data into the Native HANA environment and to define the Blueprint for Data Integration• Delivered solution using both the Onshore & Offshore model; streamline the delivery model to deliver value to the customer; managed work load, priorities, schedules, etc. based on the team capacity. • Ensured delivered designs are scalable to meet future business development.• Performed data modeling and developed Analytic views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.• Configured and Tested the Attribute view, Analytic views, Calculation views with proper joins for project. • Interacted with the business users/Business Analysts to gather requirements. Documented the meeting in meeting minutes template. • Resolved issues on issue log and centralized repository of project documents.• Reviewed performance issues and provided enhancement recommendations for HANA views that incorporated inventory, sales order, purchasing, and AR data.• Conducted workshop for the blueprint and end-user approvals. • Designed and utilized SAP-BODS solution that satisfies the business performance, functional, and technical requirements in support of client needs, including: Design and configure an SAP-based advanced reporting/analytics solution that satisfies the business performance, functional, and technical requirements in support of client advanced reporting and analytic needs. • Created Universes on top of Native HANA Analytic views and developed the WEBI reports and dashboards using SAP Analytics on cloud and Tableau.

• Created HANA modeling scenarios and activities such as setting up HANA environment - adding a system, creating schemas and various activities.• Worked on SAP HANA Security including User Management, Roles, and Privileges, Reporting, Accessing Analytical and Calculation views from EXCEL.• Migrated HANASQL Scripts, Model objects from DEV to STG and STG to PRD • Migrated tables to other nodes in DEV/STG/PRD and monitored system performance for PRD (checking for locks/long running threads etc.) • Gathered and analyzed the requirements to replicate the ECC content in HANA using the Real-time SLT Process. • Created the Visualization Reports in SAP BOBJ based on the Analytic Views, Calculation views and Universes using measures and Facets on the Information Spaces.• Monitored and conducted troubleshooting during data loads in HANA environment. • Created BOBJ Universes based on HANA views using IDT and created WEBI reports.• Provided L3, and L4 support to the end users and business partners. • Enabled client tools to access HANA directly- Business Objects, to write the reports.• Scheduled real time data load into HANA by using SLT both initial load and continuous replication.• Collaborated with BASIS team in planning and orchestrating system copies during system upgrades, system integration testing (SIT) and User acceptance testing (UAT)• Monitored the consumption of data into Webi to increase performance and stability.

• Worked with CDC team in preparing, cleansing, and loading data into the Native HANA environment and to define the Blueprint for Data Integration into Native HANA.• Performed data modeling and developed Analytic views for the transactional data, Attribute views for the master data, and the calculation views as final model in HANA Studio.• Configured and tested the Attribute views, Analytic views and Calculation views with proper joins for project.• Worked closely with the power users to capture the requirements and incorporated the same in report.• Involved in creation of universes using Information Design Tool (IDT) by retrieving the data from various data sources and connections. • Created Classes, objects, cardinalities and strategies and published the Universe to Repository. • Created Aliases and Contexts for resolving Loop Join problems in the Universe. • Created Derived tables as per the requirement in the Universe. • Worked on design, development and maintenance of Universes, and generated Web Intelligence Reports. • Created Alert, Filters, Ranking, Breaks, charts, tables, sections, Query Panel, Report Panel and Formatted while designing reports. • Created Daily, Weekly, Quarterly reports for the management team and field operation managers.• Tuned the reports to improve the performance of the report refresh time. • Fixed issues like reports opening in PDF view by default to report view.

• Designed and implemented SAP HANA info models using Attribute Views, Analytic Views, Calculation Views Restricted and Calculated Measures, Input Parameters, Variables, Stored Procedures, CE Functions and SQL script.• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures, hierarchies. • Involved working with content models, attributes, measures, hierarchies, currency conversions and schema Mapping. Experience in Text Search with different options via SQL and created Decision Tables in SAP HANA Studio. • Extensively involved in User Acceptance Testing (UAT), Pre-Production testing & Post Production Support. Trained multiple Business groups across the various Departments to fulfill complex reporting requirement needs. • Migrated info models developed in HANA from DEV to UAT to PROD using Export/Import and Life Cycle mgmt.• Performed data transformation and load into SAP HANA database from ECC, SQL Server sources using SAP Business Objects Data Services (BODS) and SAP Landscape Transformation (SLT) • Performed Error Analysis, Debugging SQL Scripts, and in using SAP HANA Plan Visualizer. Optimized existing application which migrated on HANA. • Translated business and functional requirements into development objects in SAP HANA Studio. • Participated in requirements elaboration work-shops for Accounting and Finance business processes for users in the different corporate and business units including Accounting, Tax, General Ledger, Asset Management, Treasury, Consolidation, Planning & Budgeting, Incentives & Commission Management and Regulatory/Compliance. • Worked with various aspects of HANA modeling including creating schemas and importing source system metadata, creating attributes, measures, hierarchies and developing Information Models with Attribute Views, Analytical Views and Calculation Views.

• 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. • 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. • 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.