Brian Nash Email & Phone Number

San Francisco, California, Us

San Francisco, California, Us

- Provide escalation support for a portfolio of 6 corporate and investment banking applications implemented on SQL Server 2014, using C# Windows and web services, ASP.NET MVC web user interfaces, JSON REST endpoints, Solace event broker, SSIS packages and CA Autosys job scheduling. Won three Wells Fargo awards for excellence in production support. - Fulfill scheduled data extract and update requests via creation of TSQL scripts, SQL Server Reporting Services (SSRS) reports and SSIS packages.- Monitor and optimize application performance using AppDynamics, Dynatrace and Geneos. Create specifications and define queries for application alerts. - Tune and test SQL Server query performance. Completed a multi-month project to optimize Customer Information Database (CID) stored procedures, resulting in a 24% improvement in database performance. Two mission-critical messaging components saw an 80% performance improvement.- Plan, manage and document software deployments, major upgrades, vulnerability remediation and semiannual business continuity planning (BCP) exercises across multiple environments and applications. Write game plans to coordinate work among the different responsible workgroups.- Earned division-wide Gold Coin award for performance excellence, Q4, 2019.- Earned Shared Success award for optimizations to cache server performance that significantly improved trade reconciliation speed and accuracy.

San Francisco, California, Us

- Created, maintained and enhanced SSIS packages, SQL Server stored procedures, C#.NET web services, an ASP.NET MVC web user interface, and C# Windows services as part of Wholesale Customer Information System (WCIS) system of record - Wrote functional and technical specification documents from business requirements- Integrated new partners into Wholesale Customer Information System (WCIS) via .NET web service API, realtime or batch data feeds (added 15 new partners in 2016-2017) - Earned division-wide Wholesale Technical Support (WTS) team excellence award for successful completion of backend performance improvement code project- Successfully led ETL and stored procedure development for a 7-month regulatory project to secure material non-public information (MNPI) in the Wholesale Customer Information System's data warehouse. I was awarded a Wells Fargo Shared Success award for this development effort.

San Francisco, California, Us

- As production support lead, provided escalated support for Wholesale Customer Information System (WCIS) system of record and infrastructure.- Performed ongoing performance monitoring, reporting and improvement via analysis of Dynatrace data, SQL Server profiler trace information and stored procedure execution plans- Identified and optimized key application stored procedure bottlenecks, contributing to an overall 75 - 90% improvement in system performance.- Planned and managed business continuity exercises and maintained disaster recovery plans via Sungard LDRPS Availability Services- Planned, managed and documented software deployments. - Trained team members on performance troubleshooting, Dynatrace analysis and Microsoftdevelopment tools.- Earned WISE STAR divisional team award for excellence in production support.

Redmond, Washington, Us

- Provided escalated product support and advisory services to Microsoft’s Premier accounts for SQL Server, SQL Azure and .NET development tools, producing 93% very satisfied customers in FY 2014 and 90% in FY 2013- Received ‘Great People, Great Performances’ award in FY 2013 for outstanding contributions to SQL Azure product support- Managed product support pipeline for SQL Server Migration Assistant, collaborated with a 3-person team to migrate a major bank’s data center from Sybase to SQL Server, resulting in the sale of $7 million worth of Microsoft product licenses- Managed product support pipeline team for SQL Server database connectivity, drove connection resiliency improvements in data providers and network library, resulting in fewer customer-reported connectivity errors- Created and maintained an internal website containing scenario-based SQL Server connectivity training, reducing training time for new employees- Created instructor-led training for SQL Azure support engineers worldwide- Presented ‘Ask the Experts’ webcast on troubleshooting Windows Azure SQL Database connectivity to ~500 professional developers- Led Windows 7 application compatibility initiative for Microsoft SQL Server Developer Support

Redmond, Washington, Us

- Provided escalated support and advisory services to Microsoft’s Premier accounts for SQL Server database development tools and technologies- Managed product support pipeline teams to drive improvements in security and memory management in native MSXML and Windows Data Access Components (WDAC) and eliminate stack overflows due to recursion in System.XML.- Received Ship-It award for contributions to ADO.NET 2.0 libraries, including beta support and public webcasts highlighting new product features- Delivered advanced training courses to developer support teams on network analysis, debugging and memory issues

Redmond, Washington, Us

- Designed and programmed Formal Taskers document management system for US Army Reserve Corps using C#.NET, resulting in the sale of 10 SQL Server 2000 licenses- Prototyped conversion of a Fidelity’s intranet fund quote system from EJB and J++ COM objects to C# web service, winning market share for .NET.- Created internal development standards site and performed documentation review for Morgan Stanley to ensure smooth transition to .NET programming.- Performed code reviews and performance tuning for Merrill Lynch back office applications to improve software performance and efficiency.- Led Y2K remediation efforts for Microsoft development products.

Redmond, Washington, Us

- Provided timely technical resolution of high-profile customer issues with Visual FoxPro and Visual Basic language and database technologies- Created technical content and white papers for Knowledgebase and MSDN- Mentored a team of 180 support engineers- Acted as dedicated liaison to writers and ISVs during FoxPro’s beta test cycle

- Designed and developed CISSAR clinical information and patient accounting system and implemented at 52 sites worldwide, including Mecklenburg County Area Mental Health, Youth and Family Services and Substance Abuse agencies- Designed and developed Mecklenburg Country Emergency Assistance eligibility system- Programmed the Mecklenburg Country Social Services Front Desk intake system project- Programmed Mecklenburg Country Record Room automated search system