Matthew Sourwine
Gaithersburg
Summary
With over 10 years of experience as research analyst working for media companies, non-profit organizations and government agencies providing consumer insights to a broad range of statistical and data visualization projects. Proficient in examining complex datasets and passionate about connecting data with business results, my analytical approach to evaluating key performance indicators and insights goes beyond searching through layers of reported data. Outstanding critical thinking and content management skills have trained me to detect patterns and present conclusions in a multitude of written, graphical and database related formats. My skills and training also allow me to provide excellent administrative support in a fast paced and high-pressure work environment. Orderly and committed administrative assistant offering solid skills in customer relations and resilience to handle challenges of fast-paced environments. Bringing detail-oriented and decisive nature with sound judgment, good multitasking abilities and self-motivated nature. Comfortable working alone or with teams to accomplish on-time and accurate clerical tasks.
Overview
18
18
years of professional experience
Work History
Administrative Assistant
Capitol Hill Partners
Washington
12.2012 - 08.2020
- Provided front desk administrative services in a government relations firm. Managing the reception area & office library by cataloging documents, attending weekly staff meetings, responding to phone & email inquiries and other clerical services.
- Researched grant funding opportunities available based on the educational, monetary and financial needs set by our workforce clients. Writing brief summaries that explained the funding implications, procedures and next steps in the process, tailoring each approach for specific target audiences.
- Stayed abreast of any legislative, regulatory or marketplace developments occurring within the political process that could impact my report findings and regularly updated clients about these potential changes.
- Interpreted large quantitative data sets using SQL and Excel to generate talking points, memos, fact sheets, and other presentation materials that highlighted changing market conditions in the workforce and education sector.
- Coordinated congressional visits and event logistics that included managing the event schedule, drafting talking points and creating various presentation materials (signage, nametags, portfolios) for participants.
- Created a Facebook page for the office and monitored the company’s social media presence.
- Handled confidential documents in an organized fashion according to established protocol.
- Coordinated mailings including sorting mail, preparing packages for shipping via courier service or postal service.
- Ensured efficient operation of office equipment such as printers, copiers and fax machines.
- Managed database systems containing customer contact information.
- Compiled data from various sources into organized reports for review by management team.
- Composed letters, memos, reports, emails, presentations and other written correspondence as required by management staff.
- Organized and maintained filing systems for physical and electronic documents, ensuring accuracy and confidentiality of records.
Senior Wage Analyst
Office of Foreign Labor Certification
Washington
10.2009 - 10.2012
- Calculated and processed online visa applications submitted by employers looking to hire foreign workers for US jobs. Validated the foreign wages being offered would be equal to US counterpart.
- Maintained a database that efficiently tracked relevant internal and external information through statistical software (SPSS), spreadsheets functions (vlookup, pivot tables) and power point reports that would analyze possible hiring trends and other key performance indicators within the data.
- Conducted help desk assistance to applicants via phone & e-mail answering questions with speed, insight and accuracy.
- Debugged and troubleshot software for new online visa filing website before the public release, while monitoring the output of the existing paperwork for the entire department. Regularly reporting on the visa application website analytics, focusing on user experience and the output of the collected information.
- Promoted to Senior Wage Analyst and trained new staff by co-writing an employee handbook of standard operating procedures. Handbook included tips for determining complicated wage calculations and how to troubleshoot potential coding issues.
- Communicated insights during senior management meetings about website analytics, focusing on the user experience and ease of use. Proposed website updates, production output incentives for analysts, and other ideas or concerns regarding the certification process.
- Maintained accurate records of all data collected during analysis processes.
- Collaborated with cross-functional teams on projects related to analytics initiatives.
- Implemented strategies for automating organizational processes.
- Analyzed large datasets with statistical methods and software programs.
- Identified opportunities for process improvements across the organization.
- Oversaw quality control to identify inconsistencies and malfunctions.
- Utilized document management system to organize company files, keeping up-to-date and easily accessible data.
- Monitored operations and reviewed records and metrics to understand company performance.
- Analyzed key performance indicators to identify effective strategies.
- Wrote and submitted reports on industry trends, prompting managers to develop business plans.
- Identified areas for improvement, narrowing focus for decision-makers in making necessary changes.
Data Researcher
US News and World Report
Washington
09.2006 - 07.2009
- Supported data collection activities for the magazine’s annual Best Colleges and Graduate Schools Guidebook. Proofread survey data for quality control eliminating any formatting, grammatical or mathematical errors.
- Investigated any inconsistent statistical information by cross-referencing past data and contacting university personnel for assistance to resolve issues.
- Handled multiple customer service calls answering respondents’ questions that ranged from general technical assistance, the ranking and publication details to specific survey questions.
- Maintained a communications database through daily recordkeeping that tracked any survey adjustments or special requests made via email/phone interactions for more accurate reporting and a higher response rate from clients. This also helped coordinate media outreach regarding submission deadlines, publicity opportunities and other requests.
- Worked with the Web Development team to help pressure test the guidebook website to make sure it could handle the influx viewers. Reported any programming, page layout or technical issues found.
- Tracked and analyzed online guidebook data analytics (web traffic, most viewed/read/commented articles) that may be used to influence future surveys or new stories. Shared findings with other departments to determine best practices.
- Monitored and provided data-driven recommendations about the collegiate system that would enable collaborations between journalists and other departments to provide other newsworthy story options, while pitching ways to highlight this data for readers in both digital and print media.
- Fulfilled additional fact-checking requests from other divisions of the magazine, as needed.
Research Assistant
National Center on Education and the Economy
Washington
03.2004 - 09.2006
Museum Intern
SMITHSONIAN INSTITUTION, Center for Museum Studies
Washington
02.2003 - 08.2003
Education
Undergraduate Certificate - Journalism
University of Massachusetts Online
Amherst, MA03.2011
Bachelor of Arts - English Literature
Salisbury University
Salisbury, MD12.2003
Skills
- Content Writing & Editing
- MS Office Suite
- Web Development
- HTML
- CSS
- Desktop Publishing
- Adobe Creative Suite
- Data analysis
- Hootsuite
- Google Analytics
- Salesforce
- Database Management
- SQL
- R/ Python
- Data Visualization
- Tableau
- Power BI
- SharePoint
- Social media management
- Customer service
- Event coordination
- Legislative research
- Communication skills
Training And Special Skills
- Direct experience in writing and editing content for online and offline channels.
- High proficiency in MS Office Suite (Word, Excel, PowerPoint and Outlook).
- Basic web development (HTML, CSS) skills.
- Training in desktop publishing and graphics/photo editing (Adobe Creative Suite/Photoshop).
- Experience in Marketing Automation Systems- Hootsuite, Google Analytics & Salesforce.
- Database Management: MS Access, SQL, R and Python.
- Data Visualization Software: Tableau/ Power BI (Making Visual Informatics from data).
- Social Media Training on Twitter, Facebook, Instagram, Linkedin, Twitch, among others.
- Support Collaboration Tools: Slack, Dropbox, GoogleDocs & GoToMeeting.
- Experience with SharePoint (web app creation, document management, version control, etc.).
- Competent in AP and MLA Editing Style Guides.
- Detailed-oriented with superior verbal and written communication skills.
References
References available upon request.
Timeline
Administrative Assistant
Capitol Hill Partners
12.2012 - 08.2020
Senior Wage Analyst
Office of Foreign Labor Certification
10.2009 - 10.2012
Data Researcher
US News and World Report
09.2006 - 07.2009
Research Assistant
National Center on Education and the Economy
03.2004 - 09.2006
Museum Intern
SMITHSONIAN INSTITUTION, Center for Museum Studies
02.2003 - 08.2003
Undergraduate Certificate - Journalism
University of Massachusetts Online
Bachelor of Arts - English Literature
Salisbury University
Similar Profiles
Jenna JonesJenna Jones
Administrative Coordinator at Capitol Hill VillageAdministrative Coordinator at Capitol Hill Village
SILVIA RODRIGUEZSILVIA RODRIGUEZ
8th Grade US History at Capitol Hill Middle School8th Grade US History at Capitol Hill Middle School
DAWN LEEDAWN LEE
Human Resources Director at Hilton Washington DC Capitol HillHuman Resources Director at Hilton Washington DC Capitol Hill
Sophia RoseSophia Rose
Babysitter at Family Friends And NeighborsBabysitter at Family Friends And Neighbors
Kelly FloresKelly Flores
Sales & Project Coordinator at Ivanti Marble & GraniteSales & Project Coordinator at Ivanti Marble & Granite