Tushar Sharma

CRM Aligner: Processed raw data, identified primary keys and surrogate keys, built DBT models and validated the data to provide business with the journey of a visitor from website to appointment.

CRM Claravine: Analyzed the data for standardized campaign from claravine, created DBT models and integrated claravine data with mainstream data and collaborated with data engineers and visualization engineers, helped in business with better tracking of campaign performance.

Shopify: Optimize the query for 30% faster, more accurate data retrieval and reporting. Analyzed data, adjusted timezones, redefined the formula for sales for some shops.

Hills To Home: Helped in validating the data by incorporating Time Travel in Big Query and brought parity between snowflake data and Big Query data, monitored,maintained and optimized the current DBT models.

Gigya: Enhanced data quality by performing thorough cleaning, validation, and transformation tasks, created efficient DBT models.

GA4: Created Dynamic DBT models in order to tackle changes in columns by utilizing Snowflake and macros of DBT, providing code that requires less maintenance.

PXM Phase2: created efficient DBT models to provide business with reporting numbers to analyze the products missing details on ecommerce websites, maintaining and continuously monitoring the models

Google Search Console: Thoroughly analyzed the google search console data, created the DBT models on the data coming from google search console and provided the data to other projects

• Optimized machine learning models for improved prediction accuracy and performance.
• Developed custom algorithms to solve unique challenges in data analysis and modeling.
• Utilized programming languages such as Python. SQL extensively throughout the internship – applying relevant libraries and frameworks when appropriate.
• Created data visualization graphics, translating complex data sets into comprehensive visual representations.

Taught Mathematics and Statistics to undergraduates while preparing for UPSC.