Terry Patrick, Ms Email & Phone Number

Chicago

Daily Maintenance of multiple databases via multiple serversDaily Maintenance and developments of various reports via Report Server, Excel, Access, Crystal Reports and other toolsCommunication with management on necessary upgradesDesign of adhoc databases to meet daily demandsDaily Maintenance and Upgrade of Microsoft Dynamics GPResponsible for Restore and Recovery of all databasesDaily Maintenance Backup and Recovery of SharePoint DatabasesTroubleshoot performance problems, fine-tuning of databases and index AnalysisDeveloped and tested storage strategies and disaster-recovery planResponsible for the security administration of all financial data in FinanceExpertise in T-SQL interpretation and writing stored procedures, triggers and functionsExpert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operationsCompleted SQL Server 2012 migration from SQL Server 2008 / 2005Handling Memory configurations for SQL Server 2014 and SQL Server 2012 on Windows 2012 and SQL Server 2008 on Windows Server 2008R2Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application supportCreated Linked Servers between SQL Server 2008 R2 and SQL Server 2014Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.Expertise in SQL Server Reporting ServicesWorked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costsDesigned and created databases, tables, views, store procedures and triggersUtilized DBCC Commands for Database PerformancesCreate and Monitor the execution of jobs and tasksMaintain SQL Service SecurityPerformed Best Practices in High Availability: Mirroring, Log Shipping and other forms of Replication

ENTREPRENEUR/CONSULTANT/ DBA Contracted with "Merisant” on documentation and update of previously developed databasesAnalyzed databases for clients and made necessary recommendationsCorroborated with clients on improvements necessary to maximize economy of scalesDesigned and implemented databases utilizing forms and macrosDeveloped Website for client, “New Promise land Church” utilizing Dreamweaver and Microsoft Front PageAssociated website with database tables utilizing “Access” and “MSQL”Development and troubleshooting of client’s database: “Children’s Memorial Hospital” utilizing “Access” and “Sql Server”Familiar with best practices and standard DBA tasksWorked with client as an outside consultant on Web applications

Warrenville

• Developed complex relational and adhoc Databases in Access and SQL for Billing Automation• Utilized different functions of VBA to enhance functionalities of automation processes• Utilized Excel as a frontend to multiple databases for clients preference• Utilized SQL Server to develop Adhoc reports and identify variances on sensitive data for quality assurance• Worked with end users to identify reporting needs• Developed a relational database for utilizing VBA and Mega formulas to automate the comparison of various tools• Developed documentation for the end-users and management on utilization of the databases• Developed adhoc queries and utilization of advance Excel for comparison of various data• Developed an “Action Database” utilized different functions for the purpose of prepping data before the Amgen Database• Worked with users on previously developed spreadsheets that required modification of formulas and tables to meet present demands

Communicated with different levels of management to resolve return issues with customer service on the disposition of customer’s returnsResponsible for the maintenance and daily upkeep of “non-salable” inventoryUtilized “radio-frequency” and “PC” monitor to track inventory movementsUtilized a process re-engineering to develop structure and discipline Returns Processing Tracked employees performance through Kronos, and WorkInfoInsure employees are meeting OSHA and other regulatory compliance. Communicated with “Customer Service Personnel on customer needs Utilizations of spreadsheets, Access Database, Data Warehouse, and AS400 to meet demands Reengineering of daily workflow resulted in maximization of the economies of scale. Developed a strong self-managed teamDeveloped spreadsheets utilizing pivot tables and crosstabs for product summarizationUtilized “Vlookup” and “Hlookup” tables for exact matching and lookup of items in a spread sheet

Designed and implemented databases net approximately 7,280 labor hoursDeveloped complete documentation to assist users/programmers in “SOP” of databasesCollaborated with “ISD” on finalization and implementation of databasesDesigned support documentation for four of the previously designed databasesHeld positions of increased responsibility over a 8-year tenure that included DATABASE DESIGN, ANALYSIS AND IMPLEMENTATAIONWorked collaboratively with a team of contractors, engineers, and all levels of management throughout all phases of large scale project planning, ensuring the on-time and cost-effective rollout of high budget projectsEngineered new projects, upgraded, restructured, and maintained existing systems through technical applications that included:— conceptual design and testing

Masters Of Science, Management Information Systems

Master, Dba

Ba, Management