Jonathan Villapando Email & Phone Number

United States

El Segundo

• Analyze performance of CRM marketing & promotional programs and provide recommendations on optimization measures
• Track and report success of all direct mail and boxstuffer print catalog programs
• Track health of customers based on cohort and lifecycle; help drive strategy for lifecycle optimization
• Glean large data sets of transactional information for key patterns and customer segments that inform marketing tactics and personalization strategies
• Assist… Show more
• Assist email team with analyzing and deriving insights from email marketing metrics for weekly and monthly recaps

Greater Los Angeles Area

• Develop, troubleshot and deliver ongoing and ad hoc CRM/database reports by pulling through SAS/SQL programming and partnering with external vendors.
• Communicate and partner with internal BI team to develop customer dashboards across multiple dimensions including (but not limited to): value tier, geography, merchandise, category, basket analysis, channel behaviors.
• Manage internal and external data logistics… Show more
• Manage internal and external data logistics, including data transfers and requests.
• Partner and strategize with customer service and external vendors to ensure the on-going maintenance, hygiene, and accuracy of the CRM database, and investigate and resolve issues as they arise.
• Pull customer lists for direct mail program through SAS/SQL programming and QA data as needed.

Greater Los Angeles Area

Westlake Village

• Conduct complex database research projects, simulations and advanced data mining on large transactional databases
• Assist with the development of recommendations, tactics and future testing based on analyses
• Extract data from the company’s core business intelligence database using SQL or other methods and perform analysis that results in actionable business insight, in support of key business initiatives
• Support all analysis activities that fall under the CRM group… Show more
• Support all analysis activities that fall under the CRM group, which includes campaign analysis including ROAS, break-even analysis, developing predictive CRM models, determining effectiveness of pilots and promotions.
• Pull together a presentation ready PowerPoint deck with key findings and recommendations from raw data extracted from database

Chatsworth, CA

• Organize and analyze weekly e-mail performance. Provide recommendations and insight in regards to improvement trends, under-performing campaigns, and opportunities for improvement.
• Pull and organize any ad hoc data requests. Examples include comparisons of past marketing campaigns, designing a structure for new reports, and creating pivot charts/flow charts to more easily read complex data and.
• Develop and coordinate A/B testing for e-mail campaigns. Organize the… Show more
• Develop and coordinate A/B testing for e-mail campaigns. Organize the data and clearly report on the results of the test. Provide actionable recommendations based on the findings.
• Identify and implement process improvement methods for organizing regular data reports and summaries.
• Manage production of all e-mail campaigns (across four Lamps Plus channels) and e-catalogs to ensure effectiveness, high quality, and accuracy while making certain that all deadlines are met.

San Francisco, CA

• Developed and implemented strategies for obtaining new clients through telephone, direct mail and e-mail marketing
• Cultivated and maintained long-term relationships with customers through consultative selling approach
• Defined and initiated projects as well as coordinated external receivables while managing costs, schedule, and performance
• Improved online presence through search engine optimization for over 45 clients within 3 months of contract initiation and… Show more
• Improved online presence through search engine optimization for over 45 clients within 3 months of contract initiation and achieved over 400 separate organic Google page 1 rankings
• Presented data reports and summaries of site performance and ROI using Google Analytics, Google Adwords, and additional SaaS Show less