Developed and Engineered Queries: I created and optimized SQL queries to extract key company metrics, such as sales trends and customer demographics, which were crucial for strategic decision-making.
Researched possibilities to extrapolate the findings of queries that organized the upcoming reminders in the company database to send automated emails reminding customers of their upcoming events
Template Design: Designed and implemented email templates for our campaigns, including reminder emails that aligned with our brand’s voice and aesthetics.
<mjml> <mj-head> <mj-font name="Lato" href="https://fonts.googleapis.com/css2?family=Lato:wght@400;700&display=swap"/> <mj-font name="Patrick Hand" href="https://fonts.googleapis.com/css2?family=Patrick+Hand&display=swap"/> <mj-style> .logo-img { width: 300px; /* Fixed width for desktop which should be half of typical email body width */ } .text-logo-img { width: 70%; /* Adjust to maintain design balance */ } </mj-style> <mj-attributes> <mj-all font-family="Lato, sans-serif"/> <mj-text font-size="16px" line-height="1.6" color="#000000"/> <mj-table font-size="14px" color="#000000"/> <mj-button inner-padding="15px 30px" border-radius="4px" background-color="#000000" color="white" border="1px solid #000000"/> <mj-social font-size="15px" icon-size="30px" mode="horizontal"/> </mj-attributes> </mj-head> <mj-body background-color="#FFFFFF"> <mj-section padding="0"> <mj-column> <mj-image src="https://www.quillandpigeon.com/logo.png" alt="Quill & Pigeon Logo" width="300px" css-class="logo-img"/> <mj-image src="https://www.quillandpigeon.com/logo-typewriter-black.png" alt="Quill & Pigeon Text Logo" css-class="text-logo-img"/> <mj-divider border-color="#000000" border-width="1px" padding-top="10px"/> </mj-column> </mj-section> <mj-section border="2px solid #000" padding="10px 20px"> <mj-column> <mj-text padding-bottom="10px"> <h1>Hi {{userName}}</h1> <p>Welcome to Quill & Pigeon, and thank you for letting us be part of the moments that matter in your life! 🌟</p> <p>We noticed you have an important date coming up:</p> <ul> {{#each reminders}} <li><b>{{recipientName}}’s {{eventName}}:</b> Coming up on {{eventDate}}! Just {{eventDaysOut}} days away!</li> {{/each}} </ul> <p>We’re excited to help you celebrate these occasions with some handcrafted greeting cards from Maine.</p> </mj-text> <mj-button href="https://www.quillandpigeon.com" align="center"> Visit our site </mj-button> <mj-text> <p>To ensure our card selections match their taste, could you share a little about their preferences? Do they have favorite animals, colors, or hobbies? Feel free to simply reply to this email with any details you think might help!</p> </mj-text> <mj-social icon-size="30px" mode="horizontal"> <mj-social-element name="facebook" href="https://facebook.com/yourpage"></mj-social-element> <mj-social-element name="twitter" href="https://twitter.com/yourpage"></mj-social-element> <mj-social-element name="instagram" href="https://instagram.com/yourpage"></mj-social-element> </mj-social> </mj-column> </mj-section> <mj-section padding="20px" border-top="2px solid #000"> <mj-column> <mj-text> <p>Warmest regards,</p> <p>Quill & Pigeon</p> </mj-text> </mj-column> </mj-section> </mj-body></mjml>
Testing Across Clients: Conducted comprehensive testing of these email templates across various clients to ensure consistency in appearance and functionality.
Software Research: Researched and evaluated potential software solutions to enhance our email marketing efforts, focusing on tools that could improve deliverability, analytics, and personalization.
3. Grant Applications
Drafting Applications: Took a part in drafting detailed grant applications, carefully tailoring each to the specific requirements and objectives of the funding bodies.
Researching Grant Opportunities: Conducted thorough research on available grants, focusing on those that aligned with Quill & Pigeon’s mission of sustainability and supporting local artists.
Strategic Planning: Identified potential uses for grant funds, aligning them with our long-term goals, such as expanding staff & hiring a software engineer
Conducted research on salary and size of job market for software engineers in Portland, as well as New Hampshire and the Boston area