Greg Wilson Email & Phone Number

Tampa, Fl, Us

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. • Assist application developers in refining complex queues and performance tuning • Create tables, assign permissions, import data, perform app configurations • Write and maintain technical documentation • Manage source code versioning and deployments • Stay knowledgeable with the latest advances in SQL Server and other data technologies

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 Development - Creating stored procedures (T-SQL), triggers, indexes, views and queries.Assisting with Database Administration tasks such as database maintenance, optimization, backups, monitoringDesign, code, test and troubleshoot business ETL in Integration PackagesProvide general technical support as needed, both to other functions within the business, as well as other segments of the technology department (database design, infrastructure, compliance)Assist in creating Reports

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 integrity and consistency of data and database schemas across multiple servers. This includes managing multiple versions of the database schema while working with source control, change management and other team members. Implement modifications such as partitions and memory optimized tables to increase database performance. Improve administration tasks efficiency by creating and implementing Powershell scripts.Support various development and production environments. Provide support for scheduled releases as needed. Regularly search for and identified opportunities for quality and process improvement resulting in improvements to query performance, productivity, and development procedures. Use Powershell to automate administrative tasks.Development experience in QlikView and QlikSense.Proficient in writing data extraction queries on relational databases and designing reporting solutions and provisioning data for senior management.Experience integrating Qlikview and QlikSense.

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 and data warehouse implementations.

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 warehouse implementations. Furthermore, he is an experienced technology trainer and certified developer. He has worked in a varity of projects that range in database performance, TSQL programming, data management systems, analytical systems, technical infrastructure, and application design.

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, work flow, interoperability, flexibility, scalability, monitoring and reliability in order to produce scaled down replicas of production systems. Responsible for analyzing existing systems through an interview process with technology SMEs in order to develop a complete end-to-end Current State Architecture to drive and define the Future State Architecture.Influence, conceptualize, visualize and communicate the Client architecture by explaining the complex technical or architecture concepts in a simple manner to different audiences.Market architecture best practices, guidelines, standards, principles, and patterns while working with infrastructure and technology project teams.

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, optimize and allocate physical data storage for database systemsWorking collaboratively with developers on design solutionsHardware capacity planning and database upgradesDaily maintenance activities - backups and indexing

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 created a separate process in SQL Server database to implements partitioning by running a script on a large table. Scripts supported rollback capability.Troubleshoot performance problems by using SQL Server tools and implemented the changes.Work with training other database developers on various database features and best practices when using SQL Server.

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. Implement proactive database performance monitoring, fine tuning, and optimize database systems. Develop and implement database backup and disaster recovery strategies. Identify opportunities and implement solutions to enhance existing database systems.Provide expertise concerning Data Warehousing and Datamarts. Participate in IT and business projects to define database system requirements and recommend technology solutions. Research, benchmark, document and introduce new database technologies and features into application life cycle.Collaborate with the application developers, business owners, and architects in design and implementations.

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 Triggers.Optimize databases and SQL Server .Write SQL and stored procedures.Performance tuning of existing queries.Biztalk Server 2010 development.

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 data model, including the appropriate specifications for keys, constraints and other physical model attributes.Apply best practices related to data modeling, including use of standard naming conventions, processes, and templates to ensure consistency of data models.

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• Configuration Optimization • TSQL Tuning • Stored Procedure Tuning• Windows server optimization for SQL Server 2000, 2005, 2008• Implemented Partitioned Views and Partitioned Tables • Operational improvements – Backup strategy, defragmentation, best practices• Implemented process to monitor slow servers by using Idera’s Diagnostic Manager • Rewrite of stored procedures for faster performanceMS SQL Server 2000, 2005, 2008• Handling baselines to identify performance problems with upgrade to SQL Server 2008

• 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• During the course of development, packages included FTP destinations, logging to Oracle database via web service calls, and custom package restartability• Conducted SQL Server and SSIS training with the IT staff

Santa Clara, California, Us

Milwaukee, Wi, Us

New York, Ny, Us

Us

Education record

Aa, Asociates Degree