Virginia Mcgregor Email & Phone Number

Remote

Investigate and resolve Consumer Communication Research RequestsSupport DevOps with Maintenance Medication Product ExceptionsRun and monitor existing SQL ETL jobsData research in various relational database management system environmentsCreate and update documentation for existing and new processesDevelop and update SQL/ETL automation solutions, with focus on data transformations and rigorous data QC/audit functionsResponsible for load, transformation, cleanse, and analysis of data sets sourced from various sources, including other databases, applications, flat files, and ExcelStrong knowledge integrating data from various internal and external sources, including cloud-based environments, to provide information and insights that support communication strategies. Support existing data processes that drive consumer communications including evaluating current workstreams for opportunities to build efficiencies. Define and resolve gaps in data and data-related workflows

Knoxville, Tennessee Area

Designs and analyzes data for the College of Architecture and Design undergraduate admissions, enrollment, diversity reports and other statistical reports required.Develops and updates spreadsheets and databases to track, analyze and report on applicant data for all applicants to the College.Coordinates with Directors to establish information and design forms on the Schools’ websites for applicants, student and staff utilization.Identifies and recommends changes to existing processes to improve accuracy, efficiency and quality service.Builds and maintains excellent customer relationships through timely response to inquiries and going above and beyond to accommodate unusual requests.Assists School Directors with logistical arrangements, compiling reports and student work for School Accreditation.Enters audit requests from Academic Advisor into the Degree Audit Reporting System.Processes course permissions to undergraduate students in Banner as requested by Academic Advisor.Maintains calendars and carries out administrative functions to assist in the efficient operation of the Schools of Interior Architecture and Graphic DesignResponsible for coordinating student activities and events, Board of Advisors meetings and other events as requiredResponsible for Directors’ travel arrangements to conferences, conventions, workshops and development eventsAssists with creating and maintaining semester timetables including additions, cancellations and room and instructor assignments.Assists School Directors with faculty, advisor and staff searches.Performs research to collect and record industry data.Volunteers to help with special projects of varying degrees of complexity.

Knoxville, Tennessee Area

Tracked status of documents received from project technicians.Collected reports and maintained document files for all projects.Filed all correspondence, reports and forms related to projects.Organized and maintained files of records and correspondence for projects.Assisted in the completion of forms and the retrieval and research of recorded documents.Verified accuracy of vendor invoices for equipment and payroll.Performed clerical activities to support records and management specialist.Performed general administrative duties ensuring all documents are accurate and complete.

Knoxville, Tennessee Area

Prepared documents, reports and presentations for executives and board members using advanced software proficiencies.Tracked status of vender contract documents received.Processed mail and correspondence for the C-Suite and hospital administrators.Ensured patient and staff complaints are routed to the correct personnel.Assisted Directors with the corporate office inventory and administrative supplies on hand, as well as the weekly preparation of orders for purchasing.Organized and coordinated weekly and monthly meetings including food orders, conference room equipment set-up and minutes preparation.Transcribed minutes of meetings and executed meetings and events for company to support sales, business development and senior management teams. Coordinated calendars for Directors, CEO, CNO, CFO, COO and department conference rooms. Prepared weekly expense reports, budgets and filing systems for operating officers.

Knoxville, Tennessee Area

Tracked status of documents received from project technicians.Collected reports and maintained document files for all projects.Filed all correspondence, reports and forms related to projects.Organized and maintained files of records and correspondence for projects.Assisted in the completion of forms and the retrieval and research of recorded documents.Verified accuracy of vendor invoices for equipment and payroll.Performed clerical activities to support records and management specialist.Performed general administrative duties ensuring all documents are accurate and complete.

Organized construction of new training and conference room spaces.Implemented new electronic employee file software which included scanning documents, setting user security and sharing capabilities.Created ongoing reporting of controlled substance volume for in-state and out-of-state prescription monitoring programs.Wrote ongoing reports for pharmacy and management staff for inventory tracking.Collaborated with legal regulatory staff to meet regulatory and accreditation standards.Assisted in establishing and maintaining pharmacy licenses for in-state and out-of-state boards.Assisted training coordinator with quarterly audit reports.Coordinated with Managers to establish information on the departmental web sites for patient and staff utilization.Developed and maintained variety of other documents/forms/references on websites.Created electronic departmental newsletters for internal committees and staff notifications.Maintained Policy & Procedure information on departmental websites.Coordinated the assignment of required training with new hires.Developed and maintained web based training modules.Assembled training materials including orientation manual.Maintained employees and facilities licenses and certifications.Maintained and updated electronic personnel files.Assisted education coordinator with recruiting objectives including compiling application materials.Organized and facilitated social events including budgets and contacting outside vendors.

Trained data entry staff to answer email and phone inquiries from applicants. Collaborated with data entry staff to create procedure manuals for email and phone questions; duplicate candidate profiles; and job line voice recording.Created internal HR demographic and statistical reports for workforce auditing purposes.Edited online applications for external and internal candidates in an online application system.Proofread and voice record postings for job posting line.Combined duplicate candidate profiles in application system into one profile.Verified external/internal status of applicants for reporting purposes.Answered email and phone inquiries from internal and external applicants.Scanned resumes, applications, and performance reviews using Adobe to add to the online application system.Attended meetings of data entry staff, including diversity training.Composed meeting minutes for data entry staff.Filed applications in our close-out file system using Access database.Greeted visitors and directed them accordingly.Entered numerical data into databases with speed and accuracy using 10-key pad.

Rochester, Mn

Authored a Quick Reference Guide for Opinio survey software.Provided staff support with planning, development, implementation and maintenance for institutional publishing and information delivery needs.Provided analysis, support and project management services for projects undertaken with other internal groups.Provided administrative direction for web development staff, forms analyst, Print Shop management, and distribution personnel.Created website using Contribute for new employees.

Posted payments to patient accounts into our accounting system.Sorted explanation of benefits by insurance company names for the processing teams.Verified payments were posted using the 305 report.Scanned batches of explanation of benefits for the processing teams.Verified the refund email from Blue Cross/Blue Shield using Blues and PLB reports.Sorted and routed mail to proper departments and staff.Composed staff meeting minutes.

Reconciled accounts receivable ledger to verify payments and resolve variances.Applied proper encoding of CPT and ICD-9 codes for patient super bills.Processed bill reminders and consulted with third-party collection agency to resolve past-due customer accounts.Posted payments and charges to patient’s electronic accounts.Made outbound calls to insurance companies and customers to discuss and resolve account needs.Investigated denials and corrected errors to resolve discrepancies.Verified accounts receivable reports.Prepared billing statements patients and recorded insurance and patient payments.Used accounting software to reconcile accounts, track payments and generate invoices.Responded to inbound inquiries regarding accounts and payments.Sorted and routed incoming mail for the departments and staff.Maintained certification for CPR.

Bachelor Of Science (B.S.), Technical And Scientific Communication, 3.378

Technical Writing, Project Design and Editing

Associate Of Art, Liberal Arts

Communication, Statistics and Graphic Design