John Ying Email & Phone Number

Atlanta, Georgia, United States

Atlanta, Georgia, United States

• Produced a report detailing the intersection between employer wellness programs and wearable technology, the legal and regulatory landscape around them, and associated privacy harms• Tracked the California legislative session for bills related to consumer privacy• Produced a report detailing the gaps in privacy law when applied to Courseware vendors.

Brunswick, Maine, United States

Brunswick, Maine, United States

• Integrated previously disparate database systems, improving workplace efficiency and data accuracy• Trained staff on database, website, email, and document retention best practices• Created a development plan that includes seven different fundraising channels with goals, tactics, calendars, and accountability for each channel

Portland, Maine Area

- Developing and executing major giving plan that gives ownership of identification, cultivation, ask, and stewardship tasks to everyone from volunteers to board members- Strategizing appeal lists, calendars, personal board member asks, and follow ups, leading to a 25% net increase compared to last Spring’s appeal- Creating processes and procedures acknowledging donors, welcoming new members, and encouraging lapsed donors to renew- Creating and managing Mailchimp templates to streamline workflow among our volunteers and to create a consistent look across all digital communications

Scarborough, Me

- Increased member and guest engagement outside the climbing gym by implementing Mailchimp automation and other campaigns- Increased registrations to our instructional classes and camps through management of Google AdWords, Facebook & Instagram ads, Yelp, and print media- Maintained a high level of data quality across ~30,000 customer records- Created SQL reports to provide actionable intelligence that directly increases member retention and satisfaction

Chattanooga, Tennessee Area

- Cultivate member business to join and solicit sponsorship for all 17 events in our calendar- Plan all aspects of monthly networking events and fundraising events- Produce and execute monthly newsletter via Mailchimp- Implement process improvements to better leverage Microsoft Dynamics CRM

Lewiston/Auburn, Maine Area

- Improved and streamlined donor acknowledgement processes which freed the team to focus on donor cultivation- Interfaced with a multi-faceted team from Underwriting to Finance in order to track gifts properly- Led the process of finding a new CRM that improved efficiency, cross-team communication, and saves money- Organized and executed events for major donors that engage, keep their attention, and help convert them to supporting our organization- Taught our fundraising teams how Google Analytics can give insight into donor data- Created dashboards from Google Data Studio that drive that insight- Integrated Google Analytics with email campaigns sent from Luminate, Constant Contact, and Mailchimp to measure campaign effectiveness and ROI

Chattanooga, Tennessee Area

- Strategically grew the network of third-party vendors, based on needs and opportunities - Managed brand identity, website rebuild, photography, and video projects that fall outside the company’s core competencies but are still worth pursuing- Google AdWords certified in Search, Mobile, Shopping, and Video advertising- Created whitepapers and led presentations that have become resources for fledgling companies looking to break into digital advertising- Diligently managed clients' Google AdWords spend by researching keywords, writing ads, testing bids, and creating landing pages that convert.

Chattanooga, Tn

- Exceeded guest expectations by providing exceptional customer service, leading to over 100 five-star reviews- Managed and built a proprietary reservation, point of sale, and inventory tracking database that streamlined inefficient workflows and increased conversion rates. - Increased revenue 10% YoY - Won 2015 Chattanooga Small Business of the Year award - Made new hires instantly feel part of the team by creating training materials and running training programs- Shaped and documented the culture, policies, and procedures of the company through content creation and management of multiple employee manuals- Created the company's first Eco Policy that documented the environmental impact of our business and our efforts to reduce those impacts as much as possible- Organized all of our social media outlets (Facebook, Twitter, Instagram, Yelp, TripAdvisor)

Washington D.C. Metro Area

- Provided earned value support to a Department of Homeland Security program consisting of over 40 projects worth over $50 million- Interfaced with project managers as their main point of contact regarding earned value- Developed and maintained new forms for our Cost/Schedule Status Report through the use of various Excel techniques including Vlookups, Hlookups, PivotTables, and VBA macros- Enforced proper earned value techniques compliant to ANSI/EIA-748 and to CSC’s internal Program Management Control System

- Ensured every customer's safety by belaying for first time climbers and checking equipment- Taught clinics on how to belay, tie knots, and decreased risk in climbing situations- Promoted rock climbing and our facility as fun and safe environment by using helpful and friendly customer service tacticsActivities

- Hosted a weekly 2-hour campus wide radio program with a focus on independent music- Promoted campus events by posting flyers and advertising through the radio show- Organized and cataloged one of largest record libraries on the East Coast in the WMUC station

- Created innovative techniques for 3rd and 4th grade children to practice their English Language skills- Gained priceless international experience through the school, its children and the city

Doctor Of Law - Jd

Activities and Societies: Member of the International Humanitarian Law Clinic - Working with the Center for Civilians in Conflict (CIVIC).

Doctor Of Law - Jd

• Summer Privacy Institute with courses in Global Data Transfers, GDPR, and Privacy, AI, & Ethics. • First year GPA: 3.667

Ba, English Literature

Bs, Accounting And Information Systems