Daniel Schmitt Email & Phone Number

Lake View, New York, United States

AWS DevOps Lead- Completed migration of on-prem infrastructure to AWS Cloud- Maintenance and support of QRM infrastructure on AWS EC2 - Design and implement new use patterns to meet business requirements- Advise team and management on process improvements and opportunities for automation- Plan and lead DevOps team in prioritizing and executing project tasks and releases

Buffalo, New York, United States

● Data analysis, profiling, and writing transformation expressions to map bank systems of record into universal Hadoop data warehouse. ● Work as part of an AGILE team to deliver on multiple critical regulatory projects for CECL (Current Expected Credit Loss) and FDIC (Federal Deposit Insurance Corp) preparedness.● Act as liaison between product owners, developers, scrum masters, and other analysts to ensure the highest quality data is being delivered to meet business requirements.● Support code releases and environment promotion by writing test scripts (SQL in Hadoop Hive / Impala).● Perform end to end testing and exhaustive data comparisons with industry leading tools including Python, Pandas, Informatica Analyst, TOAD Data Point and more.

Buffalo/Niagara, New York Area

● Interdisciplinary role that combines data manipulation and analysis, programming and reporting technologies to extract knowledge and insights from source system data in support of interest rate / liquidity risk management, balance sheet management and capital planning for senior management. ● Administration of QRM Risk Framework version 16 (Foundation) environment of 30+ clustered Windows servers including application support, version upgrades with regression testing, data source integration, HPC cluster administration, database administration, performance tuning, and scripting.● Serve as primary BAU support role of QRM to 30+ users, troubleshooting performance issues (planning / valuation runs, OLAP report generation etc), resource management, and user access● Administration and support of 50+ SQL servers (Windows Server 2008 – 2016 running SQL Server 2008 - 2016) housing treasury data, analytics processes, and reporting mechanisms critical to the bank utilizing a wide range of industry leading software and technologies. ● Integrate data feeds using MR, SSIS and complex stored procedures with precise SQL job controls from various systems including mainframe, FTP and Hadoop data warehouse.

Buffalo/Niagara, New York Area

Implementation and ongoing support of QRM Balance Sheet Management and Interest Rate Risk Analysis software used by global ALM groups. Responsibilities include: - Setup and maintenance of multiple Windows Server 2003 & 2008 environments running SQL 2005 & 2008.- Interfacing current data feeds with new system using TDM, ETL, VBScript.- Insuring cross-system data integrity through parallel testing .- Securing data and assigning permissions using Active Directory controls.- Continuous process improvement and automation of tasks through Windows scheduled tasks, batch files, UNIX shell scripting, Excel based scripting / macros, and Powershell.- Assist with project management, task prioritization and scheduling using traditional SDLC and AGILE methodologies. - Analyze and modify financial data transformation logic using VBScripting and SQL queries.- Troubleshoot networking performance issues & errors using standard tools such as process monitor, pathping, Route, etc. - Troubleshoot Windows Server technical & performance issues using industry standard tools such as Event Viewer, Performance Monitor, and Process Monitor.- Troubleshoot SQL database technical and performance issues using SSMS, queries, and Activity Monitor.

Sarasota, Florida Area

- Diagnosed and repaired an average of four computers per day, usually on site, with little prior knowledge of the issue. - Developed strong customer service, communication, and problem solving skills while operating with very little guidance.- Developed refined knowledge of Microsoft Windows systems, specifically diagnosing and resolving common user problems.

Buffalo/Niagara, New York Area

- Design, programming, implementation and support of management reporting program to replace Paradox process with a Visual Basic / MS Access / MS Excel system, including program documentation and maintenance procedures.- Designed MS Access training program for department and trained five non-technical users.- Provided technical assistance to Asset Liability group.