HRITIK RASTOGI

Developed a robust data-mart from Data Lake source in Snowflake to aggregate key KPIs data for the marketing team. Deployed scalable SQL scripts for 12 different media data sources in GCP Cloud. Designed optimal ETL pipelines with alert mechanisms, orchestrated in Cloud Composer (Airflow) & stored credentials in Secret Manager. Deployed end-to-end ELT pipelines in client's native IICS environment. Design & build SnowSQL data pipelines in the client's IICS environment, ensuring adherence to IT & security compliance standards. Implemented scalable Snowflake scripts (PL-SQL) for nine different brands across three hierarchical DBs, restricting data visibility. Assisted client's IT team in identifying & addressing data quality framework loopholes, thereby enhancing their overall process. Effective resume screening framework for a Global CPG company's P&O team. Collaborated with their global P&O team to analyze the root cause of problem affecting their employee's retention rate. Designed the solution architecture with leveraging ML techniques (cosine similarity, clustering, etc.). Implemented framework helped them save over 4000+ hours per month.

Demand forecasting at SKU level (100+) for the upcoming quarter using ML techniques (ARIMAX, SARIMAX) for a US luxury manufacturing company. Analyzed past 5 years data to generate insights & recommendations, which helped them reduce logistic costs by 10%.