Kenneth Huling

SKILLS: Data Architecture, Data Warehousing, Business Intelligence, Big Data, Database Administration, Storage Design and Software Engineering, Cloud Database Administration (Azure/AWS) Harvard Medical School

(HMS) is one of the

graduate schools of

Harvard University and

currently the #1 medical

school in America, as

ranked by U.S. News and

World Report.

There are approximately

2,900 full- and part-time

voting faculty members

consisting of assistant,

associate, and full

professors, and over 5,000

full or part-time non-

voting instructors.

The school is the third

oldest medical school in

the US and was founded by

Dr. John Warren on

September 19th, 1782 with

Benjamin Waterhouse, and

Aaron Dexter. The first

lectures were given in the

basement of Harvard Hall

and then in Holden Chapel.

The first class, composed of

2 students, graduated in

1788.

Harvard Medical School (Consultant Role) (01/2009-Current) LEAD DATA ARCHITECT / DBA

Reporting to the CTO of Harvard Medical School, I serve as the Lead Data Architect for a $250 Million federal grant funded open-source nation-wide distributed Web 2.0 Bioinformatics and Research Collaboration Initiative funded by the NIH.

Created repositories of Medical data from multiple Database systems, including MySQL, Oracle and SQL Server using T-sql, PL/SQL queries, stored procedures and ETL packages.

Designed Data Model, Access layer and ETL strategy for Research Networking application

(http://profiles.catalyst.harvard.edu), a to promote Inter-Disciplinary collaboration across institutions.

Designed both onsite and Cloud-Based storage strategies for Bioinformatics data repositories. Using AWS VMs and services, we produced a well performing, cost effective storage solution for our analytic data warehouse. For smaller more resource intensive databases, I designed and implemented $50K solid state drive based, analytic warehouse hardware. Consisting of Raid 1+0 across 35 SSD drives for maximum IOPS.

Incorporated complex, Social Networking Algorithms, Natural Language Processing (NLP), Author Disambiguation Algorithms and Proprietary Metric Weighting into SQL Server using Stored Procedures, CTEs, UDFs and Graph Theory to efficiently to build passive network models and graphs to discern and display known and unknown links between faculty.

Managed all DBA Responsibilities for Catalyst Profiles application databases spanning 10 VMs, 20+ SQL Server instances of various SQL Versions from 2008 R2 to SQL 2017 and hundreds of databases from 10 GB to 2 TB in size. This includes setting RTO/RPO requirements, backup, maintenance, HA/DR solutions.

Converted relational data model into a triple based RDF data model for use with a SPARQL interface for querying large amounts of data.

Developed SSAS Data Mining and Predictive Models for analysis and future prediction of Publication and Collaboration, among Doctors and Researchers, across medical and academic institutions. Using Microsoft’s Association Rules, Clustering and Neural Network algorithms, I developed models to uncover non-obvious patterns of collaboration clusters and key influencing attributes to help understand how grant applicants were being chosen and to help illustrate important attributes pertaining to past collaborations between researchers.

Created HMS Hosted repositories of publicly available data sets such as NLM PubMed, Web of Science, NIH Exporter, PatientView, Orcid, UnPayWall, Scopus, and more. These were incorporated into our Profiles Application and made available to other institutions using APIs and disambiguation services.

Designed Asynchronous Query system using SQL Server Service Broker and a series of queues, contracts and bound stored procedures to handle concurrent queries from distributed Web Services to allow for long running queries to be dispatched, and run in parallel with other queries without overwhelming the db engine during peak periods.

Designed POC Cloud Based Graph databases such as AWS Neptune as a means of migrating RDF data models into a cloud based platform

NARRATIVE: A seasoned Data Architect with 20 years’ experience in Data Warehousing, Business Intelligence, Database Administration, Software Engineering, Storage Architecture and Networking. I’ve delivered enterprise Data Warehouse and Business Intelligence Solutions for Expedia / TripAdvisor®, the world’s largest Travel Website experiencing 50 Million Unique visitors a month, built a global BI Strategy and Operational Data Store from the ground up for an Academy Award Winning Entertainment industry leader, Avid, Inc. and helped to Architect a Global Bioinformatics Federated Web 2.0 Solution for Harvard Medical School that is used Globally as part of a $250 Million grant from the NIH. I have architected a Financial Revenue Warehouse Reporting Portal Environment for AT&T, the leading Wireless Telephone Provider in the US. I’ve lead teams to design Business Intelligence and software solutions for leaders in the Academic, Telecommunications, Travel, Healthcare, Entertainment and Software Industries. EXPERIENCE:

WE SAW A PROBLEM

Our company was

established after our

founders made a discovery

while working in revenue

cycle management for a

large health system. They

uncovered an entire

industry that was using

outdated and inefficient

systems to manage patient

revenue

VisitPay (Consultant Role) (2/2019-4/2019) AZURE SQL DBA

Provided Remote DBA Services for Azure SQL Cloud Environment consisting of ~900 SQL Databases mixed between Azure SQL DB and Azure VM Hosted Databases for Medical Billing Company in HIPAA and PHI regulated environment.

Created Azure Powershell scripts for mass Database Tagging, backups, restores for regular refreshes of Dev, Stage, QA and Production database lanes.

Provided Query Tuning and support for Dev/Ops and Dev teams.

Worked in CI/CD environment for daily production builds using Jira Kanban and GitHub.

Developed queries for Medicaid / Medicare claims for Medical Billing software. EXPERIENCE:

The industry leader since

1989, Artfact.com provides

marketing and e-commerce

services to the $40 billion

live auctions market. As

part of the Artfact network

of web properties

(Artfact.com,

AuctionZip.com and

Invaluable.com),

Artfact.com supplies over

20,000 estate and art

auctioneers worldwide

with solutions including

employing the SaaS

Invaluable, LLC. (Consultant Role) (10/2011-6/2018) SQL CONSULTANT

Provide General SQL Database Administration and Advisory Services.

Provided Advisory Services for Enterprise Wide SQL 2000-SQL 2008 Migration.

Provided benchmark performance testing across enterprise for SQL Server I/O.

Coordinated with Dell and EMC vendors on $100k Hardware procurement consisting of EMC San, VMWare servers, Solid State Drive infrastructure and DELL Servers.

Designed start to finish Site Migration from SQL 2000 to SQL 2008.

Provided Data Migration Services for client acquisition. Importing client MySQL database into SQL 2012 OLTP Database environment using combination of SSIS and T-SQL scripts and packages.

Provided SQL Server tuning of poorly performing stored procedures to reduce cpu/execution times by factor of 10. Bridgeline Digital is a

developer of an award-

winning web engagement

management software suite

and interactive business

technology solutions that

help customers leverage

best in class web-based

technologies to achieve their

business objectives. The

iAPPS Product Suite is an

innovative SaaS solution

that deeply unifies web

Content Management,

eCommerce, eMarketing,

and web Analytics

capabilities into the heart of

websites, online stores, intra

Bridgeline Digital, Inc. (Consultant Role) (09/2010-8/2018) DATA WAREHOUSE ADMIN

Lead AWS cloud migration of all internally hosted data warehouse environments (5 VMs, 80+ Warehouse/Cubes).

Manage Multi-Tenanted Data Warehouse environment. Consolidated 8 over-taxed VMs to 2 high capacity SSD based systems, improving Nightly processing from 14 hours to 2.5 hrs, for a 500% performance increase.

Implemented Distributed Analysis Services environment, separating processing and query servers for redundancy and improved performance using combination of Attach/Detach and customer XMLA scripts to achieve near real-time replacement of updated data.

Designed and implemented CMS campaign tracking and reporting system using SSAS cubes, complex MDX queries, SSIS ETL packages and stored procedures with embedded dynamic MDX for custom reporting. Campaign management system allows SaaS clients to launch email/web/media campaigns and track dozens of complex and configurable goal types against their website click stream data.

Created Partitioned Cube strategy to eliminate the need for full cube reprocess every night and allow for incremental and parallel processing, thereby reducing nightly load times from hours to minutes.

Created dynamic cube processing strategy using SSIS to build dynamic XMLA script for appropriate partition to process based on date parameter.

The Nexxus Group® has

been leading the way in

Scan Based Trading (SBT)

services since 2003. Our

solutions range from

electronic data exchange

and sales and margin

reporting to consolidated

billing and price book

management.

As the industry leader in

the technology behind Scan

Based Trading (SBT) we are

ers and suppliers count on

The Nexxus Group. (Consultant Role) (04/2016-Current) Remote DBA Services

Provided Remote SQL Server DBA Services for Enterprise OLTP Database and Report Services environment.

Add nightly Stats and Index rebuilds to greatly improve query plans, index selection and query performance.

Implemented Red-Gate SQL Monitor for better issue monitoring and server tuning across IT Group.

Added regular monthly unused/suggested index checks for proper/efficient index usage for new SQL Objects.

Provide MDX query consulting for report expressions and calculated MDX.

Provide T-SQL query tuning/optimization for poorly running queries/reports using query analyzer, parameter sniffing resolution, and custom system/catalog views for index usage info. EXPERIENCE:

Triton Systems is a Global

Business Venture company

that successfully launches

innovative products and

solutions in emerging

markets worldwide. We

invest in new technologies

through in-house .

Triton Systems, Inc. (Consultant Role) (8/2016-current) SQL CONSULTANT

Contracted to convert existing Contracts/Proposal system from MS Access back-end to SQL Server.

Migrated entire access database environment, consisting of 6 MDB/MDE files and Linked Table files to single consolidated SQL Server database in SQL Server Express 2014.

Converted deprecated Novell Groupwise email specific code to generic SMTP code using native VB objects available in Access.

EXPERIENCE:

Avid has become the world

leader in digital media

creation tools for film,

video, audio, animation,

games, and broadcast

professionals – as well as

for home video and home

audio enthusiasts. Today,

the vast majority of

primetime television

shows, feature films,

commercials, and chart-

topping pop music hits are

made using one or more

Avid products. And the

company has received the

most prestigious awards in

the industries it serves –

including three Emmys, a

Grammy, and two Oscar

statuettes: the 1998

Scientific and Technical

Award for the concept,

design, and engineering of

the Avid Film Composer

system for motion picture

editing.

Avid Technologies, Inc. (07/2008-01/2009) DATABASE ENGINEER

Designed Unified Business Intelligence Strategy, consolidating disparate data silos in Oracle SAP BW, Web Diver, Excel, etc. into single cross-enterprise view of business intelligence data. Using SQL Server 2005/2008, SSAS, SSRS and Performance Point Server.

Implemented multi-environment, High-Availability, database development strategy consisting of Dev, QA, Test, Production as 2 Multi-Instance Failover Clusters (Active/Active) for Sql Server 2005/2008 Data Warehouse and OLTP Operational Data Store (ODS).

Modeled Enterprise ODS for Global Leader in Audio and Video Technology Software / Hardware to consolidate disparate ERP and POS systems across the globe in Subsidiaries and Divisions. Improving company business processes, communication, productivity and Business Intelligence Accuracy and usability. Designed Physical Storage plan, separating Logs, TempDB, Data Files and Index Files and storing on optimal Raid Sets for speed and redundancy. Used fiber channel EMC SAN with multi-gigabit Ethernet connection for shared storage.

Created SOA architecture around ODS using WebMethods and ASP.NET 2008 Web Services. Integrated ODS with Oracle, SAP and Salesforce.com across the enterprise using combination of Middleware (webmethods, SAP XI, SSIS).

Created Master Data Management (MDM) Process for hourly and quarterly exports of Customer Master Data to Dun and Bradstreet for Data Cleansing and Demographic appends. Demographic Appends data provides complete hierarchal view into customer parent organizations with detailed Sales, CEO, and Marketing information for leveraging cross selling opportunities.

TripAdvisor® Media

Network, operated by

TripAdvisor, LLC, attracts

nearly 30 million monthly

visitors* (across ten

popular travel brands,

TripAdvisor®,

airfarewatchdog.com™,

bookingbuddy.com™,

cruisecritic.com™,

holidaywatchdog.com™,

independenttraveler.com™,

seatguru.com®,

smartertravel.com™,

travel-library.com™ and

travelpod.com™).

TripAdvisor-branded sites

make up the largest travel

community in the world,

with more than 25 million

monthly visitors*, six

million registered members

and 15 million reviews and

opinions

TripAdvisor / Expedia (02/2007-07/2008) LEAD DATA WAREHOUSE ENGINEER

Managed 18 + Terabyte Sql Server 2005/2008 Data Warehouse on spread across 10 SCSI Disk Arrays using over 125 Disks. Also Responsible for multiple smaller departmental Data Marts ranging in size from to 2 Terabytes in size. Main Warehouse Fact table contained over 17 Billion Records with over 20 related Dimension tables, several of which contained over a billion records. Data Warehouse stored click stream data for one of the largest websites in the world. Data Warehouse provided analytic data to over 150 Product Managers and analysts.

Tuned and Optimized Warehouse with proper indexing and efficient/elegant Sql and at physical level, by employing volume alignment at the physical disk level, separating logs and temp databases to isolated and faster drive sets using Raid 10. Partitioned main fact table by Month to break up data files and help indexing. Created series of reports to monitor data file, table and overall db growth on a daily basis and forecasted future growth at 3/6/12/24 month intervals using growth algorithms to help keep hardware up to date.

Created and managed several OLAP Cubes using SSAS. Created 100’s of partitions, partitioned by day, each consisting of 15-20 million fact records. Created custom aggregation strategies to provide best performance for end- users. Created daily processing strategy using SSIS and Xmla/Mdx queries. Created many SSRS reports using MDX to provide flat-style reports from Cube data.

Implemented Performance Point Server 2008 for use as Reporting portal to expose OLAP Cubes to end users via OWC Pivot Table, ProClarity, Reporting Services and Excel Reports. Segmented Business Data across Business Models to create business/reporting areas for specific areas of the Business. Developed Omniture/Visual Sciences Reports for Business Analysts for real time web site statistics and complex user path analysis.

Maintained legacy Java based ETL System as well as engineering new SSIS based ETL System consisting of Dozens of Packages Importing/cleansing and “dimensionalizing” data from Postgres Databases to Sql Server Data Warehouse. Created distributed Database environment using linked servers, dynamically created synonyms, communicating with both windows and Linux ETL systems.

Created Reports to analyze user activity on the website using SQL, MDX and SSAS to score user lists and create Predictive Models to drive dynamic marketing campaigns targeted at increasing user retention/monetization.

Pulled data from Visual FoxPro Databases for Financial AR/AP reports. Enterasys provides

intelligent, best-in-class

infrastructure solutions to

enterprise customers. With

one of the industry’s

broadest product

portfolios—plus a full

range of service and

support offerings—

Enterasys is uniquely

qualified to meet the

evolving needs of today’s

businesses. As a renowned

enterprise networking

leader with more than 20

years of experience and

over 640 patents, Enterasys

has provided Secure

Networks solutions to some

of the world’s most

successful companies,

including many of the

Fortune 500.

Enterasys (03/2006-07/2008) SENIOR SQL SERVER DBA

Managed Terabyte sized, 200+ Table Sql Server 2000/2005 Global Operational Data Store. Administered 100 + Sql Server databases on more than 25 Servers for 1000+ internal and external users using Global Win2K Active Directory user and group policy objects. Designed Database Maintenance Plans for disaster recovery of production data environments. Created processes for regular refreshes of staging, QA and development environments using ETL tools like DTS and SSIS, and stored procedures to back-up, move and cleanse/obscure sensitive corporate data. Used tools like DBencrypt to encrypt sensitive customer and employee data.

Designed and Managed Data Warehouse consisting of Sql Server 2000/2005 Analysis Services and ProClarity Analytics Server 5.3 and 6.2. Processed OLAP Cubes from Star Schema Data Warehouse Data-Marts. Led Sql Server 2005 migration effort from Sql Server 2000, including DTS to SSIS migration of 100s of DTS packages. Used tools like Sql Server 2005 Upgrade Advisor and DTS Migration Wizard to perform side-by-side migration to Sql Server 2005.

Using .Net 1.1 / 2.0 Frameworks, architected secure global Web applications using C# and VB.Net languages in a Windows authentication security model. Worked with Business Users to upgrade antiquated Excel and Access business applications to centrally hosted Asp.Net Web applications to improve performance and scalability.

Led Customer Data Integration (CDI) project to cleanse customer and partner data by incorporating Dun and Bradstreet® tools and Business appends Data. Designed routines to cleanse and condense redundant customer data prior to cleansing. Created Interfaces to business applications such as Ceridian Payroll System, Oracle SAP 3.1 and Steelwedge Supply Chain forecasting software using Data Model enhancements, ETL processes, stored Procedures, User Defined Functions and customized error logging.

Created Metrics, Benchmarks and processes to monitor Sql Environment using Sql Server Health and Activity Usage Reports for Reporting Services to monitor db. Implemented Reporting Services subscriptions to route reports to internal/external Partners and clients.

Fortelligent is a diversified

provider of direct

marketing solutions that

improve client acquisition,

cross-sell/up-sell, churn

reduction and retention

programs. The Fortelligent

platform is a revolutionary

technology, which

automates the modeling

process providing high

quality analytic solutions in

a fraction of the time

required by traditional

analytical approaches.

Coupled with a ”no

nonsense” ROI approach to

solving business marketing

problems, their

breakthrough analytic

solutions have been known

to improve results,

sometimes by over 400%,

throughout the customer

lifecycle in data intensive

industries such as financial

services, retail, healthcare

and telecommunications

Fortelligent, Inc. (03/2005 - 03/2006) SR. DATA WAREHOUSE ENGINEER / DBA

Using Kimball Methodology, designed VLDB data warehouses in SQL Server 2K/2005, Sybase IQ 12.6, and Netezza Performance Server® ranging, in size, from 100’s of Gigabytes to 10s of Terabytes, with Star Schema Data Mart fact table row counts of greater than 700 Million Rows.

Performed Tuning and Optimization of Sybase IQ Data Warehouse by implementing proprietary indexes like LF, HG, HNG, DATE, FP1, FP2, etc. Designed queries for Teradata DBMS systems, incorporating Teradata SQL Analytic functions like CSUM, for use in ETL processes of customer data. Developed complex Dynamic ETL processes to automatically Load, index and query Sybase IQ and Sql Server 2000 and Sql Server 2005 databases. Monitored performance in Sybase IQ and Sql Server databases using stored procedures and tools like Perfmon, DBConsole

(Sybase IQ), sp_who2 (Sql server), sp_lock(Sql server), sp_iqconnect, sp_iqcontext, etc.

Migrated Microsoft Reporting Services Reports and Report Server to Reporting Services 2005 to extend, to our clients, new functionality, such as Report Builder, fixed headers (to mimic frozen panes in Excel). Migrated Sql Server 2000 DTS Packages to Sql Server 2005 Integration Services Packages (SSIS) for improved ETL performance and flexibility, using Visual Studio 2005.

Designed Global Business Intelligence Portal using ASP.NET, Microsoft Reporting Services, Forms Authentication, Custom Security classes, Triple-DES encryption, and strong password generation algorithms. Designed Executive Level Reports for wireless companies like AT&T using data from OLAP cubes designed in Microsoft Analysis Services, viewed using ASP.NET and OWC to provide dynamic web-based Pivot Tables with minimal client-side footprint.

Integrated Business Objects XI Enterprise into legacy web Portal using Business Objects XI .NET objects to integrate enterprise security into .net forms authentication model. Customized / branded out of box Business Objects XI Java Tomcat installation by editing jsp pages, css sheets, and web.xml files to display corporate logo / design standards. Created Business Objects XI universes and Desktop Intelligence reports.

Created Google Earth® GIS Reports from v.1 KML (Keystone Markup Language) to display wireless consumer usage trends and complex metrics in a national and local overlay of clusters and color gradient style GIS reports. TSD, Inc is a technology

driven company

specializing in car rental

software and services for

rental businesses of any

size. TSD’s flagship

product, TSD Rental

Management Software,

provides the leading

Windows based rental

software to car rental

businesses, including

features such as fast open

and close rental

agreements, contract

printing, billing, daily

reporting, management

reporting and much more.

Our comprehensive array

of car rental software

options includes

Accounting and GL

Interfaces, Credit Card

Processing, Electronic

Insurance Replacement

and Nationwide

Reservation Systems, ASP

options and more. TSD

seeks to provide true

turnkey solutions for our

customers by designing the

optimum configuration of

vehicle rental software,

hardware and services to

increase accuracy and

controls, improve customer

service and maximize

profits.

TSD-Inc. (09/2004 - 03/2005) (Consultant Role) SENIOR SOFTWARE ENGINEER

Provided Enterprise Level Software Solutions for Industry Leading Automobile, Motorcycle Manufacturers, and Car Rental companies such as Lexus, Toyota, Harley Davidson, HERTZ, Avis and Budget. Created dynamic Reports for Industry Leading Car Rental Companies using ASP, T-SQL, ActiveX, and .NET components. Created .NET Web Services using ASP.NET, to allow remote vendors and clients to integrate into Enterprise Application. Derived Soap Objects from .XSD Schemas in XMLSPY 2005, using code generation tools like the .NET tool XSD.EXE to generate C# and VB Serializable Objects. Provided Validation using .NET Classes such as XmlValidatingReader.

Engineered Business Adapters for Leading National Insurance Companies such as State Farm Insurance, Progressive Insurance, and Farmer’s insurance, etc in the form of software applications developed in various development environments including Visual Basic 5, Visual Basic 6, Visual Basic.NET 2003, ASP 3.0, and ASP.NET.

Created XML Interfaces with Partners and Vendors by consuming web services to enhance flag ship Auto Rental Management Software Suite by giving real-time location and scheduled Alert information on Automobile Asset Inventory around the world using Global Positioning Satellite (GPS) Systems and remote transponders.

Developed X12 based EDIFACT Interfaces for Worldwide GDS Leaders such as Amadeus, Galileo and Worldspan. Created Rate Update Applications to securely connect to a Remote Client IBM Mainframe and upload EBCDIC data files. Designed and maintained custom bi-directional Database, FTP, Web, XML and X12 Translators to exchange data between National Insurance companies and National Car Rental Companies to facilitate Insurance replacement Automobile reservation and Payments for their Insured clients after Automobile Accidents.

Developed and Maintained Web Applications in both ASP.Net and classic Asp environments. Provided client side validation and usability with JavaScript functions, DOM manipulation and .Net Server side Validation Controls. Corporate Overview:

Founded in 1996, SynXis

Corporation delivers

proven reservation

management and

distribution systems to

more than 4,600 hotels,

resorts and casinos

worldwide. Through a suite

of Internet-based

applications, SynXis

empowers hotel operators

with the ability to

consolidate and control

hotel inventory from all

sources, while maintaining

a single guest record. It

also provides money-

saving direct access to the

major GDSs and helps build

hotel revenue by enabling

consumers to conveniently

book hotel reservations

online through the hotel's

Web site.

HubX / SYNXIS (10/2002-09/2004) SENIOR SOFTWARE

ENGINEER

Using Visual Studio.NET, SQL Server 2000 Stored Procedures and DTS Packages, developed data integration processes between remote “Property Management System” applications residing on such diverse Operating Systems as Windows, DOS, UNIX and AS/400 with DBMS’ like Oracle, SQL/Microsoft, DB2, Access, Visual FoxPro.

Incorporated application integration techniques like “screen-scraping” using Terminal Emulator object-models, SQL queries for Relational data sources, COM, XML, Flat-File based vendor API’s, and Windows API/SDK to extract data from enterprise systems and generate data output to formats including, Character-Delimited and Name-Pair Value Flat files, XML File/Posts for transmission to relational Back-end for import using complex VBScript DTS packages, Data Tables, SQL DMO, and Stored Procedures. Experience integrating with Hotel applications, such as Micros-Fidelio, LMS, HIS, SMS, CLS, Falcon, Opera, and Mirage.

Developed Web Based Enterprise reports for major Hospitality Industry Web Site, using MS Reporting Services, RDL/Visual Studio.NET, ASP.NET(C#), Stored Procedures, and Crystal Reports 8/ 9.0. Consumed data from traditional data providers, such as SQL Server tables and Stored Procedures, XML Web Services, and MS Reporting Services’ XML based RDL (Report Definition Language.

Normalized data and applied Business Logic to client data using Transact-SQL Stored Procedures, incorporating User-Defined functions, input/output parameters, local variables, temporary tables/table variables, cursors, and SQL Mail for complex processing disparate client data received via VB/XML integration processes and DTS Packages. For Database and Query Tuning, I relied on SQL tools such as Query Analyzer, Query Optimizer, and SQL Profiler.

Used Erwin/Embarcadero to version and create Logical Data Models. Compiled documentation of Functional Specifications and business processes and Integration procedure logic into various media, including Clear Quest, Word, Visio, Adobe PDF documents, HTML Web Pages and PowerPoint Presentations.

Assisted in all phases of the Software Development Life Cycle from the definitive stages of working with Project Management staff and client Technical leads to define and document Integration and Reporting project specifications through the development, testing and delivery phases of our SDLC model. GE Healthcare provides

transformational medical

technologies and services

that are shaping a new

age of patient care. Our

expertise in medical

imaging and information

technologies, medical

diagnostics, patient

monitoring systems,

performance

improvement, drug

discovery, and

biopharmaceutical

manufacturing

technologies is helping

clinicians around the world

re-imagine new ways to

predict, diagnose, inform

and treat disease, so their

patients can live their lives

to the fullest.

GE Medical Systems (DEIO, Inc). (10/2001-10/2002) DATABASE ENGINEER

Implemented Cognos Impromptu 6.0 as reporting solution for our Clinical Software Suite. Created custom catalogs and reports for large Sybase ASE 12.5 relational databases. Converted Sybase Adaptive Server Enterprise 12.5 DDL schema scripts to Microsoft SQL Server usable Transact-SQL scripts for cross-platform compatibility of Clinical Software Data Warehouse solution. Custom Catalogs and reports designed for individual client hospitals based on EMR data captured through Anesthesia Record Keeping. Streamlined Hospital business processes by integrating scattered spreadsheet based reports into single scheduled reports for billing, Operating Room turnover, Materials Management, etc, resulting in yearly savings/profit in excess of $1,000,000.

Installed and Supported “Electronic Medical Record” Data Warehouse Software Suite for use in conjunction with Anesthesia (OR and PACU) and Critical Care (ICU) Monitors. Supported FDA Licensed/regulated medical/clinical Devices for sister company Datex-Ohmeda

Implemented and maintained Enterprise Application Integration (EAI) interface solutions for major hospital installations in U.S. and Canada using the

Contact this candidate