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

● 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.

● 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.

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.

- 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.

- 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.