Richard Kicklighter

Richard Kicklighter. Database Architect/Developer (Optimization/Tuning). Disciple of The Coming Singularity. Science and Technology Enthusiast. OCD and Recovering Germaphobe.

* Richard Kicklighter  has extensive experience creating solutions and delivering projects across multiple industries-- Investment Banking, Financial Services, Payroll Services/Processing, Advertising/Marketing, and Insurance. * Richard Kicklighter is able to deliver communication, concise in nature, targeted towards the audience at hand while also inciting an elevated level of confidence in the solution being developed. * Richard Kicklighter's ability to work collaboratively with teams of any size while encouraging team work through positive influence. * Richard Kicklighter is capable to self-motivate for individual assignments while maintaining a strong sense of commitment towards meeting project milestones and deadlines.

Senior Application Developer at Global Contact Services

May 2004 - March 2010

* Design and implemented system for capturing/managing employee detail using Microsoft SQL Server and ASP. Heavy use of stored procedures and parameterized queries to enhance system performance and security. System integrates into multiple facets of company day to day workflow: time clock system, ADP payroll management, client deliverables, operational team management, performance reviews, insurance licensing, and intranet security. * Create solutions using ASP as a front end for: payroll processing/export to ADP, employee performance review and scoring system, and insurance agent/licensing management. These projects required heavy use of stored procedures to validate business rules and process data for entry/retrieval to/from the process’ database. * Database management, modeling, optimization/tuning, and troubleshooting queries for clients in order to allow peak performance with limited system resources. Optimization/tuning relating to the optimal schema (Star vs Snowflake) required for the process as a whole while keeping in mind storage limitations and performance requirements based on real world usage of the process. Most troubleshooting requires identifying missing indexes or incorrect algorithms being applied through use of dynamic management views, inspecting execution plans and code review. * Develop multiple SQL CLR stored procedures using C#.NET. * Created front end/backend solutions for marketing campaigns relating to differing sectors requiring understanding and client specific data integrity, security, and sensitivity needs. This involves the full data lifecycle for our clients. Heavy use of stored procedures and dynamic SQL to allow reusable code. * Create a dynamic reporting engine for internal use in order to deliver what would other-wise be ad-hoc requests. * Participate in code review, system documentation, and wrote multiple articles for development department to showcase best practices and new system functionality.

Developer at Innovative Marketing Strategies

October 2003 - May 2004

* Backend data and report programming for client marketing campaigns using a custom FoxPro/SQL 2000 reporting solution. * Create a data archival process and associated lookup functionality for client data using SQL 2000. * Develop a real-time server monitoring application with automated alerts and escalation procedures using Visual Basic.

Applications Systems Engineer, AVP at Wachovia, A Wells Fargo Company

April 2010

* Contractor to FTE. *Technology lead for Investor Performance Management department for Database Architecture/Development. *Manage the Foreign Exchange and Institutional Rates & Commodities lines of business in the department and associated staff/long term technology strategy. *Identify disparate data sources (Oracle/Sybase/MSSQL/Composite) across the organization required to enhance key line of business data and integrate into (intra-) daily ETL (Extract Transform Load). *Integrate with production trading systems (Misys Opics/Calypso) to bring in real time results for reporting. * Design a warehouse solution using horizontal table partitioning for increased ETL performance and high data availability. * Built out a data hashing model using 160-bit SHA (Secure Hash Algorithm) hashes for discrete change tracking of full ETL process. This allowed a 757% improvement in load time and a 99% drop in daily ETL data churn/fragmentation, lowering I/O requirements. * Develop an algorithm for parsing, matching and scoring client data for automated linking (with human over-sight) reducing human overhead. * Contribute toward ASP.NET (C#) web application enhancements to allow business user configuration of Reporting/Analysis application attributes. * Identify SQL Server performance issues through the use of dynamic management views and server statistics monitoring and offer solutions. * Create a dependency system to programmatically identify data reload requirements for near real-time reporting. * Develop system tools to identify active processes and their sql server overhead for enhanced performance monitoring/tuning. * Design an ETL solution that analyzes user configuration detail to determine the meta/schema changes required to fulfill the end user needs. * Create ETL analysis system for identifying performance changes over time during data processing. * Automate index/statistics maintenance during ETL for higher availablity/performance.