Michael R. Email & Phone Number

Tampa, Florida, United States

Tampa, Florida

Tampa, Florida

Citigroup – CTO, Resource Supplier Management, Strategy & Planning• Collected user requirements to develop, create, and automate reporting functions as well as oversaw multiple SharePoint sites in order to communicate weekly reporting data to various clients around the worldo Scripted (VBA & SQL) Access databases to automate updates to SharePoint thereby cutting reporting time by an average of six hours per week while removing human errors from the system o Designed, programmed, tested, and debugged various Visual Basic scripts and user forms in order to achieve the necessary data update sequences o Responsible for large database systems which consisted on average of 30,000 rows and over 100 individual fieldso Developed user interfaces in Access to ensure stability and compatibility with users of various skill levelso Created user instructions to continue the automation process and to future-proof the reporting program• Created automated email notification system to alert clients to changes within the databaseso Utilized HTML programming and Outlook to auto-generate emails containing tables of the changes via VBA programming within Access

Joint Base Mcguire Dix Lakehurst Nj

• Collected and utilized base-wide energy consumption data and metrics to develop and prioritize energy auditing projects o Conducted Level 1 and Level 2 energy audits to support the creation of energy conservation measures resulting in the development of 13 energy saving projects worth an estimated $17M that will save $1.6M per year with a total of 58,992 MMBtu per year o Researched and calculated budget and life cycle costs for energy conservation projects through the Building Life Cycle Cost program which resulted in the development and acceptance of 11 energy saving projects by JBMDL personnel worth an estimated $12M and predicted to save $1.0M per year and 33,070 MMBtu per year• Led energy team of three senior analysts and one junior analyst through analysis and verification of energy savings data utilizing regression analysis and presented results to Air Force personnel, confirming a savings of $47.5M resulting in acceptance of a planned contract expansion• Created a base-wide utility data management and analysis database program to assist with monthly data collection, billing, and analysis by the entire energy department o Designed, programmed, and launched a base-wide utility program to gather monthly commodity billing for analysis and provided a standardized customer billing tool enabling the JBMDL utility department to generate and issue bills to on-base customers o Programmed in VBA Excel and Access to maintain government usefulness and comfort but designed to meet the needs of various users such as data entry personnel, energy analysts, and program managers o Developed and provided all support documentation and training• Identified possible rebate and incentive programs for energy conservation opportunities by researching state and federal programs online, through network associations such as Association of Energy Engineers (AEE), and local energy providers

Laurel, Maryland

• Provided analysis that ensured project funding prioritization based on current year funding levels within the Wind program by the assignment of Technology Readiness Levels (TRL)• Created a Project Inventory database system to track all current year projects for the purpose of people loading analytics as well as to enable metadata filtering capabilitieso Developed a tracking and reporting mechanism to monitor the workload of project managers and calculate and report an effectiveness rating for the Wind Program to guide strategic prioritization of projects for communication to Senior Management at EERE• Oversaw the development of a database and reporting system for the Annual Operating Procedure (AOP) in SharePoint for all of DOE EERE, which is used to provide funding to the National Laboratories each yearo Designed and produced a stop-gap series of forms in Excel to gather data from thousands of users, compile it into a flat database structure, and generate a formatted Word document to ensure conformity across all of EERE and to standardized the AOP process between EERE and the National Laboratorieso Process architecture and designs became the model for the next year’s software upgrade which was designed in SharePoint and is still used by EERE

• Managed multiple projects simultaneously, typically between 20 and 30 ranging in value from $25K to $50M eacho Coordinated all areas of activity pertinent to project, e.g. proposals, engineering, manufacturing, purchasing, assembly, testing, vendors, and quality control through final completion of domestic and international orderso Established and developed project schedule for all assigned customer projectso Created and revise internal drawings using the latest AutoCAD software package• Responsible for maintaining and updating databases related to the company’s hydraulic, pricing and proposal toolkitso Formulated code and logic equations based on product knowledge to establish search and selection criteria for internal and external databases which resulted in more accurate hydraulic selections, increased sales, and fewer post-order issues