Supervisor/Project Manager
Merck
Managed IT staff and performed all HR-related functions including interviewing, on-boarding, training, promotions, salary increases, employee reviews, and mentoring. Assigned projects and ensured timely completion.Managed BASIS database and corresponding software systems. Performed DBA activities and utilized SQL and FQM to develop database queries.Managed third-party application development by creating functional requirement specifications and working with the vendor to deliver error-free code. Oversaw UAT and rollout of application updates.Supervised internal development of new system applications for clinical literature operations. Integraded computer technology with operational requirements to provide productive information solutions and enhance departmental efficiency.Supervised system operations including routine maintenance, backup and data reorganization. Resolved operational problems.Coordinated vendor service for timely upgrades and repairs.Oversaw support of Clinical Literature and Merck Manuals' users and operations.Oversaw administration of SUN/UNIX server and provided end-user support and training.Migrated CLIC and Merck Manuals database files and supporting applications from a department-managed UNIX server to two (development and production) IS-managed servers in North Carolina. Upgraded five major software packages. Converted over 600,000 data records to new formats and modified more than 500 programs.Proposed, designed, and partnered with vendor to create the “Abstractor Inbox”, an Outlook-like application that allows department personnel to view and complete abstracts for articles in their backlog.Served as a Business Analyst on a project to create and enhance a web-based search interface for the Clinical Literature database.Developed a VBA module to automatically generate Disbursement Vouchers for paying authors and contributors of the Merck Manuals.Led the departmental rollout of Windows XP.