Patrick Brewer Email & Phone Number

Springfield, IL, US

West Sacramento, CA, US

• Analyzed current data environment and began working with invested parties to create a Data Governance Policy.
• Architected multiple solutions that focused on improving the data maturity model by bringing Excel spreadsheets into a data warehouse and moving the reporting process off Excel and into Tableau.
• Performed in-depth analysis of the current Carinata Proof of Sustainability process including the Green House Gas models. Then modeled a new database and architected a new process away from Excel and into a OLTP.
• Implemented a data warehouse model that imports data into a staging area and moves through the model to a reporting area, verifying and cleansing data along with populating fact and dimension tables.
• Performed a gap analysis on data modeling tools, and presented findings to the Architectural Review Board, and purchased suggested solution.
• Collaborated and created a team that crosses business entities to establish better communication and to implement best practices for data across the enterprise.

• Architected Jefferson Health Plans Azure Environment utilizing Microsoft’s Azure Landing Zone Architecture as a guide.
• Implemented Azure architectural design in Azure Environment, creating Managed Groups hierarchy, Subscriptions, Resource Groups, and assisting in the implementation of the platform managed group resources.
• Responsible for implementing naming conventions, Tagging policies, Azure Policies, Azure Alerts, Cost Alerts, Service Health Alerts, and Azure Advisory’s.
• Created and Chair of the Architectural Review Board, establishing guiding principles, developing standards documents, hosting weekly meetings, reviewing designs, and building relationships between vested parties.
• Perform a GAP analysis between Azure Synapse and Snowflake, performing a GAP analysis and executing a POC that compared on-prem Microsoft SQL Server, Azure SQL Database, Azure Synapse, and Snowflake.
• Responsible for the research, analysis, and architectural designs of multiple solutions for on-prem and cloud.

Bloomington, IL, US

• Research, architected, and performed POC for a solution that utilizes Azure Data Factory pipelines to integrate the Azure App Insights data into Azure SQL Database, along with additional on-prem data. The data is then.
• Architect, engineer and implemented a solution that utilizes Dell Boomi integration processes encapsulated in API’s that enable external clients to interact with internal databases, transferring call data to the Cisco.
• Architect, engineer, and implemented solution that interacts with a vendor’s API’s that performs multiple calls to integrate data to and from the vendor. The solution utilizes Dell Boomi for integrations, SQL Server.
• Architect and engineer multiple integrated (ETL) solutions in Dell Boomi, SQL Server (2012 – 2019), and DB2 that provide interactions between externally hosted solutions, internal cloud solutions and on-prem solutions.
• Simultaneously managing up to 14 projects, architectural designs, data models, and engineering solutions that utilize a variety of technology, such as: Azure SQL Data Warehouse, Azure SQL Server, Azure Log Analytics.
• Performed POC and architected solution to utilize Azure Data Factory to pull data from OData objects to be stored in Azure Data Lake as raw data, then merged with on-prem data in Azure SQL Data Warehouse, utilizing.

Bloomington, IL, US

• Architect, design and implement transaction processing, data mart, and data warehouse database schemas.
• Conduct design reviews with team members to ensure product quality, mentoring where applicable.
• SQL Server Upgrades, including databases, SSIS, and SSRS.
• Archive 60+ million accounts with 287 billion records and over 7 TB from IBM DB2 to SQL Server, creating a dynamic solution utilizing SQL Server, SSIS, C# Classes, and MVC Web Application.
• Worked closely with clients, executives, and users to provide complete and accurate solutions.
• Utilized advanced features of SQL Server to provide best design which includes: In-Memory Tables, Clustered Columnstore indexes, Table Partitioning, and Native Compiled Stored Procedures.

Amherst, New York, US

• Designed and developed tools in Visual Studio C# and Oracle to assist the administrators in proactively solving problems with the NuGenesis SDMS (Scientific Data Management System) application.
• Validated NuGenesis SDMS applications against scientific instruments residing in laboratories.
• Played a major role in performing the Periodic Review of the NuGenesis SDMS system, which includes validating user and group access, support documentation, system design and architecture, and Standard Operating.
• Assisted in training users in a classroom setting on the NuGenesis SDMS application.
• Completed first phase of Six Sigma business management strategy training.
• Trained in many aspects of the pharmaceutical environment and FDA rules and procedures.

Plymouth, MN, US

• Proven as the “Go-To-Guy” when in a crunch, and a reliable, accurate, efficient system needs developed yesterday.
• Served in multiple roles, including Senior Systems Analyst, Project Manager, Programmer, and DBA on many projects and tasks over the last 4.5 years utilizing SQL Server 2000, Visual Basic 6.0,.Net, and Crystal Reports.
• DBA tasks completed over the last 4.5 years: Data Modeling, Backups/ Restoration of multiple databases, replication management, SQL Job development and administration, data integrity checks, index de-fragmentation.
• Sole designer, developer, and implementer of CDR processing system, which processes over 29 million records per month with a total of 69 GB of data per month utilizing 11 different carrier layouts. The system utilizes.
• Lead Software Engineer on an invoicing application developed using SQL Server 2000 and Visual Basic 6.0 that enables accountants to invoice customers and then integrate the invoices with Great Plains accounting software.
• Lead Systems Analyst/ Programmer on the re-design and development of our CDR processing, which utilizes automated file transfer from multiple types of sources, such as FTP sites, emails, and servers on our LAN, and.

Springfield, IL, US

• Assisted in the design, development, and implementation of an N-Tier telecommunications application utilizing Visual Basic 6.0, SQL Server 7.0, dynamic DTS packages, and MTS.
• Responsible for the development of an application that processes ASCII files into SQL server, and then performs comparisons, calculations, and concatenating strings on upwards of 1,000,000 records per day.
• Served as Project Manager for a Document Management/Document Imaging System integrated into the Teachers Certificate Information System (TCIS) for two years at the Illinois State Board of Education.
• Designed, developed, implemented and supported the Document Management system utilizing Visual Basic, Microsoft SQL Server, and Diamond Head Software custom controls for Document Imaging.
• Completed an in-depth analysis identifying an agency wide Document Management/Document Imaging system that would be easily integrated into any of the agency’s applications. Design specifications included: Database.
• Assisted in updating the TCIS system including: adding True Grids, TList Pro Controls, Stored Procedures, and SQL Server Table modification, creation, and conversion.

Deerfield Beach, Florida, US

• Employed with Decision Consultants Inc. from February 1996 – July 1996 on a “Contract for Hire” position to JM Family Enterprises, Inc.
• Responsible for the support, maintenance, and custom application development of a 1000 + user Document Management/Document Imaging system powered by Identitech’s FYI Document Management software.
• Performed maintenance and support to four remote geographic locations traveling to various sites to complete mandatory maintenance and disaster recovery testing.
• Identified, implemented, and tested "Disaster Recovery" plans, which could be completed within a 12-hour window; the plan included the relocation of 12 jukeboxes’ and up to 22 servers and scanning stations.
• Designed, developed, implemented and supported an application that would monitor key systems, alerting technicians of any problems that may occur, notifying personnel via email and by pager of the exact system and error.
• Assisted in the upgrade of the existing Document Management/Document Imaging system, requiring upgrade of vendor software, 7 Object Servers, SQL Server from version 4.21 to 6.5, and re-development of custom.

US

• Hired by JM Family Enterprises
• Responsible for the support, maintenance, and custom application development of a 1000 + user Document Management/Document Imaging system powered by Identitech’s FYI Document Management software.
• Performed maintenance and support to four remote geographic locations traveling to various sites to complete mandatory maintenance and disaster recovery testing.

• Served as the Project Manager in a full life cycle application, which manages the operations for the Security Department.
• Designed, developed, implemented and supported multiple MS-Access databases for department operations.
• Converted old database systems from dBase III and dBase IV into MS-Access databases and Visual Basic applications.
• Developed several technical documents, user manuals and performed training sessions for users on new systems.
• Researched applications for departments, providing documentation on each product and comparisons of key features.
• Extracted, verified and imported medical data from the current medical system, Meditech, into the new SMS system, utilizing Allegra tools and the Magic language.

• Installed and supported Novell Network servers and workstations, along with office applications.
• Assisted in the installation of imaging workstations, object servers, and jukeboxes for an agency wide Document
• Management/Document Imaging/Workflow solution utilizing I. Levy and Associates Navigator 2000 system.
• Managed and maintained a custom application that maintained the full life history of low level radioactive waste, and calculated the radioactivity of each isotope.
• Converted the low level radioactive waste application from a dBase IV system to a Microsoft Access system.

Bachelor Of Arts (B.A.), Computer Science And Information Systems

Education record