Paul Hunter Email & Phone Number

Dallas, Texas, United States

I prefer to keep my employment out of my profile since the 2020 election.

Dallas/Fort Worth Area

Contract position for a company which has hired me full time

Lewisville, Tx

Changed teams, same great company with a different role. Applying many of the same patterns and practices from previous role.o Bringing multiple databases and platforms into TFS Source Controls System and resolve differences between various code bases.o Roll out DevOps process similar to prior team. Expanded scope to include SSIS/SSRS, MySQL, Cassandra, PostgreSQL and any other technology.o Leverage BIML to rapidly and consistently generate hundreds of SSIS packages to… Show more Changed teams, same great company with a different role. Applying many of the same patterns and practices from previous role.o Bringing multiple databases and platforms into TFS Source Controls System and resolve differences between various code bases.o Roll out DevOps process similar to prior team. Expanded scope to include SSIS/SSRS, MySQL, Cassandra, PostgreSQL and any other technology.o Leverage BIML to rapidly and consistently generate hundreds of SSIS packages to load/transform data from multitude of formats and varied sources (flat-file, MySQL, Cassandra & PostgreSQL). Show less

Lewisville, Tx

SQL Developer responsible for organizing and delivering high performance database solutions and improvement of code development and delivery practices.o Initiated DevOps solution for database deployments: • Established database source code repositories and branching strategy to support simultaneous multi-team distributed development on the common database code. • Created a Database Lifecycle Management solution utilizing the Red Gate DLM tool augmented by a custom MDM solution and… Show more SQL Developer responsible for organizing and delivering high performance database solutions and improvement of code development and delivery practices.o Initiated DevOps solution for database deployments: • Established database source code repositories and branching strategy to support simultaneous multi-team distributed development on the common database code. • Created a Database Lifecycle Management solution utilizing the Red Gate DLM tool augmented by a custom MDM solution and PowerShell leveraging the Octopus Deploy for dependable deployment of changes. • Reduced overall deployment preparation time from 10 man-days down to under one hour.o Improved SQL code quality and delivery: • Reduced code complexity to increase usability by refactoring complicated multiple single-purpose stored procedures to generalized multi-use stored procedures. • Converted numerous scalar functions to a simpler method by eliminating unnecessary variable declarations and directly returning expected value. Converted multi-statement table-valued function into more effecient in-line table-value functions to reduced processing and data movement issues (reduced I/O). • Introduced a testing framework to facilitate regression testing for database changes. • Refactored multiple procedures and function by standardizing access patterns and eliminated deadlocks. • Index enhancements by removing unused indexes and consolidating duplicate indexes to provide better usage patterns and lower I/O & storage costs. Show less

Dallas/Fort Worth Area

SQL Developer utilizing T-SQL to resolve database performance issues, research & correct operational issues and enhance the functionality of the legacy trading platform. Introduce best practices, naming convention, TDD and continuous integration to help improve overall code quality and dependability.

Carrollton, Tx

Responsible for resolving database performance issues, research & correct operational issues with the semi monthly billing cycle. Performed database restores for Unit Testing, System Integration and user environments. Coordinated changes to databases, maintenance plans, job schedules and implemented security measures to safeguard databases.

Richardson, Tx

Responsible for the design and integration of Texans enterprise systems by providing the vision, guidance and leadership necessary to continually improve business processes and reduce costs. Formulated system/data architecture plans, cost/budget estimates, staffing requirements and ensure that projects meet Texans strategic needs. Established, planed and administered the overall policies and goals for the department. Conducted due diligence analysis of 3rd party vendor products and the… Show more Responsible for the design and integration of Texans enterprise systems by providing the vision, guidance and leadership necessary to continually improve business processes and reduce costs. Formulated system/data architecture plans, cost/budget estimates, staffing requirements and ensure that projects meet Texans strategic needs. Established, planed and administered the overall policies and goals for the department. Conducted due diligence analysis of 3rd party vendor products and the software used/developed by acquisition targets. Functioned as the Development DBA.• The position was 80% hands on SQL development, 10% technical architecture and 10% management.• Created numerous SQL CLR .NET assemblies to support functions, aggregates and procedures that are difficult and/or impossible to do with native T-SQL (financial calculations, file I/O and AD manipulation).• Developed coding/naming guidelines for SQL objects. Created stored procedures to script standardized CRUD procedures for tables based upon the coding standard.• Created a flexible ETL integration framework utilizing BCP and SSIS to consolidate and automate redundant/repetitive processes.• Began development of a Data Warehouse using Kimball methodology. Created customer demographic dimensions and facts related for Balances and Transactions to capture behavioral information.• Managed a team of six .NET & SharePoint developers. Mentored team to increase their experience across multiple development paradigms (SQL, OO & SOA).• Adopted Scrum and applied Agile practices/principles to provide visibility, promote customer involvement and provide predictable delivery of development projects.• Lead conversion from Visual SourceSafe to Visual Studio Team Systems for SCM & ALM. Show less

Dallas, Tx

Owner and sole proprietor specializing in custom software design and development. Contracts include:The Telemetry Company• Hire and manage a team of three developers • Reduce system latency 50% by redesigning and combining multiple processes.Baylor Health Care System• Migrate SQL Server database to a better design without impacting the existing production application.• Create a Data Dictionary for the new system to document and allow users to understand the system.•… Show more Owner and sole proprietor specializing in custom software design and development. Contracts include:The Telemetry Company• Hire and manage a team of three developers • Reduce system latency 50% by redesigning and combining multiple processes.Baylor Health Care System• Migrate SQL Server database to a better design without impacting the existing production application.• Create a Data Dictionary for the new system to document and allow users to understand the system.• Implement naming/coding convention for database objects. Show less

Irving, Tx

WebTPA is a third-party administrator of health insurance claims processing and benefits administration.• Develop a strategy to migrate their monolithic Visual Basic 6.0 application into a scale-out n-tier distributed architecture.• Collaborate on laying a foundation for the engineering standards to migrate to new architecture.• Design security architecture to facilitate compliance with HIPAA regulations.

Dallas/Fort Worth Area

This position required the ability to integrate written and oral information from technical and non-technical managers for the design and implementation of the systems necessary to meet their business requirements. Major projects include:• Certicom Securiy – Data Architect/DBA for an n-tier, distributed, redundant, web-enabled system architecture capable of simultaneously supporting multiple lines-of-business.• GTE/Verizon – Assisted Microsoft Consulting Service to design and… Show more This position required the ability to integrate written and oral information from technical and non-technical managers for the design and implementation of the systems necessary to meet their business requirements. Major projects include:• Certicom Securiy – Data Architect/DBA for an n-tier, distributed, redundant, web-enabled system architecture capable of simultaneously supporting multiple lines-of-business.• GTE/Verizon – Assisted Microsoft Consulting Service to design and development of a prototype application to re-engineering the mainframe billing application into scalable n-tier architecture.• Simmons-SIRVEY – Lead developer of automated fuel tank monitoring system.• Eatzi’s – Lead developer converted Food Cost application to an n-tier platform.• Texas Instruments – Develop calculator software module that verified purchases used to create an installable download for Windows and Macintosh computers to load into TI programmable calculators. Show less

Worldwide

Served over seven years as a Site Development Specialist with tours at:• Spangdahlem AB, Germany -- 1978 - 1981• Warner Robbins AFB, GA -- 1981 - 1983• Kunsan AB, S. Korea -- 1983 - 1984• Barksdale AFB, LA -- 1984 - 1985Honorably discharged, May 1985 at which time I went to college to obtain my degree.

Certificate, Business Intelligence Graduate Certificate Program

Bachelor’S Degree, Major: Finance - Minor: Economics & Accounting, 3.0 Overall, 3.9 In My Major.

Activities and Societies: * Sigma Phi Epsilon (http://www.sigep.org/) * Omicron Delta Epsilon - economics honors society.