NZRU Salary Cap Tracking
I architected and subsequently developed an application to help the NZRU administer the Salary Cap. I carried out use-case analysis, produced the database schema, class design, functional specification, project estimates and the project plan.
As Team Leader I was responsible for task assignment, reporting to management, to the customer, development tasks and general support for the team. I delegated tasks whenever it made sense to do so and encouraged a scrum meeting every morning for several minutes to keep everything on track and visible.
C#, SQL Server, Win Forms, Crystal Reports, use-case analysis, design, UML, architecture
BNZ End-to-End Lending Senior Developer
I was a senior developer on a mixed Gen-i/BNZ team to develop an ASP.NET application to facilitate End-to-End lending.
My development tasks included implementing business logic and the user-interface for loan securities. During the first few days I recognised the value automated testing would lend to certain parts of the solution. I recommended the use of NUnit to the team leader and demonstrated the use a series of NUnit tests. To encourage the adoption of NUnit I provided written material and guidance. (I also investigated the use of NUnitAsp.)
The solution was in C# on .NET Framework 1.1. A SQL Server 2000 database was used to improve performance by acting as a cache between the business tier and the mainframe.
C#, Visual Studio 2005, SQL Server, ASP.NET, .NET, NUnit, NUnitASP
Legal Services Aid Global Granting Senior Developer
LSA required an application to facilitate a new process for producing invoice documents and for recording grant information against clients. The design, implementation and testing of the system had to be completed within a well-defined and small budget. I opted for a wizard-style interface and SQL Server. I used Word templates with embedded bookmarks and Word Automation to create the documents.
C#, Visual Studio, SQL
Reserve Bank FSIS Senior Developer
I was part of a team in RBNZ's Knowledge Management group designing a system to publish economic survey information on the public-facing website. We held workshops with both the Statistics and Economics department to understand the business and at the same time formed strategies on how to deliver the system and what the system should be in order to meet the needs of many different groups.
C#, Visual Studio, AZMAN, ORM, SAP, OLAP
Reserve Bank Guiding Principles
We defined a set of guiding principles around software development to be used by all future software development projects. We created the guidelines in such a way that they were genuinely guiding rather than absolute. Each guideline provided the underlying rationale so readers could understand why it existed and the degree to which it could affect their decision.
C#, architecture, design, security
IHC DTS Packages Senior Developer
I developed a DTS packages to take in a number of data sources in different formats, verify the integrity of each, manipulate the data and populate a newly created database.The incoming data was not always well-formed and the target schema was complex. Some intricate T-SQL was required to map the datasets to the schema.
DTS, SQL Server, T-SQL
DIA Passport System Upgrade
I migrated a large and complex system to the latest version of Visual Basic. The target environment was highly secure and the DCOM foundation on which the system was based posed considerable challenges. Detailed documents were required to satisfy the needs of the IT department and allow them to upgrade unassisted.
Visual Basic, MSXML, DCOM, MTS, SQL Server 7