Robert Bradley

Cumming, GA 30041

770-205-2581
rbradley@foxdev.com

Skills Summary

Work Experience

February 2008 to Present: Senior SQL Server DBA at a commercial insurance company. As a SQL Server developer I design and create databases, tables, stored procedures, functions, and reports. Technologies include SSRS and Crystal Reports. Design integration, import/export with data from USPS, ISO, and various state insurance reporting departments. Troubleshoot, fix performance issues.

February 2003 to February 2008: Through my company Broad Lea LLC I consulted to private and government organizations regarding database design and development.

• Clients in a variety of industries (financial, manufacturing, retail, government)

• Use MS SQL Server 2000, 2005, Visual FoxPro, ASP, IIS, Visual SourceSafe, ERWin, TOAD

• Developing programs for data import/export/ETL using SQL Server DTS (now SSIS) and self-developed tools

• Develop stored procedures using T-SQL

• System troubleshooting and performance optimization using tools such as Profiler

• ASP Web development, including COM object development with SQLS backend

• Lead database designer/developer on client projects, interfacing with other consultants & business units to determine client/system needs; extensive experience in documenting designs and post-development documents, both paper and using tools such as forums, bug trackers, and wikis. Coordinate data designs/specs and ETL activities with accounting and Web services consultants.

January 2001 to present: As a principal in Low Cost Prints LLC I use technology-driven approaches to marketing and order fulfillment.

• eCommerce system uses IIS, ASP with SQL Server

• Some use of PHP, MySQL in Web development

• Wholesale and retail programs, related marketing & advertising

• Back-end order management and fulfillment systems design, development

• ETL functions for batch loading new products and exporting data feeds to wholesale clients

May 2001 to February 2003: As Senior DBA at McKesson & AMISYS, a health care software development company, I developed large-scale database systems for external clients.

• Sybase ASE 12 and MS SQL Server 2000

• Crystal Reports, CAST suite

• Large stored procedure/trigger development using T-SQL, logical and physical database design, modeling and architecture, and performance tuning (all business logic was contained in the database)

• Scripts and migration of database changes from test to production; version and change tracking

• Providing assistance to customer support for issues encountered in the field

November 2000 to May 2001: I was the sole Database Administrator/Developer (DBA/DBD) at eCompanyStore, providing all SQL Server database design, development, and support for the Web-based applications, along with developing reporting and analysis applications. The end-user customers included Microsoft Corp. and HBO.

• MS SQL Server 2000

• DTS for ETL from a wide variety of clients in a variety of formats, both scheduled/automated and on-demand or one-time

• Database architecture/design, logical and physical modeling, database creation, performance tuning, rights management, administration

• SAP (data extractions from SAP databases)

• Visual FoxPro (data cleansing, analysis, reporting), ERWin modeling tool

June 2000 to November 2000: I was a consultant to DataScan Technologies, LLC.

• Wholesale finance system

• Clients included Wachovia Bank, GE Capital Credit, Chrysler

• Visual FoxPro

• Multi-lingual, multi-backend (Oracle, Sybase, SQL Server)

April 1999 to June 2000: I was a consultant to the Texas Department of Health. My assignment was the design of a very large database to support the state's move to an electronic benefits transfer (EBT) delivery method from a paper-based system.

• MS SQL Server

• Design, development, and administration

• Client and middle-tier applications in Visual FoxPro

November 1998 to April 1999: I was a consultant to Harte-Hanks Response Management, a large international marketing and fulfillment firm.

• Visual FoxPro client/server

• Sybase back-end

August 1998 to October 1998: I was a Senior Software Engineer at VRLink, a small sales force automation software company.

• Convert FoxPro Windows 2.6 to Visual FoxPro

• Electronic data interchange (EDI)

November 1997 to August 1998: I was a Lead Software Engineer, team leader at LeConte Software (reason for leaving: company financial difficulties forced sale of assets).

• Visual FoxPro front-end, object-oriented

• Oracle, SQL Server, Sybase back-end databases

• Complex financial system

May 1997 to November 1997: I was a consultant to the Texas Department of Health in Austin. I was responsible for designing and developing an interface between 600 clinics throughout Texas and the state’s Immunization Tracking system. In this project I developed in both Visual FoxPro and FoxPro for DOS. The project was well ahead of schedule due to my development efforts, and I was given additional projects to complete. (reason for leaving: end of contract term)

April 1987 to May 1997: I was on the faculty of the University of North Florida, as the head of the Computer Technology Instruction and Development department for the University’s Institute of Police Technology and Management (IPTM), the largest independent trainer of police personnel in the US.

• Designed and developed general police software

• Success includes most-widely-used criminal intelligence program (over 1,000 using agencies)

• Taught at dozens of colleges in US, in addition to on-campus courses

• Provided security software for National Security Agency

• Supervised three faculty members and secretary

• Managed, planned all software development projects for the Institute

October 1981 to April 1987: I held the positions of Lieutenant, Patrol Commander, Emergency Services Team (SWAT) leader, Training Sergeant, and Patrolman at the 400-person Law Enforcement unit at Cape Canaveral Air Force Station, Florida. At Cape Canaveral I was in charge of the unit responsible for ensuring adequate physical protection for facilities and launch sites critical to the U.S. space program.

My professional career started in law enforcement after graduating from Titusville High School (Florida) in 1976, and joined the Brevard County Sheriff's Office in 1978. I served as a Deputy and Narcotics/Vice Agent with the Sheriff's Office, and have been a sworn officer with the Titusville and Jacksonville Beach Police Departments. I have also been a consultant to Mobil Oil's headquarters in Fairfax, Virginia, where I worked on a large-scale development project for Mobil’s worldwide oil shipping and billing system.

Publications and Accomplishments

• Interviewed by 60 Minutes (background) and numerous newspapers regarding police RADAR

• My articles have appeared in FoxPro Advisor, Law Enforcement Technology and Law and Order magazines.

• Contributed, interviewed, or quoted in PC Week, InfoWorld magazines

• Certified as an expert witness in police use of RADAR cases in U.S. District Court

• Private Pilot license (FAA)

• Founded/operated IRS-recognized public charity

Education

I attended Brevard Community College, Seminole Community College, Pacific Western University and the University of Central Florida. I hold A.S., B.S., and M.S. degrees in Criminal Justice. I engaged in research for a Ph.D. with the School of Law, University of Wales, Aberystwyth.