Business Intelligence Analyst

…Continued…

Mike A. Myers *********@*****.*** • 512-***-****

linkedin.com/in/mmyers41/ • Houston, TX 77494

Qualifications Summary

An accomplished IT Business Analyst and Cost Accountant with a comprehensive background in business intelligence, data/financial analytics, and system optimization across the manufacturing industry. Instrumental in leading small to medium IT projects, encompassing everything from report and database development to broader system implementations, tasks requiring advanced programming, such as .net, are coordinated with specialized programmers, ensuring a comprehensive skill set that covers both analysis and project management within manufacturing settings. Recognized for a distinctive expertise in finance and cost accounting, that enhanced business process automation, data integrity, GAAP, and user experience design. Proficient in SQL, Excel, dashboard creation, and custom reporting tools, with a thorough understanding of ERP systems, accounting principles, and software development life cycles. Collaborative efforts with cross-functional teams and key stakeholders are a hallmark, aimed at aligning solutions with business goals and boosting customer outcomes, underpinned by a strong passion for leveraging technology to drive business transformation and operational excellence. Areas of Expertise

• Business Intelligence Development

• SQL & Database Management

• ERP Implementation & Optimization

• Shopfloor/Warehouse Data Collection Systems

• Data Analysis & Visualization

• Dashboard & API Training

• Cost Accounting Tools

• Financial Reporting

• Cross-Functional Team Leadership

• Data Integrity & Reporting Quality

• Business Requirement Analysis

• Business Process Automation

Career Experience

Accounting Consultant, SolomonEdwards, Houston, TX Sep 2024 – Current On contract at Carriage Services on MS D365 Business Central implementation project.

● Conducting Unit Testing and UAT in Fixed Assets and Jobs module.

● Preparing training materials.

● Documenting errors in functionality and Azure Data Objects scripts. Senior IT Business Analyst, CDI Products, Houston, TX Dec 2014 – Jun 2024 Designed and delivered custom reports, driving significant improvements in business intelligence, which directly enhances decision- making capabilities. Conducted comprehensive ad hoc reports and financial analyses, highlighting key factors affecting gross margins, expenses, and inventory fluctuations.

● Supported Global Shop ERP to enhance operational efficiencies, and improve management oversight across business processes, managed upgrades, troubleshooting and user acceptance testing.

● Spearheaded data migration for the Oracle Fusion Cloud implementation project, ensuring seamless integration and minimal disruption to ongoing operations.

● Developed custom reports using innovative technologies, pulling data from multiple sources to enhance decision-making and operational insights.

● Streamlined complex business processes to optimize workflow efficiencies and improve organizational performance.

● Leveraged multiple Oracle reporting tools including OTBI, BI Publisher, FAW, XLConnect, and SQLConnect IT Project Manager, Martin Preferred Foods, Houston, TX Feb 2013 – Dec 2014 Supported a mission-critical USDA ingredient label printing application, ensuring seamless operations and compliance with regulatory standards. Engineered robust solutions to optimize data handling processes, significantly improving system performance and user satisfaction. Facilitated cross-functional team collaboration to ensure technology solutions aligned with business goals, performed testing/troubleshooting and enhanced organizational efficiency.

● Oversaw and managed the data migration from MS Access to Canopy, enhancing data integrity and accessibility for strategic decision-making.

● Led the implementation of Canopy’s Data Collection Module, coordinating project tasks from planning through execution, and collaborating with the executive team to define project scope and operational requirements. Senior Cost Accountant & Inventory Analyst III, Ultra Clean Technology, Austin, TX Oct 2007 – Feb 2013 Provided daily management guidance to plant operations, enhancing operational efficiency and aligning production goals with corporate objectives. Developed critical Business Intelligence tools and custom reports that enabled key stakeholders to make informed strategic decisions. Served as the key liaison between senior plant management and corporate finance, facilitating effective communication and project alignment.

● Integrated roles as a Cost Accountant and IT BI Developer to enhance the cost accounting function and develop custom reporting solutions utilized company-wide.

● Resolved complex issues related to accounting, inventory, and ERP systems, significantly improving system functionality and user experience across departments.

● Engineered and maintained SQL databases and Crystal Reports, streamlining data analysis and supporting accurate month-end financial closings.

Cost Accounting Manager & Systems Analyst/Developer, Celerity, Allen, TX Jan 2004 – Oct 2007 Served as an Oracle Applications 11i super user, optimizing system utilization and supporting enterprise-wide operational excellence. Supervised a cost accounting team of three, guiding financial reporting accuracy and promoting professional development within the finance department. Managed hands-on month-end closing processes, including journal entries, reconciliations, and financial reporting, ensuring compliance and timely financial data delivery.

● Led team-building initiatives and process improvements that addressed significant operational and financial challenges, enhancing overall business efficiency.

● Developed customized Business Intelligence tools tailored to the needs of both management and technical users, significantly boosting data-driven decision-making.

Financial Systems Analyst & Senior Cost Accountant, First International Computer of Texas, Austin, TX Feb 2000 – Nov 2002

● Designed and implemented a customer quote tracking system, actual cost/customer quote audit database application which provided our team with the highest possible degree of true cost visibility.

● Approved vendor invoices for material costs, validated customer quote prices, obtained material cost impacts resulting major cost savings.

● Created/developed custom downloads/reports using Discoverer Report Writer for Oracle.

● Acted as lead expert regarding Oracle functionality and data integration for the accounting department.

● Super User for Oracle 11i in variance modules.

Mike A. Myers *********@*****.*** • 512-***-**** linkedin.com/in/mmyers41/ • Houston, TX 77494

Education

Coursework towards Electronics, Business Management & Accounting Amarillo College, Amarillo, TX

Licenses & Certifications

Microsoft SQL Server Business Intelligence Master’s Program SetFocus, LLC, Parsippany, NJ

EPRs - in order of last used

● Oracle Fusion, 1 year

● GSS - GlobalShop ERP, 10 years

● Aspen - Systems - Canopy

● Infor - Visual Manufacturing, 4 years

● Oracle EBS, 10 years

● SBT, 1 year

Technical Skills

● BIP, 1 year ● Plant Accounting Management, 5 years

● Business analysis, 12 years ● Power BI, 1 year

● Business intelligence, 30 years ● Power Query, 5 years

● Business Requirements, 12 years ● Process Improvement, 12 years

● Communication skills, 30 years ● Process mapping, 30 years

● Cost Accounting, 20 years ● Project management methodology, 2 years

● Crystal Reports, 15 years ● Python, 1 year

● Data analysis skills, 30 years ● Requirements Gathering, 12 years

● Data modeling, 20 years ● Scripting, 20 years

● Financial analysis, 20 years ● SOX, 5 years

● Manufacturing, 30 years ● SQL, 20 years

● Master data management, 20 years ● SQL Server Management Studio, 20 years

● Microsoft Access, 10 years ● T-SQL, 20 years

● Microsoft Excel, 30 years ● Toad Database Developer Tool

● OTBI, 1 year ● Tableau, 1 year

● Oracle SQL Developer, 5 years ● Visio, 2 years

● UAT, 12 years ● ERP Troubleshooting, 20 years

Contact this candidate