Brian M. Email & Phone Number

Seattle, WA, US

Seattle, WA, US

Seattle, WA, US

• Responsible for developing solutions using advanced Excel, SQL, VBA and AWS services for a user base of over 50 to assist with reporting, auditing, operational tasks and collecting submissions for monthly process..
• Developed a tool to collect, validate, consolidate and audit sales revenue territory updates from a user base of over 12. Tool processed roughly 10K records monthly
• Automated business process to append data to 20 Sharepoint lists for initial review as well as downloading and consolidating for further review and approval. Built process to do an hourly backup used to create status.
• Created multiple tools to accept and process automated requests sent via email. Tools used keywords to determine which process to run, validated requester had proper permissions, and would return file to user based on.
• Developed tool to ingest templates requesting changes to international teaming accounts. Tool recognized different types of requests: new, add, remove, deprecate and included error handling to catch multiple requests.
• Created reporting engine for generating Excel and PDF versions of incentive compensation reports to track metrics by 3 different plan types for 5,000 payees at multiple geographic levels.

Seattle, WA, US

• Developed tool to automate calculation of drivers of margin variance between quarters/years and actuals/forecast.
• Built table in Redshift to categorize 1 million credit transactions monthly. Table became standard to use for all service finance teams, FP&A, accounting and payments.
• Developed methodology to allocate credits to more granular level between various services. Wrote SQL scripts to generate results and built TI process to load into TM1.
• Developed cubes in TM1 to replace usage and revenue forecast previously done in Excel. Gathered requirements from users, completed all development, implementation, testing, documentation and user support. Forecast.
• Enhanced existing TM1 forecasting system to add active user accounts
• Wrote SQL scripts to take high level revenue input and transform into format and granularity to be loaded into TM1.

Seattle, WA, US

• Oversaw transition of capital forecasting process from 6 capacity forecasting models in Excel spreadsheets into TM1 environment.
• Wrote technical requirements and tested multiple iterations during development.
• Educated users on new process and provided technical support during forecasting cycle.
• Developed queries to assist with cost allocation process tagging methodology.

Seattle, WA, US

• Acted as point person for rack and server capital expenditure forecasting process. Owned and maintained forecast models to make enhancements, updates and correct errors. Collected and integrated inputs from a dozen.
• Reviewed and approved purchase requisitions for server hardware. Processed upwards of 100 requisitions per week, over $100 MM. Questioned product managers on necessity of certain orders to eliminate unnecessary orders..
• Owned monthly process for assigning racks and servers to services to determine footprint used to allocate operating expense and keep track of capacity. Processed data set exceeding 1 million rows. Improved assignment.
• Created report used to track rack purchases versus plan. Built functionality to enable users to select different forecasting scenarios, years, services and rack types. Automated report to allow update requests to be.
• Published weekly reports to track utilization of servers. Reports were used to make purchasing decisions and eliminate unneeded capital expenditures. Redesigned data structure of reports, decreasing size of files by.
• Administered system used for capital purchases for entire department. Evaluated access requests from users and helped to direct to proper permission groups.

• Led meetings of homeowner's association
• Prepared yearly association budgets and analyzed variances
• Conducted research on issues facing the association

• Counted money in 14 team envelopes for SW Kokanee men's bowling league.

Bellevue, WA, US

• Created several processes for automatically generating journal entries and critical reports as part of month end close process
• Developed process for pulling transaction data, scrubbing, aggregating and generating Travel & Entertainment reports. Reduced process time from 3-4 days to a few hours
• Developed routine to spread costs from an aggregate account down to 2000+ accounts based on various sets of rules. Reduced process time from 6-8 hours to 30 minutes.
• Designed, implemented and maintained database for tracking and reporting on revenue. Tracked revenue from three viewpoints: contracted, recognized and cash received. Ensured data reconciled to known sources. Processed.
• Developed completely automated solutions to parse specific email messages from customers, read commands, execute scripts and reply to messages
• Enhanced comparison tool to automatically extract patent data from Excel and Word files, clean up data, and place in proper format for comparison

Bellevue, WA, US

• Built tools used for extracting budget data for assets from various spreadsheets, assigning proper codes to assets and uploading data into system
• Developed Excel front end tool for displaying data in bubble chart with 4 dimensions (X, Y, size, color), with user interface to change variables, zoom in, move quadrants and see detail
• Automated a monthly process for sending out credit card statements to cardholders, reducing time needed for process from 8-12 hours to 10 minutes and greatly improving accuracy of data
• Automated a monthly process for creating reminder notices for investors and sending them out, reducing time taken for process to 10 minutes
• Automated a quarterly process for calculating management fees for 14 different investors, each of which is calculated differently. Reduced time taken for process to 15 minutes
• Built a database used to create monthly/quarterly statements for inventors and create journal uploads for Accounts Payable to process payments to inventors

New York, NY, US

• One of two employees from team of 13 identified as critical team members and selected to stay for entirety of WaMu to Chase transition
• Assisted with transition by answering management questions, and by completing ad hoc analysis and reports for WaMu and Chase colleagues while maintaining existing reporting and analytics

New York, NY, US

• Acted as supporting finance partner for Online product set--analyzed trends and created models to assist with pricing, promotions and product enhancements
• Created and maintained a variety of analytical balance, account, and geographical performance reporting tools utilized by Finance, Treasury, Product Managers, Network Distribution and Retail Executives to increase.
• Presented and trained Finance senior executives and Product teams on usage of analytical tools at the Group, State, and Regional level to assist their teams pricing/promotional decisions and key metric reporting while.
• Developed critical daily deposit balance reporting, produced automatically at 5 AM daily and relied on by top executives, regulators, and rating agencies to monitor deposit portfolio during economic period with.
• Automated key performance reports updates to eliminate manual input, increasing availability from 10 AM to 5 AM for daily report and from Monday to Sunday for weekly reports
• Automated report distribution using various channels, including email, SharePoint upload and text message to enable faster access to team

New York, NY, US

• Conducted reporting and analysis on a $140 B Retail Deposit portfolio used to support deposit pricing, promotional actions, and new product launches
• Served as point person for monthly forecasting process and yearly planning process for 3 lines of business and over 15 products including providing instructions on submission, created upload template to consolidate and.
• Reconciled and documented data differences between various reporting systems to address discrepancies and reduce confusion and increase transparency
• Validated data and developed reporting and tracking to assist with Commercial Capital Bank acquisition, involving data from several disparate sources
• Developed reporting and analytical tools and enhanced modeling while assisting with internal transition for Noninterest Income function
• Managed Moody’s Economy.com forecasting model to provide deposit growth market outlook for annual plan and 5 year long range forecast, which improved high-level forecast accuracy

• Interacted with customers, cashiered, answered phone, cleaned, assisted bar staff.
• Conducted various forms of maintenance inside and outside building independently.
• Operated machine used to clean, dust and oil lanes; filled machine when necessary.
• Repaired broken bowling machines and wrote reports about problems.
• Reorganized rental shoes into a coherent system. Designed a chart showing locations.
• Implemented a system for storing old pull tab games until disposal was needed.

Bs, Applied/Computational Math Sciences

Associate Of Arts

Education record