Lead developer with 4 years experience building data-driven web applications and workflow tools. Proficient with both Microsoft and open source platforms. Enjoying the current wave of developing Rich Internet Applications using whatever technology best fits the bill. Enjoy managing teams and getting jobs delivered. Awareness of Agile methods and Extreme Programming techniques.
Hobby project used to learn the ins and outs of Django, Apache and PostgreSQL. Built a simple but structured model for reviewing, linking, tagging and describing works of crime fiction. Made the site as Google-friendly as possible with descriptive URL's and a sitemap. An RSS feed provides updates to subscibers. Django did all the heavy lifting and made the project a pleasure to construct!
Tasked with prototyping a web based tool for quickly rating members of staff and allowing the various strata of management to find and review the success or failure of departments, teams and individuals within the organisation. Investigated various web, interface and data access frameworks to see which would give the best performance and user experience. Settled on Microsoft's recent MVC framework, jQuery for client-side styling and interface-building and LINQ for a versionable and performant data access layer. Made extensive use of xmlhttprequest calls to ensure the site was pleasing to use, and adopted client-side graphing, filtering and sorting tools to ensure data navigation was very speedy. Application reached a point where it was ready for demonstration to potential customers.
Led a team of three C# developers and one tester. Co-operated with many different departments of the bank, both technical and business-orientated. Undertook a detailed requirements analysis to quickly progress through the design stage. Built rapid prototypes to achieve stakeholder sign-off on the design. Structured the application to follow a 3-tier pattern to enable future scalability. Used NUnit to test the business logic layer and WinRunner to automate functional and performance testing. Site allowed clients of the bank to view old and new trades as they progress through their complicated life cycle. Reports were available in html, pdf and excel formats. A confirmation workflow allowed users to ensure trades matched their understanding of deals done and to request alterations in case of error. Application is currently live and has received various plaudits. Greatly improved client communications and also the efficiency of the confirmation process.
Used Analysis Services in SQL 2005, Proclarity Desktop Professional and C# to develop a data warehouse combining reports from Google Adwords, Commission Junction, Buy.At and TradeDoubler. Income and spend for tens of thousands of Google adverts were aggregated over time and numerous other dimensions. This data was then analysed in a series of MDX based views which allowed patterns to be detected, future trends predicted and the making of informed and timely business decisions. The project scaled up to allow the analysis of over a million keywords with data incoming on a daily basis.
Wrote a custom HTTPModule in C# to redirect clicks from Google Adwords to ultimate destination page and place a cookie in the client's browser. If the click converted into a sale then the cookie would identify the keyword which led to the sale via a parameterised 1x1 pixel image. All clicks and sales were logged in SQL 2005 which allowed for detailed analysis of click habits and profitable keywords. Used HTTP endpoints to provide a table dump web service and Reporting Services to track sales and queries.
Made use of triggers, views and stored procedures in SQL Server to host a database of current animation projects. Used junction tables to model many-to-many relationships between elements such as scenes and characters. A multi-user browser-based front end was created in C#/ASP.NET to allow viewing and manipulation of the data. Developed custom controls to condense complex data into small screen space. Application was used on every subsequent project at Passion Pictures, including the Gorillaz music videos, and greatly aided communication between workers and helped line producers keep track of progress.
Made use of built-in user interface SDK and Jscript to build a suite of file savers for all the file types present in a Softimage XSI 3D project. The savers preserved the history of each file while also ensuring that the most current file had a predictable filename and location. This facilitated the smooth collaboration of many specialist artists working on the same scene simultaneously and thereby improved efficiency. Saved license cost of investing in high end AlienBrain Studio software.
Prototyped a hierarchical database of company contacts in SQL server. Implemented SQL Views allowing for a contact to be viewed either through their freelance skills or their employer. This made it easy to have a unified list of everyone associated with the company, rather than disparate databases in different departments. Also meant that Christmas Party invites and PR mail-outs could be handled by the same system, rather than individually by hand. A tree-based HTML navigation system was devised in C#/ASP.NET to allow for ease of access.
Designed and implemented a 45 machine render farm to output high resolution images from 3D render engines and 2D compositing programmes. Chose the hardware and infrastructure, customised the management software with a host of scripts and authored render submission helpers for three different clients. All rendering was managed by a single management system making the most efficient use of all the facilities and preventing a render from overriding another. Meant that jobs could be delivered on time and to a good quality in terms of image resolution, anti-aliasing and motion blur.
Used the ebay web services API to download and cache images and information relating to a sellerís list of items for sale. Data was presented in a table and summary info was calculated so the profit and unsold balances could be quickly inspected. User interface built in WinForms using Visual Studio 2005 and downloaded data serialized into XML files. Application gets round the 30 day limit imposed by ebay for publicly displaying previous sales. Useful for keeping an eye on competitors and tracking oneís own sales history.