Kshitij Gupta

About

With a robust educational background in Technology Management from Columbia University and a Bachelor's in Electronics and Communications Engineering from Manipal University Jaipur, this professional has cultivated a diverse skill set in data engineering and project management. Currently pursuing a Master of Science at Columbia Business School, they have gained valuable experience through roles at IQVIA, Mastercard, INSIA, Celebal Technologies, and Darwinbox. Notably, they have led the development of transactional ETL pipelines, automated data processes, and executed cloud-based data solutions, significantly enhancing operational efficiency and data-driven decision-making. Their expertise extends to designing data storage architectures, performing complex data analyses, and developing social media analytics pipelines. With a proven track record of increasing sales and improving forecast accuracy, they have also contributed to product training and cross-functional collaboration, demonstrating a commitment to innovation and excellence in the technology sector.

Experience

• Project Management Intern, Data Strategy · IQVIA06-01-2024 – 08-01-2024

  - Executed cloud-based data solutions for IQVIA healthcare data, designing data storage architectures to improve processing speeds by 2x. - Collaborated across teams to deliver data-driven recommendations using an internal BI tool, to generate key data reports. - Analyzed add-spend data from 2016 to 2024 for pharmaceutical drugs to deliver comprehensive data insights for go-to-market strategies. - Performed asset archetyping to segment products, resulting in an improvement of drug classification for internal data repository.

• Data Engineer · Mastercard06-01-2022 – 10-01-2023

  - Led development of 20+ transactional ETL pipelines, for Mastercard Test & Learn product, by building robust relational database models, shell scripting, and SQL programming. - Performed data analysis on 100+ GB of data, to find critical patterns in consumer buying trends, increasing sales by 35%. - Conducted data extraction on datasets exceeding 10 million records using SQL and Python, creating robust statistical models that improved forecast accuracy by 20%. - Orchestrated product training sessions for new hires and interns. Led and mentored interns, imparting knowledge on ETL processes, SQL coding practices, data architecture, and product lifecycle. - Cross-functioned with product managers, consultants, software engineers, and senior leadership, to align 100% of data delivery work.

• Product Data Engineer · INSIA09-01-2020 – 06-01-2022

  - Automated data pipeline to reduce 4-hour manual process to 5-minute automated process using Python and SQL programming. - Designed and programmed over 40 end-to-end ETL pipelines and BAU processes on the platform to reduce manual data processes by 99%. - Scripted SQL queries on ClickHouse and MySQL databases to build 350+ business-specific KPIs. - Developed Social media analytics pipeline for Facebook, Instagram, LinkedIn, and Google Ads, by processing over 1M+ data points, automated the transformation of complex JSON into structured tables using Python. - Managed platform operations for 4 partner clients, organized post-production training sessions, and resolved 50+ issue tickets. - Created 30+ video tutorials encompassing the entire analytics product from Data setup, KPI configuration, Role Based Access Control, Search driven analytics, and product functionality to help increase the adoption rate by 80%. - Collaborated with other engineers, product managers, and designers to identify and platform bugs, to successfully scale automation.

• Data Engineer Intern · Celebal Technologies09-01-2020 – 02-01-2021

  - Performed data analysis and built key dashboards to highlight crucial business insights using Power BI, resulting in 10% increase in revenue. - Analyzed multiple datasets, built metrics and KPIs using DAX code to accurately calculate sales, cycle time, etc. - Scripted SQL queries to automate and increase data processing speed by 1.5x.

• Product Analyst Intern · Darwinbox01-01-2020 – 08-01-2020

  Darwinbox is a leading provider of cloud-based Human Resources Management Software (HRMS). - Performed stack ranking analysis, survey analysis, and product bug trends analysis to improve platform efficiency by 15%. - Created 20+ wireframes and Implemented logical design flow for new features and modules. Resulting in saving 3-4 minutes per user. - Designed auto-regressive moving average model prototype, with 80% accuracy using time series analysis for predictive analysis. - Cross functioned with deployment & developer teams to carry out statistical analysis.

Education

• Columbia UniversityMaster of Science - MS, Technology Management
• Columbia Business SchoolMaster of Science - MS, Technology Management
• Manipal University JaipurBachelor of Technology - BTech, Electronics and Communications Engineering
• The Hyderabad Public School, BegumpetHigh School, ICSE

Similar talent on Pangea

Vishnu A.Aspiring Data Scientist with Engineering ExpertisePraveen P.Data Scientist | Machine Learning SpecialistMumbai, MaharashtraArchana V.Tech Leader | Data Scientist | AI EngineerSingaporeHitesh S.Looking for opportunitiesKasol, Himachal Pradesh 175105