Sql Server Data

Todd Thomasson

*** ****** ****

Jacksonville, AR 72076

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

Contact Phone: 501-***-****

EDUCATION

Doctorates Computer Science, Northfield University

MBA, Northfield University

Bachelors Ministry, Central Christian College

Associates Applied Science, Southern Technical College

SKILLS

Microsoft Office – Microsoft Project – SharePoint – Microsoft Visio

SQL 2008 R2 – SQL 2012, DB2 – Access - C# - VB .net – COBOL – 370 Assembler

Micro Med – NextGen – SAP - SSRS – SSIS – SSAS - CA Erwin - PowerShell

Network Engineering, MVS JCL, DOS JCL, VSAM, Easytrieve, Focus

PROJECT MANAGEMENT

EXPERIENCE

Heifer Intl,

LITTLE ROCK, AR 10/12 – PRESENT

Non-Profit Stop World Hunger

Database Administrator

Performed Database Administration, BI Architect, Data Warehouse, Data Modeling (Conceptual, Logical and Physical schemas), Data Migration, Data Integration, Database Design, Documentation, VB .net Development, C#, SSIS, SSRS, SSAS, PowerShell, Agresso, ARC Reporting

Individual projects:

Custom Program Development C# & VB .net (Automation & Interfaces)

Agresso System Automation

Electronic Funds Transfers – Around the World

Bank Rec Statements Import .

oVB.net and T-SQL Development

Check Processing various Countries

oVB scripting and T-SQL Development

Web Interfaces (ASP, API’s)

Data Integration with Agresso from multiple packages (Red Carpet – SilkRoad, LaserFiche, BBEC, Kametrica etc.)

Windows Development

Database Administration

Database Development

Built visualizations utilizing tableau software

SolarWinds

Keith Smith Corporation,

Hot Springs, AR 12/13 – 02/14

Chicken Poultry Plant

Contractor

Moved Databases from one SQL Server to another and upgraded from SQL Server 8 R2 to SQL Server 12. I created additional tables to accommodate new front-end interface. Developed front-end interface ( Visual Basic .Net) that enabled shipment tracking from sales through delivery. I modified Stored Procedures to reflect the new Server reference. I integrated the written program into SharePoint Server.

Corkys Footwear,

North Little Rock, AR 03/11 – 10/12

Shoe Wholesale Manufacturer

IT Manager

Performed Database Administration, BI Architect, Data Warehouse, Data Modeling (Conceptual, Logical and Physical schemas), Data Migration, Data Integration, Database Design, Documentation, Project Management, IT Resources, Network Design and POS, SSRS, SSIS, C# .net Development, VB .net Development, Access

Individual projects:

Developed and Implemented Database Backup and Disaster Recovery strategies.

Developed Documentation regarding Operating Procedures and Technical Manuals.

Produced Documentation providing justification of technology implementation to executive staff.

Was proactive in Database performance monitoring and fine tuning

POS – Setup for new stores:

UPS – Generator and Labels by Design

oC#, VB .net and T_SQL Development

Analysis and Design of new Database with successful migration of existing data.

Redesigned and Installed new Infrastructure

Cross Functional Team Lead that included: planning, preparation, software development, installation and cash management. The team worked with on site technicians, network technicians and software specialists

Thomasson Technologies,

North Little Rock, AR 06/01 – 03/11

Contractor

Development of Data Warehouse and Datamarts

Collaborate with Business Owners, Application Developers and Architects in Design and Implementations.

Research, Benchmark, Document and Introduce New Technologies

Produced Conceptual, Logical and Physical Schemas of Databases

Developed Documentation regarding Operating Procedures and Technical Manuals.

Optimization and Performance Monitoring of Database

Conduct Database Capacity and Availability Audits

Developed and Implemented Database Backup and Disaster Recovery strategies

Network Installations

Network infrastructure design, performed needs analysis and system & security assessments.

Risk analysis, capacity planning

SharePoint installation and development.

Network Evaluations - Maximization of Productivity through Technology

Network Installation (Windows 2008, Windows 2003, Eleven Windows XP Workstations, Windows NT Workstation) File Servers, SQL Servers 2005, Exchange Servers, Switches, Cisco Routers, Symantec VPN's, Printers, Power Vaults, Active Directory 2003, Security Protocols, Third Party Software Analysis

System Programming

File Conversions, Database Conversions

Hardware Interfaces, Software Automation

Web Site Design and Development, Graphic Automation

Languages:

VB, Visual C, C#, SQL, COBOL, DB2/UDB, HTML, Access, Data Stage, .NET, XML

Software:

VISIO, MS Office, MS Project, Micro Med, Quick Books, Crystal Reports, Great Plains and some MS Dynamics AX with X++, CA ERwin

SharePoint Administration

oConfiguration, Installation and Management of SharePoint Server

oSet up and Managed End User Accounts, Permissions and Access Rights

oCreated Reports for Users

oTrained Users Created Documentation

oAssisted Users in deploying Web Parts

Platforms:

Windows 7, Windows Vista, Windows XP, Windows 2000, Windows 2003 Server, Windows 2008 R2 Server, UNIX System V,MVS/XA, DOS

SQL Database Administration

SQL Server Installation, Data Modeling, Importation and Extraction of Data, Reporting Capability, Administering Data Security, Architecture and Planning Recommendations, Develop the Logical Data models and Physical Designs, Managed Performance, Performed Backups/ Restores and Archiving of Data, Developed necessary ETL packages needed to populate multiple tables, System Performance and optimization, Document and Standardize Data Structures, Procedures and Processes

SMS, SCCM, SCOM, TMG

Upgraded SQL Server 2005 to SQL Server 2008

Used Integration Services to solve complex business problems by copying or downloading files, sending e-mail messages in response to events, updating data warehouses, cleaning and mining data, and managing SQL Server objects and data.

Used the graphical Integration Services tools to create solutions

Developed SQL Reports utilizing SSRS

Designed and Developed Data Mart Indexing and Extraction System for Data Mining

Utilized BI tools in the Design and Development of Collecting, Storing and Delivering Decision Support Data at the Enterprise Level.

Systems Analysis & Design with Auditing Capabilities

Individual projects:

Took a company that was originally up for sale and redesigned their entire infrastructure, set up production control system with scanning capability to enable tracking production. Through the means of automation increase productivity to the point of the company being taken off the market and clientele being booked a month and a half in advance. The President of the company said that with the investment of equipment and my time the system would more than pay for itself in a year and a half.

Developed an entire system for medical clinic that took a patient from the time they entered the doors all the way through back-end billing.

Developed interface with EKG machine used during surgery imported readings into SQL database and graphed the readings out within the patients chart.

Developed Automation of Reporting through SSRS.

Arkansas Specialty Care Centers,

Little Rock, AR 04/00 – 06-01

Director Information Systems and Communication

Recruit, train and motivate dynamic employees for optimum operations

Developed and Implemented Database Backup and Disaster Recovery strategies.

Developed Documentation regarding Operating Procedures and Technical Manuals.

Project Management

Research, Benchmark, Document and Introduce New Technologies

Establish, Maintain and Evaluate following of Processes and Procedures.

Proactive in Implementation of Database Performance Monitoring and Fine Tuning for Optimal Performance.

Performance Reviews of associates

Managed team of four individuals and acted as liaison to company of 240 associates

Coded tracking systems for problem tickets and resolution process

Established Information Systems Department from conception

Installation of VPN Clients, Cisco Switches, Routers

Developed EOB system allowing migration of collections into multiple clinics, improving collections by 35%

SMS – Pushed Updates to Workstations from the Server

Oversaw legality of licensing issues saving the company millions in possible fines

Upgraded Servers allowing much greater access speed increasing work-flow

Assisted in automation of payroll process

Evaluation and implementation of third party software

System Auditing

1.Problem Resolutions through technical support

2.Support of telecommunications and paging for doctors

3.SQL support and increase of reporting capability

4.Project Management Accountability

Blue Cross Blue Shield,

Little Rock, AR 04/99 – 04/01

Senior Systems Analyst

Membership Eligibility for Data Warehouse

Trained team members in DB2 class training sessions

Analysis and Design

On-call Rotation

Maintained and Developed programs in COBOL, Focus, and Assembler (370), DB2, VSAM, MVS JCL, Easytrieve, Focus

Project Lead for Membership Eligibility System

Taught DB2 Class

Core System modifications in 370 Assembler

Alltel Information Systems,

Little Rock, AR 05/96 – 04/99

Senior Systems Development Analyst

Analysis and Design

Data Conversions from existing client platform to Alltel platform

Program Development for IM and ST

Languages: COBOL & Assembler (370), MVS JCL, Easytrieve

Assisted in Year 2000 Development

VSAM

Data Conversion Process for new banks coming online

Development, Maintenance and Installation of features

Quality control testing

Lions World Services for the Blind,

Little Rock, AR 09/93 – 05/96

Programming Instructor

Oversaw project planning and student development

Developed curriculum that received rave reviews

Taught following courses:

1.Intro to Computers

2. C

3. Assembler (370)

4. COBOL II

5.Access

6.CICS

7.C-Shell

8.Bourne Shell

9.UNIX System V

10.System Administration

11.Systems Design

Performed student evaluation reports for hiring managers

Trained visually impaired individuals to program computers for IRS out of Washington D.C.

Managed daily processing needs

Summary:

Over Twenty years of IT industry experience with MS SQL Server 97/2000/2005/2008, SSIS/SSRS/SSAS as SQL developer.

Expertise in scripting T-SQL queries, complex stored procedures, User Defined Functions (UDF), and Database Triggers.

Experience with complete SDLC, which includes requirement gathering, analysis, design, development, maintenance and implementation. Experience with Agile and Waterfall methodologies in approach to project development.

Extensive experience in Performance Monitoring and Tuning of SQL statements, Sub Queries, Joins, Cursors and Functions. Extensive experience in the development of backup and recovery process plans.

Experience in Data Modeling (Logical and Physical Design of Databases) using Visio/Erwin, Normalization and building Referential Integrity Constraints.

Experience in Data Modeling, Database Design, Programming and Implementation of Client-Server Applications and Database systems using MS SQL 97/2000/2005/2008 for both OLTP (Batch Processing, Online Processing) and Business Intelligence (SSIS, SSAS, SSRS) applications.

Expert in working with BIDS.

Experience using SQL Server DTS and SSIS for ETL process and constructing packages for deployment.

Expertise in developing reports using SQL Server Reporting Services and MS Excel Spreadsheets.

Over fifteen years of experience with .net development.

Over twenty years of experience scripting and automation development.

Contact this candidate