Master Data Manager

• Mar 2023 - Present

Analytics Team Lead

• Apr 2022 - Present

I am a Digital Marketing Analyst at Effective Marketing Communication Inc, where I play a pivotal role in taking our organization to the forefront of data-driven and statistically modeled media planning, buying, and measurement. With a strong focus on marketing statistics, I contribute to all aspects of our media agency offering, aiming to make marketing investments with precision and control that transform them into strategic investments rather than mere expenses. By analyzing business challenges and uncovering consumer, brand, and channel insights. In my role, I develop robust statistical models that provide valuable insights into optimal investment levels in working media, helping us conduct stable tests of media channels, audience targeting strategies, ad placements, and creative versions. By identifying the weakest stages of the consumer journey, I determine the areas that require the most investment to enhance customer engagement and drive conversions. Additionally, I forecast potential sales lift and Return On Investment (ROI) for recommended media plans, while also analyzing the performance of different combinations of channels, audience targets, ad placements, and creative versions. Integrated marketing communication planning and test design are at the core of my responsibilities. I delve into each client's goals, markets, needs, and expectations, enabling me to develop comprehensive strategies that align with their unique requirements. From managing testing and sales forecasting to conducting attribution analysis and ROI measurement, I leverage various tools and techniques to deliver accurate insights and actionable recommendations. Additionally, I contribute to the development of performance reports, showcasing campaign performance drivers, recommended optimizations, and key findings to guide decision-making. Let's connect and discuss how I can contribute to driving your marketing initiatives forward with data-driven precision and impactful insights. Show less

Web Analyst

• Mar 2017 - May 2023

www.StrawHutMedia.com In my role as a Web Analyst, I successfully contributed to the growth and success of Straw Hut Media by leveraging my expertise in PHP development and data analysis. Key responsibilities and achievements include: PHP Development and Website Optimization: I utilized my PHP development skills to edit templates of WordPress websites and advanced plugins, ensuring seamless integration of new designs and project updates. By launching projects and product funnels with prototype-to-production landing pages in under a week, I significantly increased taproom and liquor store sales for Mother Earth Brewing. Data Analysis and Reporting: As the company transitioned to content production, I actively participated in forecasting and generating reports using tools like DataStudio. I created comprehensive reports on podcast statistics, enabling us to provide valuable insights to our advertisers. Additionally, I developed and maintained dashboards to display social media ad campaigns and track impressions of social media posts. Python Scripting and Data Transformation: I wrote Python scripts to extract and transform data from the Megaphone API, specifically focusing on podcast download data. This allowed for the production of detailed dashboards that provided the sales team with daily data and geolocation insights for 27 unique podcasts, comprising over 2,000 shows. These dashboards proved instrumental in targeting niche and specific advertisers effectively. Throughout my tenure, I demonstrated strong analytical skills, expertise in search engine optimization (SEO), PHP development proficiency, and data visualization capabilities. By effectively optimizing websites, providing valuable data insights, and leveraging scripting capabilities, I contributed to the overall success and growth of Straw Hut Media. Show less

Analytics Developer

• Jan 2020 - Jan 2023

As an Analytics Developer at Solvd, Inc., involved working at Google as part of the TVC program. Here are the key responsibilities and accomplishments:Data Cleansing and Record Keeping: Collaborated with a cross-functional department to perform data cleansing efforts, improving record keeping and identifying areas of slowdown. These efforts included building Gantt charts and implementing alert notifications to ensure data accuracy and efficiency.Forecast Comparison and Supply Planning: Developed forecast comparison tools and supply planning dashboards to visualize and analyze data at various levels, including hourly, monthly, quarterly, and annual reporting. These tools provided insights into geolocation breakdowns and other relevant flags. The scope of the data covered large hourly datasets for all grids spanning 40-60 years into the future.Technical Skills: Utilized tools such as Looker, Google Data Studio, Google BigQuery, and Python for data analysis and reporting. Proficiency in these technologies enabled effective handling of big data analytics and data visualization tasks.In this role, I contributed to improving data quality, streamlining processes, and providing valuable insights to support decision-making and planning efforts.By leveraging my skills in data analysis, visualization, and programming, I played a key role in driving efficiency and accuracy in analytics processes at Solvd, Inc. Show less

Technical Program Manager

• Dec 2018 - Feb 2020

solvd.comAs a Technical Program Manager at Solvd, while working at Google (TVC), I undertook the following responsibilities:Data Cleanup and Record Keeping: Led data cleanup efforts across multiple teams within the department, improving record-keeping practices and identifying areas of slowdown. These efforts aimed to enhance data accuracy and integrity, enabling more informed decision-making.Web App Development: Collaborated with a team to develop a web application that generated stable reports. Emphasizing a user-centric design approach, the app facilitated seamless data intake and improved data management processes.Forecast Comparison and Supply Planning: Developed forecast comparison tools and supply planning dashboards to support the construction and deployment of physical sites. Oversaw the entire process from ideation to completion, ensuring accurate tracking and effective resource allocation.Throughout this role, I leveraged my technical expertise in Python and data analysis to drive successful outcomes. I actively participated in Agile development methodologies and contributed to scripting and automating reporting tasks. Utilizing tools such as Google SQL, BigQuery, DataStudio, and Tableau, I provided valuable insights and supported efficient project planning and execution.Working at Google (TVC) within the Technical Program Manager capacity, I played a pivotal role in enhancing data management practices, improving reporting capabilities, and streamlining supply planning processes, ultimately contributing to the overall success of the department and the organization as a whole. Show less

SEO Analyst

• Jul 2018 - May 2020

mahon.media As an SEO Analyst at Mahon Media, LLC, I played a crucial role in enhancing the online presence and performance of client websites. Conducted comprehensive site audits of SEO and advertising campaigns to evaluate their effectiveness. Offered insightful suggestions and recommendations for optimizing campaigns and implementing new features to drive better results. Developed a strategic roadmap and established best practices for web standards to maximize the visibility and reach of client websites. Utilized Google Analytics and other relevant tools to track website performance and gather actionable data for optimization. Collaborated with cross-functional teams to ensure alignment and implementation of SEO strategies. Stayed updated with the latest industry trends and search engine algorithms to adapt strategies accordingly. By leveraging my expertise in Google Analytics and search engine optimization (SEO), I contributed to improving website rankings, increasing organic traffic, and driving better overall performance for our clients. Overall, my contributions as an SEO Analyst at Mahon Media, LLC played a vital role in optimizing websites and driving online success for our clients. In this role, I demonstrated strong analytical skills and a deep understanding of SEO principles, enabling me to deliver effective recommendations and achieve tangible results. Show less

Technical Program Manager

• Dec 2018 - May 2019

qaprosoft.com As a Technical Program Manager at Qaprosoft, working on a contract basis, I had the opportunity to contribute to projects while collaborating with Google as a TVC (Temporary, Vendor, Contractor). My responsibilities and accomplishments in this role include: BI Tools Project Planning: I played a key role in utilizing metrics, financials, and geolocation data to guide the department through their upcoming work. By leveraging my expertise in BI tools and project management, I facilitated effective planning and decision-making processes. Agile Development and Reporting Automation: I actively participated in Agile Development methodologies, ensuring efficient and collaborative project execution. Additionally, I utilized scripting and automation techniques to streamline reporting processes, saving time and increasing productivity. Proficiency in GoogleSQL, Big Query, DataStudio, and Tableau: I leveraged my technical skills to work with various tools and platforms, including GoogleSQL, Big Query, DataStudio, and Tableau. These technologies enabled me to analyze and visualize data, providing valuable insights and supporting data-driven decision-making. Throughout my contract engagement, I demonstrated my proficiency in Python programming language and showcased my understanding of data centers. In this role, I successfully contributed to project planning, execution, and reporting, leveraging my technical expertise and program management skills. Show less

Forecast Analyst

• Jan 2018 - Sep 2018

As a Forecast Analyst at FreshRealm, I held a pivotal role in managing the master data of a MySQL Database containing information for over 600 SKUs. This involved supplier details, nutrition and allergen information, as well as establishing a parent-child relationship to build meal assignments. Additionally, I collaborated with the business development and client forecasting teams to input daily expected order quantities for each meal. Key accomplishments and responsibilities in this role include: Automating Order Management and Inventory Control: Utilizing AppScript and Google Sheets, I developed an automated system to manage outgoing order amounts and inventory counts across eight food processing plants. This resulted in a significant reduction in product shortages, decreasing from 50% to 30%. By updating and sharing more accurate data through user-friendly dashboards, non-technical employees gained real-time visibility into inventory levels, fostering better decision-making and improved coordination between departments. Streamlining Data Transformation and Documentation: I transformed master data for seamless import into SAP Business One, ensuring accurate and efficient integration. Additionally, I authored comprehensive Standard Operating Procedures (SOP) for the department, documenting inventory processes and spoilage/waste procedures. This increased transparency and established stricter controls for highly valuable SKUs. In this role, I leveraged my proficiency in Microsoft Excel, analytical skills, and statistical knowledge to drive data-driven insights and optimize forecasting accuracy. By implementing these initiatives, I contributed to improved operational efficiency, reduced product shortages, and enhanced interdepartmental collaboration, ultimately supporting FreshRealm's goals and delivering value to the organization. Show less

Founder

• May 2011 - Jun 2018

As the owner of my own business, I gained invaluable insights and experiences that surpassed my previous roles as an employee. Throughout this period, I focused primarily on providing web development and marketing consulting services. Here are some key aspects of my work: Promoted clients' marketing campaigns to target a younger audience and early starters, ensuring their message resonated with the intended demographic. Developed both static and WordPress websites with e-commerce solutions, creating engaging online experiences for clients and optimizing web pages for improved search engine visibility and social media presence (including Twitter, Facebook, Instagram, and Foursquare). Utilized various analytics platforms, including Google Analytics, Facebook Analytics, Twitter Analytics, and local economic and demographic data, to build comprehensive dashboards and key performance indicators (KPIs) for e-commerce and marketing efforts. This allowed clients to track and measure the success of their campaigns effectively. Successfully freelanced on individual projects and provided consulting advice to clients during this period, offering my expertise in web development and marketing strategies. Notably, during my full-time work phase at MassRoots, I achieved a significant accomplishment by securing an almost full weekend booking for eight months for Birthday Party events at the local laser tag arena. This demonstrated my ability to drive business growth and generate successful outcomes for clients. Overall, as a freelance web developer and marketing consultant, I honed my skills, navigated business partnerships, and delivered impactful solutions to clients, contributing to their online presence and marketing success. Show less

Produce Recovery Manager

• Sep 2013 - Mar 2017

As a Produce Recovery Manager at Food Share of Ventura County, I was responsible for organizing volunteers to harvest and rescue almost 650,000 pounds of produce valued at five million dollars. In addition to this, I sourced another 2.4 million pounds of produce from packing houses, local ports, neighborhoods, and farmers. One of my key achievements in this role was creating and managing our database of donors. I used GSuite (Google Sheets, Slides, and Docs) to create automated reports that helped us better target opportunities to the right picking seasons and ensured that volunteer opportunities yielded the most for those in need. This level of detail and insight brought my average wait time from 2 months down to 2 weeks or less, maximizing the yield from as many donors as possible and creating more opportunities weekly for volunteers of all availabilities to get involved in the community. I also developed a route sheet that printed turn-by-turn directions and provided donor history to the driver for when cellular reception was limited. To accomplish this, I primarily used open-source AppScript that guided volunteers with Maps API and the database I had built. In addition, I built web-based forms and applications for volunteer and donor information. This expedited the turn around by prioritizing picks, produce, and volunteers that were available. It's worth noting that I accomplished all of these tasks with no budget other than printer fees. Show less

Sales and Catering Analyst

• Jul 2012 - Sep 2013

As a Sales and Catering Assistant & E-Marketing Coordinator, I played a vital role in promoting hotel services and facilities to prospective clients, while providing support to senior sales and catering managers in their day-to-day activities.Utilized the Knowland Insight product to solicit appointments and developed “Warm” sales calls for sales managers in geographic regions. Developed a deep understanding of the hotel's past events, analyzed the data to identify key trends, and used the insights to target the right customers for maximum room occupancy.Cataloged past profitability and customer experiences to create call objectives for sales and catering managers, leveraging a MySQL DB to query specific industries and group sizes per the upcoming supply of hotel rooms. This enabled us to maximize the profitability of booked events and ensure excellent customer satisfaction.Designed and maintained a hotel website (WordPress), increasing usability and traffic, and replying to online reviews to remedy issues of hotel guests. I optimized the load time of the hotel website for both desktop and mobile sites, created blog content about local attractions, and managed a local calendar to optimize SEO for localized results leading to the Crowne Plaza Ventura Beach becoming the top result in both ads and organic results for high-value queries.Assisted all departments with software and hardware technology questions and implemented fixes or recommendations for correction or enhancements. Provided IT support for Banquet customers and analyzed on-site internet issues to offer assistance in problem resolution. Assisted in on-site inspections requiring substantial Internet/audio-visual capability to help close local meetings for the Catering Managers or tech-heavy conventions for the Sales.Overall, my strong communication skills, attention to detail, and ability to work collaboratively with teams enabled me to make valuable contributions to the sales and catering team. Show less

Sales And Marketing Intern

• May 2012 - Jul 2012

As a Sales Intern, I gained hands-on experience in promoting hotel services and facilities to prospective clients, supporting senior sales managers in their day-to-day activities. I learned how to develop and maintain customer relationships, and provided excellent customer service throughout the sales process.During my internship, I helped organize and participate in sales presentations and property tours, developing a deep understanding of the hotel's features and benefits. I also collaborated with the marketing team to develop promotional materials and social media campaigns, contributing to the hotel's overall marketing efforts.Through my enthusiasm and strong communication skills, I consistently exceeded expectations and made valuable contributions to the sales team. As a result, I was offered a full-time role and continued to make an impact in my subsequent positions.Assist all department with software and hardware technology questions and implement fixes or recommendations for correction or enhancements. Assist the Banquet Department in audio visual and internet issues for our customers. Assist operations and 3rd party IT company with analysis and on site assessments of internet issues and offer assistance in problem resolution. Assist on site inspections requiring substantial Internet/audio-visual capability to help close local meeting for the Catering Managers or tech-heavy conventions for the Sales Mangers.Utilize analytic tools to measure the results of E-Marketing Promotions and campaign effectiveness and sales conversions. Create a rich content photo and video library for use in advertising, banner creation, VBrohure "Pushes" and press releases.I was successful as an Intern that was brought on to work fulltime. Show less

Senator of the Arts & Marketing

• Aug 2011 - Jun 2012

As Senator of the Arts & Marketing at CSU Channel Islands, I was responsible for enhancing the university's image and engaging its mostly commuter student population. My main objective was to connect with students and address their concerns about entering the professional world. I created and executed successful online campaigns on social media platforms such as Facebook and Twitter, highlighting opportunities for jobs, scholarships, volunteering, and community engagement. These campaigns helped to spread awareness about relevant school and political activities, especially during a time when students were still grappling with economic concerns from 2008. To provide an anonymous platform for students to share their problems and suggestions, I set up an online communication system. This was particularly useful since many students had varying schedules and were unable to attend in-person meetings or events. To foster a more active and engaging campus community, I also worked on organizing clubs and organizations. Our efforts resulted in the implementation of a weekly "University Hour," during which no classes were scheduled, and large auditoriums and halls were available for clubs, career development opportunities (such as resume building, networking, and skill classes), and sports and athletic activities. Overall, my time as Senator of the Arts & Marketing at CSU Channel Islands demonstrated my ability to connect with students and enhance their experiences on campus. I effectively led and organized events, campaigns, and online communication platforms, while addressing the concerns of the student population. Show less

Social Media Associate

• Apr 2011 - Feb 2012

As a Social Media Associate at Haley and Associates, I carried over accounts from my previous employer, SocialMash Media, and maintained the same relationships with those companies within the new office. After SocialMash Media was acquired by a client I had helped, I joined a team of 2 content producers and 3 creatives (Graphic Designers and Photographers) to help with their expansion from one location to 4 locations in Central California. In my role, I managed 10 client accounts, tracked analytical data, and produced content. This led to a managerial role where I became the point person for both the clients and Haley & Associates. Working closely with my team, I effectively led the transition and addressed the concerns and wishes of our clients. We presented ideas and feedback on new projects directly to the client. During my time at Haley and Associates, we saw similar growth in metrics and traffic to clients' sites and e-commerce portals, as we had at SocialMash Media. I also trained one member of the team in project management to ensure effective team management and consistency in the SOPs I had written. Additionally, I was responsible for vetting influencers to increase the effectiveness of reaching new audiences. Overall, my experience as a Social Media Associate at Haley and Associates allowed me to further develop my managerial and team-building skills, as well as refine my social media strategy and data analysis capabilities. Show less

Social Media Intern

• Aug 2010 - Apr 2011

As a Social Media Intern at SocialMash Media, I was responsible for creating and automating social media content for 6 clients across Twitter, Facebook, and Foursquare. This involved writing up to 60 posts per day across all accounts, while balancing my junior class work. To streamline this process, I used tools such as HootSuite and website-specific platforms to track and aggregate data into spreadsheets. I also wrote macros in Excel to automate the tracking and analysis of social media impact, reducing the monthly effort from 10 hours to just 2-3 hours. On average, over 50% of the web traffic to our clients' sites was generated through social media, and some of our most viral posts brought in over 100k impressions for just Facebook alone. I worked independently as well as within a team to complete necessary tasks. When my schedule had to change due to finals week, I delegated and logged my job tasks to ensure a smooth transition. As the social face and online presence for our clients, I also monitored specific forums to answer questions and provide documentation for products that were over 8 years old and not available on their websites. Using this feedback, we updated their help pages and used the new links to drive traffic back to their websites, resulting in an increase in support sales. Overall, my experience as a Social Media Intern at SocialMash Media gave me valuable skills in content creation, data analysis, and customer engagement that I continue to use in my career today. Show less