SUMMARY:

• 8+ years of extensive technical experience which includes more than 5+ years in SAP HANA (HANA Studio, S/4 HANA BODS) and around 3 years on Oracle Siebel CRM and PL SQL.
• Experienced and Strong knowledge of SAP Native HANA and S/4 HANA.
• Worked on Data Provisioning tool like SAP Data Services. (BODS).
• Have worked on HANA XS job scheduling and xsjs scripting.
• Hands on experience of Power BI, Lumira, AO/BO and Tableau Reporting Tool.
• Good analytical and programming skills.
• Strong experience in SDLC, architecture, database design, implementation of software solutions.
• Able to take high - level requirements or architectures and develop them into robust applications.
• Strongly self-motivated, Innovative, creative and always keen to learn new methodologies and techniques.
• Strong knowledge of Procedure, Function, Triggers, Sequence, CE Functions.
• Cross-trained on SAP BW on HANA.
• Working knowledge of Oracle Siebel CRM.

TECHNICAL SKILLS:

Languages: PL/SQL, SQL (CDS View in S4 HANA)

Database: SAP HANA, S/4 HANA, Oracle 10g, Oracle 11g

Operating platforms: Windows XP, Windows 7

Development Tools: SAP Data Services, Microstrategy, Lumira, HANA Studio, S/4 HANA, Toad, SQL DeveloperDomain: Telecommunications, Financial Services and Manufacturing

PROFESSIONAL EXPERIENCE:

Confidential

HANA Consultant.

Responsibilities:

• Leveraging plan Viz to identify the memory consumption issues in the current design and address performance obstacles.
• Have created script to track the memory consumptions using in runtime.
• Working on HANA XS job scheduling and xsjs scripting.
• Working on optimization of complex HANA calculation view to make simple with less memory consumptions.
• Working on support issues and enhancements in HANA Projects.
• Working on Odata service implementation for used to create API’s and iflow in CPI (Cloud Platform Integration).
• Have knowledge on creating API’s, iflow and FIORI applications.
• Complexity estimates and effort estimates for the approved RICEFWs with stake holders.
• Responsible to Debug and find if issues in production system and fixed them on high priority.

Confidential

Team Lead HANA Consultant.

Responsibilities:

• Hands on experience in core data services to import S/4 HANA data and build consumption views.
• Implemented new financial reports as per client requirements by using basic, composite and consumption CDS views.
• Troubleshooting and RCA of production issues and fixed them.
• Developed Data Migration program and migrate all non-SAP data to SAP system
• Expertise in SQL and created multiple procedure to handle E2E business process.
• Insertions of data into SAP HANA using flat files and excel.
• Created calculated columns, restricted columns and input parameters
• Knowledge of analytical privileges and assigning it to users.
• Created Jobs in UNIX in and scheduled it for various data flows.
• Worked on SLT and replicated of SAP ECC table in HANA
• Written SQL logic to track the various historical data
• Written Procedures to create HDBDD file format reduce manual effort.
• Written Procedures to find out calculated columns, logic, data type, Length and to identify position of calculated column from view to validated EDW system or we can validate the model logic is proper or not.
• SAP Revenue Accounting and Reporting implementation with BODS, HANA, BRF Plus and Data Hub for meeting IFRS 15 standards. The overall scope of the project is to allow the client to meet IFRS 15 regulatory requirements.
• We build a Revenue Account processor, which will source data from an SAP HANA data foundation (called Normalized Database, NDB), and processes them within the same HANA instance using HANA views and HANA stored procedures and generated the RAI item with Specific RAI format to feed data to SAP RAR module.
• Provided the solution for contract split & combine, Invoice split, Performance obligations, RAI creation for order from billing data and error handling.
• Created the BODS jobs for pushing and processing bulk data to the API (SAP RAR system).
• Created the automated tools for Data service job creation, HANA artifacts (HANA tables for CDS, HDB tables etc.) that saved lot of efforts and it accelerated the project deliverables.
• Created complex data models (Attribute, Analytic and Calculation Views) for order and invoice RAI creations.
• Administer data models in SAP HANA, including setting of information validation rules, managing schemas,the importing/exporting and transporting of data models.
• Developing HANA Procedures using Dynamic SQL Scripting to highlight Data Integrity
• Performed UNION, JOINS between views to represent business cases, created Input Parameters, Variables, Filters
• End-to-End implementation experience of Design, Development, Defect resolution, Go-live & Support

Business Analyst / Software Engineer

Confidential

Responsibilities:

• Development of PL/SQL code.
• Creation of different database objects like PL/SQL procedures, functions, tables, views etc.
• Perform unit testing of PL/SQL code after development of PL/SQL code.
• Involved in preparation of Technical Design Documents.
• Customization of UI objects like applets, views and screens.
• Involved in customization of Business and data layer.
• Creation of links and joins according to the requirement.
• Configuration of Drilldowns, Pick lists, MVGs and Applet Toggles and Added Extension columns to the Existing Tables.
• Implementing Custom Scripting in the Business Components and Applets using effective Scripting techniques.
• Use User Properties at BC, Field and Control level for achieving Specific Functionality
• Conducted POC’s on application backend to be migrated it to SAP HANA.
• Migrated one existing reporting module to SAP HANA and presented the feasibility of implementing to business.