Ken Huling Email & Phone Number

Portsmouth, New Hampshire, US

SQL Server Data warehouse DBA

Boston, MA, US

• Working with the CTO of Harvard Medical School, I am the Lead Data Architect for a $250 Million federal grant funded open-source nation-wide distributed Web 2.0 Bioinformatics and Research Collaboration Initiative.
• Designed Data Model, Access layer and ETL strategy for OPEN-SOURCE, Research Networking Web 2.0 application (http://profiles.catalyst.harvard.edu), a tool for promoting Inter-Disciplinary collaboration and sharing.
• Worked on project to convert 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.
• 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.
• Provided analytic reporting for Harvard Pathfinder, an NIH ARRA Pathfinder grant funded project aimed at fostering a diverse scientific workforce.

Ipswich, MA, US

www.thesqlservergroup.comAs specialists in the areas of Business Intelligence, Data Warehousing, Database Design, Architecture, Analytics, Performance Tuning and Predictive Modeling, our mission is to unlock our client's most precious asset, their own data. By designing efficient, scalable and well performing Data Warehouses, with the necessary Business.

Milford, Connecticut, US

Residential Mortgage Loan officer

Beverly, MA, US

SQL Server Consulting services

Woodbury, New York, US

• Manage Multi-Tenanted Data Warehouse environment. Consolidated disparate, sub-optimal VMs to 4 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.
• 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.
• 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.
• Drove Hardware Procurement and Implementation of 4 high-powered Dell Servers with 10 Drive SSD arrays, to consolidate disparate underperforming VM Data Warehouse environment.

Boston, MA, US

• Provide SQL 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 cutting edge Hardware procurement consisting of EMC San, VMWare servers, Solid State Drive infrastructure and DELL Servers. Achieved superior I/O throughput utilizing this.
• 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.

Burlington, MA, US

• Implemented Multi-Instance Failover Clusters(Active/Active) for Sql Server 2005 Operational Data Store(ODS).
• Designed Physical Storage plan, segregating Logs, TempDB, Data Files and Index Files and storing on optimal Raid Arrays for optimal speed and redundancy.
• Implemented Logical Enterprise ODS Model for Global Leader in Audio and Video Technology Software / Hardware to consolidate disparate ERP and POS systems across Subsidiaries and Divisions.
• Integrated ODS with SAP and Salesforce.com.
• Create SOA architecture around ODS using Middleware and ASP.NET 2008 Web Services.
• Created Series of DDL Triggers and Output Storage to monitor Stored Procedure and general ddl changes for Sarbanes-Oxley Compliance and Secondary Source Control.

Needham, MA, US

* Developed BI solutions against 15 TB Sql Server 2005 Data Warehouse spread across 10 seprate SCSI Disk Array’s consisting of over 125 Disks, with a main Warehouse Fact table of 17 Billion Records and over 20 related Dimension tables,with more than a billion records. * Developed dozens of SSIS based ETL Packages Importing/cleansing and creating Dimension.

San Jose, CA, US

* Responsible for Terabyte sized, 200+ Table Sql Server 2000/2005 OLTP 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..

* 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 Cingular Wireless using data from OLAP cubes designed in Microsoft Analysis Services, viewed.

US

• Created.NET Web Services for Leading National Insurance Companies such as State Farm Insurance, Progressive Insurance, and Farmer’s insurance, etc using ASP.NET, to allow remote vendors and clients to integrate into.
• Created XML Interfaces to give 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.
• 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.

• 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.
• 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.
• 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.

• Implemented and supported Business Objects 5.02 installations. Created customized Business Objects universes (catalogs) for large complex relational database platforms in MS SQL Server and Oracle 9i. Developed “slice.
• Created/maintained SQL Server 7.0/2000 databases > 10 gigabytes in size and consisting of more than 85 tables, 20 views, 80+ stored procedures, 250 + users and 100+ triggers.
• Designed and conducted data conversions of client’s legacy data into our product’s SQL Server 7/2000 databases using 35-45 customized Transact-SQL scripts and DTS packages. Physical database design, performance tuning.