Replaced decade old .Net policy loader with one utilizing SQL Server, Stored Procedures, Integration Services (SSIS), .Net C#, Reporting Services (SSRS), JSON, Particular NServiceBus transport, and Windows Services.

New system loads in parallel, achieving 70% reduction in load times.

(Navigators became a part of The Hartford in 2019)

• Built up SQL Server based reporting infrastructure from scratch. Put together the servers, linked servers, permissions, and authentication structure.

• Designed, developed, and implemented a SQL Server 2012 reporting system that combined data from a MySQL 5.5 and SQL Server 2014 machine. System features detailed logging, notifications, error trapping, and multi-server execution for speed and accuracy.

• New views, schemas, stored procedures, tables, and indexes went into production that heavily emphasized and achieved great fault tolerance/recovery, impressive speed, and ability to process large data sets on limited hardware.

• Reduced previous execution times of reports and ETL processes by factors of 100 or more.

• Developed new import and export processes and standards. These were used to create SSIS packages and whole ETL process capable of dynamically adjusting to load different file structures, create export files, and transmit them via SFTP and FTPS using 3rd party libraries. These libraries were used directly by the SSIS packages and were successfully deployed to both development and production servers.

• Created from scratch and rewrote export processes and reports that carry the weight of the company’s name and are submitted to state enforcement and compliance agencies. Took direction from and worked closely with the executive, legal, and operations teams on these reports and exports.

• Built development servers at Amazon EC2. Tied Windows development servers at Amazon EC2 to MySQL RDS instances and our production servers at Rackspace. Maintained the firewalls, users, and windows security groups used for access at all locations.

• Built production level servers at Amazon EC2. Servers are used by other parts of the company, and allow them to access a daily copy of production without touching the actual production servers. Both SQL Server and MySQL data are transferred daily.

• Design, create, implement, and support 55 inbound streams of data into our system. Spanning daily volumes of 10,000 to 30,000 transactions/day, volume has increased 3.5x, while accuracy and speed improvements have allowed that same data to be processed by half the staff.

• Altered database structures to convert system from a US Currency only system to a Foreign Currency system. This change allowed entry and use of foreign currency data while alleviating the need to change the back end or front end commercial software, or immediately modify existing reporting and normalization code.

• Created highly custom SQL code to please especially specific requests. Business logic takes into account for source of data, date data represents, and the arrival time of that data to meet current business needs. It runs 70% faster than the code it is replacing while supporting the massive increase in complexity.

• Took a system completely dependent on receiving X and Y to calculate Z and designed a system that takes only Z and backs into X and Y. This previously completely manual process, which used to consume 50+ man hours a month, has been reduced to a few minutes, freeing up resources for other projects.

• Designed and implement complex process to value alternative investments properly in a system designed for regular assets.

• Used Query Plans and SQL Profiler to speed up by factors of 60 old legacy stored procedures.

• Supports a team of over 20 operations personal in their daily task of loading and reconciling.

• Continuously respond to requests from departments all around the company for data analysis, trending, and cleaning.

• Collaborated with others in my team and around the company to facilitate the transition of our database platform from SQL Server 2000 to 2005, 2008, and 2008R2.

• Successful cultivated and kept contacts with representatives with the public, private, and high wealth banks to get the data our company needs in a format we can use.

• Reduced load time, added crucial error handling, and enabled the application of business logic to the load of call center lists through SSIS packages and stored procedures.

• Reverse engineered VB and VB.Net load programs.

• Created important reports and analysis cubes used by management and clients to monitor the performance of various campaigns; all accessible through SharePoint and Reports Server.

• Reverse engineered, maintained, and improved custom in-house CRM built in ASP, JavaScript, stored procedures, and html.

• Designed and tested backup and restore strategies for the CRM’s database to ensure low downtime and minimal data loss.

• Successfully oversaw the rollout of a new product using in-house staff and outsourced talent.

• Maintained and built SQL Server 2005, Exchange, Domain, ISA, File, and Analysis servers in two locations over the country.