Continued work (remotely) as part of dedicated team assisting the Pathology Department with all data and technical needs.- Troubleshot and improved HL7 electronic pathology reporting working with a 3rd party integration team and medical practices to reduce the costly process of mailing or faxing pathology reports- Increased revenue by fixing pathology billing and charging data quality issues- Developed CCL programs and reports to extract data for end users.

Developed a national benchmarking program for public pathology services. - Designed custom ETL tools and a data warehouse for the program using SQL Server, Transact-SQL, Access, and Excel. - Presented on data analysis and findings at workshops and forums. Composed key points for executives to communicate about the data to generate support for public pathology services.- Created an Excel based data analysis tool for distribution to executive teams. - Provided customized reports… Show more Developed a national benchmarking program for public pathology services. - Designed custom ETL tools and a data warehouse for the program using SQL Server, Transact-SQL, Access, and Excel. - Presented on data analysis and findings at workshops and forums. Composed key points for executives to communicate about the data to generate support for public pathology services.- Created an Excel based data analysis tool for distribution to executive teams. - Provided customized reports to each participating pathology service.- Supported the analytical requirements of the benchmarking program and Public Pathology Australia. Show less

Part of a dedicated team assisting the Pathology Department with all data and technical needs.- Developed CCL programs and reports to extract data for end users.- Gained domain expertise in pathology by working closely with scientists- Configured and repaired hardware (handheld printers, PDAs, medical devices, etc) as needed for the department.- Provided out of hours support for Pathology applications.- Liaised with vendor to troubleshoot Cerner application problems for end… Show more Part of a dedicated team assisting the Pathology Department with all data and technical needs.- Developed CCL programs and reports to extract data for end users.- Gained domain expertise in pathology by working closely with scientists- Configured and repaired hardware (handheld printers, PDAs, medical devices, etc) as needed for the department.- Provided out of hours support for Pathology applications.- Liaised with vendor to troubleshoot Cerner application problems for end users. Show less

Administered and controlled multiple transactional and data warehouse databases. Interfaced with various application development teams in an Agile development environment, focusing on data storage and performance considerations for application systems being developed. Designed, developed and improved PL/SQL code for the applications. Provided quick turnaround to business users on complicated data warehouse report requests, enabling rapid decisions. Upgraded non-production database environments… Show more Administered and controlled multiple transactional and data warehouse databases. Interfaced with various application development teams in an Agile development environment, focusing on data storage and performance considerations for application systems being developed. Designed, developed and improved PL/SQL code for the applications. Provided quick turnaround to business users on complicated data warehouse report requests, enabling rapid decisions. Upgraded non-production database environments to use Oracle 12c Pluggable databases to maximize resource utilization and decrease costs.Assisted senior management in exploring the possibility of moving the application databases into the cloud. Built proof of concept database servers with Amazon Web Services (AWS) EC2 Servers with Oracle 12c using Automatic Storage Management. Utilized AWS Oracle Relational Database Service (RDS) for certain applications. Show less

Immigration and Customs Enforcement (ICE) – Trade Transparency Unit (TTU)Enabled ICE-wide and world-wide deployment of the Data Analysis and Research for Trade Transparency System (DARTTS). Designed, developed and implemented a plan to migrate DARTTS data to Oracle from thousands of MS Access databases. The resultant 4+ terabyte Oracle 11g database improved select query performance by 80 – 900% and allowed an increase in users from 30 to 1,000.Supported both development and… Show more Immigration and Customs Enforcement (ICE) – Trade Transparency Unit (TTU)Enabled ICE-wide and world-wide deployment of the Data Analysis and Research for Trade Transparency System (DARTTS). Designed, developed and implemented a plan to migrate DARTTS data to Oracle from thousands of MS Access databases. The resultant 4+ terabyte Oracle 11g database improved select query performance by 80 – 900% and allowed an increase in users from 30 to 1,000.Supported both development and production aspects of the DARTTS application. Created and updated ETL scripts for many diverse raw data sources to provide timely information for analysis. Performed regular updates to all data sets using transportable tablespaces to facilitate quick movement of data between environments. Worked with developers to identify performance bottlenecks and solved them with varying options such as materialized views or database configuration changes. Supported ICE Agents and Intelligence Analysts by developing custom queries to support deeper analysis than the application could provide. Provided world-wide database technical support with extensive travel to Europe, South America, Central America and Mexico. Supported senior management by serving as a technical resource in negotiations with foreign governments. In addition to providing data and database expertise, configured all DARTTS related hardware including Linux Database Servers and Windows domain and file servers. Performed ad-hoc technical tasks as needed such as setting up training laptops, configuring and encrypting PCs, and setting up off-site stand-alone DARTTS implementations. Show less

Overseas Private Investment CorporationQuickly became a trusted technical expert depended on for input on all critical technical decisions. Created implementation plans for Oracle 10g Grid Control and Recovery Manager. Implemented Oracle 10g Grid Control on a Windows 2003 server. Compared Oracle and SQL Server Baseline Security Documents to the actual Oracle and SQL Server Environments. Troubleshot various problems in the SQL Server environment as they arose.

Built upon foundation of database knowledge to become the in-house database expert relied on to support all aspects of Oracle, extending into server administration and application development.