raman gupta

Software Engineer

Ilink Systems•  May 2022 - Present

• Designed and implemented optimized data warehouse tables to efficiently store and manage large volumes of data • Improved query performance by 30% by implementing partitioning strategies. Developed comprehensive schema designs that effectively supported the reporting and analytics requirements of the project • Demonstrated expertise in data extraction, transformation, and loading (ETL) by writing scripts to extract data from diverse sources and load it into DWH • Implemented SCD Type 2 methodology for incremental data processing, ensuring accurate and historical representation of changing data over time • Reduced data update time by 70% by implementing efficient SCD techniques. • Built a robust data pipeline that seamlessly moved data from the silver layer to the gold layer, ensuring accurate and reliable data for reporting purposes • Proficiently utilized a range of ETL tools and technologies, including PySpark, SQL, Python, and Azure Data Factory (ADF), to streamline the data integration and transformation processes

Software Engineer

Careers360•  March 2022 - April 2022

Conducted data analysis as a Research Intern in the Data & Operations department, utilizing tools such as Excel.

Research Intern

Soil Agritech Pvt Ltd (NSRCEL IIM Bangalore)•  May 2018 - July 2018

Objective: To amplify the small differential signals which is used in wide range of consumer electronics devices. • Simulation and analysis of class A, class B and class AB amplifier with sinusoidal wave input. • PCB design and fabrication of class AB audio amplifier using TDA2030A.

IIIT, Bangalore (International Institute of Information Technology)

Data Science, Post Graduate Diploma•  November 2021 - Present

Pursiung post graduate diploma in Data Science

National Institute of Technology Meghalaya

Electronics and Communication Engineering, B.Tech•  August 2015 - May 2019

Completed my Bachelor of Technology from National Institute of Technology Meghalaya with 6.75 cgpa.

R R College Sheohar

Intermediate, Intermediate•  April 2013 - February 2015

Completed my High Schooling with 76.80 percent.