Sql Server Visual Basic Sharepoint Admin/Developer

Database Developer/DBA

Marshall Brandt

717-***-**** ******.********@*****.***

SQL Server Developer/DBA and Programmer

For the past nine years I have been working as a SQL DBA and developer working with medical insurance billing records working with data from major health insurance companies. DBA tasks include importing very large data sets into our databases from various clients to perform custom auditing. As a database developer I create custom scripts to monitor and report on the status of the data importation process.

Proven experience as a DB technical analyst and DB project manager, handling technical projects from inception to completion, meeting the company’s expectations.

Experienced in working in large heterogeneous computing environments to enable data interoperability forming highly functional integrated computer systems.

TECHNICAL EXPERTISE

Databases: SQL Server, DB2, Sybase, PostgreSQL, Access, dBase, FoxPro, Paradox

Programming: .Net Visual Basic, C#, VBA, Java, Javascript, SharePoint

Operating Systems: Windows, AIX, Solaris, Xenix, HP-UX, SCO Unix, Linux, Mac OS

PROFESSIONAL EXPERIENCE

CDR ASSOCIATES, LLC, PRINCIPAL INFRASTRUCTURE MANAGER

(March 2008 to Present)

Create stored procedures to Import large data files (400 gigabyte), Use SSIS. Develop indexes for performance of multi terabyte sized databases with over 1 billion records, Convert EBCDIC files with variable length records using VEDIT Macro programming for file conversions and data cleansing, Create data mining SQL data extraction reports, Develop using MS Access, Perform C# code conversion of routines to T-SQL. Lead team of 3 junior dba. Monitor systems for table locking and other system performance issues. Backups, Restores. Complex ad hoc reports.

MARSHALL BRANDT CONSULTING, SYSTEMS CONSULTANT

(2002 to Present)

Part time business helping small companies with IT needs that do not have full time IT programming staff typically they have just network and server staff. Dot Net both C# and VB. Intranets and desktop apps. Office VBA programming. SharePoint. Sql Server development. Pull data from machines such as stamping machines and pull it into sql server and then into intranet.

LINK COMPUTER CORPORATION, SENIOR SOFTWARE DEVELOPMENT ENGINEER

(February 2007 to March 2008)

Developed desktop and database applications using ASP.NET, MS Access, Crystal Reports and Visual Basic.

Administrated SQL Server databases.

LINCOLN GENERAL INSURANCE, SENIOR PROGRAMMER ANALYST

(September 2004 to February 2007)

SQL Server DBA. Developed SQL Server 2000/2005 applications using Visual Basic.NET.

Created applications to receive text files from agents. Processed files to ensure compliance with various state DMV rules.

Created an application to format claims data.

Created a bar code application to track policy binders physical location.

Created an application to update MS active directory with employees’ personal information.

Created Sharepoint application for managers to perform the annual employee review process.

M BRANDT CONSULTING

(September 2002 to September 2004)

Created applications for clients.

Example: Created client applications using MS Access for managing vehicle servicing and inventory. The application interfaced with Quickbooks for invoicing.

Used Visual Basic and Visual Basic mobile for Windows CE and SQL Server

PARAGON CONSULTING, VISUAL STUDIO DEVELOPER

(January 2001 to September 2002)

Visual Basic and Visual Interdev development of custom desktop and EDI applications accessing various databases such as: SQL Server, AS400 DB2, Access, Foxpro

Performed Visual Basic and Crystal Report development.

EDP CONTRACT SERVICES, NETWORK ADMINISTRATOR

(February 2000 to August 2000)

Windows and Linux and Solaris Administrator

ENGEL MACHINERY, ENGINEERING SYSTEMS ADMINISTRATOR

(September 1998 to February 2000)

Administered Solaris and HP UX servers and workstations

Developed MS Access app for machine specifications

RITE AID, NETWORK ENGINEER II

(May 1998 to September 1998)

Administered Solaris and Novel servers

Crystal Report development

Sybase Data extractions

YORK COUNTY VO-TECH, TEACHER COMPUTER TECHNOLOGY

(1996 to 1998)

Taught Unix on NCR system Vi editing scripting

Taught C, Pascal, Visual Basic, HTML, Javascript, Perl, MS-Access

METALOGIA (later became DER SYSTEMS), IT DIRECTOR

(1996 to 2006)

Developed Software for medical transcription business. Visual Basic and SQL Server and classic ASP.

Architected solution and directed contract programmers.

Installed network and servers.

EDUCATION

1988 TO 1993

PENN STATE YORK, MECHANICAL ENGINEERING

40+ credits mostly in Engineering program

1987 TO 1988

ELECTRICAL ENGINEER, CENTER FOR DEGREE STUDIES SCRANTON PA

Correspondence course on Electrical Engineering 18 credits

1986 TO 1987

DIPLOMA IN MICRO COMPUTER REPAIR, ICS SCRANTON PA

Correspondence course on Micros computer repair

Contact this candidate