Business Analyst Project Manager

David Lockwood

**** *. ***** ***. ****** City, MO 64151 816-***-**** *************@*****.***

SUMMARY

Project Manager experienced in database design and maintenance, extensive dataset management, project planning and execution, and active collaboration with all levels of project stakeholders to deliver products and results that achieve the desired outcomes. SOFTWARE EXPERIENCE

Microsoft Access, Word, PowerPoint, Visio, Excel, Publisher, Outlook; SEVIS; Blackboard; T-Res; One45, PeopleSoft Financial, Human Resources; Adobe Acrobat, Illustrator, Photoshop; WordPerfect; GroupWise; SoftChalk; SQL; E-Value; ExamSoft; Visual Basic; Power BI; SSRS, TSO; Service Now; GitHub; Jira;

EDUCATION & CERTIFICATIONS

DeVry University, Kansas City, MO

Bachelor of Science in Technical Management, Specialization in Project Management, October 2015

Missouri Western State University, St. Joseph, MO

Completed 67 hours toward a Bachelor of Science in Computer Information Systems New Horizons Computer Learning Center

Access 2010 Programming with VBA, 2012

Advanced Access 2010 Programming, 2012

University of Miami’s Collaborative IRB Training Initiative (CITI) Data or Specimens Basic Course in the Protection of Human Rights, 2010 PROJECT HIGHLIGHTS

ePresentment Cloud Migration: Designed and implemented Kanban Board and roadmap. Managed Project documentation and timelines.

Service Now: Designed and implemented dashboards and ticket management across multiple teams and managed process improvements for client service requests. JetHub: Designed and implemented an online hub for users to download Excel reports, pulling data directly from SQL Datasets onto an Excel report via the Jet system. D. Lockwood, Page 2

Curriculum Longitudinal Student Database Project: Designed to show a student’s performance from Year one of DO Medical School to their fourth and final year; provided longitudinal data on a student’s performance on the NBME standard practice exam for boards and compared the breakdown of the scores to how the students performed in their first two years; showed issues with what was taught during those years and how we could better improve the student’s education; and served as an indicator of how a student may perform on board exams.

Faculty Teaching Database Project: Created a simple system to show how many hours and courses a faculty member was teaching.

T-Res Database Project: Accorded data from an outside vendor and worked with data to reflect that third and fourth-year students received the required education at off-site locations. International Student Project: Created a database that allowed the Assistant Dean to quickly enter and pull data required for fourth-year medical students to go on their elective internationally and tracked the students coming in from other countries for their one to four month rotation requirement.

PROFESSIONAL EXPERIENCE

SS&C, Kansas City, Mo 2023-2024

IT Product Support Analyst, GIDS Support Intake 2023-2024

● Support Ticket administration across Digital Investor, Web Support, Desktop, and Vision application

● Triaged and did initial research for Digital Investor, Web Support, Desktop, and Vision applications

● Full Stack research using C# and Mainframe COBOL to determine the root cause of bugs

● Managed user traces to research different requests from our clients

● Provided Business Analysis for internal automation

● Worked on Cloud Migration as an Application Analyst

● Jira Bug Ticket Administration

● TAHub and Smartdesk triage level one testing

Unite Private Networks, Kansas City, MO 2018-2023

Data Analyst, Integration Data Management 2020-2023

● Project lead on Development and implementation of JetHub-supplying data via reports to users out of SQL

● Design and maintain Dashboard using PowerBI

● Design and maintain Dashboard using SSRS

Business Analyst, Integration Data Management 2018-2020 D. Lockwood, Page 3

● Provide technical support via email and chat with internal and external users requiring assistance

● Troubleshoot and manage system issues from notification to resolution

● Coordinate with internal and external parties to develop and implement system enhancements

● Coordinate with internal and external parties on system data uploads and data verification

● Manage system access, system notifications, and master data information Kansas City University of Medicine and Biosciences, Kansas City, MO, 2009-2018 Assessment Coordinator, Assessment Department, 2015-2018

● Created Faculty Teaching database – assessed how the data would come into the database, how the Assistant Dean wanted it displayed, how best to design data entry for the end user, and achieved a database that met the required standards for all stakeholders

● Assisting the Dean of the College of Bioscience with the Higher Learning Commission accreditation project

● Maintain multiple external web pages, work with various users on updating and streamlining their web pages

● Manage and create exams in ExamSoft for the College of Bioscience and assist with the creation of exams for the College of Medicine

Assessment Coordinator, Curriculum Affairs, 2009-2015

● Created and managed Curriculum Longitudinal Student Database – includes nodal information for years 1-4; residency match data for all students; and multiple reports developed for students, advisors, chairs, and deans

● Maintained performance data in Blackboard – including subject exam scheduling, delivery, and report; clerkship assignment completion; and T-Res tracking for 500+ students

● Scheduled exams with off-site coordinators and delivered exams on-site monthly

● Worked with Assistant Dean to design reporting tool in CLSD Database

● Used outside vendor to maintain tracking of patient logs for over 500+ students

● Created and managed T-Res Database – includes patient encounters, procedures, level of participation, objectives met, and level of mastery for 500+ students

● Worked with the vendor for the T-Res database on a way to import data from the patient logs to a database and with the Assistant Dean to design what would need to be present when using the database

University of Kansas Medical Center, Kansas City, KS, 2000-2008 International Student Coordinator, International Programs, 2004-2008

● Maintained department budget, including 4 separate accounts

● Created and maintained incoming and outgoing Student International Database

● Doubled the number of international students in the Short-Term Program by working with the international populace to improve the program

D. Lockwood, Page 4

● Assisted all international students, including those not in the Short-Term Program Administrative Specialist, Office of Medical Education, 2000-2004

● Designed and maintained Access Database for budget and Standardized Patient Program, actively worked with the Program Director to create more efficient database

● Assisted with first and second year medical student classes and the Rural Rotation Program for fourth year medical Students

Trans World Airlines, Kansas City, MO, 1999-2000

Administrative Assistant

● Organized and maintained Access Database for Y2K compliance. EDS, Kansas City, MO, 1997-1999

Administrative Assistant

● Assisted in finding missing back-office airline tickets and designed an instruction manual for procedures regarding missing airline tickets

● Took on the role as lead for special projects team, in addition to responsibilities working with airline tickets

PUBLICATION

Adkison, LR, DL Lockwood, AL Hanson, AG Glaros. 2014. Development of a longitudinal database for an integrated curriculum. Medical Education Development 4(1): 5231. POSTER PRESENTATIONS

Adkison, LR, D Lockwood, AL Hanson, AG Glaros. 2013. Enhanced feedback with the implementation of a longitudinal database in an integrated curriculum. Presented at Harvard Macy Poster session of the AAMC annual meeting, November 2013. Adkison, LR, D Lockwood, AL Hanson, AG Glaros. 2013. Development of a longitudinal database for an integrated curriculum. Presented at the AACOM annual meeting, Baltimore, MD, April 2013

Adkison, LR, DL Lockwood, JJ Dougherty. 2011. Electronic Tracking of Patient Encounters and Procedures Improves Feedback about Student Engagement in Clerkships. Presented at the AACOM annual meeting, Baltimore, MD, 13-16 April 2011.

Contact this candidate