Principal ConsultantCompany Name GoMnemonicsLocationLas Vegas, Nevada Area• Data Systems Team Management• Data Systems Requirements Development• Data Systems Management• MS SQL Server Development & Operations• MS SQL Server SSRS, SSIS & SSAS• Cloud Management & Operation• High Availability Groups• Performance Tuning

IT Consulting on Infrastructure and Operation of large data systems.

Position eliminate by Pandemic.

Responsible for all SQL server operations to include production, QA and development systems. The production system are High Availability system using both Clustering and Always On technologies (Availability Groups). The QA and development systems are mostly virtualized. This tasks spans 100's of SQL Servers and 1000's of databases. I also design, development and implementation some casino analytical system(s). I work with several casino business units to understand business requirements and procedures. My role in the organization included training and 2nd & 3rd level support of operational sites as required. Created and managed several data paths (DB2, Terra Data, Link Servers, etc...) between other systems to support a wide range of applications. I participated in many casinos opening s to include (but not limited to) Wynn Resorts, Sienna Casino, Encore Resorts, Graton Casino and Resort. Current Systems & Languages: MS SQL 2000, 2005, 2008, 2012, 2014, 2016, High Availability Groups and Clusters; Server, MS 2000, 2003, 2008, 2012, 2014 Server, Availability Groups, SSRS, SSIS, SQL, C#, .Net, COM +, ODBC Connectivity, ScaleArc.

Responsible for design, development and implementation of casino gaming system architecture. This required an in-depth understanding of all system architectures and interfaces. I lead and worked with several organization in the casino to understand business requirements and or castrate system architecture. The database requirements were documented and implemented by me: Tables, Stored Procedures, Triggers, Primary Keys, Foreign Keys and resource planning. My role in the organization included training and 3rd level support of operational sites as required. Created and managed several interoperability paths between other products. I participated in the opening of Wynn and Encore casinos and hotel.Systems & Languages: MS SQL 7, 2000, 2005, 2008 Server, MS 2000, 2003 Server, SQL, COM +, ODBC Connectivity, Crystal Reports

Responsible for developing the Cage & Table Accounting (CTA) Casino System. This required the development of all aspects of the database: Tables, Stored Procedures, Triggers, Primary Keys, Foreign Keys and resource planning. It also includes 3rd level support of operational sites as required. Consulted with product management and customers to help guide the products growth. Created and managed several interoperability paths between other products. Implementation of this product line has been focused on a transaction base system and highly normalized. I have participated in the opening of 6 different casinos.Systems & Languages: MS SQL 7, 2000, 2005 Server, MS 2000 Server, SQL, COM +, ODBC Connectivity, Crystal Reports

Company purchased by IGT.

Responsibilities included database architecture standards and all projects. Mentoring junior developers and ensuring projects meet standards. Providing both server & network managed solutions to meet customer needs. Systems have been developed for financial institutions in the following areas: Client and Account management, Company & Contact management, Accounts Payable & Receivable, Communications with Clients and Contacts and integration of multiple system to coordinate these activities. Systems & Languages: MS SQL Server, MS NT Server, MS NT Workstation, SQL, ODBC Connectivity

Provided development and maintenance services for overall architectures of E-Commerce on the internet. Implemented web sites with both a B2B and public facing end points. Developed specification for B2B interfaces and implemented same interfaces. Systems & Languages: MS SQL Server, MS NT Server, MS NT Workstation, SQL, ODBC Connectivity

Providing server & network managed solutions for Site Materials & Services Group (SMS). Network analysis of both fiscal & logical layers. MS Windows NT servers running a variety of applications: IWCS (Interactive Workload Control System), FTZ (Free Trade Zone), Maximo (Off the shelf H/W maintenance), SQL, etc... Providing system/application training to all SMS employees. Coordinating/Implementing new business process flows for existing factories and new factories. Implemented a core user structure to address new business issues and distribute corrections back to the business units. Creating and administering WWW page content. Also acted as ERT (Emergency Response Team) Leader, assisting/coordinating chemical, environmental, structural evacuations and clean-up efforts and hazards.Systems & Languages: SyBase SQL Server, MS SQL Server, MS NT Server, MS NT Workstation, SQL, ODBC Connectivity, HTML, Cold Fusion, InfoMaker, Impromptu

Provided DBA services to Intel's IT department, developing and maintaining a proprietary application. This application was an international effort to manage facilities maintenance.