Kshitij D Gupta Email & Phone Number

New York, Ny, Us

Durham, North Carolina, Us

• 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.

Purchase, Ny, Us

• Led development of 20 transactional ETL pipelines, by building robust relational database models, shell scripting, and SQL programming.• Performed data analysis 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, using statistical data models to improve forecast accuracy by 20%.• Led product training sessions for new hires and interns. Led and mentored 2 interns 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.• Monitored database health using Splunk, ensuring data accuracy for Machine Learning algorithms.

Bengaluru, Karnataka, In

• Automated data pipelines to reduce 4-hour manual process to 5-minute automated process using Python and SQL.• Scripted SQL queries on ClickHouse and MySQL databases to build 350+ business-specific KPIs.• Designed and programmed end-to-end ETL pipelines and BAU processes to reduce manual data processes by 99%.• Built social media analytics pipeline (Facebook, Instagram, LinkedIn, and Google Ads) by processing over 1M+ data points, and automated the transformation of JSON data into structured tabular data.• Managed platform operations for partner clients, organized post-production training sessions and resolved issue tickets.• Created 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%.AWS Services: S3, EC2, RDS, CloudWatch.

Jaipur, Rajasthan, In

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

Singapore, Sg

• Performed stack ranking analysis, survey analysis, and product bug trends analysis to improve platform efficiency by 15%.• Created 10+ 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.

• Built a SaaS product from scratch for all academic materials, campus updates, essential contacts, and practice question papers.• Spearheaded business strategy and business development for Mext. Successfully Incubated start-up under Manipal Group. • Garnered 2M+ website visits, over 3000 users, and delivered academic content for over 170 subjects.• Analysed user trends and audience response via organic and social feedback to improve existing features and overall user experience.• Marketed Mext among 8000+ students via social media marketing initiatives, college associations, and campus partnerships.• Engaged with 10+ investment groups to raise capital and developed data models to scale platform operations.

Lewes, Delaware, Us

• Performed Arduino and Raspberry Pi programming of temperature, fuel & load sensors to increase fleet efficiency by 15%.• Generated revenue by closing over Rupee 1 lack in POCs and Rupee 5 lack in new sales.• Improvised analytics dashboard to display fleet statistics efficiently with 3 new features and KPIs.

Hyderabad, Telangana, In

Created data-driven decision reports using ETL operations, SQL programming, and data warehousing with applications of software engineering.

Jaipur, Rajasthan, In

• Developed cost-friendly and high-utility prosthetic arm using 3-D printing for the differently-abled. • Enhanced user experience by adding 2 new triggers to increase overall functionality by testing over 50 test case scenarios to critically evaluate product design.• Carried out extensive research on market competition and technical stack to be used for product development.

Master Of Science - Ms, Technology Management

Master Of Science - Ms, Technology Management

Bachelor Of Technology - Btech, Electronics And Communications Engineering

High School, Icse