Salil Trehan

India

@trehansalil1

Senior Data Scientist, HT Media | FMCG | Automotive | Ex-KPMG | Ex-Nielsen

Badges

Problem Solving
Python
Sql

Certifications

Work Experience

  • Data Scientist (Consultant)

    Amenify•  February 2022 - Present

    1. Participated in team-building activities to enhance working relationships. 2. Delivered services to customer locations within specific timeframes. 3. Worked on enhancing/automating/streamlining crawler architectures to create data pipelines linked to the Postgresql database. 4. Collaborated with domestic as well as international team members to achieve target results. 5. Drove operational improvements in dash boarding which resulted in savings in expenses and improved visual interpretation of various dashboards. 6. Identified, measured, and recommended improvement strategies for KPIs across business areas. 7. Utilized advanced querying, visualization, and analytics tools to analyze and process complex data sets. 8. Created plans and communicated deadlines to complete projects on time.

  • Senior Data Scientist

    Hindustan Times•  June 2021 - April 2022

    My Job Role is more around working with the Recommendations Team & the Crawling Team & my responsibilities are as follows: 1. Daily work on Data Sanity issues using MongoDB and code base versioning. 2. Worked upon developing various SQL queries to make analytical reports inflating the google sheets for validating data & provided recommendations based on insights. 3 Solved NLP problems using the classical taxonomy structure with Spacy Pipelines & NER Concepts. 4. AWS Code Commit Repo maintenance & working around AWS deployment along with cron scheduling. 5. Developed Data pipelines for solving moengage push notifications problem (number 1 reco). 6. Scraping Movies/Shows Information from various OTTs to create a Data Lake in MongoDB. 7. Scheduling Daily Crawls in AWS EC2 instances and streamlining the shell scripts. 8. Nurtured & developed a team of 5 people for crawling & recommendations work.

  • Data Scientist

    NielsenIQ•  February 2020 - May 2021

    - Developed a Geo-Kmeans algorithm in Python focussed on both demographic similarity and geographic contiguity. - Responsible for migrating a multi-billion dollar FMCG product from C++ to Python and deployed the setup on AWS EC2 machine. - Automated an FMCG product with statistically selecting relevant data for multiple regression problems. Sales and volume numbers across various FMCG Segments were around 4% - MAPE - Performed a Clustering Study (25L) at the town level for MARs & Wrigley to help them understand Route-to-market Strategies, Innovative Product development and Rebranding different products for effective marketing. - Developed basic dashboards in Power Bi for Auto & FMCG Clients. Worked with BU Heads & Industry Experts to research, automate, and present an Auto-Specific Sales Forecasting product for 2 major industries using Machine Learning/Deep Learning techniques.

  • Research Analyst

    Cambridge Technology Group/KPMG•  May 2019 - August 2019

    - Advisor to the team on key updates in client guidelines & AML-KYC norms. - Directly coordinating with other teams of our department, mentoring and guiding newcomers to help them understand RDC Guidelines & client requirements. - Analyzing and creating pivot reports as well as visual reports on a weekly basis to the Asst. Manager. - Directly working on urgent client requirements and managing the work completed in a timely manner. - Conducting required training sessions to help new joiners understand the criticality for their work.

  • Digital Marketing Executive

    Temz•  May 2018 - July 2018

Education

  • Great Learning

    Data Science, PGDM•  September 2019 - Present

  • University School of Management Studies, GGSIPU

    Business Administration, MBA•  August 2017 - July 2019

  • Jamia Millia Islamia University, New Delhi

    Electrical Engineering, B.Tech•  August 2012 - July 2017

  • Great Lakes Christian College

Skills

trehansalil1 has not updated skills details yet.