SUMMARY:

• Solution oriented, highly motivated information technology professional recognized for innovative approaches and solutions that support and enhance business processes.
• A results driven professional who thrives on new challenges.
• Broad - based skills encompassing: process development, data management, systems analysis, deployments, software development, quality assurance, and change management.

EXPERTISE AREA:

• Project Management Configuration Management
• Change Management Data Analysis
• Computer Systems Validation System Analysis
• Database Design System Development Life Cycle
• Determination of Data Migration Path Oracle Development
• Microsoft Access Development PL/SQL Development

PROFESSIONAL EXPERIENCE:

Consultant - SQL/Oracle Apex Developer

Confidential

Responsibilities:

• Developed Food Safety application screens and applicable packages using Oracle Application Express and Quest Toad for the Food Safety Department in Virginia Department of Agriculture.
• Performed extensive data analysis on disparate data where referential integrity and business rules constraints were not enforced.
• Completed 85% of the data migration and implemented new data integrity and business rules.
• Worked closely with the business client and IT SME to understand the business and IT needs for success migration of data and development of the new application.
• Assisted to DBA with resolving export issues which required table design changes and data remapped to ensure a successful import. The need for this changes occurred less than 24 hours before go live.

Consultant - SQL Developer

Confidential

Responsibilities:

• Developed processes and database solutions that supported the State Longitudinal Data System, App4VA, and new FOI reports found on the VDOE website.
• Leveraged extensive data design and PL SQL to create custom built tables that provide the reporting needs of researchers, parents, school divisions and legislators.
• Process improvement via automation of data refreshes which reduced the need for human intervention.
• Gathered and documented requirements for new processes.
• Provided maintenance support and troubleshoot issues that involved current public facing production reports.
• Tested internal and external development for suitability and ensure that the deliverable adhered to business requirements.

Software Quality Assurance Manager

Confidential

Responsibilities:

• Managed the newly created Software Quality Assurance team for the Healthcare Logistics (HCL), a subsidiary of Confidential & Minor.
• Leveraged knowledge of distributed applications, databases, EDI, SQL, and system integration and tested changes to applications which supported the OM HCL business.
• Created standardized quality assurance practices. Documented repeatable test scenarios, and created reusable test scripts.
• Ensured SQA team adhered to GAMP, and FDA Guidelines and Computer System Validation methodology.
• Determined test plans, identification of regression test, and integration testing.
• Provided guidance and trained SQA resources which included IT and non-IT team members in support of various implementations.
• Improved the Change Control process by automated the Change Control process and approval.
• Acted as implementation manager for several client implementation and enhancement requests.

Consultant - System Analysis/PL/SQL De veloper

Confidential

Responsibilities:

• Responsible for determining the security configuration for client and web based access for the WMIS upgrade.
• Worked closely with business analyst to translated business rules in to design requirements to ensure that the application met the client need.
• Wrote PL/SQL scripts that performed data loads from source tables to new upgrade tables that had differing database designs and data requirements. Ensured that data integrity was maintained and required data gaps were mitigated by the PL/SQL scripts
• Analyzed and determined data mapping of varying data sources, Microsoft Excel, Microsoft Access, delimited flat files and older database versions.
• Worked with a cross functional team to create system design and functional specifications for new development projects.
• Developed custom code for the existing Work Management Information System (WMIS) to ensure end user requirements were met.

Project Lead

Confidential

Responsibilities:

• Historically, the CCB meeting would run over the scheduled meeting time by as much as an hour. Streamlined and improved the change control processes and procedures via improved communication and documentation of the process. Meeting time was reduced to the scheduled meeting time or less.
• Managed the development and deployment of the Emergency Prescription Drug program. This program would allow displaced individuals in the event of a natural disaster to receive prescription benefits free of charge. Program developed and implemented in 30 days
• Supervised bulk data loads from Pharmacy Healthcare provider’s retiree drug information into the CARDS application, ACS proprietary application. This application allowed private employers to be reimbursed eligible retiree prescription drug benefits.
• Resolved data discrepancies and recommended process improvement to reduce data load and fixed flat file format issues.

Associate Engineer

Confidential

Responsibilities:

• Planned and executed all phases of project management including system analysis, scheduling, design, design, task assignment, development, testing, and deployment.
• Brought onto projects as the Project Manager or co-Project Manager for projects experiencing challenges such as difficult clients, delays and/or unclear project objectives which were in jeopardy of missing the project deployment date..
• Information System Technical Project Manager responsible for system requirements, configuration needs and business rule changes required to integrate into the company-wide enterprise system.
• Managed the Oracle Reports sub-project to upgrade reports from Oracle 8i to Oracle 10g as part of the SQL *LIMS Upgrade. Project implemented on time and in budget due to dual role as the project manager and lead internal developer.
• Responsible for configuration management which ensures that the SQL *LIMS application was maintained in a validated state and adhered to FDA regulatory and GAMP.
• Assessed and evaluated client requests for modifications, enhancements and upgrading of existing systems to determine if the request were feasible with regard to company objectives, budgetary and resources needed.
• Wrote scheduled batch jobs to ensure that the 24x7 SQL *LIMS application exceeded the SLA required uptime of 90% for US and UK client.

Consultant

Confidential

Responsibilities:

• Created graphical user interfaces for application and Oracle reports.
• Consulted with business users to understand business rules and needs in order to ensure the programs met the expected objective.
• Reviewed, analyzed, and evaluated business systems and user needs when addressing requests for modifications and enhancements.
• Identified data sources, provided data flow diagrams and documented processes.
• Wrote detailed descriptions of the program functions and steps required to develop or modify TimeCard®.