Michael Simich Email & Phone Number

Buffalo, New York, Us

Provide monthly loan forecast and financial deliverables to M&T Commercial Bank Leadership, focusing on Middle Market, Asset Based Lending, Not-for-profit, and Government Banking.Drive positive change and process improvement with tools like Alteryx and Tableau.Provide testing related to Oracle EPBCS.

Pittsburgh, Pennsylvania, Us

Provide data and reporting support to Highmark Inc Financial Planning and Analysis groupProvide forecast support to provide twice-weekly margin summaries for management to create informed pricing strategies.Manage support tickets and testing to implement bug fixes and enhancements.Created several Alteryx workflows to aid with the analysis of large datasetsDesigned workflow to compile up to 20 years of monthly financial data from Excel workbooks o Previously would have to go into each month individually and copy each month manually to get data o Data is being utilized in Power BI dashboards for analyst and management reportingAnother workflow combines over 800,000 rows of data and formats to be usable within a newly designed Power BI dashboard o Combined, this workflow and corresponding dashboard make a previously quarterly analysis now monthly to allow upper management to make more time sensitive decisions o Previous process required the updating of multiple Oracle Smart View retrieves, prone to error as they were fixed queries that required investigation if inaccurate o Designed dynamic Smart View queries to eliminate errors and manual processes. Also incorporated control totals to ensure all data was correct and complete. o Overall workflow and dashboard process moves day-long process to under 3 hoursImplemented alternate hierarchy in Oracle PBCS to classify contribution margin costs o Systematic fixed/variable splits allow for easier analysis by a larger variety of people o Reduces data volume required by 75% to perform contribution analysisDesigned Alteryx workflow to pull and process monthly GL of new business entity to allow for entry into the corporate general ledger and reporting systems.Provide ad hoc query and data support for senior management

Ellicottville, New York, Us

• Assist in the first aid care of Holimont members efficiently and effectively • Responsible for opening trails and ensuring member safety• Completed senior ski patrol program – over 150 hours of training and successful completion of benchmark evaluations• Improve core ski patrol competencies to further educate and provide continuous quality improvement to members of the Holimont Ski Patrol • Assist in the administration of the annual ski patrol refresher training session

Buffalo, New York, Us

In addition to the responsibilities in the Finance Systems Support II position,Assist with affiliation to Highmark Inc.Create and document new reconciliation process to increase efficiencies

Buffalo, Ny, Us

Support all areas of the finance department for HealthNow.Participate and lead a variety of process improvement and departmental initiatives.• Support PeopleSoft Financials configuration and reporting assistance• Implement and test PeopleSoft enhancements• Assist business users with PeopleSoft troubleshooting and querying expertiseCreate multitude of reports and queries to provide the business information and automation.Implement process improvements with the core PeopleSoft Financials system.Utilize SQL to drive change and reporting within HealthNow off of MySQL and Sybase databases.Driver of change through projects and examination of current processes and improvements that can be made to them.

New York, New York, Us

• Process over 200 daily trades for clients • Manage, monitor, and maintain client portfolio of over 400 clients• Utilize interpersonal and time management skills to design, develop, and implement new procedures and process improvements within the Retail Foreign Exchange group • Use Bloomberg, MISYS, and FXall to assist with client settlement of FX transactions• Maintain and update client database records for entire Retail Foreign Exchange group• Led major process change to comply with new audit requirements and regulations. Interfaced with clients constantly during the process to ensure timely processing and a seamless transition• Created a macro to efficiently organize and filter transactions for specialized pricing processing• Created a macro to streamline and nearly automate previously manual process, resulting in decreased risk of mishandling confidential information and personnel time to complete process by 10-fold• Designed over 200 SWIFT templates for a single manual process to aid in the debiting of client accounts with increased accuracy and decreased personnel processing time

New York, New York, Us

Processing of FX trades for retail clients of Citigroup.

Grade 7 Referee• Referee over 75 youth and adult games each summer • Responsible for game, player, and coach management between other players, coaches, and referees• Mentor youth referees – providing guidance, training, and constructive feedback for quality improvementRefereed at WNY Region State Cup 2008-2012.Refereed at Region 1 ODP, 2012Refereed at Region 1 ODP Camp, 2011

Buffalo, Ny, Us

• Created accurate and meaningful weekly location reports for Vice President of Finance, Parks and Resorts• Designed and developed over 5 spreadsheets collating data for management decisions• Generated multiple annual finance reports on resorts for National Parks Service• Consolidated and revised monthly reports and projections for resorts

New York, New York, Us

• Designed a macro to streamline manual processes• Created over 3000 Standard Settlement Instructions saving time for clients with frequent transactions• Developed a Microsoft Excel spreadsheet to manage and maintain client records for Retail Foreign Exchange group• Built a Microsoft Access database for inputting and tracking daily transactions processed by Retail Foreign Exchange group• Performed daily activities for team members, including generating reports

• Curated Drosophila melanogaster regulatory elements for REDfly• Read and summarized over 650 scientific papers and inputted over 1000 new cis-regulatory elements and 3000 transcription factors into international database, REDfly• Developed a comprehensive user guide for REDfly curators

Master Of Business Administration (Mba), Finance, General

Bachelor Of Science (Bs), Bioinformatics