SURYA H R
Bengaluru
Summary
Accomplished Senior Software Engineer at HCLTech with expertise in SQL and Azure Data Factory. Proven track record in optimizing ETL processes and enhancing data retrieval efficiency. Adept at data analysis and problem-solving, driving impactful solutions in data warehousing and analytics projects. Passionate about leveraging technology to deliver business insights.
Overview
4
4
years of professional experience
Work History
Senior Software Engineer
HCLTech
Bengaluru
11.2024 - Current
- Completed various courses on Databricks and Azure on Udemey/Linkedin
- Participated in Data hackathon conducted by HCL
Systems Engineer
Tata Consultancy Services
Bengaluru
11.2022 - 11.2024
- Implemented ETL process to streamline the import of data from various sources into data warehouse using ADF, SSIS packages and T-SQL
- Developed pipelines using Azure Data Factory to ingest data, extract data from ADLS storage and perform transformation using various data flow activities and generate the output files which will be used by business customers for further analysis
- Worked on Datawarehouse redesign project to redesign the existing Datawarehouse model to Data Vault model
- Developed Databricks Notebook using PySpark and created ADF pipelines to load staging data to Datawarehouse
- Conducted data analysis to identify patterns and trends in customer behaviour
- Improved query performance through indexing and query optimization techniques for enabling faster data retrieval for analytics teams
- Worked in Enterprise Data Warehouse to New Analytics Platform migration project to migrate several SSIS packages to ADF pipelines for improving performance of the ETL process
- Developed and maintained stored procedures, views, and functions in SQL server to optimize data extract, transform and load (ETL) processes
- Worked on Airline domain revenue monitoring application which included developing SSIS packages to extract the revenue data received from source and then clean the raw data, transform it as per business requirement and load the final revenue data into the data warehouse
Jr. Software Engineer
Cognizant
Bengaluru
02.2021 - 10.2022
- Developed SSIS packages and implemented them across different environments
- Developed scripts and stored procedures in SQL
- Monitored daily schedules jobs
- Prepared technical design and unit test case documents
- Gained knowledge of the working and functionality of ETL and Banking related applications
Education
Electronics and Communication Engineering -
Adichunchanagiri Institute of Technology
Chickmagaluru01.2020
Skills
- SQL
- T-SQL
- Pyspark
- Azure Data Factory
- SSIS
- Azure Databricks
- ADLS Gen 2
- Azure Synapse Analytics
Languages
- English
- Hindi
- Kannada
Personal Information
Date of Birth: 12/04/98
Timeline
Senior Software Engineer
HCLTech
11.2024 - Current
Systems Engineer
Tata Consultancy Services
11.2022 - 11.2024
Jr. Software Engineer
Cognizant
02.2021 - 10.2022
Electronics and Communication Engineering -
Adichunchanagiri Institute of Technology
Similar Profiles
Nivetha BNivetha B
Linux Administrator at HCLTechLinux Administrator at HCLTech
NEHA SHARMANEHA SHARMA
PMO-CIO (Deputy Manager) at HCLTechPMO-CIO (Deputy Manager) at HCLTech
NEERAJ KUMARNEERAJ KUMAR
Cyber-Security Analyst at HCLTechCyber-Security Analyst at HCLTech
Sashanka BoraSashanka Bora
Technical Lead at HCLTechTechnical Lead at HCLTech
Ayushi SharmaAyushi Sharma
Emerging Architect at Shell India Markets Pvt LtdEmerging Architect at Shell India Markets Pvt Ltd