CHRISTINA S. KING ***** Southcreek Court, Indianapolis, IN 46236

317-***-**** • adjxrk@r.postjobfree.com

Analytical, deadline-driven professional with over 20 years of IT experience, including 17 years with a Fortune 500 company who is able to describe complex information in laymen’s terms and communicate with customers worldwide.

Core Competencies

Organization

Problem solving

Attention to detail

Training

Judgement

Communication skills

PROFESSIONAL EXPERIENCE

DAUBY O'CONNOR & ZALESKI (DOZ), CARMEL, IN 12/2016 - Present

IT Business Analyst - Manager

Research cloud-based software applications comparing the latest functionality that would enhance our company's processes along with pricing comparisons in order to replace current accounting packages that used in-house servers.

Directed a committee of senior level auditor and tax partners to assist with testing various software applications.

Advised one of our CEOs to use a right-sized file storage system rather than a document management system which resulted in saving the company $60,000 annually.

Collaborated with individual departments to migrate their in-house server data to the new file storage system.

Assisted with the implementation of a cloud-based tax application.

Launched an online recruiting application to replace a paper system.

Create and modified Excel macro reports using Visual Basic for Applications (VBA) and MS SQL.

Produced an automation system using VBA macros which used HUD audit information from Excel spreadsheets as input to populate information in a government Financial Assessment website.

Leverage SQL Server Integration Services (SSIS) to extract, transform, and load data from different databases and flat files to create dashboards using our Smartsheet data visualization tool.

Document business process workflows, application best practices, and troubleshooting guides.

Use MS SQL interface tables and procedures along with SSIS to automate the addition and editing of clients and their accounting projects

Manage one employee by communicating job expectations, monitoring assignment workload, and providing career coaching.

ELI LILLY AND COMPANY, INDIANAPOLIS, IN 05/1999 – 12/2016

Associate Consultant SME – Global Data Delivery, 08/2012 – 12/2016

Served as the global subject matter expert for clinical trial electronic data capture (EDC) and management (CTMS) using Oracle's InForm 5.5 and InForm 6.0 software, providing support for users in India, Australia, Japan, Canada, Latin America, Russia, Turkey, United States, and all of Europe.

Served as subject matter expert for Oracle’s InForm security setup using Oracle’s User Management Tool.

Provided customer support to Lilly Clinical Data Analysts and the Global Patient Safety department as well as third party organization personnel on InForm and User Management Tool functionality.

Managed problem resolution for phase 3 clinical trial management issues by analyzing data within the InForm application interface, audit trails, or ad hoc reporting.

Supported Clinical Research Operations and site users by providing guidance in alignment with InForm training and reference materials.

Adhered to Lilly's regulatory policies, procedures, and SOPs to ensure patient data privacy and compliance with GCP.

Tested new releases of the User Management Tool software.

Analyzed new versions of InForm leading the required modifications, testing, review, and implementation for newer versions of InForm software.

Developed business relationships by being a liaison between the clinical research customers and Oracle to provide system improvements and right-sizing newer versions of the InForm software.

Updated training materials with recent software and business process modifications.

Provided InForm training sessions for clinical data analysts, third party organization, and site personnel.

Created and edited SOPs, workflows, and step-by-step instructions to ensure accurate documentation of current business processes.

Strategized best processes for InForm usage with the clinical trial workflow template design in Oracle's Central Designer as well as the impact to downstream systems from InForm.

Associate IT Consultant – Elanco Animal Health Dept. GL885 – Elanco IT, 06/2007 – 07/2012

Programmed modifications to Elanco Sales Tracking and Automated Reporting (ESTAR) invoicing system using Informatica, Oracle SQL using T.O.A.D., and Unix.

Worked closely with an Oracle DBA to create a new database structure out of the Elanco Sales Tracking and Automated Reporting (ESTAR) system to create a new data warehouse (Global Data Warehouse) that incorporated country specific data.

Delegated development tasks to contractors for the Global Data Warehouse project.

Lead the design, testing with the creation and execution of test cases, and implementation of a Global Data Warehouse project for Elanco Sales and Marketing using Informatica, Oracle SQL using T.O.A.D., Unix, and ODBC connectivity.

Supported the Global Data Warehouse software for Elanco Sales and Marketing.

Prioritized enhancements and fixes to the Global Data Warehouse centered on customer feedback and information gathering.

Improved efficiency for data flow entering and exiting Global Data Warehouse.

Set up new OUS affiliates in Global Data Warehouse.

Documented system modifications to keep validation package current.

Replaced the Datacore vendor customer matching and merging process used by Global Data Warehouse with Trillium software vendor package used by Lilly.

Implemented interface between Siebel and the Global Data Warehouse to handle retail customer orders for Posilac.

Senior Systems Analyst – Corporate Dept. MC49H – Global Data Sharing, 03/2004 – 06/2007

Supported business in transferring data using Informatica ETL and Oracle databases to create publications to and subscriptions from data warehouses and ensure data governance on the warehouses within Global Data Sharing.

Assisted in the data warehouse processes to support a new LIMS system.

Incorporated Lilly-sponsored control and improvement processes within new publications and subscriptions by using LSEF and Six Sigma processes.

Senior Systems Analyst – Lilly Clinic and Corporate – Global Medical Regulatory IT, 08/2003 – 02/2004

Implemented operational qualification processes for the (Laboratory for Experimental Medicine) LEM instruments.

Assisted in the remediation of ER/ES issues concerning the LEM instruments.

Created systemic workflows for manual processes within LEM.

Updated LabVantage software to work with Business Objects.

Upgraded and system tested LabVantage software for LEM.

Provided enhancements for Version 2.0 release of the DNA Banking System using PowerBuilder and Oracle PL/SQL.

Senior Systems Analyst – Lilly Clinic – Global Medical Regulatory IT, 03/2001 – 08/2003

Supported Clinical Pharmacology Operational System (CPOS) using Powerbuilder and Oracle PL/SQL.

Engaged in the CRU Toolkit implementation by mapping and migrating data from CPOS to the Alphadas CRU Toolkit database using Oracle procedures.

Supported the Alphadas CRU Toolkit post-implementation.

Senior Systems Analyst – Corporate – Regulatory Affairs and Clinical Development IT, 05/1999 – 03/2001

Supported the Generic Lab System on the AS/400 using RPG III/IV and COBOL.

Supported the Clinical Research Information Systems on the AS/400 using RPG III/IV and COBOL.

EDUCATION

Master of Library Science, Indiana University - 2017

B.G.S., General Studies, Indiana University, Business – 1999

A.A.S., Computer Technology, Purdue University – 1986

COMMUNITY SERVICE

Volunteer, Lilly Day of Service, DOZ Outreach Committee

Contact this candidate