Nothing real new here for the work, but migrating from an excellent company to a great company along with a number of good friends.

Works within the Hard Rock IT department. Responsible for, but not limited to, the support , development, and maintenance of the Hard Rock Business Intelligence (BI) and Data Warehouse environments. Assists in the training, communication, and documentation of applications in a centralized corporate IT environment.

Strong SQL Server hands-on knowledge from SQL construct to optimizing existing SQL and stored procedures. Excellent SQL Server database administration and work with SSRS and SSIS.

• Worked with SQL 2014 in an Amazon Cloud environment. • Put together some initial planning for SQL 2017 migration.• Assisted with the migration of databases from the development, QA, staging and production environments.• Ensured nightly backups were performed in all environments for over 30 databases in each environment.• Reviewed, modified and created maintenance tasks for the databases. Maintained and created stored procedures that were the basis for the front end for the clients and support staff. Modifications included readjustment on joins, index columns ordering and included columns and ensuring that the correct database was being used.• Exported data from clinical system to be used in a client’s data mart.

· Assisted with the migration of SSIS packages from SQL Server 2008 R2 to SQL Server 2012.· Reviewed and modified views that were the basis for reports for implementation in current and upgraded system(s). Modification included readjustment on joins, index columns orders and included columns and ensuring that the correct database was being used.· Reviewed and modified stored procedures that were the basis for the front end for the clients. Modification included readjustment on joins, index columns orders and included columns and ensuring that the correct database was being used.· Suggested the use of a clustered, primary key on a large table that had non

• Managed and maintained SQL Server installations for development, QA, staging and production environments. In total, there were over two dozen servers and nearly 800 user databases.• Optimized over 2,500 stored procedures and functions by studying their execution plans.• Migrated a Team Foundation Server (TFS 2005) running on SQL 2005 to TFS 2015 running on SQL 2014. The project was on time and under budget.• Led a technical team that loaded 600 plus sources into the databases for background and related searches. • Migrated database servers from SQL Server 2000 to SQL Server 2005, then from SQL Server 2005 to 2008, then migrated some to 2014. In so doing, migrated from Crystal Reports to SSRS 2005 and to SSRS 2008. • Responsible for set up of SQL servers, performance tuning and monitoring, backup and restore policies, writing and implementing database access policies and standards for SQL scripts within a change request.• Implemented encryption of data at rest on all user databases.• Worked with infrastructure team to implement third-party corporate sponsored backup hardware and software.• Worked on mirroring databases within our staging environment, ended up using EMC’s Replication.• Used 3rd party software to maintain efficiencies and performance in databases as well as sending and receiving data from secure FTP sites using SSIS packages. Vendors were Solarwinds (Confio), RedGate, and SQL Sentry.

• Managed and maintained a production and three development environments for both the public (Boykin Lodging Company) and private (Boykin Management Company) sectors of the company.• Led the technical side of the PeopleSoft implementation, including system and functional security. This include set up of SQL Server 2000, performance tuning and monitoring, backup and restore policies and a number of viable DTS tasks that ensure performance and efficiencies.• Developed teamwork with existing network, help desk, and financial personnel to accomplish the aggressive implementation schedule.• Assisted and led outside consultants in database installation, security procedures, and task prioritization.• Monitored system for efficient use of resources, ensured 100 percent uptime, set baseline measures for client response.• Implemented and maintained policies for Sarbanes-Oxley compliance, including security, and change management. Assisted internal and external auditors to assure that policies and procedures were met.

• Managed staff of four database administrators that monitored and maintained over 60 databases. Responsible for assigning of database staff to projects, and program development for the Information Services staff. Accountable for planning, development, and approval of $3 million for new software and licensing. Technical liaison to physicians, nurses, and management. Developed and standardized the installations, maintenance, and backup procedures for various database engines (SQL Server, Oracle, and Sybase).• Assured HIPAA compliance in existing clinical applications for security and tracking.• Installed and maintained a web-based database system that allowed for the care and results tracking of patients in their HIV program.• Planned and maintained a Clinical Data Reporting System using Sybase. Implemented team building to achieve physician and nursing ideas that address clinical, financial, and production issues. • Led project team that installed a portal intranet single sign-on application.• Developed and implemented pilot project that conceptualized an intranet for corporate departmental website structure and policies using Microsoft SharePoint Portal Server 2003.• Coordinated and implemented digital echo cardiovascular system that merged images from three diverse systems allowing viewing, measurements, and diagnosis on one system.• Assisted with selection of intranet web-based pharmaceutical product that provided current and accurate drug information to healthcare providers.• Directed the migration and implementation of an archival database on a Microsoft SQL Server 2000 platform. This system allows data to be viewed through web-based applications.• Technical lead in the planning and implementation of PeopleSoft financial package for General Ledger, Material Management and Inventory Control. Assisted in the implementation of financial and human resource modules. The changes led to shortening the monthly close by 4 days.

Director, Capital Administration and Decision Support, Cleveland, OhioReviewed and analyzed plans and capital projects for the automotive sector. Developed support coverage for the computers and software. Trained and assisted personal computer users.• Planned, implemented and maintained TRW Automotive Local Area Network, which saved the sector $2.5 million annually of mainframe costs for monthly financial reporting.• Developed, implemented, and maintained TRW Automotive capital reporting procedures and a computer based Capital Reporting system for the sector’s $2 billion capital program.• Wrote TRW Automotive Capital Investment Manual to assist operations in overall capital decision process and that standardized the process of project presentation over $1 million.Manager of Planning, Electronic Assemblies Division, Chicago, IllinoisPut together annual business operating plan and 5-year strategic plan. Analyzed and reviewed manual and computer systems in operations located in Chicago, Marshall, New York City, Taiwan, and Haiti.• Gathered, analyzed and presented data to compare various countries for a low cost manufacturing and electronic assembly plants leading to plants and expansions in Taiwan and Mexico saving the division over $1 million annually and allowed for better utilization of existing facilities. This was done using SSPS analytical modeling software.• Wrote specifications and coordinated activities on various large capital projects, including the selection of computer-aided design and engineering systems.• Interviewed, hired, and assisted a consultant for a part numbering system that led to a $2.5 million savings in inventory.