Katherine E. Lightsey

Las Vegas, NV

adatwn@r.postjobfree.com

https://www.linkedin.com/in/kelightsey

I am a SQL Server professional experienced in the design, development, and administration of Microsoft SQL Server and SQL Server objects. I am quality conscious and self-motivated with extensive experience working in a team environment. I have worked extensively with Agile methodologies to ensure business requirements are met within business constraints for costs and time. I maintain a personal repository of code used for training, presentations, and prototypes.

Accomplishments

●Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification of existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management.

●Development and use of unit tests to test and validate SQL objects during and post development and deployment.

●Development of automated job scheduling processes to allow both serial and parallel processing of SQL Server procedures.

●Development of methods and objects using TSQL, SQL XQuery, XML, Merge, Common Table Expressions, Pivot, Unpivot, and Service Broker.

●Improvement of performance using SQL Server Profiler, Query Plan analysis, instrumentation of code, Partitioning, and best practice analysis.

●Use of Powershell and Python for automated install and uninstall of SQL objects and data cleansing for ETL routines.

●Development of an internationalized data store allowing maximum flexibility in data storage using XML rather than defined tables and columns using XSD to type different data types.

●Analysis of existing and recommendation of additional techniques and methods as required to adhere to industry best practices for development, testing, deployment, and documentation.

●Development and instruction in standardized code used to solve specific business requirements such as data cleansing and merge with history records.

●Setup and management of automated backups of all data as well as recovery of data in test, development, and QA environments as required for testing and to recover from user error.

●Implementation of a high speed data access and delivery system including development and tuning of stored procedures and implementation and maintenance of indexes and Change Data Capture.

●Development of ETL processes to cleanse, transform, and load data into an OLTP structure including logging and a bad record handling.

●Development of ETL processes to load aggregate data into an OLAP data structure without interruption of high speed OLTP operations.

●Design and deployment of an Online Analytic Processing (OLAP) Data Warehouse for reporting purposes.

●Development of a logging and reporting tool to be used for non-specified applications allowing maximum flexibility in data storage using XML rather than defined tables and columns.

●Implementation of Online Transaction Processing (OLTP) databases to support an applications development platform for Internet and wireless applications and multiple platforms utilizing an N-Tier and scalable architecture.

Career

●SQL Server Data Architect/DBA/Developer July 2018 – Present Aristocrat Gaming Las Vegas, NV – Contract: Support of the Aristocrat Gaming ERP Migration. Supported a team of business analyst/developers in an ETL migration. Developed and managed a deployment and integration landscape to execute SSIS packages automatically including logging and reporting. Worked with business analysts to ensure successful package deployment and execution. Built and managed a Run Book to support ongoing business analysis operations. Developed and managed a code repository using Git, Visual Studio, and Azure DevOps including automated data exports. Utilized PowerShell and Python to script tasks as required. Built a Python web application to provide a control panel view into the data architecture, tasks, and logs. Implemented stored procedures and PowerShell and Python scripts and processes to process ETL (Extract/Transform/Load) tasks. Used XML and Query to load, log, store, and extract data to be used for Load processes.

●SQL Server Developer Jan 2017 – Jul 2017 Transact Technologies Las Vegas, NV – Contract: Modifications and improvements to existing stored procedures. Design of new objects consistent with existing design as well as proposed design changes to address new requirements. Documentation of new and existing SQL objects. Work with development team to analyze defects and performance issues, build and test solutions, and build packages for deployments. Worked with the deployment manager and DBA to address performance issues. Replicated customer environments in the lab to simulate existing issues and to develop solutions to improve performance or add or develop new features. Supported SQL Service Broker processing including troubleshooting and adding additional functionality.

●SQL Server Developer Sep 2016 – Dec 2016 Thrift Books Kent, WA – Design, development, performance improvement, and modification of existing and new procedures, tables, triggers, and functions. Implementation of best practices using XML, extended properties, code formatting, and relational database theory. Worked with the team to design and implement new features using SQL best practices.

●SQL Server Developer Nov 2015 – Sep 2016 International Gaming Technology Las Vegas, NV – Design, testing, and deployment of procedures and jobs required to manipulate data in a multi-terabyte data store. Improved performance on existing Transact SQL reports by improving either or both the Transact SQL code as well as managing indexes and underlying data or schema structures. Worked with the development team to plan new feature implementations or modifications to existing features to meet customer requirements. Worked with the DBA and development team to analyze customer data, replicate implementations in a lab environment, and analyze and recommend improvements to address customer issues.

●SQL Server Developer May 2015 - Sep 2015 HealthCare Providers Nevada Las Vegas, NV – Contract: Design and deployment of an Online Analytic Processing (OLAP) Data Warehouse for reporting purposes. Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management. Development of automated job scheduling processes to allow both serial and parallel processing of SQL Server procedures. Development of methods and objects using TSQL, SQL XQuery, XML, Merge, Common Table Expressions, Pivot, Unpivot, and Change Data Capture.

●SQL Server Developer May 2014 - Aug 2014 Torchmark Corp McKinney, TX - Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management. Development and instruction in standardized code used to solve specific business requirements such as data cleansing and merge with history records. Analysis of existing and recommendation of additional techniques and methods as required to adhere to industry best practices for development, testing, deployment, and documentation. Development and use of unit tests to test and validate SQL objects during and post development and deployment. Development of methods and objects using TSQL, SQL XQuery, XML, Merge, Common Table Expressions, Pivot, and Unpivot. Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management.

●SQL Server Developer Dec 2013 - Apr 2014 Noetic Partners Mexico City, DF, Mexico – Contract: Development of a logging and reporting tool to be used for non-specified applications allowing maximum flexibility in data storage using XML rather than defined tables and columns. Design and implementation of an architecture using SQL Service Broker to decouple OLTP from OLAP processes.

●SQL Server Developer Jan 2013 - Oct 2013 Santander Consumer USA Inc. Dallas, Texas - Development of ETL processes to cleanse, transform, and load data into an OLTP structure including logging and a bad record handling. Analysis of existing and recommendation of additional techniques and methods as required to adhere to industry best practices for development, testing, deployment, and documentation. Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management. Used PowerShell and RegEx to scrub data prior to loading into SQL Server.

●SQL Server Developer Jun 2012 - Sep 2012 Blue Cross Blue Shield Richardson, TX – Contract: Development of documentation management applications using XML/XQuery.

●SQL Server Developer Oct 2011 - Feb 2012 Sally Beauty Corporate Denton, TX – Contract: Development of ETL processes to cleanse, transform, and load data into an OLTP structure including logging and a bad record handling. Analysis of existing and recommendation of additional techniques and methods as required to adhere to industry best practices for development, testing, deployment, and documentation. Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management.

●SQL Server Developer Jan 2007 - Apr 2011 Knowledge Based Marketing Richardson, TX - Development and implementation of a large database for customer analytics. Development and use of unit tests to test and validate SQL objects during and post development and deployment.

●SQL Server Developer Jan 2001 - Dec 2006 Tetra Pak Denton, TX - Development and use of unit tests to test and validate SQL objects during and post development and deployment. Design and deployment of an Online Analytic Processing (OLAP) Data Warehouse for reporting purposes. Development of new and upgrade of existing procedures, functions, triggers, and schema objects to incorporate best practices as well as modification existing code to improve performance and correct errors or add new functionality and to meet business objectives while allowing for robust data management.

●SQL Server Developer Aug 1998 - Jan 2001 systemIP Dallas, TX - Implementation of Online Transaction Processing (OLTP) databases to support an applications development platform for Internet and wireless applications and multiple platforms utilizing an N-Tier and scalable architecture. Design and deployment of an Online Analytic Processing (OLAP) Data Warehouse for reporting purposes.

●Microsoft Certified Trainer January 1998 - May 1998 SMU School of Engineering and Applied Sciences Richardson, TX – Contract: Instruction of Microsoft Official Curriculum.

Additional Skills

●Use of statistical methods for implementation of artificial intelligence and decision support systems, data and systems analysis for performance and decision support.

●Career experience in thirty different programming languages including ANSI SQL/TSQL/PLSQL, C/C#/C++, Java, EJB, PowerShell, SAP ABAP, Assembly language, various Programmable Logic Controller languages (primarily Allen Bradley), and defunct languages including Modula 2, Forth, LISP, Sperry Mapper, and Ada.

●Experience includes SQL Server from versions 6.5 to 2017, Oracle versions 8 to 10g, and MySQL.

●Development of web front ends using HTML5, Cascading Style Sheets (CSS), and Adobe Flex.

Education and Certification

●Bachelor's Degree, Mechanical Engineering Technology, Texas A&M College Station, TX.

●Microsoft Certified Database Administrator (MCDBA), SMU School of Engineering and Applied Science.

●Microsoft Certified Systems Engineer (MCSE), SMU School of Engineering and Applied Science.

●Microsoft Certified Professional, SMU School of Engineering and Applied Science.

●SCPJ2 Sun Certified Programmer for the Java 2 Platform, SUN Java.

Contact this candidate