PRERNA SINGH
DELHI
Summary
Enterprise Data Warehouse developer with 5+ years of expertise in SAP Native HANA modelling, SQL scripting, interpreting, analyzing data for the business solutions. Proficient knowledge in analytics , understanding of business operations and analytical tools for effective analysis of data.
Overview
5
5
years of professional experience
Work History
Senior Analyst
Deloitte
02.2022 - 10.2024
- Responsible for gather requirement information from client and perform further analysis
- Responsible for Project delivery and technical assistance to Project Team
- Worked on multiple Projects in Talent, Finance and Marketing domain
- Implemented data quality checks for systems
- Created HDB Tables, HDB Sequences, HDB Procedures and Synonyms in SAP Native HANA Development Perspective
- Responsible for creating Technical Design document for enhancements proposed based on impact assessment and analysis done on existing code
- Hands-on of creating Table Functions and Procedure, scheduling through HANA XS jobs and enabling in XS Job Dashboard
- Responsible for Peer Reviews for other developer's HANA code
- Responsible for deploying the code through ALM
- Worked on documenting the deployment instructions for DBA team
System Engineer
Tata Consultancy Services
08.2021 - 02.2022
- Responsible for developing Qlik dashboards and writing SQL scripts and loading data through data load editor
- Experience in delivering dashboards using Agile based methodologies
- Developing SAP HANA information models such as Procedure and HANA Views(Attribute, Analytics and Calculation views) with graphical and SQL Scripting in HANA Studio
- Expertise in creation of Calculation Views by using Aggregation, Joins, Union, Projection and Rank nodes
- Develop data models for applications, metadata tables, views or related database structures
Assistant System Engineer
Tata Consultancy Services
08.2019 - 08.2021
- Integrated data from different data sources into SAP HANA using ETL(Talend Open Studio, Talend Enterprise)
- Written SQL scripts to manipulate data for data loads and extracts
- Exposure on HANA Modeling Row store and Column store Tables, HANA Schemas Synonyms, Package views
- Worked upon Calculated columns in Calculation views
- Provide Training to other developers as well as lead knowledge Transfer
- Perform unit Testing of all development items prior to passing the items to Business Analyst for minimal changes
- Experience in all phases of Software Development life cycleGathering Requirement, Designing, Developing, Unit Testing and Documenting
Education
Electrical Engineering -
Poornima College of Engineering
Jaipur, Rajasthan05.2019
Higher Secondary (10+2) - undefined
Kendriya Vidyalaya No.3
Jaipur, Rajasthan05.2015
Skills
- SAP Native HANA
- HANA Studio
- Data Warehousing
- Data Modeling
- Relational Database
- SQL
- SDLC
- ETL
- Agile
- GIT
- Data visualization
- SVN
- Business Intelligence
Accomplishments
- Certified in SQL-MYSQL for Data Analytics and Business Intelligence by Udemy, 04/2020
- Awarded with Spot and Applause awards for contributions in Deloitte.
- Received appreciation from Canadian clients and Business users on successful Project Go-lives.
Languages
English
Hindi
Hobbies and Interests
- Travelling
- Photography and Cinematography
- Singing
- Dancing
Professionalprojects
- Deloitte Technology Canada, Deloitte, 05/2023, 09/2024, Played a SAP HANA Developer role to support Deloitte Canada HR, Finance and Marketing data with various data migration, system upgrades, Implementation of Data Analytics and enhancements.
- Enterprise Analytics Project, TCS Data Office, 11/2019, 02/2022, Having 2 years of experience in analysis, design, development, and implementation of HANA in order to develop and deliver Qlik dashboards to end users.
Timeline
Senior Analyst
Deloitte
02.2022 - 10.2024
System Engineer
Tata Consultancy Services
08.2021 - 02.2022
Assistant System Engineer
Tata Consultancy Services
08.2019 - 08.2021
Higher Secondary (10+2) - undefined
Kendriya Vidyalaya No.3
Electrical Engineering -
Poornima College of Engineering
Similar Profiles
Angela Zamora-DownsAngela Zamora-Downs
Technology Support Analyst at DeloitteTechnology Support Analyst at Deloitte
Brendan RiccardiBrendan Riccardi
Senior Audit Assistant at DeloitteSenior Audit Assistant at Deloitte
Ishaq ArifinIshaq Arifin
Senior Engineer at DeloitteSenior Engineer at Deloitte