Ron A. Romero

SQL Server DBA/Developer

***** ********* **** **. *******, FL 33323

PHONE: 954-***-**** EMAIL: acch4b@r.postjobfree.com

PROFESSIONAL RESUME

SQL Server OLAP/OLTP DBA/Developer/Architect; Senior Business Systems

Analyst; and Project Lead; are just some of the titles I've held in my 20

year career in the Information Technology field. I am a fully engaged, and

dedicated self-starter, who has had the privilege of working with some of

the finest engineers in the world, and on many well-know projects for:

Boeing, Raytheon, Intuit, Aetna, Mitchell International, and others --

bringing skillsets acquired from many different industries, and

technologies.

Database Technologies:

MS SQL Server 6.5, 7.0, 2000, 2005, 2008 R2, 2012; SSIS, SSRS, SSA, SSMS;

MS Access 2.0 - 2010

Software/Web Technologies:

Visual Studio 5.0 - 2012 Utilizing VB 4.0 - 6.0, VBA, VBScript, JavaScript,

HTML, Classic ASP, ASP.NET 2.0 - 4.0, C#

Publications:

Contributor - Power Programming MS Access 2003 with VBA

Update Co-Author - Advantage Series - MS Access 2003

WORK HISTORY

GREAT FLORIDA BANK

2013 to 2014

Database Administration / Development / Migration / Integration

Under the direction of the COO, and CIO: Advised in Data Warehouse

migration project, as a member of the project steering committee; Conducted

Administration and Tuning of proprietary OLAP and OLTP databases - SQL

Server 2005 - 2012; Program Modification, and Documentation of Banking

Applications: Sales Management System, Real Estate Management System,

Credit Management System, Deposit Management System, and Loan Pipeline in

T/SQL and ASP.NET 2.0 with C#; Migration of SQL Server 2005 Databases to

SQL Server 2012; Implementation of SSIS, SSAS packages; Proactive

involvement with COO, CFO, CIO, and staff.

CALIFORNIA DEPARTMENT OF TRANSPORTATION _ _

2006 to 2013

Contractor: Database Consultant / Data Governance / Business Systems

Analyst

As a Consultant for Caltrans, I was responsible for designing and leading

the development of a new Administrative database application system that

integrated the Construction, Maintenance, and Program Management

departments for district 11. I coordinated the various departments in a

cooperative effort of information sharing and process modifications that

was used to benefit these departments in their reporting information to

each other, and to Sacramento.

Installed, Configured and Maintained SQL Server 2008 R2 for use by various

departments. Developed proposal for IT in Sacramento on how the state can

improve information sharing with SharePoint Server. Developed Data

Governance program for District 11 as a model that could be adopted by

other districts in the state. Consultant/Advisor for Statewide mission

critical Financial Database Management Systems. Subject Matter Expert.

Coordinated and Delivered presentations to all levels of staff.

Other Development and Administrative duties included:

Development/Migration/Integration of Microsoft Access 2003 and 2007

database using VBA, SQL Server 2005 and 2008 R2 Views, Stored Procedures,

Functions, Triggers, BI, Backup & Recovery Planning, Packages, Security,

Logins/Roles, Jobs, Indexing, Ad hoc Reporting in Crystal Reports and

advance SSRS, Tuning.

ADVANCED MARKETING SERVICES / BAKER & TAYLOR PUBLISHING 2005 to

2006

Contractor: Database Consultant

Working as a Consultant, I was responsible for the development and

integration of GC3-MTS/Oracle databases with SQL Server 7.0 Security, DTS,

Stored Procedures, Views, Table Schema Design, Tuning and Optimization.

PL/SL Oracle Data Analysis with Toad. Requirements Gathering, Discovery,

and Design Documentation utilizing UP processes and MS Access XP.

INTUIT

2005 to

2006

P/T Contractor: SQL Server / Oracle integration with MS Access

I was hired as a Consultant by the TurboTax program to redevelop the MS

Access InProgress database to create sample data from three main SQL Server

and Oracle databases across the country for use by the Customer Advocacy

group. Tasks included Requirements gathering, Cost benefit analysis and

Development in T/SQL and VBA.

PACIFIC DATABASE MANAGEMENT

SYSTEMS 2002 to

2005

Owner: Business Admin / Writer / Payroll / Database Architect

After receiving many 1099 projects from previous employers, I opened

PacDBMS. I worked in many industries and designed and developed LAN

networks; MS Access Applications, Software projects in VB 6.0 that

utilized Windows API's, Group Policy Objects, Windows Registry, Creating

Windows Services, and ADSI for Windows 2003 server Developed various

timekeeping systems for a Naval Repair company, and a Research &

Development company.

Contributor/Co-Author "Access 2003 Power Programming with VBA" for Virginia

Andersen & Allan Taylor -- Wiley Publishing; Revised Text Book: "Advantage

Series - MS Access 2003 complete edition" for Microsoft Certification -

Authors: Sarah E. Hutchinson and Glen J. Coulthard - McGraw-Hill Irwin.

RAYTHEON SYSTEMS

(N&MIS)

2000 to 2002

Consultant: DBA / Database Design, Development Lead - (Secret Clearance )

Common Aviation Command and Control System program (CAC2S) - Portable

aviation command and control center for the Marine Corps. Companies and

divisions participating included: Raytheon, General Dynamics, Lockheed

Martin, Gallium, Kongsberg, Marine Corp., Camp Pendleton, MarCoSysCom

Quantico, VA and SPAWAR.

While on the CAC2S I was primarily responsible for the Development of a

secure Intranet collaboration environment for project personnel to design

and develop the new CAC2S System. Included, was a web-based Risk Management

application that I developed in SQL Server 7.0 and JavaScript. I was also

responsible for all Database Administration tasks. Made ADE Environment

presentations to scientific experts and high-level Marine Corp personnel

and defense industry management.

Landing Platform Deck program, (LPD 17-21) -- Next generation LPD project

for US Navy and Marine Corps. Also included the USS New York, which used

scrap metal from the World Trade Center in it's construction.

Program Lead for the National (PrIDE), Program Integrated Design

Environment database re-design in MS Access 97, and MS SQL Server 7.0

utilizing full life cycle development methodologies. PrIDE Database DBA,

Stored Procedures, Views, Tables, Security, Maintenance, Tuning, Backup and

Recovery. Program Lead for the (EDR), Engineering Deficiency Reporting

database used for quality assurance in tracking issues on the LPD program

and software.

BOEING

AEROSPACE

1999 to 2000

Project Lead / Enterprise Application Developer

At Boeing, I was hired to develop a Database Application system to move

engineering schematic changes through the Engineering department in

Seattle, to the Parts Listing department, and finally to Illustration

departments in Southern California for the development and distribution of

Boeing Repair Manuals for all Boeing commercial aircraft models, the

Pentagon's E4B, and Air force One.

Integrated engineering application with AutoCAD to automatically produce

title block on the illustrations and assign diagrams to Illustrators

according to their aircraft team. Developed application that measured

productivity and performance metrics for parts listing and illustration

departments utilizing a comprehensive time scale per engineering matched

against timekeeping records.

EDUCATION & TRAINING

Bachelor's Candidate, Business Administration / English - San Diego

Community College District / Seminars; Advanced MS Office Programming and

Project Management, New Horizon. Currently Studying for MCSA, MCSE

Certification for SQL Server 2012.

Contact this candidate