Sql Server Data

Richard Summerville (Rick)

Phone: 817-***-****

Email: *************@*****.***

Summary

Microsoft Certified Professional with 20+ years of IT experience in MS SQL Server database development experience (MS SQL Server 7.0 – MS SQL Server 2015)

Certified HIPPA Security Specialist (CHSS) with 8+ years of experience in healthcare domain

Strong MS SQL Server Developer Skills including writing Stored Procedures, User Defined Functions, Views, and complex Queries, In-depth knowledge of T-SQL (DDL, DML and DCL).

Data Architecture (Performance tuning, table creation, Stored Procedures, Views, Triggers, Functions, Index's)

Experience using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for data applications.

Experience using SQL Server Integration Services (SSAS) and MDX.

Excellent experience for managing BI environment, which includes Business Model, Data Model, Data Sources, ETL Tools, and Reporting Tools.

Experience in creating SQL Jobs, Alerts, SQL Mail, Agent, and Database Mail and scheduled SSIS Packages.

Expert in database activities, database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster Recovery, Backup/Restore and Migration.

Expertise in generating Reports using SQL Server Reporting Services (SSRS), Excel Spreadsheets, Business Objects, Crystal Reports, scheduling and deploying Reports with Reports Manager.

Excellent verbal/written communication skills and strong analytical abilities. Can perform well both independently and as a team player.

Experience Administrating Personify Business Application.

Areas of Expertise

SQL Database Administration and Development

Microsoft SSIS/SSRS/SSAS Development

Client Server 2/3 Tier Application Development

BI Tool set, ETL Architecture

Microsoft Visual Studio 2010/2012/2015

Extranet/Intranet Portal SharePoint

SAP Business Objects

Education

Computer Science – Tarrant County College, Fort Worth, Texas

Electronics Technology – Rio Hondo College, Whittier, California

Certification

HIPPA

Certified HIPPA Security Specialist (CHSS)

Microsoft

Certified SQL Developer (DBA)

Certified Visual Basic Developer

Visual Basic .NET Developer (non certified)

Certified SharePoint Developer (2007)

Technical Skills

Software: Windows Platform Vista/NT/2000/XP/7, ORACLE 8i/9i/10g/11g/12g, MS SQL Server 7/2000/2003/2005/2008r2/2012, Database Software, IIS, SSIS, SSRS, SSAS, Visual Basic 3/4/5/6, Visual Basic DOTNET, ASP/ASP.NET, Crystal Reports (Enterprise version 8.0/8.5/9.0), XML, Borland Pascal, C++, COBOL, MS SharePoint 2007, Microsoft Office Enterprise, PowerBuilder, ArcGIS, Toad v11, NetSuite, Navigator, Oracle Reports 11/12, Personify 5.7.2/6.7.1, SAP Business Objects, Webi Reporting. SyteLine

Methodologies: System Development Life Cycle (SDLC), 2/3 Tier Client, Data Architecture, Application Life Cycle Management (ALM), Waterfall Iterative, AGILE SCRUM, XML, FTP, Flat Files, GIS,

ERP: Microsoft Great Plains, Smart Connect, FRx

Professional Experience

LKQ Corporation July 2017 - November 2017

Senior SQL Programmer

Work with third party Application (Syteline)

Create SSIS/DTS ETL packages to extract and load Syteline Application data from text files and Excel spread sheets.

Create Business Requirements Documents and Functional Requirements Documents.

Write complex SQL queries, CTE's, Stored Procedures, Functions, Triggers, Views.

Create Databases, Tables, Functions, Stored Procedures, Views, Triggers, Backups/ Restorer's and SQL Jobs using Agent in SQL Environment.

Data manipulation in Part Cat third party Application.

Automate ETL Packages to run as Jobs in SQL.

Collaborate with end user's for requirements gathering.

TEK Systems - San Antonio (Contract) January 2017 - July 2017

Community First Healthcare

Data Analyst

Work with third party application (Navitus).

Creating (SSIS) ETL packages to extract and move data from one location to another.

Create Business Requirements Documents and Functional Requirements Documents.

Convert various data types to SQL Server environment.

Create fixed width Flat Files for export (FTP) to government entities.

Create complex queries, CTE's, Functions, Triggers, Tables, databases

Collaborate with end user's and Customer Service personnel for requirements gathering.

Fort Worth Technologies (FWT) - Fort Worth (Contract) September 2016 - November 2016

Wilks Brothers

Data Analyst

Work with third party application (Auction Flex) converting data to SQL format and performing data analytics.

Work with third party application (Sugar CRM Application), automating data downloads through SQL.

Work with third party application (Customer Data Records - CDR) converting application data to SQL format and automating process to upload into another third party application.

Minimum exposure to Power BI.

Microsoft Office 365

Utilization of Visual Studio applications, ETL (SSIS) and Reporting (SSRS).

Collaborate and planning with Finance, utilizing T-SQL for data analysis.

Robert Half Technology - Fort Worth (Contract) April 2016 - July 2016

AAPL

Personify Administrator

Responsible for creating, modifying, designing and deploying complex Business Objects/WebI/Crystal Reports into the Server environment.

Responsible for creating, modifying, designing and deploying complex Matrix Reporting for Education, Finance, Publications and Membership departments.

Responsible for creating SSIS packages and using SSAS for Data Analytics and MDX scripts.

Responsible for creating, modifying, designing and deploying complex SQL queries, Views, Triggers and Functions in the Personify Notification process.

Responsible for all aspects of Personify Administration.

Responsible for setting up Products and Codes in Personify associated with QuickBooks for Financial Reporting.

Collaborate across Planning, Marketing, Finance, Credentialing, Membership and Education departments to extract data requirements for Reporting and Process requirements.

Randstad Technologies - Plano (Contract) November 2015 - April 2016

Conway Freight

Data Reporting Analyst

Member of a three (3) man team to transition to new Financial/Billing and Invoicing software (NetSuite).

Responsible for Creating, Modifying, Designing and deploying complex Oracle Reports into the Server environment.

Responsible for trouble-shooting and writing SQL queries, Views, Triggers and Functions in Toad and PL/SQL to resolve issues.

Interface with Staff in various departments to extract Data Requirements for new Processes and Procedures used in the transition process from old Billing/Invoicing Application to the new environment.

Responsible for converting obsolete Oracle Reports into the NetSuite Application.

Create BRD's (Business Requirement Documents).

Responsible for Tuning Toad, PL/SQL, and SQL Queries, Functions, Triggers and Views.

University of North Texas Health Science Center - Fort Worth August 2014 - November 2015

Senior Information Specialist

Lead, participate and mange a team in all activities related to the design, implementation and support of data structures and business intelligence tools for institutional data needs.

Interface with institutional staff and faculty to evaluate business data needs and projects.

Collaborate across members of IT (Information Services, Infrastructure & Security and Client Services, Client Services) to deliver coherent and supportable solutions.

Assist with business analysis and improvement, project management and web application projects.

Participate as a team member across all actions, fostering trust, transparency and adaptability.

Responsible for data organization/architecture and use modern BI tools (Qlik View, Tableau, Power Pivot, SSIS, SSRS, etc.

Responsible for creation of ETL packages (SSIS), performance tuning for Stored Procedures, Views, Functions and new code ('TSQL), Data Architecture, Table creation.

TEK Systems - Fort Worth (Contract) April 2014 - August 2014

GM Financial

Data Analyst III

Responsible for converting MS Access databases to ORACLE 10g Utilizing PL/SQL and Rapid SQL.

Responsible for converting MS Access and Excel Report to COGNOS Reports utilizing PL/SQL/Rapid SQL

Responsible for creating Views and Database Tables utilizing ORACLE 10g PL/SQL and Rapid SQL

Responsible for converting queries created in Discover Software into ORACLE 10g PL/SQL and Rapid SQL

North Texas Specialty Physicians – Fort worth April 2013 – April 2014

Senior MS SQL/ETL Developer

Responsible for MS SQL Server/Database maintenance and tuning utilizing T-SQL.

Created SSIS solutions to solve complex business problems using ETL and Business Intelligence.

Data Architecture, Create Tables, Stored Procedures, Triggers, Functions, Indexes, Tables, Views and T-SQL code to implement business rules.

Design, deploy, and maintain various SSRS Reports in SQL Server 2008 R2 and 2012.

Complete Report requests from business stakeholders leveraging necessary BI tools

Develop and create BRD’s (Business Requirements Documents).

Develop and create process and procedure documentation.

EFG Companies – Irving, TX June 2011 – April 2013

Senior MS SQL Developer/DBA

Responsible for MS SQL Server/Database maintenance and tuning utilizing T-SQL.

Data Architecture (Performance tuning, table creation, stored procedures, views, triggers, functions).

Created and tested SSIS packages for importing and exporting data from data warehouse.

Created Reports from SSRS and SSAS Analytics with MDX script.

Designed and generated simple, custom and complex reports against the new cubes using SSRS

Create, manage and configure SharePoint sites for production

Responsible for ERP System Management Great Plains utilizing T-SQL

Colorado Dept of Public Health and Environment – Denver, CO March 2007 – June 2011

Senior MS SQL Developer/DBA

Responsible for MS SQL Server/Database maintenance and tuning utilizing T-SQL.

Data Architecture (Create Tables, Views, Stored Procedures, Triggers, Functions)

Create and develop SSIS packages for Water Quality Control Division

Create and develop SSRS reports for Water Quality Control Division

Responsible for Creating and managing SharePoint sites.

Worked with EPA to build reportable water collection databases utilizing T-SQL

Maintained (ArcGIS) GIS database for Water Source Location utilizing T-SQL

Certified with ETO (Efforts to Outcomes) software for government performance and Case Management.

Global Healthcare Exchange (GHX) – Broomfield, CO March 2006 – March 2007

DBA/Content Developer

Responsible for MS SQL Server/Database maintenance and tuning utilizing T-SQL

Implementation of SQL Server Integration Services (SSIS), design/change/deploy ETL packages

Design and develop reporting models using SSRS Report Builder to meet business requirements

Create and develop VB.NET business applications utilizing T-SQL and Visual Studio/PowerBuilder

Prototype Data Cleansing Applications utilizing T-SQL and PL/SQL

Leverage and direct India Offshore development team for new and existing technologies.

Broadlane, Inc – Dallas, TX July 2003 – March 2006

Database Analyst

Responsible for building and running complex nested queries utilizing T-SQL

Responsible for the creation of OLAP and ADHOC Reports utilizing Crystal Reports, T-SQL and PL/SQL

Responsible for VB.NET Application prototyping and full life cycle development utilizing T-SQL, Visual Studio and PowerBuilder

Build Web pages for customer interaction utilizing Visual Basic.NET and T-SQL

Retailer Owned Research Company – Arlington, TX January 1996 – July 2003

Software Developer

Responsible for developing multi-tier Point of Sale Application software utilizing T-SQL and Visual Basic 6.0

Responsible for full life cycle development and project implementation

Responsible for Code Specifications and Design documentation

Created custom Reports for Point of Sale application utilizing Crystal Reports and T-SQL

Responsible for interfacing CASIO, NCR Registers, Flat Bed Scanners and Telxon/Symbol Bar Code Readers to the point of sale application utilizing T-SQL and Visual Basic 6.0.

Responsible for building internal Intranet Web site

Responsible for pushing software updates and enhancements to customers utilizing T-SQL

Responsible for User documentation and Service Manuals.

Contact this candidate