Yan Shi

American Federation of State, County, and Municipal Employees (AFSCME)

Digital Intern ➡️ Digital Media Data Specialist ➡️ Senior Strategist II, Data Engineer ️️ • June 2018 — July 2020

I started as a digital intern on the digital communications team in June 2018 assisting with social listening and media management during the AFSCME vs JANUS Supreme Court case. I transitioned into the Digital Media Data Specialist role in August 2018 at the end of my internship. I was promoted to Senior Strategist II in December 2019. At AFSCME, I've worn several different types of hats. I've worked on ETL projects, using data sources from APIs to mirrors. I've experience in Action Network, EveryAction/VAN, Mobile Commons, Hustle, and more.

• Built, documented, and maintained data pipelines/ETL processes using Python, Luigi, AWS S3, Redshift, SQL and other tools and packages.
• Created and collaborated with other departments and field data coordinators to create dashboards in Periscope, regarding membership, warehouse health, organizing efforts, and digital metrics.
• Led a cross-departmental data skills training conference with over 100 attendees, made up of affiliates and HQ staff.

American University School of Communication

Online Assistant • Jan. 2017 — May 2018

I migrated over 40+ pages to new templates and components and wrote site copy when needed. I've also copy-edited, wrote, and researched stories on alumni, SOC events, and current students.

National Geographic Society

Digital Content Production Intern • June 2017 — August 2017

I diagnosed and developed solutions for various requests assigned to me via JIRA for the digital team. I consulted with stakeholders and built another iteration of The Globe under two weeks, using Python, Django, and location APIs.

NBC4-Washington

Digital Team Intern • Aug. 2016 — Dec. 2016

Wrote articles and updated local and national voting numbers for the 2016 election. I have several bylines for local news, wire news, and entertainment articles. I was also responsible for cutting and uploading videos from the news broadcasts.

USA TODAY

Interactive News Intern • June 2016 — August 2016

I managed, edited, and organized content for a large, nationwide project, Trump Nation and Clinton Nation. I also developed and stood up coding projects using Python, JavaScript, HTML/CSS, and Django.

American University College of Law

Office Assistant • Jan 2016 — May 2016

I was an office assistant for 10+ professors and was responsible for daily data entry, data tracking, document processing, course material preparation, and handling of nonsensitive and sensitive information.

Newseum

Video Production/Broadcast Technology Intern • Aug. 2015 — Dec. 2015

I edited B-roll and media using Adobe Premiere and AVID. I was tasked with biweekly updates for the "A Lighter Look at the News" exhibit. I also digitized and encoded tapes and media using StreamZHD techonlogy, and troubleshot software and computer hardware issues on desktop and web. One of my favorite projects was assisting and creating content for the FBI exhibit, which opened in November 2015.

American University, Washington, D.C.

BA, Broadcast Journalism & Computer Science • 2014 — 2018

• UPE Honors, Cum Laude

During my time at American University, I was a teaching assistant for two computer science classes, where I held office hours for homework, graded work, and provided feedback to students. I also held other leadership positions, such as holding the PR chair for AU's Association of Computing Machinery and the Asian American Student Union. I was also the web editor for our investigative journalism magazine, American Way of Life, where I oversaw our migration and redesign of our website.

Journalism Videos & Reel

Writer, editor, and videographer • 2017 — 2018

During my studies, I had several assignments that focused on tv/video production. Included in the link is a video reel of my tv production course as well as my video projects where I focused my videos to center around stories from communities within DC.

Writing Clips

Writer/Editor • 2014 — 2018

Included in the link are writing clips from my time in my role as an office assistant at the School of Communication, NBC4-Washington, and student-led organizations.

Python

I'm comfortable with using Python to create solutions to problems. I've used Python in the context of ETL processes, web scraping, and the one-off personal project. I've experience in using packages e.g. pandas, beautifulsoup, csv, luigi, leaflet, Django, and more.

Vanilla HTML/CSS/JavaScript

Emphasis on vanilla.

Adobe Suite

Premiere, Photoshop, Audition, and Illustrator are all applications I've used.

Digital content development & creation

Copy writing, AP style, wireframing, UI/UX, CRMs and CMSs, digital analytics

Organizational Skills

I've experience in using JIRA, Trello, and Slack in communicating and organizing work within a team and among departments.