Deepshikha Agrawal

HANA Technology Expert:
• Delivering HANA Technical Performance Optimization Service for many banking customers which focuses on SAP HANA Database Tuning, analyzing the effect of system configuration on database response times, as well as the most
expensive statements, to provide recommendations for improving system response time.
• Findings regarding statement optimization and improving system configuration are summarized based on the information obtained by analysis session.
• Areas of concern and recommendations are highlighted in the action list at the beginning of the report and are described in detail throughout the report.

Application Consultant for Large Commercial Banking in Germany:
• Implemented proof of concept for outbound integration between FSDP (Financial Services Data Management) and SAP
IQ. Data from settlement table of FSDM is moved to SAP IQ using SDI (Smart Data Integration) technique.
• Provided a detailed guide which describes step by step process to achieve this integration and created calculation view
joining SAP IQ database and FSDM for reporting purpose.

Application Consultant and security Expert for Internal Project Application Security and DPP:
• Supported the team in Business Partner Data Controller and Purpose Agent adaption.
• Collaborated with SAP DPP security team for generating SDM reports for different software components to obtain a list
of authorization objects which needs to be adapted with new guidelines provided by SAP.
• Created a wiki based on my research on best Infrastructure as a code scanning tools available in the Market and their comparison.
• Worked on Microsoft sway to create a newsletter to notify security experts about security related topics and tasks.

Application Consultant for Internal Project S/4 FPSL:
• Created users with role profiles for different types of demo users (view only, running process, running demo, maintaining configurations) by creating roles in PFCG and providing them relevant authorization to perform expected tasks as per user type.

Developer at S4 HANA Quote to Cash Management:

• The SAP S/4HANA Quote2Cash unit drives innovation and thought leadership across the quote to cash processes. This enables companies to sell physical, digital, and subscription-based goods as a service by monetizing subscriptions and
  real-time usage-based services.
• Responsible for developing and delivering latest innovations in Sales, Service, Billing, and Pricing using technologies like Fiori Elements, SAP UI5, OData, CDS, ABAP etc. with agile methodology of development.
• Worked on Sales Order Without Charge, Sales Quotation and Customer Returns applications independently. Creating ABAP CDS views, ODATA services, UI application with latest Fiori development guidelines.
• Responsible for creating Vyper script for in and out testing of the UI applications. Writing ABAP units for automation testing of ABAP CDS views, ABAP Classes and Function Modules.
• Also responsible for authorization and security testing in all apps with creating test plans and test cases for different landscapes.
• Point of contact and expert for continuous feature delivery process. By CFD, our aim is to deliver functionalities and features in small chunks to our customers in a time period as short as one month.

Fellowship in Business Logging team:

• This team works on SAP Cloud Platform, SaaS, Continuous Integration, Micro Service, Agile Software Engineering methodologies, various Industry Business Scenarios.
• Worked on development of microservices using Java and spring framework.
  Learned deployment of applications on SAP Cloud Platform using cloud foundry and code management using Git.
• Used various tools like Jenkins, Postman, Git Hub, Visual Studio and SAP API Hub for service maintenance, testing and development of new features.
• Worked on Rabbit MQ, EMS (Enterprise Messaging Services) and ANS (Alert Notification Service) for notification service.
• Worked on multitenancy(where multiple independent instances of one or multiple applications operate in a shared environment) and SaaS subscription model(Software as a service is a way of delivering applications over the Internet— as a service).
• Worked on CAP(The CAP theorem states that a distributed database system has to make a tradeoff between Consistency and Availability when a Partition occurs) based development of microservices.
• Also worked on OData V4 where ODATA V4 is optimized version of OData V2.

SAP TIES Project:

• SAP TIES is a platform developed by a small team of SAP employees on SAP technology with the purpose to encourage a culture of learning and sharing without bias or boundaries.
• SAP TIES is an employee-driven initiative. SAP kindly offers and hosts the platform, allowing all SAP employees (and children of SAP employees) to connect with each other.
• Worked as a full stack developer in SAP Ties application project.
• Worked on JAVA backend and SAP UI5 frontend.
  Created forum and mail notification services in current version of app.
• Developed log out functionality of the application. Also fixed existing bugs in UI and enhanced the existing functionality.
• Also worked on database to update DB tables with new fields and updated the services respectively.
  Working on honeycomb to deploy application on different landscape (dev, test and prod).
• Worked on the design of TIES 2.0 from scratch following the microservice architecture. This new version of TIES is based on React Js and Node Js.
  Responsible for solving customer incidents.

Developer at FSDM (Financial Services Data Management) :

• Worked on data modeling tool called SAP Power Designer to create new data warehouse for financial services domain.
• Responsible for end to end development following agile methodology.
• Developed User Interface using master data template of SAP FIORI for Interface Generator. This UI is connected to backend services to generate HANA procedures for writing data into FSDM tables by just one click.
• Created simple to complex HANA calculation views for different reporting scenarios. Also, consumed the same in BW and analytical applications like SAP Lumira, BO Analysis Office and SAP Analytical Cloud.
• Good experience of working on XSA infrastructure and WebIDE. Experienced using Git for code management.
• Experienced in tools: SAP HANA Studio, ABAP NetWeaver, SQL server, SQL scripts, Data Life Cycle Management, Dynamic Tiering, Flowgraph, ETL(Extract, Transform and Load), NDSO (Native Data Store Objects), SAP DATA HUB etc.
• Worked at customer locations in Europe for product implementation and custom development.
  Worked on concepts like partitioning, parallelism, performance tuning, optimal data loads etc.
• Good knowledge in SAP Banking framework like Bank Analyzer, FPSL and CML.
• Also worked on different scheduling, monitoring and orchestration tools like data warehouse foundation, task chains and XSA Job scheduler (Node.js application).
• Expertise on integration project to integrate different banking domains like FSDM, CML and FPSL.
• Responsible for designing the ETL (Extract, Transform, Load) process and error handling concept.
• Also took care of reconciliation by creating reporting scenarios using HANA CDS views.
  I was actively involved in the end to end integration scenario between CML( Customer Mortgage Loan), FSDM (Financial Services Data Management) and FPSL( Financial Products Subledger) where I have designed and implemented ETL process for inbound integration between CML and FSDM for master data (loan accounts, conditions, accruals and business partners) and flow data ( posted and planned cashflows).
• I have also worked on the implementation of ETL process for outbound integration between FSDM and FPSL which covered mapping of data related for accounting like Business partner, Financial contracts, Financial instruments, Securities account, Target Values, Impairment data, Accounting classification status, Market data, Business
  transactions, Cashflow (Posting documents).
• I have knowledge of FPSL account related data model and functionality which I have gained while mapping data model between two different products. I also have knowledge of RDL (Result
  Data Layer) and SDL (Source Data Layer) as we have used RDL as our result data source.

Scholar at SAP:
As a Scholar, I got chance to work on 3 different projects for duration of seven months each.

In first practical phase (September 2014-March 2015):

• Worked on CPM (Customer Project Management) project.
• Worked on SAP Fiori to develop new functionality of applications.
• Worked on ODATA services to perform CRUD operations.
• Was responsible for in and out testing of application.

In second practical phase (March 2015-September 2015):

• Worked in Solution Experience Team.
  Learned and adopted various technologies like (HTML, JQuery, AJAX, JavaScript, and PHP) to design and develop various sample assignment apps.
• Worked on various customer focus projects (e.g. Sompo Japan deal, Metro Medellin deal) for SAP presales where I delivered various key deal opportunities from mobility area.
• Worked on project for SAP HR, apps like sentiment analysis, the eye-catcher for all SAP employees and where they can fill in their sentiment feedback as per question provided through iPad app located on main building entrance, it helped HR people to understand and make the report as per the sentiments of employees.
• Based on customer focus goal and using problem solving capabilities to understand complex problem logically and executes them technically, I helped the team to rebuild more than 100 mobile apps on SAP's Jenkins build server so that each app can compatible with latest iOS release.

In third practical phase (September 2015-April 2016):

• Worked on MDG (Master Data Governance) project.
  Was responsible for Understanding the MDG Product and Delivery Overview.
• Created technical POC using SAP Fiori for create and change of SFlight.
• Was responsible for handling of Regression messages, Customer messages for MDG Fiori application for Request Supplier, Request Customer etc.