Sergio Mercado

  • La Grange US-IL
Sergio Mercado

Work History

Work History
Nov 2009 - Jan 2011

Sales and Marketing Associate

Coughlan Companies, dba Heinemann-Raintree Publishing
Jan 2007 - Nov 2009

Pre-Press Coordinator

Pearson Education, dba Heinemann-Ranitree Publishers

Used Adobe Illustrator, InDesign and Photoshop to conceptualize, design, and deploy custom sell kits and brochures; supported two Senior Graphic Designers in catalog layouts and general print advertising design; assisted in managing vendors. • Increased revenues in weak performing territories by 15% YoY through the execution of custom marketing materials for sales representatives. • Supported national projects initiated by the marketing manager including catalogs, brochures, ads, email marketing campaigns, and website graphics. • Assisted in ad-hoc sales reporting and marketing research projects such as competitor reviews, territory funding analysis and supporting month end sales reporting.

May 2005 - Jan 2007

Sales Support Coordinator

Reed Elsevier, dba Heinemann-Raintree Publishers

Supported three National Sales Managers and 90+ independent sales representatives by providing regular sales reports, processing monthly commissions, and working on ad-hoc market and product research initiatives. • Utilized advance Excel formula techniques to decrease processing time of monthly dealer commissions by 75%. • Generated an 8% increase in specific regional territories by leveraging Microsoft MapPoint and mapping Excel territory data to visually track dealer and product sales. • Traveled to national dealer training conference to provide training support.

Marketing Specialist

Aug 2003 - May 2005

Graduate Assistant

Illinois State University
  • Provided technology hardware and software support to faculty, staff and students.
  • Independently managed College of Arts and Sciences IT office, laboratory, and student staff.

Education

Education
Aug 2009 - May 2010

Certificate of Web Development and Design

Illinois Insitute of Technology
Aug 2003 - May 2005

Master in Arts

Illinois State University
MA, Political Science

2003 – 2005

Activities and Societies: • Pi Sigma Alpha National Political Honors Society, Kappa Sigma Chapter (2005) • Committee Secretary, College of Arts and Sciences Curriculum Committee (2004/2005) • Editorial Board, Illinois State University’s Critique: Journal of Political Science (2004/2005) • Graduate Assistant, College of Arts and Sciences, Graduate Study Fellowship (2003-2005) • Chairperson, Illinois Conference for Students of Political Science (2004)

Aug 2001 - May 2003

Bachelor of Arts

Illinois State University
  • Interned with the Peruvian Truth and Reconciliation Commission in Lima, Peru (2002) http://www.cverdad.org.pe/ingles/pagina01.php

Skills

Skills

Catalog Development

I have managed catalog production schedules, managed vendor relationships, organized the catalog data within Excel from product databases and led a team of 2 designers, freelance proofreader and in-house content writer. I can also work on layout and template design leveraging my InDesign skills.

Trade Show Marketing

I have been responsible for organizing kick-off strategy meetings, ordering furniture and carpet, organizing logistics and coordinating promotions for 15 total trade shows for booth spaces ranging from 10ft to 40ft in size. I have extensive travel experience to all of the major convention cities including Orlando, Anaheim, San Antonio, Houston, New Orleans, Atlanta, New York City, Boston and Chicago.

Email Marketing

I am passionate about website design trends, social media, SEO, SEM. I am certified through the Illinois Institute of Technology in Web Development, and am currently offering my insights to help companies engage their customers online. + Social Media marketing + Email marketing + SEO/SEM

Google AdWords

I am passionate about website design trends, social media, SEO, SEM. I am certified through the Illinois Institute of Technology in Web Development, and am currently offering my insights to help companies engage their customers online. + Social Media marketing + Email marketing + SEO/SEM

Search Engine Optimization

I am passionate about website design trends, social media, SEO, SEM. I am certified through the Illinois Institute of Technology in Web Development, and am currently offering my insights to help companies engage their customers online. + Social Media marketing + Email marketing + SEO/SEM

Microsoft Word

Proficient at using Mail-Merge from Excel and outputting print jobs for labels and envelopes.

Microsoft Power Point

Excellent at designing presentation templates.

Microsoft Excel

I can do most everything you can expect Excel to output--any method you need your data sliced and diced I can get it done. I am especially adept at using "Look up & Reference", "Date", "Logical" and "Text" formula groupings. Especially skilled at organizing data, and merging spreadsheet info using VLOOKUP and SUMIF. Also adept at Pivot Tables.

CSS

My code is standards compliant, always validated and supported in IE7-8, Safari, Firefox and Chrome. Both my CSS and XHTML are clean and minimized, using the least amount of code possible, making for smaller file sizes, easier updates and quicker downloads. The use of alt tags, title tags and proper meta ensures accessibility standards, good SEO and keyword rankings.   Please see http://www.sergiomercado.com for coding examples.

HTML/XHTML

My code is standards compliant, always validated and supported in IE7-8, Safari, Firefox and Chrome. Both my CSS and XHTML are clean and minimized, using the least amount of code possible, making for smaller file sizes, easier updates and quicker downloads. The use of alt tags, title tags and proper meta ensures accessibility standards, good SEO and keyword rankings.   Please see http://www.sergiomercado.com for coding examples.

Adobe Photoshop

Experienced using Photoshop for both print design work, as well as website design of templates.

Adobe InDesign

Used in print design and production. I have extensive design experience working within InDesign--catalogs, creating brochures and other direct mail collateral.

Adobe Illustrator

Used for designing web elements.

Summary

Thank you for viewing my profile, please let me know if I can be of assistance to you by connecting with me. I am a versatile, proactive marketing specialist with a background in direct marketing: + B2C product catalog development and distribution + B2C direct mail design and distribution + email marketing + trade show marketing planning and execution + print and online advertising I am experienced in report writing, market/competitor research and am currently offering my talents as a Web Marketing Consultant through the Sergio Mercado design studio, www.sergiomercado.com I am passionate about website design trends, social media, SEO, SEM. I am certified through the Illinois Institute of Technology in Web Development, and am currently offering my insights to help companies engage their customers online. + Social Media marketing + Email marketing + SEO/SEM I have high academic achievement with an advanced degree in International Relations, multiple marketing focused certifications, excellent interpersonal skills and conversant in Spanish. I relish the opportunity to learn something new and readily face challenges head-on. My peers would describe me as selfless and someone who is willing to put in extra hours to learn more efficient methods of handling tasks or just get a project completed.

Specialties

+ B2C direct marketing + Product catalog development + Trade show marketing + Advanced data mining and report writing + Email marketing + HTML template coding + Designing websites templates in Photoshop + Adobe Creative Suite CS3/4 (45+ hour certificate) + XHTML, CSS, Jquery (90+ hour certificate) + Studying for Google AdWords certification through the Google Engage program (1/2011) + Developing freelance SEO strategies for small business to gain experience and knowledge (1/2011)

Objective

Multi-disciplined, solutions-focused sales and marketing professional leverages an ever-expanding portfolio of qualifications covering direct marketing, email marketing, and trade show marketing. Further experiences include report writing, conducting market research, graphic and website design as well as emerging media, SEO and SEM. Seeks regular full-time employment within an agency or corporate marketing communications department.

Interest

Direct Marketing Specialist | Web Designer | Social Media & SEO Enthusiast | Web Marketing Consultant | @samerca

Certifications

Certifications
Aug 2009 - May 2010

Web Development and Design

Illinois Institute of Technology