Rajesh R.

Rajesh R.

Data Analyst

Followers of Rajesh R.8000 followers
location of Rajesh R.Seattle, Washington, United States

Connect with Rajesh R. to Send Message

Connect

Connect with Rajesh R. to Send Message

Connect
  • Timeline

  • About me

    Sr. Marketing Analyst | DSP | Python | Tableau | SQL | Marketing | DBT | ETL | Snowflake | Ad Tech

  • Education

    • University of Minnesota - Carlson School of Management

      2023 - 2024
      Master's degree Business Analytics

      Analytics & data science courses• Exploratory Data Analytics• Predictive Analytics• Big Data (Hadoop, Hive, Pig, Spark, AWS)• Programming (Python, R)• Data Management, Database and Data Warehousing (SQL)• Causal Inference• Analytics for Competitive advantage• Statistics for Data ScientistsBusiness & Management courses• Financial Accounting• Marketing Management• Agile ManagementAnalytics & data sci

  • Experience

    • DecisionTree Analytics & Services

      Jun 2021 - Apr 2022
      Data Analyst

      ● Collaborated with data engineers to create ETL pipelines, enhancing real-time data accuracy by 20% resulting in ROI analysis for online and offline campaigns, reducing go-to-market time by 25%.● Collaborated with consumer insights teams to identify trends and insights using SQL and GoogleCloud Platform to provide actionable reports, resulting in approximately $30k in savings within 1 year. • Optimization of spend and performance drove business growth through improved conversions and targeted marketing efforts.● Established code review checks using GIT & coordinating internally to maintain engineering best practices resulting in high quality code. ● Employed statistical methods using A/B testing in advertising campaigns to uncover causal relationships through t-test, resulting in a 15% revenue increase leading to optimization of sales funnel.● Lead & monitored the ad hoc analysis initiatives for Website & Marketing Channel teams, using Tableau which resulted in a 20% increase in website conversion rates.● Partnered with the data science team, implemented regression models to optimize ad targeting strategies resulting in a 20% improvement in click-through rates across ads platforms (Google & Facebook).● Collaborated with data scientists to implement causal inference models for campaign measurement and optimization of a $1.2 million marketing budget across Facebook, Google & etc.● Designed and implemented experiment designs to measure the incrementality of marketing campaigns, utilizing causal inference techniques resulting in a 15% revenue increase.● Lead & monitored the ad hoc analysis initiatives for Website & Marketing Channel, using Tableau which resulted in a 20% increase in website conversion rates. Show less

    • InMobi

      Apr 2022 - May 2023
      Business/Product Analytics

      ● Spearheaded the development and launch of 10 app features, resulting in a 30% increase in user engagement within six months.● Collaborated with cross-functional teams to craft data-driven narratives around customer, resulting in a 20% improvement in marketing campaign targeting efficiency.● Led A/B testing initiatives that increased conversion rates by 10% and generated an additional $100,000 in revenue within a six-month period.● Worked on SQL to extract, manipulate, and analyze over 2 TB of client data from various sources, generating insights that led to a 12% improvement in CTR.● Managed Google Analytics (GA4) and Google Tag Manager to optimize website performance, resulting in a 18% increase in conversion rates over a two-month period.● Scaled the development of a dashboard in Tableau to 20+ members in sales team. This provided actionable insights on KPIs related to logistics & sales. Resulted in an 80% reduction in cash burn for the ecommerce unit.● Developed an automated schedule for retrieving data using app script reducing everyday manual efforts from 2 hours to 12 minutes for a team of 15, enabling more time for strategic work.● Managed and optimized data pipelines for sales and order data, improving pipeline performance by 25%.● Led the comprehensive integration of KPIs, like revenue, profit, tax, and cost of goods sold (COGS), for over 1000 drop shippers spanning 14 categories.● Developed scalable ETL pipelines to integrate ecommerce order data from multiple sources into a Snowflake data warehouse, enabling real-time sales analytics dashboard in Tableau.● Conducted comprehensive customer research by cold calling 80+ customers, implemented market analysis to inform product development strategies and enhance user experience.● Saved 60% of weekly/monthly/quarterly reporting time by developing reusable analytical toolkits with SQL and Tableau for 40+ team in logistics. Show less

    • Carlson Analytics Lab

      Jun 2023 - now

      Client: Largest mall of United States● Utilized Python and Pandas for data preprocessing and analysis to isolate loyalty customers, resulting in a streamlined dataset for targeted analysis.● Leveraged clustering algorithms to uncover distinct segments based on spending behavior, leading to actionable insights for personalized marketing strategies.● Employed Tableau for visualizing cluster results and identifying patterns in Insider spending habits, facilitating data-driven decision-making for the client.● Assessed the effectiveness of the Insider Loyalty program during the holiday season, enabling optimization of promotional efforts and maximizing ROI. Show less

      • Analytics Consultant

        Jan 2024 - now
      • Data Analyst

        Aug 2023 - Dec 2023
      • Data Analyst

        Jun 2023 - Aug 2023
    • Cognitiv

      Jun 2024 - now
      Data Science Analyst

      • Improved benchmark by 30% by developing and implementing real-time dashboards, directly supporting the optimization of $1M+ in Paid Media investments.• Managed and optimized campaigns using DSPs, SSPs, and Ad Exchanges, improving media performance by 30%.• Lead the analysis of multi-channel data, resulting in a 20% increase in conversions and a 15% reduction in cost per conversionthrough strategic optimizations.• Developed data pipelines to support internal attribution models and measure incrementality, enabling 25% faster identification ofhigh-performing media channels.• Led ad marketplace management by analyzing multi-channel data, resulting in a 15% reduction in cost per conversion for one of the biggest cruise company. Show less

  • Licenses & Certifications

  • Volunteer Experience

    • Student Volunteer

      Issued by National Service Scheme on May 2017
      National Service SchemeAssociated with Rajesh R.