Seeking for a challenging and interesting role of SQL and SAP NATIVE HANA Developer in a company where my experience and knowledge can be utilizing and enhance.
Overview
4
4
years of professional experience
3
3
Languages
Work History
Senior Project Engineer
Wipro Technologies
12.2021 - Current
Project - BI HANA (Business Intelligence HANA)
This is an internal Project where it deals with Wipro as its client. Business users for this project are Wipro Competency team. Tools that are used for development of reports are SAP Hana Studio and SQL Server Management Studio for HANA Modelling/SQL scripting in the back-end development and Microsoft Power BI Report Builder (for generation of reports) and Power BI Desktop (for creation of dashboards) in the front-end development. This project includes development of new reports based on User requirements and, maintenance of existing reports (debugging data issues, change requests based on user observations) across multiple tracks (Competency, HRSS, GIMS, Finance, Time Management).
The workflow starts with gathering requirements from Business User. Initiating backend development in development env, share data for UAT and get sign-off from Business on report to move it to production env. Using CHARM tool, the object is deployed to Testing env. and then to production env. Using Power BI Desktop and Microsoft Power BI Report Builder, Reports are enabled in front-end to User to download and use for their analysis.
Education
B. Tech - Computer Science and Engineering
RAJAMAHENDRI INSTITUTE OF ENGINEERING AND TECHNOLOGY
East Godavari, Andhra Pradesh
01.2020
Intermediate (XII) - MPC
GEETAM JUNIOR COLLEGE
East Godavari, Andhra Pradesh
SSC (X) -
JAWAHAR NAVODAYA VIDYALAYA
East Godavari, Andhra Pradesh
Skills
Database Tool: SAP HANA STUDIO (228), SQL Server Management Studio
Professional Summary
Multi-faceted, efficient & reliable Data Analyst with experience in end-to end implementation of Data Modelling.
Currently working as Database (SAP NATIVE HANA, SQL Server Management Studio) backend developer for Wipro Technologies having hands-on experience on SAP HANA.
Have Technical & Functional knowledge to take a concept and turn it into a finished product through played role as Data Analyst.
Driven very critical reports to closure well before deadlines to ensure business satisfaction.
Diversified skill set covering application development, project management and client relation.
Expert in requirement gathering and implementing the best possible solutions.
RESPONSIBILITIES / ACTIVITIES
I have been working in Organization project that generates reports for Competency, GIMS and HRSS tracks using HANA Modelling/SQL Scripting.
Domain Knowledge on Inhouse Trainings, Wage HRSS, Employee Profile Data, Onshore and offshore Data, Travel and Hospitality claims.
Strong experience in Native HANA development (procedures, calculation views, Sap Hana functions), SQL Queries, SQL Commands (DDL, DML, DCL, TCL).
Query Optimization and use of temporary tables for SQL query performance tuning.
Strong experience with trouble shooting data issues, debugging, identifying bottlenecks in core logics.
Work on complex SQL queries.
To have multiple interaction with Business Users (Wipro Competency and GIMS Team) to validate the reports and to get sign-off for object movements to production environment.
Develop/modify all backend developments in SAP Native Hana, Hands on SQL scripting Knowledge, including stored procedures development.
Analyses Business Requirements Document (BRD) given by Business users, identify and develop stored procedures/calculation views as per the requirement and interact with the business users to enable the developed reports.
Debugging the exceptions from the logs, root cause analysis and providing the fix in logics.
Having knowledge in full life cycle development of a Data warehousing project and SDLC.
Preparing documents like Design document, Functional Specifications, Technical Specifications.
DECLARATION
I hereby declare that above mentioned information is correct up to my knowledge and I bear the responsibility for the correctness of the above-mentioned particulars. Place: Date: (Sandeep Sai Tutta)
Timeline
Senior Project Engineer
Wipro Technologies
12.2021 - Current
B. Tech - Computer Science and Engineering
RAJAMAHENDRI INSTITUTE OF ENGINEERING AND TECHNOLOGY