Vijina V SAP HANA Developer

Bosch Project

• Working on creating foundational data warehousing solutions using SAP BW, including creation of InfoObjects and InfoProviders (DSO, InfoCube)
• Designing and executing ETL processes to extract, transform, and load data from source systems into SAP BW environment.
• Building and optimizing BEx queries to support business reporting and analytical requirements.

BBB Project - Apple

• Worked extensively on HANA and SQL development based on requirements.
• Worked thoroughly on data modelling design like developing HANA objects including graphical calculation views, procedures and tables.
• Considerable efforts are directed towards testing data in HANA through data insertion and utilization of HANA features to optimize data processing and improve system performance.
• Actively involved during testing by various teams to guarantee that jobs are operating for seamless data flow.
• Wrote SQL scripts for data manipulation and analysis within the HANA environment.

Platoon Project – Apple

• Worked on designing, developing and testing HANA objects including calculation views and procedures.
• Extracted data from both HANA and Snowflake databases using SQL queries and compared the data sets to ensure they have similar data points.
• Wrote SQL scripts to manipulate data for data loads/data insertion and extracts.
• Used SQL queries to extract and compare the data sets within HANA and verified the data integrity by checking for duplicate records, missing values, or data inconsistencies within the different sets of data. If discrepancies are found, investigate the root cause and take necessary actions to resolve them.
• Troubleshooting deployment issues in order to fix bugs.

Ultimatix Project - TCS Internal

• Worked extensively on Data Modeling design like developing HANA objects including Graphical calculation views and tables.
• Designed, Developed and Debugged Calculation views to model data for reporting purpose and also wrote dynamic or static filter condition as per requirement.
• Created HANA modeling scenarios and activities such as adding a system, creating schemas and content models, attributes and measures.
• Implemented functionalities including Rank node and aggregate functions like SUM, COUNT, AVG, MAX and MIN.
• Created tables using SQL query, Loading data into tables by statements or through Excel/CSV file.
• Written SQL scripts to manipulate data for data loads/data insertion and extracts.
• Good knowledge of SAP HANA security including User Management, Roles and privileges.
• Worked on Optimization and Performance testing of Calculation views.
• Ensure that CV code is well-tested and meets quality standards.