SUMMARY

• 13+ years of software development experience in Native HANA/BW/BO/Tableau.
• Extensively worked on Native Hana Modelling(Hana Modelling,Hana SQL, Performance Tuning, Cloud/On - Premise environment) and Data Provisioning Tools(SLT/Golden Gate, SDA, SDI and BODS).
• Implemented Five full life cycle implementations for different modules (FI/CO, SD, MM and PM) in SAP, involved in all phases like Gap analysis, Blue-printing, design Functional and Technical specification, development, performance tuning, integration and UAT, documentation, code and peer code reviews, training and trouble-shooting.
• Expertise in Native Hana Modelling.
• Expertise in creation of Procedures, Table Functions, Functions and Hana SQL.
• Extensively worked on Variables, Input parameters, Calculated columns, Filter expressions, Input Parameter mappings with procedures, Input parameter expressions and Input Parameter cascading.
• Converted all the Attribute, Analytical Views to Calculation Views and Scripted Cal views to Graphical/Table functions.
• Proficient in Performance Tuning of Complex models, memory optimization using PlanViz.
• Pushed Complex calculations to SDI environment and moved all the calculated columns to Logical views in order to improve the performance.
• Expert in Hana Cloud, Hana on Azure Cloud, Cloud Foundry and On Premise environments.
• Transportation of Hana models to various environments using Import/Export, Charm and LCM tool.

PROFESSIONAL EXPERIENCE

Confidential, Bentonville, AR

Native Hana Developer

Responsibilities:

• Redesign of Qlikview Dash Boards into Native Hana with Power BI Dash Boards.
• Developed few reports for asset accounting for the depression value.
• Created the data flow and report for general ledger based on planned value and actual value.
• Understanding the business process and creating the technical and functional specifications documents.
• Creation of Materilized views to handle huge volumes of data by loading the data into physical tables using Procedures.
• Creation of Replication tasks for the replication of Tables from various sources.
• Provided support for data load, validation, performance monitoring and tuning. BW Data load scheduling, monitoring, and troubleshooting data extraction / load.
• Created Open ODS View, Composite Provides, Advanced Data Store Objects and Open hubs
• Developed few reports to Display Sales Order which are Back Order.
• Designed and implemented SAP HANA data modeling using Calculation View.
• Imported SAP BW Models in SAP HANA, Converting the standard DSO into HANA Optimized DSO, Standard Info Cube into HANA optimized Info cube.
• Conducting the workshops to Identifying the KPI for the business owners

Confidential, Plano, TX

Senior Hana Modeler

Responsibilities:

• Prepared Functional specifications, technical specifications and Run books.
• Creating and submitting the ROM, LOE.
• Part of maturity project group and providing the best ideas for the improvement of processes.
• Identifying the risks and taking the necessary steps as per the discussion in the cadence call.
• Involvement in creating and finalizing the cut over activities and participation in all deployments.
• Part of production deployments activities for major and critical projects.
• Coordinating with the SAP BODS team for the development of programs for sending the data to the downstream systems.
• Interaction with Automation team for the automation of reconciliation process in the POS data management.
• As a single point of contact to the customer providing the weekly stats updates on the ongoing enhancements and projects.
• Creation of HANA views as part of new requirements and migrating them across the landscape.
• Interaction with the upstream and downstream systems during the creation of new data flows.
• Active participation in planned and unplanned outages by communicating with SAP BASIS, Hadoop, Scops BI teams.
• Involvement in Unit testing, user acceptance testing and live demos to the business teams.

Confidential

Native Hana Modeler

Responsibilities:

• Creating a roadmap for HANA Analytics and implementing BI solutions using HANA Analytics
• Coordinating with SAP cloud team for ensuring smooth operations of BI tools hosted on Azure Cloud.
• Migration of SAP systems to Hana DB.
• As a HANA Analyst, responsible to analyze the end-user business requirements and architect data models supporting the new reporting requirements.
• Coordinate with the business team to understand the requirements and hence further create the related Business reviews documents for providing the direction in creating the technical specifications.
• Worked with HANA Modeling - Calculation Views with different joins and unions used in the HANA modeling e.g. Inner join, Outer joins, Referential joins etc. and Worked with Aggregation, Projection, Star Join, Union, Inner Join, Left Outer Join and Text Join
• Built BW models using LSA++ architecture Acquisition, propagation, corporate memory, transformation, Dimension, and reporting layer.
• Migrated BW on DB2 to SAP Native HANA by developing the HANA views
• Analyze legacy models and propose alternatives to migrate data models with HANA optimized providers.
• Prepare detailed design documents and keep track of every step executed for proper cutover plan and transports.
• Extensively used generated HANA views where composite providers were not able to support the design requirements.
• Created graphical and Script views to model hybrid models.
• Responsible to implement data models in BW/4 HANA system using advanced objects leveraging true potential of HANA.
• Prepare detailed technical spec for the requirements by identifying gaps.
• Create advanced HANA objects in HANA studio.
• Responsible to design and develop hybrid data models combining data from S/4 HANA & BW, create analytical and Operational reports leveraging the potential of S/4 HANA.
• Identify problems with the existing models and resolve them on priority by proposing alternate designs.