Mario Chavez Email & Phone Number

San Francisco, Ca, Us

San Jose, Ca, Us

San Francisco, California, Us

• Utilized Python and SQL for comprehensive data analysis, translating data into actionable strategies that successfully influenced organization-wide updates in creative best practices.• Focused on maximizing learning opportunities and delivering actionable insights to refine future marketing strategies, using a blend of analytical tools and methodologies.• Enhanced data visibility and accessibility for the team and stakeholders through advanced data visualization tools like Tableau or Superset, improving decision-making processes.• Actively shared insights and findings with cross-functional partners, influencing key decisions and strategic planning, ensuring data-driven accountability and effective decision-making at all levels.• Collaborated with cross functional teams on strategic priorities for annual planning and beyond, focusing on turning pinner lifecycle education vision into reality. Continuously evolved the role to drive success using advanced analytical techniques.

Santa Clara, Ca, Us

• Supported audience creation for outbound marketing campaigns, including email, push, SMS, and in-App notifications. Leveraged behavior based and modeled targeting to manage a segmentation methodology that drives strong engagement, offers relevant personalization, and maintains channel health.• Partnered closely with marketing and other teams across the organization to help identify impactful business problems, translate them into structured analyses, reports, and provide actionable insights and recommendations to a wide audience, including senior business stakeholders and company-wide execs.• Built dashboards for scalable monitoring, utilizing Tableau or Amplitude, to conduct trend analysis on marketing metrics, especially relating to driving campaign revenue, campaign performance and customer retention• Defined metrics instrumentation and wrote SQL scripts for Marketing Onsite and In-App campaigns• Built SQL scripts and ETL processes to analyze data or automate routine data collection and reporting processes to provide precise reports to stakeholders• Pull audience lists for targeted marketing campaigns using SQL queries and automation tools• Provided actionable insights by delivering clickstream analysis, outcomes analysis, search analysis, trend analysis, customer segmentation• Conducted A/B tests to guide strategy and operational decision-making for different marketing projects• Performed exploratory data analyses with Python, generated and tested working hypotheses to build and define solutions to solve business problems uncovering trends and relationships• Applied technical skills using Analytics Software, Tableau and SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner• Partnered with marketing and other teams to forecast conversion funnels performance, analyzed issues/opportunities within conversion funnels

Seattle, Wa, Us

• Provided actionable insights to help stakeholders make better business decisions by means of robust reporting and interactive visualizations• Built and automated SQL scripts that executed precise weekly reports for managers• Analyzed large datasets using, SQL and other internal analicts tools, to discover patterns of risks, abuse and help reduce bad debt• Effectively communicated actionable insights to optimize buyer abuse prevention within the ‘Try Before You Buy’ product• Collaborated with cross-functional groups (Engineering, Policy Development, Support, Legal, and other Trust and Safety Enforcement teams) to deploy innovative processes and policies to address abuse new vectors• Ran weekly direct marketing campaign insights. Evaluated what is working and what is not with goal setting/forecasting for benchmark analysis• Wrote SQL queries to filter large datasets by multiple, complex conditions and evaluate query efficiency• Identified improvement opportunities on purchase funnel by monitoring existing metrics, analyzing data, and partnering with cross functional teams leading to an increase in purchases made• Performed exploratory data analysis with Python, generated and tested working hypotheses to build and define solutions to solve business problem uncovering trends and relationships• Developed data pipelines in and out of data warehouse using combination of SQL and Python

Dublin, Ca, Us

• Designed, developed, and maintained Business Applications, communicating with cross-functional teams regarding product and design• Designed and developed automated reporting solutions to surface potential gaps of existing mechanism and support data-driven decisions• Analyzed performance, including performance for Lifecycle Marketing, for in-product marketing channels, notifications and emails. • Identified ways to improve click-throughs, downstream engagement, and more.• Designed dashboards and reports utilizing Tableua and PowerBi to communicate meaningful metrics for senior executives• Provided automated and self-service reporting solutions and developed data visualizations for stakeholders.• Performed hands-on coding to retrieve and analyze large datasets using SQL and Python• Provided user requirements analysis, design, and programming support for enhancement of Web applications• Provided training and detailed documentation for new systems and applications across multiple departments

San Francisco, California, Us

Vancouver, British Columbia, Ca

Data Science

Bachelor Of Science - Bs, Computer/Information Technology Management

Associate Of Science - As, Business Administration And Management, General