Patrick Holmes Email & Phone Number

Atlanta, Georgia, United States

• Determine daily data operations priorities.• Ensured Data Ops team members adherence to SLA requirements.• Assist in developing team best practices.• Liaison for customers, professional services, and support requests• Managed requirements gathering, estimation, gaining customer approval, execution, testing and delivery of professional services requests.• Managed deployment of data integration and custom reports to the production environments.• Work with upper management and quality control processes• Identified and implemented process improvement opportunities.• Reviewed new processes being deployed to production for accuracy and necessary documentation.• Mentored team members. • Trained new Data Operations Analysts. • Provide education and training to business partners and their teams to encourage and enable improved data literacy.

Atlanta Metropolitan Area

• Troubleshoot Web Service Calls using Cast Iron WebSphere and Soap UI• Performed integration deployments to Production Environments using SQL Scripts, DTS Config Packages, and IBM’s Cast Iron WebSphere• Created new folder paths, directories, and updates existing folders based off the Integration’s Code and Architecture Document• Created and modify complex SQL queries to produce desired field calculations within client integrationsMade updates to Cast Iron Orchestrations to fix errors within integrations• Created SQL Agent Jobs for Data Extracts, AP and AR Exports, Sales Data Imports, and Vendor Imports• Analyzed our internal processes such as Production Deployments and Database Tuning to figure out how to optimize these processes• Modified SSIS Packages by updating or creating property values within dts config files• Migrated old legacy integrations into our current Cast Iron Platform by scoping out requirements and reviewing with the Development Team

Atlanta Metropolitan Area

• Triaged client requests based on urgency, priority, and complexity on an everyday basis.• Resolved severity 1 and 2 issues within 48 hours of receiving these requests.• Use Microsoft SQL Server to create custom SQL scripts to update or modify our client's databases. • Create complex queries run on our client’s database, to help identify and mitigate issues that are located on the front end of application.• Trained our clients on our applications ETL Tool, System Administrator functionalities, Portfolio Module, and Projects Module.• Mentored Client Service Team Members and help train new team members. • Assist other team members with open items.• Trained clients on Portfolio Module, and Projects Module application functionality, ETL Tool, and System Administrator functionalities.

Greater Atlanta Area

• Managed several internet based application development projects to support the activities of the Information Resource Management Office (IRMO) Bio-Terrorism Workgroup, the National Center for Infectious Diseases (NCID), Office of Health Communication (OHC), and the Division of Foodborne, Waterborne, and Environmental Diseases (DFWED). • Provided software engineering services for several database driven web applications using the following development environment: .Net, IIS, SQL Server, ASP.net and COM+, C#, Visual Basic, VBScript, JavaScript, HTML.

Greater Atlanta Area

• Managed a Web development team and external resources to simultaneously develop, implement, and maintain multiple websites for the tradeshow industry.• Coordinated all technical aspects of development on client projects.• Designed and developed the projects’ code and databases using ASP and COM+, VBScript, Client-side JavaScript, IIS and MTS, and SQL Server.• Integrated and implemented custom modules. • Resolved implementation problems.

Greater Atlanta Area

• Analyzed clients’ business and strategic goals for internet services. • Led a systems development team consisting of subject matter experts and developers to identify and analyze the system requirements for an enterprise-wide client/server system that integrated the client’s business functional systems with the client’s multiple plan administration systems. • Achieved goal of designing and developing a SQL Server database that could consolidate over 100 individual systems that were designed to handle complex and customized executive level benefits plans. • Designed and developed multiple front-end systems using Visual Basic.

Greater Atlanta Area

• Designed and developed client/server systems used for the administration of executive benefits plans and other Executive Benefits Division (EBD) business functions. • Administered multiple databases on different platforms. • Maintained hardware and applications used by EBD. Performed help desk function for all EBD employees.

Syracuse, New York Area

• Planned and organized logistical support for a Light Infantry Company. • Planned and organized training activities for an infantry platoon. • Led motivated, and directed personnel to achieve goals and objectives. • Coordinated the movement of personnel, equipment, and materials on multiple assignments.

Oswego, Ny

• Supervised team members and provided technical guidance to accomplish team duties.

Liverpool, Ny

• Provide first aid and medical triage duties for a combat field hospital. • Assisted in the erection and tear down of a mobile hospital.

Master Of Science - Ms, Computer Information Systems

Master Of Business Administration - Mba, Decision Sciences

Bachelor Of Arts - Ba, Economics