Bill Joyce Email & Phone Number

Greater Denver Area

Greater Denver Area

Amazon is hiring in Denver

Centennial, Co

Responsible for performance and scalability of a system with one of the largest SQL Server deployments in Colorado (over a billion database requests per day, tens of TBs of data, and some tables with a few billion rows). • Created a simple, reusable sharding framework that provides an unlimited scale-out solution. This framework is being used by multiple subsystems, the largest of which is handling over 100 million requests per day among the shards. Performance is 3x faster after… Show more Responsible for performance and scalability of a system with one of the largest SQL Server deployments in Colorado (over a billion database requests per day, tens of TBs of data, and some tables with a few billion rows). • Created a simple, reusable sharding framework that provides an unlimited scale-out solution. This framework is being used by multiple subsystems, the largest of which is handling over 100 million requests per day among the shards. Performance is 3x faster after sharding.• Over the course of two years, reduced CPU, number of calls, and contention by at least 80% each in the two most highly used databases. Saved well over 100 million calls per day in one database. Also made significant improvements in other databases.• Identified bottlenecks by analyzing stored procedure and index stats from SQL Server DMVs, root blockers, trace files, and execution plans.• Became very proficient at resolving performance issues via index tuning (optimal clustering, covering indexes, dropping unused indexes, etc), refactoring stored procedures, caching, denormalization, and when necessary, plan hints and plan guides.• Drove an effort to improve the interview process and raise the competency of the development staff. Interviewed about 20 candidates each year as part of this effort.• After a company-wide move toward NoSQL, spearheaded adoption of Amazon Aurora as a viable data store and pushed the first Aurora project to production.• Currently working on migrating 3TB from Cassandra to Aurora to reduce administrative overhead and cost by 90%. Show less

Denver, Co

Led majority of architecture, patterns, and quality of Microsoft’s next generation financial reporting product (an n-tier winforms application). Championed UI / UX, and built awareness among the team of six developers. Major contributor to the group’s highly successful agile approach to development. • Workgroup Health Index consistently around 90 (Microsoft average is typically upper 70s).• Our development environment (with full TFS integration) was the subject of an internal… Show more Led majority of architecture, patterns, and quality of Microsoft’s next generation financial reporting product (an n-tier winforms application). Championed UI / UX, and built awareness among the team of six developers. Major contributor to the group’s highly successful agile approach to development. • Workgroup Health Index consistently around 90 (Microsoft average is typically upper 70s).• Our development environment (with full TFS integration) was the subject of an internal Engineering Excellence Group case study.• Significantly extended DataGridView, including support of undo and redo, in both bound and unbound scenarios.• Received a patent for automated dialog guideline compliance.• Recently submitted a patent application for run-time detection of missing exception handlers.• Designed the group’s UI automation approach using VS2010 to help our test team catch up. Show less

Denver, Co

• PresenterDelivered numerous presentations on Microsoft developer products, tools, and technologies, including an introduction to C# for the Java Users Group.• Enterprise Architect for ProcardTracked down in three days an application error that had been causing server downtime for months, then provided knowledge transfer on the tools used to debug these issues. Conducted a thorough application review and recommended numerous areas of improvement, from application architecture… Show more • PresenterDelivered numerous presentations on Microsoft developer products, tools, and technologies, including an introduction to C# for the Java Users Group.• Enterprise Architect for ProcardTracked down in three days an application error that had been causing server downtime for months, then provided knowledge transfer on the tools used to debug these issues. Conducted a thorough application review and recommended numerous areas of improvement, from application architecture to tools and processes that should be used during the development cycle. • Content management system development at JDEdwardsDevelopment lead for JDE’s content repository. Users edit content with Word on the front end and can build different types of output. The content is stored in a SQL Server 2000 database (accessed via ADO) and the system enforces check in and check out of content. Project responsibilities included application architecture, specifying and designing features based on requirements, scheduling resources, and coding. This application was demonstrated at the national Office 2000 launches in New Orleans and Nice, France, and also at the local launches in Denver and Salt Lake City.• Enterprise Architect for eCollegeInstilled in their development team the processes and mindset necessary to ship robust software on schedule. Reviewed their architecture, created daily build and deployment scripts, provided knowledge transfer on current and future products and technologies, and assisted with architecture directions. Did some performance work, including reducing execution time on one of their more complex pages by about 85%.• Enterprise Architect for First Data Corp.Architected and implemented a solution using BizTalk to remove a dependency on custom code for each new customer. This company can get new customers up and running two to three weeks sooner. Educated staff members on relevant areas of BizTalk, Visual SourceSafe, and development methodologies. Show less

Redmond, Wa

• Worked on the Visual C++ debugger on versions 2.0, 2.1, 4.0, and 4.1. Fixed bugs, added new features, and made performance improvements.• Wrote the front end of the then-brand-new class view feature, which received great press reviews.• During “App Week,” ported MS Money to the Mac with one other peer. This involved first porting Money from 16 to 32 bits, and then to the Mac using the VC++ Mac Edition. Our changes were ultimately merged back into Money’s source tree.• Architected… Show more • Worked on the Visual C++ debugger on versions 2.0, 2.1, 4.0, and 4.1. Fixed bugs, added new features, and made performance improvements.• Wrote the front end of the then-brand-new class view feature, which received great press reviews.• During “App Week,” ported MS Money to the Mac with one other peer. This involved first porting Money from 16 to 32 bits, and then to the Mac using the VC++ Mac Edition. Our changes were ultimately merged back into Money’s source tree.• Architected and implemented expression evaluation, JIT debugging, and some of the stepping model for Visual J++ 6.0, along with considerable performance work using the profiler.• Dev lead for the Visual J++ 1.1 debugger.• Designed and wrote the Visual J++ 1.0 expression evaluator, which was used by most of the J++ debugger windows to parse and evaluate complex expressions.• With two other peers, designed the Microsoft Java VM Debug API. The J++ debugger used this API, and other tools vendors are looking into using it as well.• Worked on the Visual C++ PowerMac Edition, fixing bugs and implementing new features such as remote Just-In-Time (JIT) debugging• Started my debugger work by porting the 68k debug monitor (DM) from 68k assembly to C. Next added some features to the 68k debugger such as step out, stop debugging, and data breakpoints. Also polished up the transfer utility that transfers files between the Mac and the PC.• Wrote the 68k linker for Visual C++, Macintosh Edition. During this time, I worked with internal clients such as Word, Excel, VB, and FoxPro developers to add the features they needed most and to fix bugs that hindered their product development. Show less