Greg Wilson Email & Phone Number

Tampa, FL, US

Purchase, NY, US

Purchase, NY, US

Purchase, NY, US

• Senior Data Engineer
• Develop complex queries and stored procedures using T-SQL; Implement HEDIS logic
• Analyze requirements to develop, test, configure and deploy complex SSIS packages
• Use of SQL Server 2012, 2014 or 2016 experience to implement robust, maintainable solutions
• Evaluate large and complex data sets
• Troubleshoot SSIS packages to address critical production issues.

Itasca, IL, US

Gather requirements from the business in order to create the necessary queries and related Reporting Services and/or Excel Pivot Table reports and Integration Services PackagesGather data and summarize it into Key Performance Indicators with recommended approaches to the business based off of sample data setsAssisting with QA review processDatabase.

Downers Grove, Illinois, US

Develop and implement modifications to existing applications, systems, and data extracts. Focused on quality by following development standards and best practices. Improve the performance of databases that includesd the development and support of stored procedures, triggers, views, cursors, index optimization, ETL tools and other utilities. Maintain the.

Greg Wilson is a independent SQL Server consultant with more than 20 years experience in programming, application development, training, curriculum development, database administration and implementation. He specializes in SQL Server development, performance tuning, TSQL programming, database administration, performance reporting, data modeling, data-mart.

JP

Greg Wilson is a senior consultant with more than 14 years experience in programming, application development, training, curriculum development, database administration and implementation. He specializes in SQL Server development, performance tuning, TSQL programming, database administration, performance reporting, data modeling, data-mart and data.

Durham, NC, US

Analyze the business solution proposed for architecture impacts and define technology solution architecture focusing on infrastructure, logical and physical layout of the systems and technologies.Analyze existing hardware, distributed and virtual systems, software, security, data management, storage, backup/recovery, applications, messaging, networking.

Working with SQL Server 2008 Enterprise EditionMonitor database system details within the database, including stored procedures and execution time, and implement efficiency improvementOptimize indexes, index management and database statisticsDesign and implement redundant systems, policies, and procedures for disaster recovery and high availabilityMonitor.

Amarillo, Texas, US

Special 1 week assignment that required performance tuning and analysis of existing slow DB2. Provided recommendations which included optimized query rewrites, partitioning, Materialized Query Tables, and Connection Pooling update.

Chicago, Illinois, US

Worked with SQL Server 2005 and SQL Server 2008 migration.Updated existing stored procedures to improve performance.Developed various T-SQL scripts for the deployment of new tables, indexes, stored procedures, triggers, functions.Developed a SSIS package to automatically create partitions for an Analysis Services database for improved performance. Also.

Eden Prairie, MN, US

Short term database management and support for SQL Server.

Cincinnati, Ohio, US

Architect to support the IKON Database Team located in Blue Ash, Ohio. Design, implement, maintain, and consolidate existing database structures across the entire enterprise. Apply best business practices for the design and administration of databases. Create and maintain standard database policies, operating procedures, and overall documentation..

Naperville, Illinois, US

Programming objects including schemas, databases, tables, views, indexes, stored procedures, triggers and declarative integrity constraints. Create SSIS packages.Review, analyze, and convert complex stored procedures to increase speed and performance in SQL Server 2005 and 2008.Modify SQL Reporting Services reports.Write Stored Procedures and.

Milwaukee, WI, US

Working with technical teams to create logical data models, logical entities, define their attributes using best practices in order to ensure high data quality, reduced redundancy and normalization.Creating logical and physical data models to support new and existing projects.Creating physical data models with the details necessary for a complete physical.

Marshfield, Wisconsin, US

• Providing performance tuning and optimization for all the SQL Server versions currently at Marshfield Clinic.
• Architecture Optimization - Disks, CPU, Memory
• Configuration Tuning - Database Settings, Server Settings
• Performance Analysis – Slow SQL, Blocking Problems, Procedure Execution
• Recommendations - Hardware, Configuration, Operational Changes, Code Changes
• Benchmarking – Incremental baselines, verification of performance gains

• Developed SQL Server stored procedures and triggers
• Developed architecture for current SSIS data migration processes
• Created ASCII and EBCDIC output files for downstream systems
• Integrated SSIS with TIDAL job scheduler
• Verified format of EBCDIC files on mainframe using ISPF/FileAid
• Involved in entire lifecycle of data transformation packages which included traditional development, code promotion, and QA verification

Santa Clara, California, US

Milwaukee, WI, US

New York, NY, US

US

Education record

Aa, Asociates Degree