Terry Patrick
Elwood
Summary
Data analyst and database administrator specializing in data integrity and database performance optimization. Proven track record in developing and implementing reporting systems that automate processes. Collaborated effectively with IT teams to enhance operational efficiency and drive data-driven decision-making.
Overview
26
26
years of professional experience
Work History
Database Administrator
Academy of General Dentistry
Chicago
02.2013 - Current
- Administered database systems to ensure data integrity and security.
- Managed user access and permissions for database applications.
- Optimized database performance through regular maintenance and monitoring.
- Developed backup and recovery strategies for critical data assets.
- Collaborated with IT teams to implement software updates and patches.
- Provided technical support for database-related issues to staff members.
- Documented database procedures and protocols for operational consistency.
- Trained users on effective database utilization and best practices.
- Migrated existing databases from one platform to another with minimal downtime.
- Configured user accounts, privileges, roles, profiles. in the database server.
- Resolved customer queries related to database issues promptly and accurately.
- Monitored performance of queries and tuned them using Explain Plan tool.
- Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
- Coordinated with other teams such as network administrators and system admins for resolving complex issues.
- Provided support for complex issues related to software tools, applications and databases.
- Analyzed and developed technical and functional specifications for databases.
- Developed data models and database designs to plan projects.
- Performed daily backups of the databases using RMAN utility.
- Created and monitored performance metrics to ensure databases operated at optimal capacity.
- Performed regular health checks on all databases to ensure optimal performance levels are maintained.
- Conducted training sessions for junior DBAs regarding best practices related to database administration.
- Analyzed system logs regularly to identify any potential problems or suspicious activities.
- Created new tablespaces for applications to store their data in the database.
- Supported end users in selecting, procuring and using software applications.
- Deployed patches and upgrades on a timely basis to keep up-to-date with latest software releases.
- Assisted in disaster recovery planning by testing various backup strategies and scenarios.
- Developed and implemented database security measures to safeguard sensitive data.
- Tested application code changes before deploying them into production environment.
- Aligned systems with business needs to enhance scalability of database structures and recommend improvements.
- Supported planning for software development and purchases and coordinated implementation.
- Ensured that all stored procedures are optimized for better performance of the system.
- Led database migration and upgrade projects to ensure smooth transitions.
- Monitored database performance and implemented changes to improve response times.
- Evaluated and recommended new database technologies and tools to enhance productivity.
- Coordinated with development teams to optimize database queries and indexes.
- Oversaw the installation and maintenance of database software and updates.
- Designed and implemented database systems to meet organizational needs.
- Optimized storage and archiving practices to manage database size and performance.
- Conducted regular database capacity planning to accommodate business growth.
- Prepared and maintained detailed documentation for database architectures and procedures.
- Analyzed and resolved complex database and system issues promptly.
- Analyzed workflows and established priorities for daily operations.
- Devised reports and visualizations to present requested data in a sleek format.
- Assessed data processing proposals and requirements to determine project feasibility.
- Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
- Maintained knowledge of advances in information technology systems and applications.
- Detected and resolved data quality issues and discrepancies for integrity and quality control.
- Spearheaded development and implementation of business intelligence architecture to deliver end-to-end BI solutions.
- Wrote scripts and processes for data integration and bug fixes.
Data Analyst
Collabera
12.2011 - 01.2013
- Developed complex relational and ad hoc Databases in Access and SQL for Billing Automation
- Utilized different functions of VBA to enhance the functionalities of automation processes
- Utilized Excel as a frontend to multiple databases for clients' preference
- Utilized SQL Server to develop Ad hoc 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 ad hoc queries and utilization of advanced 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
- Collaborated with AT&T and Amgen teams on database projects.
- Analyzed large datasets to identify trends and insights for strategic decision-making.
Data Analyst / DBA
Taps Computer World
Country Club Hills
11.2008 - 06.2011
- Extracted, transformed and analyzed large amounts of data through (Excel/SQL/Access); identified potential quality issues using (Excel PivotTable, PivotChart reports, VLookup)
- Created and Analyzed Ad Hoc and other reports in Access and Excel
- Utilized Visual Basic in 'Access' to provide special functionalities and commands in 'Forms'
- Pulled, Retrieved and collected data using SQL queries
- Contracted to work with documentation and updated previously developed databases
- Analyzed databases for clients and made necessary recommendations
- Designed and implemented databases utilizing forms and macros
- Associated website with database tables utilizing 'Access' and 'MSQL'
- Development and troubleshooting of client’s database
- Designed support documentation for previously designed databases
- Utilized drill down in SQL and Access in order to retrieve data from multiple data sources through 'SSRS' via Visual Studio
- Calculated large amounts for reports and provided excellent customer service
- Country Club Hills, IL
Sr. Data Analyst
SetFocus, LLC
Parsippany
09.2008 - 11.2008
- Designed database maintenance plans to set up core maintenance tasks to make sure that the database performs well, is regularly backed up in case of system failure and is checked for inconsistencies.
- Utilized Visual Basic in 'Access' to provide special functionalities and commands in 'Forms'
- Created numerous simple to complex queries involving self joins, correlated sub queries and XML techniques for diverse business requirements.
- Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies.
- Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using XML and SSIS.
- Implemented robust stored procedures, functions, and triggers to implement required functionalities.
- Developed a backup and recovery plan based on the data availability requirements of the library and on the potential impact of data loss on the business after considering and analyzing the different backup and recovery strategies.
- Used the SQL Server Profiler tool to monitor the performance of SQL Server – particularly to analyze the performance of the stored procedures.
- Analyzed different high availability solutions and implemented database mirroring and replication.
- Parsippany, NJ
Data Analyst / DBA
Amerisourcebergen
Romeoville
02.2007 - 05.2008
- Developed and implemented 'Access' databases to monitor daily activities and validate inventory levels
- Developed tables and joins to insure proper relationships and security of 'Access' and 'SQL' databases
- Utilization of spreadsheets and Access Database to meet demands
- Developed a strong self-managed team
- Developed spreadsheets utilizing pivot tables and crosstabs for product summarization
- Utilized 'Vlookup' and 'Hlookup' tables for exact matching and lookup of items in a spread sheet
- Utilization of functions to create complex formulas and cell referencing
- Developed complex workbooks with excel and access linked to maintain updated information for day to day activities
- Developed charts to assist in easy view of data
- Utilization of SQL commands to assist in macros and complex applications and forms
- Prepare reports and analyses of distribution processes, adverse trends, and make appropriate recommendations or conclusions
- Romeoville, IL
Data Analyst / DBA
Taps Computer World
Country Club Hills
02.2000 - 02.2007
- Contracted to work with documentation and update of previously developed databases
- Developed and implemented 'Access' databases to monitor daily activities and validate inventory levels
- Developed spreadsheets utilizing pivot tables and crosstabs for product summarization
- Utilizations of spreadsheets and Access Database to meet demands
- Associated website with database tables utilizing 'Access' and 'MSQL'
- Utilized 'Vlookup' and 'Hlookup' tables for exact matching and lookup of items in a spread sheet
- Analyzed databases for clients and made necessary recommendations
- Tuned and optimized queries by altering database design, analyzing different query options, and indexing strategies
- Country Club Hills, IL
Education
Master SQL Server -
Set Focus
09-2008
Masters of Science - Management Information Systems
Governors State University
University Park, ILBachelors of Arts - Management
Chicago State University
Chicago, ILSome College (No Degree) - Political Science
University of Illinois
Chicago, ILSome College (No Degree) - Business Administration And Management
Grand Canyon University
Phoenix, AZ03-2026
Skills
- Transact SQL
- XML
- PHP 5
- HTML
- SQL Server 2005 Reporting Services
- Microsoft Front Page
- Microsoft SQL Server 2000
- Microsoft SQL Server 2005
- Microsoft SQL Server 2008
- Data Encryption
- MySQL
- Access
- Windows 98
- Windows ME
- Windows NT
- Windows 2000
- Windows XP
- Windows Server 2003
- SQL Server Management Studio
- Microsoft Visio
- Microsoft Office
- Database Engine Tuning Advisor
- SQL Server Profiler
- Dreamweaver
- Visual Basic
- Business Intelligence
- Excellent Customer service
- Excellent Verbal and Written Communications skills
- MS Office
- Database management
- SQL development
- Performance tuning
- Process automation
- Technical documentation
- Systems integration
- Problem solving
- Team collaboration
- Quality assurance
- Cross-platform skills
- Continuous integration
- Microsoft powershell
- Systems administration
- Database troubleshooting
- Root-cause analysis
- Database analysis
- Microsoft NET framework
- Database development
- Writing queries
- Stored procedures
- Patch management
- Version control
- Implementing security measures
- Database design
- SQL proficiency
- Microsoft SQL
- Disaster recovery
- Database documentation
- Database administration
- Relational database management
- Schema management
- Cloud database services
Languages
French
Professional
Timeline
Database Administrator
Academy of General Dentistry
02.2013 - Current
Data Analyst
Collabera
12.2011 - 01.2013
Data Analyst / DBA
Taps Computer World
11.2008 - 06.2011
Sr. Data Analyst
SetFocus, LLC
09.2008 - 11.2008
Data Analyst / DBA
Amerisourcebergen
02.2007 - 05.2008
Data Analyst / DBA
Taps Computer World
02.2000 - 02.2007
Master SQL Server -
Set Focus
Masters of Science - Management Information Systems
Governors State University
Bachelors of Arts - Management
Chicago State University
Some College (No Degree) - Political Science
University of Illinois
Some College (No Degree) - Business Administration And Management
Grand Canyon University