Sql Server Online Marketing

Harry B. Collier

*-***/ ***-**** ************@*****.***

OVERVIEW

Developed, implemented, and managed information systems supporting online marketing, one-to-one communications (between sales associates and their customers via text, email, mobile devices and website interfaces), and analytical infrastructures in the hospitality, gaming, and travel industries. Created new products for the consumer products industry. Designed, developed, marketed and patented products. Secured off-shore production capacity, and marketed through trade shows, sales representatives, in-store merchandizing and product licensing. Conducted consumer market campaigns and delivery.

Established, hired staff, and managed the Biomedical/Clinical Engineering Department for a large Medical Center.

PROFESSIONAL EXPERIENCE

Conrad Hall and Associates, Boulder Colorado 14 Years 2008 -- 2022 Click1to1.com. develops, licenses, and supports one-to-one online marketing applications. Chief Information Officer – One-to-One Online Marketing Systems

Developed and managed multiple SQL Server databases supporting the company's products including MySQL 5.x.x development for two years prior to SQL Server transition.

Developed tools and client support for online, one-to-one marketing relationships between Clients’ sales associates and their individual customers, including website and database support for:

Content Management

Email and Wireless Marketing

Client Marketing and Sales Management Support (Administrators and Sales Associates, referred to as “Hosts” in Gaming Industry)

Client-Customer (referred to as “Players” in Gaming Industry) direct Communication and Account Statistics

Data Analysis and Reporting

Multi-variant, logically searchable, bitmapped Customer Information Tables

On-Going Product Development

Front End Development and Interfaces

Scheduled and episodic data import/export

Clients included:

Group Voyagers -- $300m annual worldwide tour operator

Qdoba Restaurants -- 750+ restaurants nationwide

Extra Space Storage -- 2nd largest public storage company in the US

MGM Resorts, Las Vegas – 500k Customer Base; Used by 10 Las Vegas properties including: Bellagio, MGM Grand, Mandalay Bay, Aria, New York New York Also used by a variety of independent Travel and Casino organizations located in the United States and foreign countries Technologies: TSQL, Management Studio, Power Shell, sqlcmd, JavaScript, HTML/CSS, XML, JASON, ColdFusion, SQL, AJAX, Java (w/reference) Created, Developed and Managed SQL Server Databases in Hardware and Cloud Environments.

Utilized Microsoft Office Professional Suite for operations and presentation requirements in the general business environment.

Harry B. Collier Page 2

1-303/ 807-6330 ************@*****.***

Travel & Tour Company 4 Years

The Company assembled and sold tour packages -- flights, accommodations and on-site events. Information Technology Partner

Developed in-house SQL Server Databases and integrated Website Marketing and Reservation systems, booking travel arrangements (Flight and Lodging) and on-line payments. System supported in-house Booking Agents and Sales Representatives.

Supported 30K+ customer reservations annually -- flight reservations booked out of 10 US cities, hotel reservations at 20+ facilities in Mexico, Jamaica, and Dominican Republic, along with "On Site" special event and group touring reservations Technologies: Created, Developed and Managed SQL Server Databases, TSQL, Management Studio, Created Travel Websites, JavaScript, HTML/CSS, ColdFusion, and MS Access databases Consumer-Products Company 6 Years

President

Product Management

The Company designed and produced unique consumer products – Marketed in industry magazines, in- store displays and nationwide through Independent Sales Representatives and Trade Show presentations. Managed design and production: Products and components produced in the US and off shore in Taiwan and Hong Kong, delivered to company warehouses and distributed nationwide to toy and gift stores and large merchandiser warehouses.

Created and produced or licensed unique consumer products

Conducted Market Testing and Positioning

Invented and produced the first theft alarm device for bicycles – Bike Alert. Expanded the product market to protection for other portable property such as Luggage items and Handbags

Developed and produced a convenient and effective household Paint Touch-up device, marketed as One Minute Painter ™

Invented, developed and marketed a hand-held unique rubber stamp device encasing electronic circuitry that generated sounds activated by stamping action. Sounds generated are associated with the stamp image – “Vroom” when Racecar image stamped, a happy “Bark” with Puppy image,

“Kerching” the cash register sound with PAID stamp and other fun sound examples. Marketed as Talking Stamps ™. Filed and received US Patent. Subsequently licensed Talking Stamps ™ and patented technology to a major stamp manufacturer

Developed first system design for remote controlled toys, and other remote control devices, to enable the device to generate sounds (on-board) coordinated with the actions the device is instructed to take remotely. For Example: A remote controlled racecar makes a “screeching” sound when signaled (remotely) to turn sharply; a rumbling sound when idle and other related sounds Built prototypes modifying existing remote control toys. File for US Patent and licensed technology to major remote control toy manufacturer

Established Off-Shore product manufacturing including molds, electronic circuits, microchips and assembly alliances

Developed a Kids version of the Bike Alert – “Fire When Ready” which, in addition to bike theft detection and alarm functions, the alert included the ability to activate five different kids’ action sound effects while riding. Received Licensing Agreements from DC Comics and Nintendo America for Name and Character Image use on products and advertising – “Batman Bike Alarm”; “Nintendo Bike Cop”. Subsequently, licensed alert mechanism technology to a major toy company and a consumer electronics company

Invented an efficient Cooling Cartridge to maintain cool liquid temperatures in large “Sports” beverage bottles precluding the need for ice and its dilution effects

Developed a sales tracking and management desktop software package “Sherlock”

Granted 4 US Utility Patents

Technologies: Microchip programming and provisioning, Circuit Board design and manufacturing, Electronic motion detection and artificial sound generation, provisioned in microchips. Pascal programming language and various microchip systems utilized

Harry B. Collier Page 3

1-303/ 807-6330 ************@*****.***

VA Medical Center 5 Years

Manager, Clinical Engineering

Established, hired staff and managed the Clinical Engineering Department within the Facilities Management Department for a Veterans Administration Medical Center

Maintained clinical engineering standards such as ensuring patient safety

Established and consistently met all requirements, selection specifications and maintenance standards for medical equipment and facilities

Oversaw all installations and operations of electronic, direct patient care equipment such as EKG machines, Ventilators, and other direct care devices

Continuously met standards of medical facility oversight by Joint Commission of Hospital Accreditation and others – (the gold standard in health care)

Managed Department Technicians and staff – The Department functioned integrally with other Facilities Management staff

Defined needs for Medical Center Upgrade and Modernization Projects, in consultation with Medical Staff:

Medical Intensive Care Unit

Surgical Intensive Care Unit

Open-Heart Surgery Suite

Cardiology Care

Nuclear Medicine Facilities

Diagnostic Imaging and Interventional Radiology Units

Psychiatric Care Facilities

Respiratory Care

Ambulatory Care Area

Upgraded 20 patient bathroom areas for ambulatory care access Established and managed technical staff for Design, Construction, and Equipment Selection to upgrade and modernize these core service departments within the Medical Center. EDUCATION

University of Maryland, College Park, Maryland

BS Degree Chemistry, Emphasis Organic Chemistry

Biomedical Engineering Masters Program

Additional Engineering Studies: Information Technology, Electrical Engineering Military Service: US Army – Honorable Discharged

Harry B. Collier Page 4

1-303/ 807-6330 ************@*****.***

EXPERIENCE OVERVIEW

DATABASE/TECHNICAL EXPERIENCE

Databases: SQL Server 2000, 2005, 2008, 2012, 2016; MySQL 5.x.x; Std SQL Tools: Management Studio, Navicat, RedGate, Devart ex. DB Forge, MS Excel Programming/Scripting: TSQL, PowerShell, SQL, JavaScript, HTML/CCS, Java (w/reference) ColdFusion, Pascal

Data Transmission: Import/Transmit XML and JSON formatted data, Export/Import large collections of data as csv files via FTP (compose/provision/send) (import/extract/translate/store data) Development – 14 Years: Developed and managed transactional oriented SQL Server DB’s to support Corporate Clients website interfaces, email and data uploads/interfaces

Development included production databases, process server databases, mirrored databases, and data transfers to and from Corporate clients’ and commercial databases (Adestra, Exact Target, and others)

Created tables within relational models, temporary tables, table variables, and CTEs

Created complex queries, stored procedures, functions, views, triggers and dynamic SQL Procedures

Optimized Query and index performance with regard to execution evaluation

Oversaw data backup processes and performed development and testing on development and staging servers

General Business: Utilized Microsoft Office Professional Suite for operations and presentation requirements

PRODUCT DEVELOPMENT AND MARKETING EXPERIENCE

Product Management

Product Envisaging

Off Shore Production, Resource Identification/Vetting/Contracting

Product Positioning

Product Licensing

Market Testing

US Distribution and Sales

In Store Mass Merchandizing

Individual/Specialty Store Sales

Tradeshow Advertising and Merchandizing

Plastic Mold Design for Products

Retail Package Design

BIOMEDICAL/CLINICAL MANAGEMENT EXPERIENCE

Established and Staffed the Clinical Engineering Department

Oversaw Technical Staff creating architectural designs

Selected Major Equipment (i.e., ICU Patient Monitors)

Developed Budgets and Selected Construction Contractors

Managed Logistics and Daily Project Progress to Completion References and/or Products Portfolio

Available upon Request

Contact this candidate