James Bann

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

Westminster, CO 80031

Home: 720-***-****

Cell: 719-***-****

acujzk@r.postjobfree.com

Objective:

Seeking a position as a SQL Developer. I have 30 years in experience in systems programming and administration. I have 10 years of database administration and SQL development. I am adept in designing and building databases; creating stored procedures, views and triggers; performing backups and recovery, system monitoring and tuning; as well as other database administration duties. I am an MBA, MCSA, MCSE, and MCDBA certified. Possessing functional expertise spanning Internet, intranet, and web technologies, software development, and data transformation services, I am confident I will prove a valuable addition to your technical team. In addition, I have extensive experience in software development and have participated in all aspects of the software development life cycle.

Work Experience:

04/2012 – Present SQL DBA

Reed Group, Inc.

Denver, CO.

Managed several hundred client databases.

Created jobs to back up and restore databases.

Created SSIS packages to extract date from the databases.

Monitored daily job activity, fixed and reran failed jobs

Created SSRS reports to monitor database activity.

Added stored procedures, functions, tables, etc. to the databases.

10/2011 – 03/2012 SQL Developer

Direct TV, Inc.

Denver/Colorado

• Created custom reports for Clients using SQL for Microsoft databases.

• Integrated SQL database extracts with SSIS to generate Xcel reports that were produced on a regular basis.

• Used SSIS to load database tables with test data.

12/2004 – 09/2011 MS SQL Developer

Trizetto Group, Inc.

Denver/Colorado

• Created custom software solutions for Clients using SQL for Microsoft, Oracle, and Sybase databases.

• Worked with testing and installation teams on testing new software and versions. Duties included installing SQL Server, installing databases, creating stored procedures, creating database backup and recovery procedures, installed custom database jobs, creating user roles, configuring the databases, loading data, etc.

• Also helped install Trizetto software on Client systems by setting up, installing, configuring databases, etc. on Client systems for storing Client data.

• Created custom reports for Clients using SQL Report Services. Also, created custom database installation packages to customize Client database configuration.

7/2004 - 12/2004 Risk Analyst II Centrix Financial

Denver/Colorado

Duties include writing SQL procedures, view, functions, DTS, etc. in conjunction with Crystal Reporting tools to generate Risk Analysis reports. Perform data and risk analysis. Additional responsibilities include system and reporting trouble shooting and data analysis.

11/2001 - 11/2002 Systems Analyst II ATT Broadband

Denver/Colorado

• Worked on converting AT&T Broadband telephone customers to AT&T customers prior to the AT&T Broadband merger with Comcast. Oracle and Access databases were converted to an MS SQL database using T-SQL scripts, DTS, and VB scripts.

• Installed SQL 2000, created stored procedures, T-SQL scripts, DTS packages and jobs, security policies, backup and recovery procedures, etc. for MS SQL repository database.

• Several MS Access databases were created to generate queries, and reports using T-SQL and VB scripts for the auditors and managers to check the validity of the converted data, and monitor the progress of the data conversion.

• Created a Web Site using VB6.0 and SQL server database used to track the conversion of customer data that had to be manually processed.

7/2001 - 11/2001 Systems Analyst II ATT Broadband

Kansas City/Missouri

• Worked on an audit team consolidating and converting multiple AT&T's Broadband databases into a single database.

• Created MS Access databases, queries, and reports using T-SQL and VB scripts for the auditors to use to monitor the progress of the data conversion and check the validity of the converted data.

• Created an MS Access issues database with data entry forms, queries, and reports to track data integrity issues.

4/1986 - 3/2001 Systems Analyst II WorldCom Inc.

Colorado Springs/Colorado

• Worked in Internet and Web Development using ASP, HTML, JavaScript, SQL, T-SQL and VB script. Have participated in all aspects of the software development life cycle including analysis, design, coding, testing, and maintenance.

• Worked on development and database design of a Project Tracking System. This system allowed an analyst to perform a feasibility study, determine and track project costs and man power. Once a project was approved various system managers were able track project progress, project delays, and generate progress reports.

• Developed other web projects including a system for tracking and resolving production problems; a system for tracking and broadcasting system outages due to system failures or upgrades; and a system for tracking problems found during software testing.

• Helped maintained client/server network interfaces; administered shared files, printers and security; and performed trouble shooting on the desk top environment.

• Designed and developed a system for tracking and migrating project software from development, to test, and production environments.

• Worked in production support. Reviewed the daily batch job run and "turned around" any failing batch jobs. Reviewed JCL to make sure it was production ready. Performed Racf and security administration. Resolved production data problems and performed data fixes. Worked on small maintenance and adhoc projects.

3/1983 - 4/1986 Computer Programmer FBI

Washington D.C.

• Worked on automating the field offices by setting up and installing FBI software on the LAN's in the regional offices.

• Helped designed and code FBI software for Cases, Leads, Exhibits, Time and Attendance, etc.

• Helped trained field office personnel on the new FBI software and technical support.

• Designed, coded, and installed the first Forfeiture Seized Property tracking software.

• Other responsibilities included Racf administration and providing data security for the FBI files.

Education:

Dates Attended School Degree Location

6/1981 Ohio University Master's Degree Athens - Ohio

6/1976 Lafayette College Bachelor's Degree Easton - Pennsylvania

Skills:

Active Server Pages Crystal Reports Data Transformation Services

DHTML Enterprise Manager HTML

Infomatica SSIS JavaScript

MS Access SQL 2005 SQL 2008

SQL Query Analyzer SQL Reporting Services T-SQL

VBScript Visual Basic 6.0 Visual Studio 2010

References:

Reference Name: John Plunkett

Reference Company Trizetto Group, Inc.

Reference Title DBA

Phone 303-***-****

Email acujzk@r.postjobfree.com

Type Professional

Contact this candidate