Brian Powers Email & Phone Number

Fort Wayne, IN, US

London, England, GB

• Reduce inventory levels through ERP application engineering and development. Support supply chain functions as a lead analyst.
• Write complex SQL queries to deliver data insights to senior management.
• Create, enhance, and maintain enterprise data warehouse applications. Gather, prioritize, estimate, and deliver high quality code in short iterations. Create ETLs, govern metric usage, set project timelines, deliver.
• Develop PowerBI reports and train end users to take advantage of a self service data mart in order to meet operational data needs.
• Architected and implemented manufacturing software solutions software integrations using Oracle Apex, Epicor, and Inductive Automation Ignition leading to modern factory floor solutions.
• Implemented operational service desks leading to enhanced clarity of work in process and improvements in response times and closure.

Fort Wayne, Indiana, US

• Served as principal dba guiding full time DBA and a team of outsourced software engineers.
• Solution architected custom CRM software using c#.net REST, SQL, and Blazor WASM to integrate with in-house ERP.
• Created BI Data Mart on Microsoft Azure data platform. Azure Synapse, Azure blob storage, Azure Active Directory, Azure SQL, Azure Event topics, Azure Devops, and Power BI
• Developed and maintained ETL code for integration of discrete applications using python and SSIS
• Managed Hybrid On-prem and cloud-based Active directory infrastructure.
• Implemented digitally integrated cameras and controls for sensitive physical security environments.

Fort Wayne, IN, US

• Served on core ERP database team developing custom code to automate workflows.
• Developed multi-threaded high volume ETL process using Python for ETL integrations to Postgres SQL.
• Integrated 4D server platform with enterprise monitoring tools.
• Extended development environment to integrate with Gitlab and wrote code quality tools.
• Supported C# apps.
• Served as primary developer for product advertising workflow tool.

Fort Wayne, IN, US

• Coded Python data notebooks to assist in data profiling and data wrangling.
• Developed machine Learning models to help identify key brand sentiments using Python
• Developed BI/Data Warehousing teams supporting regional distribution centers.
• Integrated vendor content management system.
• Functional expert database source controls and release processes.
• Performed CRM platform data migration.

Fort Wayne, Indiana, US

• Analyzed ERP system requirements and translated requests into requirements documentation.
• Maintained Production MSSQL servers for multi-site 700+ user organization
• Developed Manufacturing and quality modifications for large-scale custom ERP implementation. Microsoft AX
• Developed data warehousing applications within an MSSQL infrastructure including SSIS and SSRS which was used to reduce manufacturing defects and reduce labor costs.
• Maintained and extended mission-critical in-house ASP.net manufacturing shop floor data collection system.
• Maintained and extended PHP, CSS, JQUERY, HTML5 based corporate intranet.

Farmington, CT, US

• Manager back-end database migration from Sybase ASE to MSSQL 2008 for several critical applications.
• Provided database security configuration per corporate standards and industry best practices.
• Administered MSSQL database server.
• Enhanced and maintained Quality Product Tracking Application, Powerbuilder, and C#.net
• Documented business processes using Microsoft Visio.
• Created automatic version control front ends for key applications which reduced deployment costs and improved version consistency.

• Managed project and wrote code for multi-site preventative maintenance system in order to automate production process record keeping.
• Developed maintenance software using Microsoft Access and Microsoft SQL server.
• Migrated existing data into new data structures.
• Developed reporting modules.

Fort Wayne, IN, US

• Developed web applications using ASP.net, VB.net, and Microsoft SQL Server.
• Developed engineering library program using Visual Basic & Access.
• Maintained internet and intranet site. (HTML – CSS – Dreamweaver - SharePoint).
• Reduced server / pc administration by over 50% using scripts, WSUS, and network administration practices.
• Configured and deployed switching equipment, servers, VOIP phones, and thin clients.
• Acted as a network administrator for 100+ PCs across 3 sites in an active directory environment.

• Maintained and installed Konica business copiers in the field.
• Troubleshot mechanical, electrical, and software issues with enterprise level copiers while maintaining a parts cost budget.

Master Of Business Administration - Mba, Organizational Leadership

B.S. Business Information Systems, Computer Science

A.A.S. Business Administration, Business