Shelby Johnson Email & Phone Number

Olympia, Washington, United States

In addition to my duties in my previous role, as a Senior Data Analyst I have taken on more tasks in a project management and process documentation capacity.These include: -Within the Educational Data System (EDS, which is a centralized suite of web-based applications regarding educational data), working with dedicated development staff to add needed functionality to applications for end users. This means involvement in the life cycle of the process from idea to reviewing in the test environment and production. -Tracking and maintaining yearly goals and updates for the data flow for the operational assessment data flow. -Creating documents like quick start guides for employees new to the Assessment Analyst role, a Desk Manual, and other documentation of key annual processes.-Assisting in communication and process for the Data Sharing Agreement within the Data Foundations team-Assisting with creating comprehensive tracking calendars, workflows and documentation within the Data Foundations team-Training new employees on tasks within the Data Consultant and Data Analyst roles, including explaining operational data flows and requests, data sources and how to liaise with districts and data users. _____________________________________________________________________________________________________________2023 Employee Annual Review: "You have done a great job in building sustainability of processes through both of your goals, which is foundationally critical for getting our team to a place where we can be more effective at current state but also expand upon what we do. Your commitment to supporting your teammates and tireless work ensuring the districts have what they need is admirable, particularly when resources and system reliability are scarce at times. I also really appreciate your participation in DEI conversations and sharing insight and ideas that help push us as an agency to think differently."-Director of Student Information, Data Foundations Team

Olympia, Washington, United States

I work within the larger Assessment and Student Information team. My tasks and deliverables include: - Assist School Districts, Educational Service Districts and other Local Education Agencies (LEAs) with data questions within some applications in OSPI's Education Data System (EDS). - Assist School Districts, Educational Service Districts and other LEAs with data questions within vendor managed data and reporting systems. - Assist School Districts, Educational Service Districts and other LEAs with data questions regarding the Graduation Pathways Database within EDS. -Load student pre-identification files into the applicable vendor managed systems for assessment access. -Manage sending updated district and school directory files to the multiple vendors, at the start of each school year and for specific deliverables throughout the year. -Compile vendor provided project schedules for the annual assessment cycles and related tasks, and create internal deliverable tracking and project our internal Analysts deliverables schedule for the Assessment Analysts team. -Creating dashboards, reports in Smartsheet. Also tracking for enhancements in Card Lanes in Smartsheet. -Coordinating the edits and review on an annual basis for two internally produced manuals/guides about systems and data for the Washington Comprehensive Assessment Program (WCAP).-Assisting with review of other documentation and items for the WCAP and related portal. -Assisting with User Acceptance Testing of vendor managed systems. -Other Ad Hoc data requests as assigned, and other Ad Hoc project management tasks for the Analysts team. -Attending vendor planning meetings, State Technical Advisory Committee meetings, WERA Conferences, and other professional development meetings as well. -In addition to many homegrown systems within the Agency and Vendor Systems, other software and systems used for job tasks and data work include: Microsoft SQL Server, SFTP Servers, Microsoft Suite, Smartsheet

Kirkland, Washington, United States

Kirkland, Washington, United States

-Promoted to Office Manager in March 2017.-Use of and familiarity with multiple web-based systems, including Harvest, Zoho Creator, Xero, Slack, Asana, iPad Receptionist, Confluence, Salesforce, Trello and more.-Managing executive calendars and meeting scheduling.-Assisting in time sheet submission reminders and submission, as well as occasional troubleshooting.-Reconciling time between client-side systems and internal system.-Updating project and employee information in multiple web-based systems.-Assisting with compiling receipts and preparing for monthly statements.-Uploading, tracking and assisting with records and statements of work for client projects-Planning large scale offsite employee meetings or client events.-Sourcing vendors for events, including venues, caterers, and other necessary vendors; coordinating the budgets, timing of vendors and events and more.-Assisting as needed with generating invoices from web-based systems, on a bi-weekly or monthly basis.-Travel arrangements for executives, technical staff, and other administrative staff as requested.-Orchestrating office move by sourcing vendors, scheduling appointments and meetings, and setting up new office space. -Assisting with the general plan for things such as office moves, purchasing large items such as furniture, etc.-Maintaining asset tag spreadsheet.-Ordering office supplies, including food services and beverages, workstation supplies, in addition to any other needs and special requests.-Obtaining and maintaining building access information.-Documenting processes in my position for purposes of assisting if back up is needed, and for workflow.-Assisting in process and procedure writing for operational functions at Dev9 as requested.

Indianapolis, Indiana, United States

I received a promotion to Administrative Assistant Level II in 2013 at Indiana Connections Academy. In addition to all my previous tasks as an Administrative Assistant I (as seen below in Administrative Assistant I entry), I also have taken on the following roles and tasks:-Assisting Office Manager in implementing new tasks and procedures with Level Administrative Assistants. -Training of new Level Administrative Assistants in overall job duties and day to day tasks.-Composing all process manual sheets for Level Administrative Assistant tasks.-Field any questions from team members regarding new processes. -Serve as project lead for any new projects or tasks given to Level Administrative Assistant team. -Running reports for Office Manager's weekly check in meetings with Level Administrative Assistant team. - Collecting and organizing all pertinent information for the Administrative Assistant team process binder. Including, but not limited to: typing out process sheets, binder creation, requesting/collecting information and processes from other team members.- Assist in leading summer projects, such as file clean-up and audit, change of processes, gathering school Intent To Return documentation, and any other special summer task as requested of me. -Creating informational and process driven presentations for help with employees or team training for manager, using Prezi mainly to create them to be interactive. Also used power point or other products in the Microsoft Office suite if necessary. - Assist with any additional duties as requested. I have also served as the interim High School Administrative Assistant and interim Elementary School Administrative Assistant, concurrently at some times, in addition to my Middle School duties, as we fielded staff vacancies and hired new employees. I have taken on additional student withdrawals, records management and any other task as needed or requested for the High School and Elementary School level.

Indianapolis, Indiana, United States

-Running reports to access data regarding students whom have enrolled and need records requested, and students who have an intent to withdraw. -Sending out records requests for students to their former schools, then uploading on to the Connexus database and creating Cumulative Files. -Filing student records. -Withdrawing students from the school, including tasks such as requesting Withdrawal Forms, completing online Dataviews pertaining to the Intent To Withdraw, creating/publishing a progress report for the student on Connexus,removing students from their online courses, checking the State of Indiana DOE STN Database for enrollment elsewhere, gathering Enrollment Verification from new school, and assisting the guardians/caretakers with questions. -Complex mailings to students and caretakers regarding school events, courses, etc. Creating a mailing includes, printing all letters, using V-Lookup via excel databases to pull contact information, and using Mail Merge on Microsoft Word. -Forwarding student records to new schools. -Answer any and all phone calls and questions directed to me. -Front desk coverage, including sending out Enrollment Packets, completing Welcome Calls for the school, answering the front desk calls, sorting and delivering the mail and greeting any visitors.-Assisting in packing for State Testing for multiple testing locations spread out throughout the State of Indiana. -Trained co-workers on the process of requesting student records from previous schools.-Summer file audits to ensure accuracy of student cumulative files, and proper storage.-Any other task as requested by management, or to assist co-workers.

Bellevue, Washington, United States

-Answered all inbound calls, and answered client questions or routed appropriately. -Generated invoices for customers whom had received product. -Assisted in set up and preparation for any meetings in board room, including but not limited to providing presentation materials, creating specialized binders and product information. -Printed and stocked company's custom literature wall, with more than 30+ individual pieces. -Sent out specialized literature packets to customers as requested. -Filed/tracked all customer invoices, statements and bills. -Took all deposits to appropriate banks, as well as getting cashier check and deposits for payroll. -Oversaw registration process for up to 20+ products in 29 states through the appropriate office within the Department of Agriculture in that state, including new products in the appropriate Organic Programs.-First point of contact in registration process with state governments. -Completed all renewal paperwork for registration. -Prepared and sent all tonnage reports to state governments, including monthly, quarterly, semi-annually or annually, depending on state requirement. -Kept database of current registration and tonnage information for the states up to date. -Sent out pertinent information to customers such as MSDS, Labels and/or any other document as requested. -Assisted in compiling, and oversaw construction and binding of financial booklets, board reports and other informational booklets. -Oversaw RSVP database/sheet for hundreds of attendees at large company event. -Helped to create name tags, compile all necessary event items, set up event and work as event staff. -Reported directly to the CFO, but frequently assisted President, Senior Vice President, Graphic Designer and all Sales staff with tasks.-Any other task as requested.

Bellevue, Washington, United States

-Completed sales orders for customers purchasing small appliances or accessories. -Completed appropriate paperwork for customers picking up appliances at store location. -Assisted Marketing Manager, or other Managers, with tasks as requested. -Assisted with Marketing duties such as signage placement or any other needed task, mainly in Bellevue location.-Open and Closing procedures of the cash till for all sales reps at store. -Taking deposits to the bank, and sending corporate the financial and deposit information. -Sending specified paperwork to corporate at the end of each day. -Team member responsible for updating and maintaining an RSVP database to large event. -Contacting event attendees. -Working events in store and other locations if needed.-Calling for delivery follow-up calls to customers. -Assisting in setting up the reception area of the new store location, as well as certain display decorations. -Any other task for location as needed.

Seattle, Washington, United States

-Assisted with on air guest arrivals, and other visitors including corporate representatives and attendees/artists for in house performances.-Secured all necessary prize winner information for pick up of prizes (including verifying ID, etc.). -Reworked and created an excel database for tracking and storing prize winner information for FCC reporting purposes. -Help with promotional activities, including but not limited to set up help at concert events, making promotional materials, etc.-Provided in-house voice talent if requested for commercials or show soundbites, including things like Seattle Oktoberfest and PCC Natural Markets commercials.-Any other task as requested.

Bellevue, Washington, United States

-Packed and Set up Promotional Events for the station. -Worked station sponsored events. -Drove station sponsored vehicle. -Performed duties in the station including organizing the storage and prize closets. -Assisted in contacting vendors for large events. -Updated prize winner contact information in the database. -Assembled prize packs. -Fielded customer questions regarding the station. -Contacted prize winners with details on how to pick up their prize. -Helped organize and execute prep work and staffing in both front of house and back of house for large station sponsored concert.-Any other task as requested.

Bellevue, Washington, United States

-Packed and Set up Promotional Events for the station. -Worked station sponsored events. -Performed duties in the station including organizing the storage and prize closets. -Created flyers for On-Air Talent to read about for prize giveaways. -Performed media recap, checking other stations current events and giveaways. -Updated the events calendar. -Updated prize winner contact information in the database. -Assembled prize packs. -Fielded customer questions regarding the station. -Contacted prize winners with details on how to pick up their prize.-Any other task as requested.

Nonprofit Management Graduate Certificate, Non-Profit/Public/Organizational Management, Gpa 3.94

Activities and Societies: Public Affairs Student Association (PASA) MemberObtained a Nonprofit Management Graduate Certificate (Masters.

Bachelor Of Arts, Cum Laude, Music Business; Minor In Business Administration, Gpa 3.55

Activities and Societies: University Chorale, Jazz Choir, Opera Productions (PR Assistant to the Director), Honor RollEarned a Bachelor.

Transfer Credits, Music, Gpa 3.80

Transfer Credits for Degree Completion within the Music Department.