Frank Andrew Brenner

Information Technology Professional

Accomplished and respected Information Technology Professional; enabling businesses to get the most from their ERP systems through Data Analytics, Report Writing, and Application Development. Creative Problem Solver with a focus on blending various elements together to create effective and optimal solutions; meeting and exceeding design requirements. Proven reputation for outstanding support to both technical and functional audiences. Exceptional analytical skills and the ability to intuitively understand the scope of any project, diagnose the issues, and devise viable and creative solutions. Consistently recognized for outstanding communication and interpersonal skills; team player.

Application Skill Sets

SQL Server Management Studio / SQL Server Integration Studio / Power BI developer, Crystal Reports XI, Data Analytics & Reporting – Infor Application Studio Report Application Suite - IQS, Quality Performance Management – Lawson & Epicor, ERP Solutions – MAS90, Sage’s Accounting – Progress & Oracle, Database & Application Server – Sterling, EDI and Data Translation

Software Testing: Verification of acceptance criterial Happy Path White Box Negative Test Regression / Smoke Testing Performance Testing Integration Testing

Toad, SSMS, SSIS: Stored Procedures Dynamic SQL DB Functions Table & Permission Scripting DB Functions Subqueries Various ETL Solution (Execute SQL, Data Flow, Email, & Various File Destinations))

Power BI /Crystal/SSRS: 7 Years Experience with Crystal 8.5 & XI In-Depth Usage of SQL Nested Grouping Functionality Sub-Reporting Program Using VB Basic Use of Global & Local Variables & Arrays Conditional Formatting Reverse Engineering Reports to Modify Existing Reports Creating Run-Time Applications for User Community Drill Down & Drill Through DAX Programming

OLAP/Infor App Studio: 2 Years Experience with Infor BI Application Studio Adept Understanding Multi-Dimentional Data Sources & Native MDX Syntax Utilizatize Various Reporting Objects/Features; Hyper-blocks, Combo boxes, Actions, Formulas, Variable Assignment & Referencing Apply Supression/Formatting In Reports To Achieve Aesthic Results Incorporate Attributes From Lawson Into Reporting Enviroment

Epicor/Lawson ERP: Familiar with Various Form & Functionality Create Business Intelligence Drill Down Hyperlinks Utilize Data Dictionaries General Process Flow Customization/Personalization Database Triggers Modification of Routing/WIP Tags Financial, Manufacturing, Quality & Sourcing Reporting Data Imports & Migration Business Activity Manager Business Process Management Business Activity Query Dashboards Security/Menu Maintenance

Education

B.A., Management Information Systems, Wright State University, Dayton, OH 2001

Associates, Business, Sinclair Community College

Professional History

Caresource Vaco, Dayton OH 7/2018 – 9/2020

data analysis / developer

Supported various groups to modify/design/convert various SSRS reports. Reviewed and modified underlining TSQL code, altered and or added reporting parameters, created report actions/drillthrough, created dynamic headers and met various formating requirements. Modified stored procedures; removed/replaced unicode segments, modified tables relations, extensive use of various TSQL expressions meet business requirements. Utilized system and information schema’s to find/identify specific table columns and names. Modified existing SSIS projects; altered source SQL code, mapping & testing. Designed Power BI dashboard objects utilizing slicers, bookmarks, dynamic formating & DAX expressions. Created, modified and reviewed various test cases for SQA validation process.

Premier Health Partners Veronis, Dayton OH 10/2015 – 7/2018

data analysis / olap / developer

Verified HCA to Lawson, created reports & dashboards for finance, used parameters in concert with BPW table to affect delivery/suppression of designated posting account records, trouble shot issues with various builds of alias/cubes, applied dynamic filtering and formatting to result set, jumping/drilling between reports, defining element lists, MDX statement and Hierarchical. Created/Rewrote various Crystal reports; Income Statement analysis, Project budget and expenditures tracking, Corporate Allocations reports-written, Payroll Earning codes analysis, LBI tables reporting and modified/created new suite of reports from Lawson OLE DB. Modified report definitions thru native Lawson RW report writing tools; row file, format file, level groups and accounting groups. Assisted in maintaining/converting/writing LBI report between 2008 PLSQL & 2012 PLSQL environments as well as utilizing the RW On-Demand methodology for future applications.

Developed utilities to test corporate allocation prior to execute.

Gem City Engineering & Manufacturing, Dayton OH 6/2012 – 10/2015

erp manager / it analysis

Specialized in the utilization of Epicor, Progress Database, and Crystal Reports. Excelled as Database Administrator; developed Epicor email alerts and triggers, wrote scripts and procedures in 4GL, customized system forms (Job Traveler and Purchase Order), created various Crystal reports (financial, supply, manufacturing, and quality), and provided technical as well as functional support. Developed VBA utilities to enhance Excel’s processing of ERP data and assisted in the development of VBA. Managed net projects within Epicor. Performed data analysis and created dashboards. Customized forms incorporating user-defined fields and assisted Systems Administrator in work load.

Increased efficiency and saved the company time by creating a 4GL HTML script that eliminated unnecessary data entry methods.

Successfully identified triggers and processes in the 4GL database that inhibited the consistent and automatic delivery of Sales Order Acknowledgements; corrected the issues resulting in reliable HTML documents being sent automatically.

Streamlined Sales Order Acknowledgement process yet again by modifying existing script to create a Paid Acknowledgement HTML document.

Premier Health Partners Indecon, Dayton OH – Indianapolis IN 4/2011– 6/2012

it analysis / report writer

Responsible for analyzing existing reports and changing them to fit functional designs. Optimized performance for various financial reports via stored procedures and assisted other consultants with Smart Notification development. Developed database views via Oracle Developer. Provided technical documentation on closure of projects. Validated report results by using various Lawson ‘Forms’. Added hyperlinks to activate Lawson ‘Drill Around’ feature. Consistently and expertly used Lawson, Oracle Developer, and Crystal Reports.

Facilitated the successful resolution of an intimidating report writing challenge by communicating with the Project Lead, actively listening to their concerns, understanding the vision desired, and promptly producing a working prototype still in use today.

Ensured smooth transition during ERP implementation; recognized for being a personable and talented problem solver, quickly became the “go-to” person for the Finance team. Utilized in-depth knowledge of report writing techniques and intuitive communication skills to fulfill department needs.

Excelled at creating and producing complex Crystal reports that use sub reports, commands, formulas, groups, specified orders, and Oracle stored procedures containing packages and global temporary tables.

IMDS, Vandalia OH 6/2007 – 4/2011

it analysis / report writer

Applied extensive knowledge of Epicor ERP, Progress Database, Corvu Business, IQS, and Crystal Reports for IT analytics and report writing. Created reports for inventory, purchasing, manufacturing, quality, and finance. Designed, coded, and implemented corporate dashboards for tracking sales metrics. Utilized Access database to optimize performance of labor reports. Redesigned existing report to accommodate change of end-user requirements. Responsible for lot tracking utilities of raw materials and customer supplied inventory components. Customized inventory tags, job routers, packing slips, and various user screens. Supported Progress database. Designed and modified Progress database triggers and resolved technical and functional support issues. Imported Salesforce CRM data into Access database and Quality Specifications into IQS. Developed Corvu’s web portal for customer’s order analytics.

Consistently requested by System Improvement & IT Director to provide assistance in corporate and highly strategic projects because of recognized ability to investigate meticulously and thoroughly; trusted to research, test, and pull together information needed for strategic projects.

additional work history

M21, Dayton, OH (2006) ACG, Dayton, OH (2005) NCR / Permond, Dayton, OH (2000-2003) Harlow Marketing., Dayton, OH (1997-2000)

Recommendations

I would like to recommend Frank Andrew Brenner based on his excellent professional and personal skill sets. I was fortunate enough to have the opportunity to work with, and ultimately hire, Andrew. Andrew was initially hired as a consultant but became such a key part of our team that I hired him as a permanent employee, a move that paid huge dividends for our ERP Project, our Implementation Team, and the Finance Division as a whole

Andrew not only brought strong technical skills and an almost insatiable appetite to learn to the position but he also brought a set of people and communication skills that was a pleasant surprise.

-Calvin Oliver, Director of Finance Information Management, Premier Health, adhnya@r.postjobfree.com

Andrew always took the time to make sure he understood the functional needs, so he could develop the most efficient & accurate reports. In addition, he took the time to explain the technical aspects in ways that I would understand how the solution was going to work………

Andrew is a great pleasure to work with and would be a great asset for your company. I highly recommend him.

Debbie Riesbeck, Senior Business Analyst – ERP Systems, adhnya@r.postjobfree.com

Of all the individuals I have worked with, Mr. Brenner is ranked overall in my top one percent in both erudition and relentless focus…….

Mr. Brenner is and will be successful in all he does! By allowing him to work for you, you will promulgate the fact that he will be part of your success and that he will epitomize the values of your company through great execution in his objective and department goals. I am a strong advocate for Mr. Brenner and feel confident he would be an asset to your organization as he was to mine.

Ben Miller, Systems Improvement and IT Director, IMDS

Recommendations

I am writing today to recommend Andy Brenner for employment. I hired Andy as a Data Analyst in 2007 and was immediately impressed with his willingness to learn and his attitude towards work. He has wonderful interpersonal skills that allow him to communicate with all levels of personnel, from developer to end-user. He has always been flexible and eager to take on new challenges………I’m certain that Andy would be a great asset to any company that hired him.

Chris Mulford, IMDS, adhnya@r.postjobfree.com

Contact this candidate