Developed IT Business Operation (ITBO) Reporting Center of Excellence (COE)’s standards and guidelines for developing and maintaining Power BI reports. Topics include approved data sources, data dictionary, formatting standards, trouble shooting, and best practices. Implemented COE standards across all ITBO Power BI reports resulting in a reduction in the Power BI reporting portfolio and a 75% reduction in the cloud storage used in the Power BI Service. Managed all ITBO reporting development and update tasks using MS Planner, assigning tasks and providing guidance\training to junior staff, and validating all work prior to publishing new\updated reports. Maintained and modified Power Automate flows and Power Apps that support IT Investment Committee approvals and required documentation for IT projects. Provide data analysis support to IT Business Operations staff and IT Project Managers and provide assistance with Power BI, SharePoint, Power Automate, and Power App to IT and Non-IT personal.

Designed and implemented an end-to-end reporting environment in support of operational reporting for the Chief-of-Staff within the Information Security Office (ISO). Created Extract, Transform, and Load (ETL) packages using SQL Server Integration Services (SSIS), developed operational reports and dashboards using Power BI, SQL Server Reporting Services (SSRS), and Excel macros. Lead and supported reporting process improvement initiatives and implemented custom SharePoint solutions to improve ISO’s internal operations using Power Automate and Power Apps. Created senior manager, executive level, and board presentations, as well as presentations for regulatory bodies which included financial, operational, and compliance metrics/content, as well as ISO IT project updates. Provided analytical and reporting technical support throughout ISO upon request.

Developed a new sampling process using Business Objects to assist internal auditors with SAP transaction testing. Authored training materials and conducted in-person and web-based training to auditors on the new sampling process. Develop SQL scripts and VBA macros for validating the completeness and accuracy of SAP data extractions and SQL scripts for process controls testing. Develop reports using Report Builder for searching for key words and phrases within the audit department’s internal knowledge repository database and develop risk dashboards using Spotfire to evaluate the risk at branch locations. Train auditors on the principles of data quality and data profiling.

Built statistical models, such as, multivariate and logistic regression models, using SAS to identify key factors that played a role in a consumer’s ability to complete a Debt Management Plan (DMP) and to predict the likelihood a consumer would successfully complete a DMP. Develop, deploy, and analyze the results of consumer surveys, using SilverPop and Survey Monkey, to measure the impact of financial programs, address specific industry questions, and measure customer satisfaction. Retrieve data from large datasets and databases, perform data cleaning and quality control, data merging and create datasets for further analysis using SAS, SQL and Excel. Make recommendations for correcting existing data issues and for data entry changes to ensure data quality. Assisting Marketing and Strategic Development Teams with in-depth analysis using internal and external data sources in support new business/product development activities. Prepare supporting materials for state and federal grant applications and reviewed statements of work prior signing and execution of any grant or contract activity.

Retrieve data and calculate loan performance statistics using SQL and ad hoc reporting using SAS for DataX’s clients. Assist the pre-sales technical team developing business rule logic for lead and identity verification.

Perform statistical analysis and reporting on critical processes to support the space shuttle hardware processing and all astronaut training. Develop operating procedures, created process maps and develop methods for tracking and measuring department processes. Served on Lean Six Sigma Black Belt project to track configuration of hardware on the space shuttles and managed a Green Belt project for requesting mission specific tools for training exercises.

A one year part-time assignment assisting a team of researchers building multivariate regression models utilizing SAS.

Challenged to design/build a 3,000 square foot warehouse operation for this startup company. Responsible for staff recruitment and training, order fulfillment, receiving, stocking, shipping and product delivery. Developed standard operating procedures, inventory control and inspection systems to ensure operational integrity.

Managed a team of ten employees for production and machine shop operations. Scope of responsibility included training, scheduling, inspection, shipping and receiving, warehousing, inventory control. Developed and implemented a quality control program companywide. Introduced new automated processes that significantly improved productivity.

Led a team of six within an infantry mortar platoon. Scope of responsibility included training, counseling, squad inspections and the enforcement of standard operating procedures. Honorably discharged holding the rank of Corporal.