SAIKAT KUMAR MALLICK

- Part of Digital Analytics Technology Team

- Researched and analyzed business operations to identify inefficiencies and emerging trends, and implemented automation for 20+ processes, saving more than 60 manual man-hours/month for the team and delivering actionable insights. - Developed & automated a funnel tracking dashboard of 45+ KPIs across the storefront, demand, and operations, providing daily, weekly, and monthly insights for 27+ brands. - Integrated Jira for daily updates, improved project tracking, validation, time management, and reduced issue resolution time by 12%. - Designed and deployed scalable data pipelines using Python & Flask for data product development and executive reporting, conducted clustering, classification models, and A/B testing that improved SOF conversion by 13%. - Proactively focused and managed issues, risks, dependencies, and escalations using Agile/Scrum methodologies. - Built a dashboard leveraging web scraping and NLP models (LSTM, NER) to consolidate and analyze competitor insights. Automated tagging for 1,000+ competitor stores/month using logic based on explicit naming, Google search, and historical data. Reduced manual work by 20+ hours/month and improved tagging accuracy by 35%, and was able to address missing cases of cuisine by 80%. - To address limited visibility into lost sales, an integrated analysis of Found Rate, mC/R, Online Rate, and GB Impact has been implemented, which resulted in a 100% improvement in root cause visibility. - Implemented data pipelines & used Python for data mining, executive reporting, clustering, classification-based models, and performed comprehensive hypothesis testing to guide features such as SOF and promotions. - Successfully led cross-functional initiative and collaborated closely with cross-functional teams (like Product, Data Science, Operations, Business, etc) to gather feature requirements and define success metrics. - Managed a team of 3 analysts, providing guidance to overcome blockers and ensuring on-time delivery.

1. Accountable for end-to-end tracking of all business metrics to identify the pain points as well as to understand different cohort performance. Eg:- SAV to Booking Ratio, Traffic to SAV ratio, impression to views ratio. 2. Established the complete full funnel Dashboard in the supply and demand sides of Marketing which top leaders use for brand awareness, lead conversion, and product engagements. 3. Communicated product vision, roadmap, and releases to the Marketing, Operation and Leadership teams. 4. Carried out a comparative study between the company's product & the market trends and proposed areas of improvement in some product features. 5. Collaborated with the Data Engineering team to optimize query runtime by adding crucial indexes and removing redundant columns, resulting in a ~95% improvement. 6. Collaborated closely with Cross-Functional teams including UI/UX Designers, Marketing, Product, Tech, and Engineering to develop Business Requirement Documents(BRD) and statistical models using machine learning methods to make data-driven decisions. 7. Developed end-to-end tracking for all Real Estate Portals and a few product features using, a customer-centric approach to identify pain points and improve the online journey for our users. This helped identify several areas where users were experiencing friction in the platform experience. Improving the SAV flow conversion by ~10% and reducing CAC by ~5%.

1. Created, managed, and automated dashboards for monthly business metrics/workflow, to facilitate detailed analysis and project prioritization. 2. Defining Key metrics and dimensions to measure the performance with the help of several Data Visualization tools like Google Data Studio, Power BI, etc. 3. Collaborated with Cross-Functional Teams like Analytics, Retention, Marketing & Product which was aimed at improving data sharing, cross-functional tasks, and overall effectiveness in achieving organizational goals. 4. Responsible for Process improvement, smooth coordination, and effective management. 5. Successfully supervised a team in every blocker as well as challenges. 6. Executed the role of gangplank in times of emergencies

- Worked closely with Digital Marketing Team, Events and Sales Teams. - Slashed the administration costs 20% by negotiating the deals and pricing, while ensuring the continuation and enhancement of services.

AIKYATAAN(THE TRADITIONAL CLUB):- It is a student-driven initiative founded by us to motivate the individuals from VIT Vellore to portray and enrich the great literature and culture of Bengal.

Dealt with the Core Engineering Team and identified areas of Trans. Losses in the company. - Followed the six sigma DMAIC Approach to improve the efficiency and Quality of processes. - Developed Automatic Load Controller with the help of Analog Time Switch.The Device usually saved 15 Units/Day, which gives total savings of Rs- 1,30,000/year depending on geographical location. - Optimized the complete Cost of the company YOY

I designed interconnected microgrid which operates in MPPT (maximum power point transfer) algorithm cascaded with ARIMA model based on weather forecasting leading to continuous power supply in rural areas — This model generates a weather prediction which essentially can be used as for a generation forecast of the renewable source, PV system — key implementation in this project is ARIMA (Auto-regressive integrated moving average) model using MATLAB Simulink .

Riviera, an annual International Sports and Cultural Festival, is conducted by VIT to facilitate and promote healthy competition, companionship and leadership skills. A much-looked-forward-to annual event by students within and outside VIT, it has, besides being great fun, consistently brought out excellent coordination skills and overall management strategies of VITians.

I designed a Microcontroller based home automation Bus which retrieves the sensor data established to every appliance which is feeding online through cloud connect/online computation. After that, I sent the data to administrative software(BLYNK) which receive data/plot data/track the data also — Based on I2C(I-squared-C) protocol.

Relevant Coursework:- 1. Computer Programming and Problem Solving. 2. Multivariate Calculus and Differential Equations 3. Differential and Difference Equations. 4. Complex Variable and Partial Differential Equations. 5. Probability Theory and Random Processes. 6. Applied Numerical Methods.