SATYA SAIRAM POTHULA
Toronto,ON
Summary
Results-driven data professional with over 5 years of experience in Data Warehousing and Business Intelligence technologies. Proven expertise in SQL for query management and data extraction across diverse sources. Skilled in data visualization tools and adept at designing, creating, and implementing robust data models. Experienced in maintaining data warehouses and managing data support activities. Proficient in data modeling, process documentation, and ad hoc reporting, consistently delivering exceptional business solutions.
Overview
8
8
years of professional experience
Work History
Senior Analyst
Loblaw Digital
11.2022 - Current
- Audience Segmentation : Develop and profile audience segments to provide tailored recommendations for stakeholders at Loblaw Media and collaborate with the Sales team to identify and prospect new segments.
- Data Modeling : Create data models using dbt and leverage Snowplow Analytics to enhance insights and performance tracking.
- Data Extraction and Transformation : Query, mine, extract, and transform raw data from the data warehouse using SQL to support audience initiatives.
- Audience Planning : Utilize the internal Audience Planning & Targeting tool to extract transactional data and generate audience lists for the Data Management Platform (DMP) and media buying platforms.
- Trait and Segment Management : Create, maintain, and activate traits and segments in the DMP and media platforms for targeted execution, while monitoring segment sizes and match rates to flag irregularities.
- Data Aggregation : Aggregate first-party offline and online data within the DMP to create rich audience profiles.
- Audience Management : Manage audiences across various platforms (DMP, Facebook, Google Marketing Platforms) and build audiences for audience-centric measurement and reporting for the Data Science team.
- Reporting and Insights : Provide audience insights and analytics to support Sales and Strategy teams, executing measurement frameworks for post-campaign reporting.
- Collaboration and Optimization : Collaborate with the Solution Architect to optimize and automate data processing tasks.
Digital Analyst
Horizon Media
03.2022 - 11.2022
- Working with product & marketing managers to define learning objectives, KPIs and supporting metrics based on business objectives and design direction
- Work with Business Analysts and Leaders to define Objectives, Goals and Key Performance Indicators
- Create and maintain automated weekly/monthly reports and dashboards that report on the health of website for product owners/senior management
- Provide monthly/quarterly campaign reports & performance insights
- Develop quantitative and qualitative analyses and ad-hoc reports to monitor performance and trends
- Manage various Tag Management platforms/solutions together with team members
- Working with client stakeholders to identify site objectives and key performance indicators (KPIs)
- Campaign Reporting: Work with the analytics team to track the effectiveness of campaigns
- Implemented advanced analytics tools to track customer journeys, improving overall user experience.
- Optimized digital marketing campaigns by analyzing performance data and identifying areas for improvement.
- Increased website conversion rates with thorough analysis of user behavior and implementing A/B testing strategies.
- Provided ongoing training to junior analysts on industry best practices and emerging trends in digital analytics.
Data Analyst
Rentmoola
09.2021 - 02.2022
- Working closely with B2B Product Managers to understand their analytical needs, including identifying critical metrics and KPIs, and delivering actionable insight
- Gather data on competitors and analyze their prices, sales, and method of marketing and distribution
- Optimizing existing operational reports and reporting tools for the greatest efficiency
- Analyze competitive market strategies through analysis of related products
- Identify and analyze industry or geographic trends with business strategy implications
- Provide technical support for existing reports, dashboards, and other tools
Sr. Executive Data Analytics
Redbus
01.2017 - 05.2019
- Working closely with B2B Product Managers to understand their analytical needs, including identifying critical metrics and KPIs, and delivering actionable insights
- Gather data on competitors and analyze their prices, sales, and method of marketing and distribution
- Developing and delivering daily, weekly, monthly, quarterly and yearly operational reports for account transactional reporting services to the redBus Finance Operations organization
- Provide insights on product enhancements after thorough analysis by being a part of Sprint Planning and help the Product managers in continuously improving the product and business growth
- Testing of new enhancements/product after the QA Testing confirmation before the feature rollout
- Planning, development, support and implementation of reporting services to redBus product end-users using SQL and Excel
- Optimizing existing operational reports and reporting tools for greatest efficiency
- Analyze competitive market strategies through analysis of related products
- Identify and analyze industry or geographic trends with business strategy implications
- Provide technical support for existing reports, dashboards, or other tools
- Collect and analyze data on customer demographics, preferences, needs, and buying habits to identify potential markets and factors affecting product demand
- Measure the effectiveness of marketing, advertising, and communications programs and strategies
Education
Diplomas - Big Data & Business Analyst
Montreal College of Technology
Montreal, QC12.2021
Bachelor of Engineering -
Andhra University
India12.2014
Skills
- SQL
- Looker
- Tableau
- Big Query
- dbt
- CODA
- Confluence
- Salesforce
- Python
- Snowflake
- ELT
- Hadoop
- HIVE
- Apache Kafka
- Apache Spark
- AWS
- API
- Excel
Timeline
Senior Analyst
Loblaw Digital
11.2022 - Current
Digital Analyst
Horizon Media
03.2022 - 11.2022
Data Analyst
Rentmoola
09.2021 - 02.2022
Sr. Executive Data Analytics
Redbus
01.2017 - 05.2019
Diplomas - Big Data & Business Analyst
Montreal College of Technology
Bachelor of Engineering -
Andhra University
Similar Profiles
Hannah BeckfordHannah Beckford
Merchandising E-commerce Analyst- Shoppers Drug Mart at Loblaw DigitalMerchandising E-commerce Analyst- Shoppers Drug Mart at Loblaw Digital
Gugulami JamelaGugulami Jamela
Sr Site Experience Manager at Loblaw DigitalSr Site Experience Manager at Loblaw Digital
Tarun YTarun Y
Dynamic CRM Developer at Loblaw DigitalDynamic CRM Developer at Loblaw Digital
Shana KhoshnawShana Khoshnaw
Tutor at Toronto District School BoardTutor at Toronto District School Board
Priscila WanderleyPriscila Wanderley
Shipping and Receiving Clerk at Harry Rosen IncShipping and Receiving Clerk at Harry Rosen Inc