SUMMARY:

• Serving as a member of the Teradata Service Focus Team for over a four years. I am published on the Teradata.com web site which includes my biography. This is part of the Partners general council team in conjunction with the PAC.
• Experience with Mobile application architecture design and development using JSON. Designing QR Code applications to market to customers using any IOS or Android device. In conjunction with this effort I am designing an Aruba Wi - Fi infrastructure so any customer can be supported at any of the casinos, restaurants, nightlife or retail shops.
• Primary support and administrator of multiple Teradata Data Warehouse systems. The current version of Teradata software is 13.10. This includes the support of Business Analytics, Cognos, Impromptu, and Microstrategy Administrator for building dashboards and daily operational reporting for all of our casinos, including hotel management, point of sale, slot analysis and other capabilities.
• Converted SAS, Excel and Access programs to Microsoft SQL Server for Casino Direct Marketing Statistical Analysis programs and reporting. Delivered reports to Casino Management which helped make strategic marketing decisions for future marketing campaigns. Experience with Teradata TASM, BAR, Worked with the Teradata GSC in resolving RDBMS related incidents. Working knowledge of Teradata suite of tools; TDWM, Teradata Manager, Viewpoint, Teradata Administrator, Aprimo, Data Mover, PMON, BTEQ, ARCMAIN, FASTOAD, MLOAD, TPUMP, DBQL, PDCR.- Working knowledge of Mainframe interfaces and execution; TDP, JCL, TSO,ISPF, FICON, NDM. Other knowledge of tools are with Teradata Systems setup, GDO, DBSControl, Multitool, Nagios.
• Teradata BAR technology, Tara server, NPARC
• Working knowledge of Viewpoint and Teradata Data Mover
• Design, developed and implemented the Customer Relationship Management on the Teradata Enterprise Data Warehouse that required, campaign development, and campaign mail output and trend analysis for our 6 casino properties. Erwin was the base for all Teradata Database Design Structures. Strong experience on data analysis, business analysis, user requirement gathering, user requirement analysis, gap analysis, gathering metadata data cleansing, data transformations, data relationships, source systems analysis and reporting analysis. Experience in Master Data Management Projects and Solutions.
• Developed, designed, and implemented HRIS/Payroll systems utilizing Employee and Manager Self service on the web.
• Led 50 employees to oversee seven large scale projects that were imperative to the success of Sprint’s ‘On Demand Network’ topology linking long distance, local, internet, and wireless technologies. We used 4 Teradata Warehouse platforms for this effort.
• Managed a team of Data/Database Architects to deploy Sprint’s Enterprise Teradata Data Warehouse Architecture. Designed the architecture to build a variety of subject areas that use information and message broker technology by using the TOM model.
• Created a logical to physical model for a multiple terabyte Enterprise Data Warehouse and accomplished the first cut model using Erwin as the tool. Each warehouse has grown to over 13 terabytes.
• Support 1400 + SQL Servers version 2000, 2005 and 2008 R2 within the Caesar’s Corporate Enterprise Environment that included full life-cycle Database Management support for all servers including our Virtual Environments in the United States, Canada and Overseas

TECHNICAL SKILLS:

Operating Systems: HP-UX 11.11, Sun Solaris 7/8/9, RH Linux 7.1/8/AS 3.0, IBM-AIX, 5.6/5.7, Windows 2003/XP/2000/NT 4.0 2003/XP/2000/NT 4.0

RDBMS: Teradata versions 6 -14, DB2 9.5/9.7, MS SQL Server 2005/2000/7/8/12, 14,MS-Access 2000, Oracle, Informix, MySQL

Business Tools: Rational Suite, MS Visio, Crystal Report, MS Project, MS Powerpoint, T

Languages: C, C++, Java, J2EE, Java Script, VB Script, VB.NET, ASP.NET, HTML, XML, SQL, PL/SQL, COBOL, Assembler, Macro Level CICS

Tools: Embarcardero ER Studio, ERwin, Embarcardero DBArtisan 5.4, Embarcardero Rapid,ASM, VIEWPOINT, REDGATE CISCO, TIBCO, VMWARE, Teradata Manager, Cluster Manager,Nagios, SQL, Teradata Administrator, Toad, SQL Navigator, Informatica 6.x/7.x, Informatica PowerCenter, Embarcadero DT/Studio 2.3/3.0, Power Designer 15.0, XML Spy, Silverrun, DataStage

Management: Clear Case, Perforce, CVS, VSS, Model Mart

Others: MSOffice (Word, Excel, PowerPoint, Access), XML, XSLT, Rational Rose, UML, Hadoop, Hive, Pig

PROFESSIONAL EXPERIENCE:

Confidential

IT Architect

Responsibilities:

• Responsible for the architecture design, development and implementation of the MDW(Marketing Data Warehouse) for the corporation. My responsibilities are to build a Marketing data warehouse and Loyalty-Offer program for a new casino being built in Las Vegas, and also centralizing disparate systems throughout the Enterprise. I am also designing a mobile application to sync with this program so we will be first to market with mobile technology in the Amazon cloud for our customer base, not only in the casino, but also as part of the Hotel, Nightlife and Restaurant verticals. We will be using a middleware vendor which will be designing and implementing the QR Code technology to market to all customers from IOS or Android devices. Through my recommendations the vendor will use JSON, JAVA and XML as part of this architecture for which I have hands on experience working with the vendor application developers. I will be developing in house database platform for MS SQL Server and MySQL for which I will be responsible for database administration, design, backup and recovery and integration to other systems. My responsibilities for the MS SQL Server was administration of the database, building schemas, performance and tuning, backup and recovery and scheduling SSIS and Stored procedures. I also assisted helping the Marketing team build queries with their analysts to market to our customers using SAS and Microsoft access. I also helped them build pivot tables in Excel and imported them into SQL Server for which they built email campaigns for our customer relationship management initiative.
• I current hold a in ‘CRM Application Development’, I worked with CRM for at least 10 years, helping various marketing departments complete their campaigns. Cognos was used for some campaigns as well, depending on the business requirements.

Confidential

Lead Database Engineer

Responsibilities:

• Responsible for the Design, Development and Support of Caesars Microsoft SQL Server Enterprise Environments consisting of over 1400 servers running Microsoft SQL Server 2000, 2005 and 2008 R2, 2012 and 2014.
• Responsible for Disaster Recovery for all database platforms. Experience with Redgate backup software.
• Worked closely with the TIBCO middleware team to design and support multiple database systems within the Caesars network. TIBCO was used vastly across the enterprise with all systems that our team supported.
• Experience also with Remedy ticketing system and Sharepoint.
• Responsible for the Design, Development and support of Caesar’s Teradata Data Warehouse systems. These systems also feed our Business Analytics applications including but not limited to Cognos, Impromptu and Microstrategy and Datastage.
• Representing Caesars Entertainment on the Teradata Partners Service Focus Team. My personal publication on the Teradata.com web site.
• Responsible for the support and development of limited Informix, DB2 and Oracle application development and administration in the UNIX and Linux platforms.
• Partner with the Application Development Departments and play a key role in Data Modeling team for the design and Architecture of all Enterprise applications.
• Currently working with CRM, BI, Erwin, Aprimo,Teradata 14.10, Microstrategy, Cognos, Tableau, Viewpoint, and Microsoft SQL Server supporting Casino Enterprise Systems (Bally ACSC, Bally BI) as well as Financial, Marketing, EDW, MDW, POS, and various small applications either vendor driven or in house design.
• Support the Epiphany Application and Data Warehouse. Responsibilities include Researching database issues, including design, performance, data integrity, and the model. Support the implementation of a back up recovery strategy for the SQL Server Platform. Perform SQL Server DBA responsibilities for all Caesars properties, including but not limited to Capacity Planning, Back and Recovery Strategy, Database Maintenance, SQL Performance and Tuning and Network Troubleshooting.

Confidential

MIS Data Management Manager

Responsibilities:

• Managing a team of SQL Server programmers to convert SAS and Excel programs to Microsoft SQL Server for Casino Direct Marketing Statistical Analysis programs and reporting. This improved the delivery of their reports to Casino Management that helped make strategic marketing decisions for future marketing campaigns.
• MRI has several casino clients in the Las Vegas, Nevada and New Jersey areas that they provide Direct Marketing Redemption analysis monthly reports as well as monthly and quarterly trend analysis for the casinos to do their strategic marketing planning.
• Responsibilities include writing SQL Server code to build Casino Data Warehouses that have a Business Intelligence Cognos front end.
• Design, code, and implement T-SQL code and design and implement Cognos web based reports for various casino properties

Confidential

Senior IT Manager of Application Development and Data Warehousing

Responsibilities:

• Managed all Argosy Applications and implemented their first Teradata Data Warehouse.
• Implemented CRM (Customer Relationship Management) on the Teradata Data Warehouse and supported the Marketing Organizations using CRM to do trend analysis, marketing campaigns, segmentation, coupon redemption, and profitability.
• Implemented a BI/Cognos front end for the marketing clients to access cubes and do IWR reporting. Casino Operations, Employee, Financial data was also implemented on the Teradata Data Warehouse and used by the BI/Cognos front end.
• Developed the HRIS and Payroll systems using Ultimate Sofware, Ultipro, Kronos, Travis Cobra, TimeKeeper, Smartstaff and Photo Id Badging system.
• Responsible for Micros, the food and beverage system at all casinos. Plans were underway to pull information in to the Teradata Data Warehouse for player ps.
• Responsible for operational systems such as CDS and IGT, and had several applications that pulled information from those systems and created some proprietary systems using MS SQL Server. These systems supported the Casino cages, Finance and Marketing.