SUMMARY:

• Hands - on database and software developer.
• Excellent communication via written documents, oral presentations, and informal conversation.
• Extensive experience managing and mentoring database, web, and software development groups consisting of designers, developers, engineers, DBAs, and QA staff.
• Replaced entire set of accounting queries that had been based on nested views with new table-driven procedures that performed an order of magnitude better, and provided an Excel tool for executing the queries, as of any historical date.
• Improved the reliability and performance of an application used to synch data between thousands of kiosks and hundreds of databases by refactoring .Net code and stored procedures.
• Wrote a 4000 line script to clean data and migrate it from a de-normalized MySQL store to a fully normalized SQL Server database.
• Wrote a CLR-based stored procedure in C# to calculate the IRR of an arbitrary cash flow.
• Using the MVC-based Web API framework, coded a RESTful API for a financial firm.
• Refactored C# data access code to greatly enhance SQL Server performance.
• Designed and coded a WCF web service, as well as Windows services comprising over 10,000 lines of C# code, 150 stored procedures, and over 300 pages of Word and Visio documentation.
• Guided database activities required for a major conversion of a legacy mainframe system.

PROFESSIONAL EXPERIENCE:

Confidential, San Francisco, CA

Consulting Software Engineer

Responsibilities:

• Reviewed the software and database architecture for the India - based TicketUtils suite of products, which were acquired by Confidential .
• Identified major deficiencies in both and suggested programs for improving maintainability, reliability, and performance.

Environment: Visual Studio 2017, Git, GitHub, ReSharper, SQL Server 2016; Confluence, JIRA, Slack, Couchbase, Memcache, MuleSoft, SimpleInject, Splunk.

Confidential, San Francisco, CA

Sr. Software Engineer

Responsibilities:

• Reviewed SQL Servers and databases. Corrected security, archived obsolete data occupying 80% of the space, corrected maintenance plans, documented system using Confluence, set up JIRA project for development work
• Reviewed workgroup s applications, including an Access front end, a Word app, four Excel apps, a VB.Net desktop app, several SSRS reports, and a SQLCLR stored procedure.
• Refactored queries that referenced views many levels deep, re - wrote all accounting queries for earned and unearned revenue, inventory, bills, broker bills, receipts, invoices. Introduced history tables to enable recreating financials as of any point in time.

Environment: Visual Studio 2010 Premium: WinForms, VB.net, C#; SQL Server 2008R2; Excel, Word, and Access development using VBA and VSTO, Confluence, JIRA, Slack.

Confidential, Palo Alto, CA

Database and .Net Architect

Responsibilities:

• Improved the reliability and performance of an application used to synch data between thousands of kiosks and hundreds of databases by refactoring .Net code and T - SQL stored procedures. Designed and coded a new system for taking and releasing locks to manage concurrency.
• Performed an audit of the central SQL Server instance.
• Set up a Slack channel for alerts and job failure emails, planned for an upgrade from SQL 2008R2 to SQL 2014 using database mirroring, researched using Confidential Web Services instead of acquiring new hardware, tightened server security, fixed database mail, established dedicated admin connection capability, and documented non-default configuration parameters.

Environment: Visual Studio 2013 Premium: WinForms, VB.net, TFS; SQL Server 2008R2, 2014; Slack, ReSharper, Redgate Performance Profiler Professional, HP LoadRunner.

Confidential, San Francisco, CA

Senior Software Engineer

Responsibilities:

• Wrote a windows service to monitor and improve the reliability of a REST - based data exchange process between Confidential and a third-party provider.
• Converting a legacy Ruby on Rails/MySQL application to a .NET/C#/SQL Server platform.
• Designed a new, scalable, fully relational database and created scripts to migrate legacy data, and clean it in the process.
• Lead for overall system architecture and assisting with GUI design.

Environment: Visual Studio 2013 Premium. C#; SQL Server 2012; GitHub, SVN, JIRA, HipChat; ReSharper, MySQL. Python.

Confidential, Santa Clara, CA

Solution Architect

Responsibilities:

• On behalf of a London - based investment firm, developed a RESTful API using Web API, an MVC-like framework for web services.
• Wrote SQL queries and returned results as JSON.
• Implemented dynamic web-based documentation for the API by generating JSON as input for the IODocs open-source documentation tool.

Environment: Visual Studio 2010, 2012, and 2013 Ultimate: Unit Tests, .NET 4.5, ReSharper; SQL 2008R2 and SQL Server 2012 Standard: database design, T-SQL, stored procedures; Git, JIRA.

Confidential, Palo Alto, CA

Sr. Software Engineer

Responsibilities:

• Developed and tested SQL scripts to implement table partitioning to facilitate archiving and improve query performance
• Refactored C# code to improve data access performance and enhance SQL Server operations. Eliminated dynamic SQL generation, introduced use of table-valued parameters, proper declaration of varchar parameters.
• Optimized indexes in key tables, some having several billion rows.
• Created a 200 MB version of a 2.2 TB database, with all dropped foreign keys reinstated and seeded with referentially valid data, ending the need for developers to share a single instance.

Environment: Visual Studio 2010 Professional: Unit Tests, .NET 4.0, ReSharper, ANTS Memory and Performance Profiler; SQL 2008R2 and SQL Server 2012 Enterprise and Express: database design, T-SQL, stored procedures; SVN; Red Gate DBA and .Net Developer Tool Suites

Confidential, San Jose, CA

Sr. Software and Data Architect

Responsibilities:

• Designed and coded an enterprise-level system for managing the integrity of an enterprise's collection of Excel workbooks across multiple computers and domains. Features include workbook discovery across the enterprise, detailed auditing and alerts regarding workbook changes, passive monitoring and active management with source control, workflow, and inferring likely sources of workbook errors based on patented heuristic algorithms. Implemented state and observer code patterns.
• Designed and implemented the database schema, over one hundred stored procedures and functions, one central WCF web service that communicated with two client applications, and three Windows services comprising more than 10,000 lines of solid C# code.

Environment: Visual Studio 2010 Ultimate: C#, .NET 4.0: File System Watcher, WCF 4.0, ReSharper, ANTS; SQL Server 2012 Enterprise and Express: database design, T-SQL, stored procedures; SQLite, Tortoise SVN, FogBugz, Excel 2003, 2007, and 2010: Primary Interop Assemblies, COM add-ins, light Agile environment.

Confidential, San Francisco, CA

Sr. Data Architect

Responsibilities:

• Advised the WCIRB and its contractors during the effort to convert their systems from a legacy mainframe platform to a modern system based on the Microsoft technology stack.
• Reviewed functional specifications, guided the creation of a pragmatically normalized schema comprising nearly 400 tables, and guided the migration of data from mainframe legacy sources to the new database.
• The database supports a service-based web application built in C# using dependency injection, Telerik RadControls for ASP.NET Ajax, and Microsoft Enterprise Application Blocks for logging, error handling, caching, and data access.

Environment: Visual Studio 2010, C# 4.0; Ninject, ASP.NET, FxCop, ReSharper, MS Team Foundation Server for source control, bug tracking, requirements management, test management, and continuous builds; SQL Server 2008 R2, SSRS, SSIS; Erwin Data Modeler; WCF 4.0; Telerik RadControls for ASP.Net Ajax; waterfall environment.