Erfan Yazdpour Email & Phone Number

Kitchener, On, Ca

Ontario, Canada

In this role, I focus on building and implementing data engineering and architecture solutions to drive marketing analytics and actionable insights for stakeholders.Data Engineering & Architecture:Developed and managed scalable ETL/ELT pipelines using Python, Pandas, and SQL to transform raw data into structured formats for analysis. Leveraged Google Cloud Platform (GCP) and BigQuery to architect and optimize data storage solutions, employing medallion architecture for efficient data management and analysis.Data Pipelining & Automation:Engineered end-to-end data pipelining processes, integrating and harmonizing data from multiple marketing sources. Automated data extraction, transformation, and loading processes to improve data flow efficiency and ensure accuracy across various reporting systems.Data Analysis & Visualization:Utilized SQL, Python, and Pandas for in-depth analysis of marketing campaign performance data. Applied visualization tools such as Tableau and Looker Studio to create interactive dashboards, providing stakeholders with real-time insights and enabling data-driven decision-making.Stakeholder Collaboration & Presentation:Collaborated with internal teams and external client stakeholders to present clear, actionable insights derived from complex datasets. Translated analytics into business recommendations and drove improvements in campaign performance through regular presentations and updates.

Ontario, Canada

As a Marketing Data Analyst, I drive the strategic use of data to optimize B2B marketing strategies for top-tier clients including Oracle, Cisco, Shopify, IBM, FIS, Equifax, Google Cloud, Graebel, Windstream, Rive, Chevron, Alorica, and Pathward. Leveraging advanced analytics and a suite of tools such as Python, Pandas, SQL, Alteryx, Looker, and Tableau, I transform complex datasets into actionable insights for data-driven decision-making.Key Contributions and Achievements:• Advanced Analytics Leadership: Spearheaded comprehensive data health assessments, coverage gap analyses, and intent analyses, guiding strategic marketing decisions.• Data Visualization and Reporting: Developed and automated dynamic dashboards and reports, providing clients with clear, actionable insights to inform strategy and enhance engagement.• Strategic Data Solutions: Orchestrated the development of sophisticated data architectures and warehouses, integrating data from diverse sources to bolster multi-touch attribution modeling and campaign performance analysis.• Operational Efficiency: Revolutionized data processes, reducing costs and maintenance by 80% through automation and templating.• Mentorship: Mentored specialists and junior analysts, elevating our team's analytical capabilities and productivity.• Cross-Functional Collaboration: Facilitated seamless collaboration across departments, ensuring that data-driven strategies are comprehensively integrated into broader business goals, thereby enhancing data literacy and strategic decision-making across the organization.My approach not only involves meticulous analysis and interpretation of complex data but also extends to transforming these insights into strategic recommendations. This dual focus has been pivotal in driving marketing effectiveness and operational efficiency.

My role expanded to include leadership responsibilities, overseeing a team of analysts, and spearheading innovative analytics projects that significantly impacted the company's bottom line and market presence.Key Contributions and Achievements:• Leadership and Strategy: Led a team of marketing analysts, fostering a culture of innovation and continuous improvement. Developed and executed a comprehensive data-driven marketing strategy that aligned with business objectives, leading to sustained business growth.• Advanced Analytics Projects: Initiated and managed advanced analytics projects that leveraged machine learning and predictive modeling to refine marketing efforts, enhance customer targeting, and improve ROI.• Team Development and Mentorship: Mentored analysts and specialists, enhancing their skills in data analysis, visualization, and strategic thinking. My focus on professional development contributed to a high-performing team that consistently exceeded goals.• Stakeholder Engagement: Enhanced communication channels with senior stakeholders, translating complex data insights into actionable business strategies. My ability to articulate the value of data-driven decisions was instrumental in securing buy-in for key initiatives.• Market Expansion and Revenue Growth: Played a pivotal role in identifying and capitalizing on new market opportunities, directly contributing to a 70% increase in market presence and significant revenue growth through optimized marketing campaigns and product pricing strategies.• Award Recognition: Under my leadership, the team's innovative approach to data-driven marketing contributed to the company winning the "Iran Pardis Award" for the best non-academic learning program, highlighting our impact on the industry and commitment to excellence.

Tehran, Iran

As a Senior Marketing Analyst at Marketing Camp, I played a pivotal role in driving data-driven marketing strategies that significantly elevated brand awareness and market presence. Leveraging my expertise in analytics tools and methodologies, I delivered insights that informed targeted engagement strategies and optimized marketing initiatives.Key Contributions and Achievements:• Market Research and Analysis: Conducted in-depth market analyses and customer behavior studies, utilizing advanced analytics to identify trends and opportunities for growth.• Brand Awareness: Implemented data-driven marketing strategies that resulted in a 60% increase in brand awareness, employing A/B testing and analytics to refine and target marketing efforts effectively.• Customer Retention: Analyzed customer data to develop targeted engagement strategies, successfully reducing the churn rate by 40% through personalized marketing campaigns.• Market Expansion: Identified and capitalized on new market opportunities, leading to a 70% boost in targeted market shares by leveraging data insights to guide market entry and product positioning strategies.• Data-Driven Decision Making: Utilized analytics to optimize product pricing and promotions, enhancing revenue growth and competitive market positioning.• Collaboration and Reporting: Worked closely with the marketing team to ensure strategies were aligned with business goals, providing regular insights and reports to stakeholders to inform decision-making.

Karaj, Alborz Province, Iran

In my role as an IT Instructor at the Tehran Institute of Technology, I had the privilege of teaching and guiding future IT professionals. I was responsible for delivering courses across a range of topics, from programming fundamentals to database management, with an emphasis on practical skills and real-world applications.Responsibilities and Contributions:• Course Development: Developed course material for IT subjects, aiming to make complex concepts accessible and engaging for students. My goal was to align the curriculum with current industry practices and technological trends.• Practical Skill Building: Prioritized hands-on learning to enhance students' understanding of programming, data analysis, and database management, preparing them for the challenges of the tech industry.• Interactive Teaching: Created an environment that encouraged interactive learning, using projects, coding exercises, and collaborative tasks to foster critical thinking and problem-solving abilities.• Support and Guidance: Offered support and guidance to students, assisting them with academic challenges and advising on project work and career development.• Continuing Education: Organized workshops on new technologies and IT concepts to keep both myself and my students informed about the latest developments in the field.Teaching at the Tehran Institute of Technology was a deeply rewarding experience, offering me the opportunity to contribute to the education and development of aspiring IT professionals. My focus was always on enabling students to explore their interests, develop their skills, and achieve their career goals in information technology.

Tehran, Iran

During my co-op tenure as a Database Developer at the Telecommunication Company of Iran (TCI), I had the opportunity to apply my academic knowledge to real-world database design and optimization challenges. This role was pivotal in my development, offering hands-on experience in managing, optimizing, and safeguarding database systems.Learning and Contributions:• Practical Database Design: Engaged in designing scalable and efficient database structures, gaining practical experience in balancing operational requirements with system performance.• Optimization Techniques: Applied normalization and query optimization techniques to reduce data redundancy and improve performance, enhancing my understanding of database efficiency.• Advanced Query Development: Crafted complex T-SQL queries for data analysis and reporting, contributing to my growth in data manipulation and extraction skills.• Collaborative Projects: Collaborated with IT and development teams, providing database support for application development and operational needs, which enriched my teamwork and technical communication skills.• Data Management Best Practices: Learned the importance of data integrity and security, implementing strategies to ensure reliable and secure data handling within the organization's database systems.This co-op position was not only a significant learning experience but also a chance to contribute meaningfully to TCI’s data management practices. It honed my technical abilities, problem-solving skills, and understanding of the critical role of databases in organizational infrastructure.

Tehran, Tehran Province, Iran

Founder and CEO of TestHub, a crowd testing app for web/mobile applications that can test everything from Usability to Bug Detection

Tehran, Iran

In my role as a Web Developer at Persian Web Hosting, I was responsible for the end-to-end development of web applications, showcasing my full-stack development capabilities. My tasks ranged from database design and backend development to crafting user-friendly frontends.Key Responsibilities:• Full-Stack Development: Led the development of web applications, implementing both backend logic and frontend interfaces, ensuring a seamless user experience.• Database Design: Engineered and managed databases, ensuring efficient data storage and retrieval.• User Interface Design: Created intuitive and responsive user interfaces, focusing on usability and aesthetic appeal.• Technical Problem-Solving: Addressed and resolved technical challenges, enhancing website functionality and performance.

Master Of Engineering - Meng, Computer Software Engineering, 4/4

Bachelor Of Software Engineering, Computer Software Engineering, 3.8/4

Diploma, Mathematics