Saurabh Joshi

🚀 Full Time | Data Analyst | Media.net

04/01/2024 - Present

• Created a data pipeline for the Internal Crawler product to report daily product usage stats.
• I Support with Daily Reports to share Product P&L to the CEO and stakeholders.
• Collaborated with the Product Manager to analyze Ad position and Ad placement parameters, passed to our Internal Bidders to measure feature impact and coverage on domains.
• Developed a Python script to extract millions of data using Kibana API, analyzing ad-code / ad-type mappings, which resulted in identifying key optimization areas.
• Conducted Exploratory Analysis on Domain - Publisher level of our product to discover missed opportunities.
• I conducted a Root Cause Analysis to find a drop in traffic for the YBN Bidders.
• Supported with A/B testing for various ad products, interpreting results to inform optimization decisions.
• Supporting with Ad-Hoc analysis requests.

🚀 Full Time | Associate Project Management | Media.net

06/07/2022 - 03/01/2024

Responsible for developing various analytical reports to measure campaign performance and its metrics.

Analytical Reports:

• Automated the daily campaign reports with SQL Queries to track key performance indicators (KPIs) at a granular level, including campaign launches and finding out trending/network level keywords utilization, and implemented automated weekly Campaign Manager performance report using BigQuery and tableau, reducing manual reporting intervention by 98%.
• Created various SQL report to identify new and existing keywords based on seasonal trends. This resulted in an increase in campaign launches by 2x and a 16% increase in trending/network-level keyword utilization, which led to a 45% increase in gross profit.

Ad-Hoc Tasks:

• Worked with Tableau to create multiple dashboards to find profitable campaign patterns to optimize and drive better results.
• Shipped a 0 to 1 Article Subtitle Feature across all domains, and delivered new websites to Campaign Managers and Partner Teams.
• Collaborated with Tech/Design teams to solve data/site/UI issues.

🚀 Freelance | Analytics Engineer | Fiverr

01/10/2021 - Present

• Implemented and optimized data models using dbt, SQL, Python, Bigquery/Snowflake, following best practices for data integrity and performance. Developed and documented comprehensive data models and key metrics, enhancing data accessibility and usability for non-technical stakeholders.
• Utilized ELT tools for efficient data extraction, transformation, and loading processes.
• Helped startups to set up data pipelines, increasing 20-30% process efficiency.
• Collaborated with clients including Yahoo, Ellequant, buidlerstribe (buidl.so), and Klimaticz on various data projects, delivering actionable insights and process improvements.

🚀 Internship | Software Engineer | CodeWind

01/06/2021 - 31/07/2021

Responsible for developing CURD API using NodeJS integrating with PostgreSQL database.

🚀 Internship | Data Analyst | Georgia Tech University

01/03/2021 - 31/06/2021

• I developed a Standalone database prospect search engine tool for Georgia Tech University as a Data Analyst Intern.
• Implemented a Web Sports Analytics dashboard application to analyze players’ game data and track player sentiments, tweet comparison and overall standings between players, resulting in a 10% increase in player performance and a 5% increase in player recruitment.