Sql Server Data Integration

TERRY WITT

**** ****** *****, ********, ** ***** 214-***-**** **********@***.***

Analytical, organized, and detail-oriented database designer with extensive expertise in building robust database solutions. A collaborative team player with a strong sense of ownership and a proven track record of delivering high-quality database and application solutions to tackle complex challenges. Skilled in creating custom data warehousing solutions to support seamless data integration, reporting, and analysis.

EXPERIENCE

October 2001-Present

MIS Director / Database Administrator / Programmer Thomas Printworks Richardson, TX

Designed a database and distributed application for invoicing and tracking production with real-time reporting. Developed data integration from the invoicing and tracking system to Great Plains. Created APIs to facilitate the transfer of information to and from remote locations. Engineered customer-specific data integration for seamless data transfer into various accounting systems. Designed a database and web application for internal and customer reporting, including retrieval of invoice copies. Developed and programmed an EDI system to accelerate the transfer of invoice data to customers, enabling faster payments. Delivered hundreds of reports using SQL Server Reporting Services. Provided technical support for Clustered SQL Server, SQL Server Data Warehouse, stored procedures, and security.

February 1998 – September 2001

Database Designer / System Engineer iSoft Dallas, TX

Designed SQL Server databases and Visual Basic programs for the Gas Industry Standards Board’s (GISB) Electronic Data Interchange, enabling efficient ordering and delivery of natural gas. Developed SQL Server databases and Visual Basic programs for Walmart’s Electronic Data Interchange to streamline product order processing with suppliers. Created SQL Server databases and programs for Thomas Reprographics, Inc., focused on invoicing, production tracking, and reporting solutions.

January 1990 - February 1998

System Engineer Electronic Data Systems (EDS) Plano, TX

Provided customer service support for the main Credit Union application, including data migration from customers’ original systems to EDS’s Credit Union system. Delivered customer support and programming for financial management reporting applications developed in LOTUS. Designed and programmed the American Express Travelers Cheques Electronic Data Interchange, enabling streamlined cheque purchases. Developed a program for Credit Life and Credit Disabilities Insurance payments based on loan data. Collaborated with a team to design and program a Credit Union Clearing House application. Created and implemented a payroll deduction system to facilitate payroll distributions into customers’ accounts.

EDUCATION

December 1988

Bachelor of Accountancy (BA) University of Oklahoma

Relevant coursework: Accounting, Management Information System, Inventory Management, Economics, Tax Law, COBOL, FORTRAN, BASIC

GPA 3.27

SKILLS

Microsoft SQL Server (24 years)

SQL Server Data Transformation Services (10 years)

SQL Server Integration Services (2 years)

SQL Server Reporting Services (10 years)

Internet Information Server (10 years)

Visual Basic / Visual Basic.Net (26 years)

C# (2 years)

ASP.Net / MVC (5 years)

Blazor / C# (2 years)

Visual Studio (22 years)

Great Plains Dynamics Database (20 years)

AvaTax (8 years)

Microsoft Excel (20 years)

Microsoft Word

Microsoft Power Point

Contact this candidate