Lily Pipkin Email & Phone Number

Austin, Texas Area

- Lead training & optimization projects on Tessitura CRM for a team of 10+ full-time staff in Development, Marketing, Sales, Finance and Data Analytics.- Responsible for all outgoing Marketing and Segmentation lists, including a 50,000 person, 20-segment structure for Ballet Austin's 2020 Recovery Campaign, which raised $700,000 towards COVID Relief.- Project lead in converting Community Education department from Google Sheet project management into Tessitura's CRM.- Develop annual Analytics Dashboards in Tessitura's Business Intelligence suite for cross-departmental reporting on KPIs, Finance Projections, Moves Management and COVID Recovery.- Develop highly personalized emails using Tessitura's Output Set and Wordfly's Dynamic Content functionality, including a series of triggered renewal prompts for expiring members and customized pre-show emails for new, returning, and VIP patrons.- Manage software maintenance and upgrades for Tessitura and affiliated hardware and programs (includes TNEW 7, NSCAN ticket scanners, Wordfly Email and Pages, iWave Prospect Screening, Wordpress, Worldpay to Windcave cutover project, and all Tessitura version upgrades).- Started and maintain a working internal documentation on processes and troubleshooting for Tessitura and other Ballet Austin practices via Google Sites.- Import data via SQL/SSMS from other softwares (MINDBODY, 501 Auctions, GiveSmart, Sumo) into Tessitura for stremalined analysis and marketing efforts.- Develop/update SQL reports, stored procedures, data updates and security.

Austin, Texas Area

- Responsible for recording all contributed revenue and sending all acknowledgements and tax receipts for a $2.1 million annual Contributed revenue budget.- Created a new automated process for sending $100 and below receipts via triggered personalized emails.- Managed seating and event software, plus registration volunteers for 3 years of Ballet Austin's annual 500 person Gala - Fete.- Maintained Development portions of Ballet Austin's e-commerce website (TNEW).- Co-developed new uses for moves management system with Associate Director of Individual Giving- Responsible for all reporting for Grants, Individual and Institutional Giving, Events, and Finance reconcilliations.

Austin, Texas Area

- Managed adoption, customization, and integration of Salesforce as a new CRM and Project Management system to replace redundant databases currently in use.- Developed custom project management objects and tabs through Salesforce.- Cleaned, consolidated, and managed data from Neon, Filemaker, Google Sheets, and Gmail for import into Salesforce.

Austin, Texas Area

- Assisted the Associate Director of Individual Giving in managing Tessitura CRM and event planning.- Pulled reports, ran lists & extractions, and imported data into our donor and membership database, Tessitura.- Managed Greater Giving to track over 800 attendees and 300 auction items for the Paramount Gala, the organization's largest annual fundraiser.- Updated and maintained online giving and contribution pages.- Planned and assisted with donor events throughout the year ranging from 100 to 1,200 people.

Austin, Texas Area

- Used customer service site ‘Talk to the Manager’ to respond to customer concerns, compliments, and complaints.- Responsible for timely responses to approximately 300 customer communications every day.

Austin, Texas Area

- Wrote scope & content descriptions of over 30 small collections for the National Archives database.- Responded to research requests and created social media outreach posts.- Assisted in reorganizing and consolidating LBJ’s Personal Papers collections in the archive stacks.

Austin, Texas Area

- Drafted, filed and retrieved hundreds of state documents each week for Texas business lawyers and CPAs.- Promoted to lead position of IRS-related requests and obtaining Employer Identification Numbers (EINs).- Familiarity with the Texas Business Organizations Code and basic Texas Comptroller tax requirements.- Experience with taking orders and assisting clients over the phone and by email.

Bachelor'S Degree, English Language And Literature, General, 3.96

Activities and Societies: English Honors Program and Undergraduate Thesis Shakespeare at Winedale (2015 and 2016) Shakespeare at Winedale.

Bachelor'S Degree, Plan Ii Honors, 3.96

Activities and Societies: The Broccoli Project (Theater)Plan II is a challenging interdisciplinary curriculum leading to a Bachelor.

Bachelor'S Degree, History, 3.96

Activities and Societies: The Normandy Scholars ProgramNormandy Scholars Program, Class of 2016: This honors program is a semester-long.

High Shool

Activities and Societies: Drum line, Percussion in Orchestra and Concert Band, The Featherduster Newspaper, History Club, Gay-Straight.