Neville Smith – Personnel Details
Contact Details
Telephone:(office) 0141 779 2292(mobile) +44 07904 241720
E-mail:b:
Preferred locations:Glasgow, Edinburgh, Stirling and London
Primary Technologies
Microsoft: .Net web (ASP.Net and ASP.Net MVC), windows(winforms and WPF) and Silverlight development;comfortable with both C# and VB.Net (and VB and C++). SQL Server and Oracle database design, development and tuning: SQL, T-SQL, and PL/SQL. Microsoft Business Intelligence: DTS, SSIS, SSRS, and SSAS.
I have developed Windows, ASP.Net, MVC and Silverlight solutions, and I have also migrated older applications to newer technologies, e.g. ASP.Net to MVC and winforms to Silverlight (XAML/WPF). In addition I have worked on a number of both large and small BI projects using SSIS, SSRS, SSAS, advanced T-SQL and PL-SQL, and intensive database and query tuning. I have over 15 years of experience with most aspects of Microsoft technologies and essential associated technologies (HTML, jQuery, javascript, Oracle back-end, Subversion, PVCS, GIT, nHibernateetc.). I am also conformable and enjoy working on mathematically intense projects such as quantitative analysis, 3D transformation algorithms, standard numerical analysis techniques, statistical analysis, etc.
I am open to both long and short-term contracts – I often undertake short but highly time critical work with clients needing to urgently solve often mixed environment (DB/BI/code) problems.
Education
B.Sc. Computing ScienceUniversity of Essex
M.Sc. Computing Software and System DesignUniversity of Newcastle
Ph.D. Colour Science (3D non-Euclidean transformation algorithms)University of Teesside/Newcastle
Professional Qualifications
MCPD: Enterprise/Web/Windows Application developerVisual Studio 2005, 2008 + 2010
MCSD: Microsoft Certified Solution DeveloperVisual Studio 97 (VB6) + 2002/3
MCTS: Silverlight 4 DeveloperSilverlight 4
MCITP: Database Developer (Advanced T-SQL)SQL Server 2005 + 2008
MCITP: Business Intelligence (SSIS, SSRS, SSAS)SQL Server 2008
Oracle SQL and developing PL/SQL Program Units1Z0-001 and 1Z0-101
Experience MatrixYears
.Net:C#, VB.Net, .ASP.Net, .Net (1.0 to 4.5) andXAML/WPF7
BI:ETL, SSIS, SSRS, SSAS, DTS, and Crystal Reports4
Silverlight:3.0 (Beta + release) and 4 (Beta + release), XAML and MVVM1.5
n-Tier:WCF, COM+, MTS, Component Services, MSMQ, and Web Services5
Senior roles:Technical architect, analyst, and designer (Rose, Visio, DSDM, etc.)3
Optimisation:Database, system architecture, object, and user interface2
ASP.Net MVC:ASP.Net MVC 1+2, jQuery and Javascript0.6
Windows:Webforms, WPF, XAML and MVVM.4
Web:HTML, Javascript, JavaControlToolkit, CSS, IE, Firefox, etc.4
SQL Server:Database design/modelling, SQL, T-SQL and performance tuning10
Oracle:Database design/modelling, SQL and PL/SQL7
Financials:Mortgages, risk analysis, quantitative analysis, asset managementetc.3
TDD:CastleWindsor, RhinoMocks and Unity (all within Finance)1
Contract History: 1997 to 2013
2013Jul – 2013 SepWPF/XAML and SSIS/SSRS DeveloperThe Weir Group (Glasgow)
I worked on two projects at Weir split 50/50: developing a new WPF application to scan and process Excel documents, and designing, developing, populating and reporting on a data warehouse and cube unifying invoicing data from the 60 companies that comprise the Weir Group. Extremely tight deadlines with prompt delivery of accurate solutions essential. Usual C# coding techniques: OO, Excel Interop, multi-threading, customized generics, extension methods, etc., WPF and XAML. SQL, SSIS, SSRS and SSAS for data warehousing and cube design, population and reporting.
WPF, XAML, C#, MVVM, VS2012, SSIS, SSRS, SSAS and SQL.
2013Mar – 2013 AprASP.Net and jQuery developerNorthgate (Glasgow)
Working with Northgate on their Athena project porting an existing traditional winforms application by changing the large and frequent post backs to AJAX post backs and moving the C# control handler’s interactions from the server (code behind) to client side with extensive use of jQuery, JSON and AJAX. Note 2 month contract: I and four others were brought on 8 weeks before scheduled UAT to try and return the project back to its scheduled delivery date. Note Northgate bought the public sector business from Anite (who I had contracted for in 2004).
ASP.Net, C#, jQuery and Javascript, AJAX and JSON.
2011Oct – 2013FebSSRS/SSIS/SQL Server developerGlas. Cal. Uni. (Glasgow)
Direct liaison with Glasgow Caledonian University senior managers on the design and build of Sharepoint hosted custom SSRS reports on their core student administration system (SQL Server 2008 R2 – replicated from live). Approximately 70+ core reports covering the university’s finance, administration, planning and UK Border Agencies compliancedivisions including tabular, matrix, drill-down (hyperlink) and sub- (embedded) reports. The two core databases contained over one thousand tables each originally sourced from non-relational flat-files - the database contained no referential integrity and only around 20% of the tables had primary keys: the resultant stored procedures were often (as a consequence of this) extremely complicated and required to be highly optimised. Extensive use of advanced SQL techniques: scalar and tabular UDFs, indexed views, triggers to capture deleted data so it could be reported upon (the only way to track changes made by the third-party software), index detection and creation, CTEs, etc. Around 10+ SSIS jobs to load data into the system from Excel, CSV, flat-file and XML sources including C# scripting components to cleanse and supplement the data, and four windows applications (C#) to perform ancillary tasks. Development of standardised UDFs for the ETL process. [2/2 – previously migrated data into this system using SSIS in 2008 from legacy system – see earlier contract]
SSRS and SSIS2005/2008, SQL Server 2008 R2, and C# (windows development).
2011Mar - SepFront-office (analysis, design and build)Ignis Asset Mgmt (Glasgow)
Direct liaison with senior traders to provide analysis, design and build of a decision planning system for quantitative investment for approximately £30bn portfolio of funds. The system enables senior traders to specify house rules (broad, regional, country, etc.), benchmarks, exclusion mandates and fund specific rules to calculate target positions for all Ignis managed funds based on custom target calculation and breach resolution algorithms. Feeds from fund management systems (including ThinkFolio) provided actual positions of the funds including support for collectives, sub-funds and ACI funds; the difference is used to determine how the funds deviate from their target positions. The system then proposes trades (collectives, futures and direct stock) for funds with one or more deviations in excess of a user definable threshold (at the broad or regional level – either system wide or at the fund level) that balance the fund to zero or to a user-defined target deviation (either system wide or fund specific). Functional specification was developed by me and another team member from direct liaison with the senior trader; and the system was developed in ASP.Net (C#), WCF, and SQL Server using Agile practices with demonstrations of progress on a daily to weekly basis. [2/2 – company previously known as Britannic Asset Management].
VS2008, ASP.Net, C#, WCF, NHibernate, SSIS, SSRS, CastleWindsor, RhinoMocks, AJAX Controls Toolkit and SQL Server 2008.
2011 Apr – JulySilverlight 4 DeveloperUnifiedFX (Glasgow)
Development of a CISCO phone endpoint management system allowing near real-time interaction with a range of CISCO phone models: see what the user sees and activate any phone button remotely. Silverlight 4 OOB application coded in C# with XAML animation and asynchronous communication with device's IP address.
Silverlight 4, C#. .Net 4.0, XAML
2010Aug - DecASP.Net MVC 2.0/BI DeveloperBrewin Dolphin (Edinburgh)
Design and development of financial applications built using ASP.Net MVC2 (C#) and embedded (local) SSRS reporting, jQuery, nUnit, and Unity; SOA architecture based on WCF services. Loading and extraction of corporate actions data to/from Advantage and CAPS using SSIS with SQL Server databases and CSV flat files.
VS2008, ASP.Net MVC 2.0, C#, WCF, SSIS, SSRS, jQuery 1.4.x, nUnit, Unity, and WebServices.
2010May - AugASP.Net MVC 1.0 DeveloperStandard Life (Edinburgh)
Front-end development of Standard Life’s (FNZ) Open WRAP system in ASP.Net MVC with RESTFul web services to the domain. ASP.Net MVC solution with IoC via Castle Windsor: pages built using HTML, jQuery, AJAX post-backs and Fluent extensions, unit testing using xUnit and Rhino Mocks, GIT source control and continuous build using Nant and Team City.
VS2008, ASP.Net MVC 1.0, jQuery 1.4.x, AJAX, JSON, Castle Windsor, xUnit, Fluent, GIT and RESTFul Svcs.
2010Mar + 2011 FebMS Windows DeveloperStudent Loans (Glasgow)
[2010 March] Five week fixed price contract extending their timesheet system and porting the system to VS2008 and Oracle 10. [2011 February] Four week fixed price contract extending the reporting tools, VBA work and providing training on Oracle installation. System was originally designed and developed by myself in 2006/7. [2/2]
VS2005/8, VB.Net, Oracle 8/10, and Excel VBA 2002/2007
2009Jul – 2009AugMS Web DeveloperScottish Widows (Edinburgh)
Design and development of a web tool to provide flexible regular expression searching of Word, Powerpoint and Excel documents hosted within Microsoft Sharepoint using a web application and VSTO. [2/2]
VS2005, C#, ASP.Net, Visual Studio Tools for Office, Exce/Word/Powerpoint VBAand IIS
2009Apr – 2010AprSilverlight 3/4 DeveloperVirtual Color Systems (USA)
Port of a mathematically intensive graphical .Net winforms (VS2002) application to Silverlight 3.0 and then to Silverlight 4 (Toolkit Nov09) using Visual Studio 2010 Beta 2/Release and .Net 4.0. [2/2]
VS2008 and VS2010, C#, Silverlight 3.0 and 4, (dynamic) XAML and LINQ
2008 Oct – 2009MarMS Web and Windows DeveloperCIGNALife (Glasgow)
Design, development and support of .Net ASP.Net MVC web and windows applications: Absence recording system (ASP.Net), Billing and invoicing System (ASP.Net), and older VB6 and classic ASP applications. Significant security analysis and upgrades to their international corporate websites. DTS and SSIS applications interfacing to and from SQL server with AS400 and Oracle. [2/2]
VS2005, C#, VB.Net, ASP.Net, MVC Beta to 1.0, WinForms,VB6, classic ASP, SQL 2005,DTS, and SSIS
2008 June – 2008 SepBusiness Intelligence and InterfacesGlas. Cal. Uni. (Glasgow)
Specification, design and development of SSIS packages and support systems for data migration (Oracle to SQL Server), data cleansing, and interfaces to ancillary systems for a Student Records and Finance system at Glasgow Caledonian University. Extensive use of complex SSIS packages interfacing to Oracle, SQL Server and files. [1/2]
SSIS, VB.Net, Oracle 10g, SQL Server 2005, ASP.Net and IIS
2007 May – 2008 MayFinance, Web and BI DeveloperSWIP (Edinburgh)
Front office support and solution architecture forXEC (XIP Enterprise Compliance) and ThinkFolio financial compliance systems including Moodys, Fitch, S&P, and Bloomberg integration. Design and development of ETL process to load data from web services, SQL Server, XML sources, FTP flat files, and Advantage into SWIPs OLAP system. Security architecture and development of a management analysis and reporting system using SQL Server Business Intelligence tools: integration, reporting, and analysis services; ASP.Net front-end utilising web services to SSIS and DataStage. Security, Technical Design, and Implementation Plan document preparation.
VS2005 (C#web app and services), SQL Server 2005, SSIS (VB.Net), SSRS, SSASand IIS.
2006Oct – 2007AprWindows Developer (Banking)Student Loans (Glasgow)
Design and build of an integrated timesheet, client billing and finance system with extensive Excel VBA and windows forms front-end with asynchronous business logic. Design, build, maintain, and tune Oracle database. [1/2]
VS2005, VB.Net, WinForms, ADO.Net, Excel VBA, TOAD, and Oracle (development and DBA work).
2005 Aug – 2006 OctWeb Developer (Insurance)CIGNA Life (Greenock)
Re-architecture of two Microsoft enterprise web applications (VB6/classic ASP port to Asp.Net). Analysis, design, and build of an enterprise level ASP 2.0 absence recording system including web service design, build, and security. [1/2]
VS2005, ASP.Net, C#, VB.Net, VB6, classic ASP, Crystal Reports, XML, XSD, SOAP, WSE3.0 and SQL 2000.
2005 Jul – 2005 DecWindows/BI Developer (Finance)Martin Currie (Edinburgh)
Analysis and development of data loading systems to securely upload and cleanse financial data utilising a VB.Net front-end and a SQL Server back-end (including DTS interfacing to Excel, encryption, and FTP). Analysis and development of a windows based production control workflow tracking system in C#.Net.
C#, VB.Net, ADO.Net, WinForms, SQL Server 2000, DTS, and Excel
2005 May – 2005 JunWindows Developer (Public Sector)NHS (Glasgow)
Migration and performance tuning of windows forms based clinical systems from VB6 to VB.Net and architectural analysis of a third party system.
VB.Net, VB6, SQL Server 2000
2005 Feb – 2005 AprWindows Developer (Graphics)Virtual Color Systems (USA)
Design and development of a graphically and mathematically complex windows-based graphical modelling system with extensive graphics and mathematical programming (3D non-Euclidean interpolation and extrapolation algorithms (port from MS C++ to .Net) [1/2]
VS2005 (Beta 2), C#, ADO.Net, WinForms, and SQL Server 2000
2004 Jun – 2004 DecWeb Developer (Finance)Data Explorers(Edin.)
Design and development of enterprise web based financial analysis tools to monitor the performance and profitability of clients’ securities lending activity: share price reporting, commodity trading analysis, and risk analysis. Front end, including custom web control development, and web services in ASP.Net using C# with a back-end SQL Server 2000 database.
C#, ASP.NET, Web Services, Web Controls, Javascript, XML, XSD, SOAP, WSE2, and SQL Server 2000.
2004 Apr – 2004 MayBusiness Analyst (Public Sector)Anite (Glasgow)
Analysis and Design of Scottish Prosecution Service support system.
Visio and design document preparation.
2003 Oct- 2004 JanWindows Developer (Banking)Scottish Widows (Edin.)
Re-architecture and performance tuning of their live VB6 business critical mortgage banking system; this included liaison on business requirements with users, the performance tuning of the client applications, the re-architecture of the middle-tier components, and DB de-normalisation, tuning and query optimisation. [1/2]
VB6, MTS, XML, and SQL Server 2000.
2002 Jun-2003 SepWindowsDeveloper (Retail)COOP (Newcastle)
Business analysis, system architecture design, and software development of two n-tier (one VB6 and one Vb.Net) enterprise applications: a pricing system and a contracts tracking system using Component Services/MSMQ middle tier, SQL Server 2000 back-end, and Cognos Impromptu reporting.
VB.Net, VB6, COM+, Rational Rose, Cognos Impromptu, and SQL Server 2000.
2002 Feb - 2002 AprWeb Developer (Manufacturing)SANMINA-SCI (Irvine)
Business analysis, design, software development, and test of an Intranet hosted document storage system utilising SQL Server 2000 back-end, VB6 middleware, and ASP front-end.
VB6, InterDev, ADO, COM, SQL Server 2000, and classic ASP.
2001 Mar- 2001 SepWindows/BI Developer (Utilities)Northern Electric (Newcastle)
Software development of an N-tier pre-payment electric metering system, VB6 front end and MTS middle tier, SQL Server back-end database, and report writing using Crystal Reports.
VB6, ADO, COM, MTS, Crystal Reports, and SQL Server.
2000 Sep-2001 Feb:Web Developer (Finance)Britannic Asset Mgmt (Glas.)
Requirements gathering, business analysis, design and development of a financial service company’s intranet utilising ASP/HTML front-end, VB6 MTS hosted business logic, and SQL Server back-end including database design,tuning, maintenance, and administration. [1/2]
VB6, ADO, MTS, XML, ASP, Rational Rose, and SQL Server design.
2000 Jan- 2000 Aug:Windows Developer (Utilities)RealTime Eng. (Glasgow)
Design and development of an n-tier NETA compliant energy trading system based on a VB6 front-end and Oracle back-end; including performance tuning of Oracle database and VB6 code.
Oracle, VB6, ADO, COM, DCOM, MTS, ASP, and Rational Rose.
1999 Sep- 1999 DecWindows Developer (Retail)Sock Shop (Cumbria)
Design and development of a client-server warehousing, stock control, and invoicing application based on a VB6 front-end and SQL server database with reporting facilities developed using Crystal Reports; included extensive SQL Server development DBA responsibilities and database performance tuning.
VB6, ADO, COM, Crystal Reports, and SQL Server 7.0 development DBA.
1999 Jun- 1999 AugWindows Developer (Manufacturing)Solectron (Dunfermline)
Design and development of production line support systems for a major electronic component manufacturer developed using Visual Basic, SQL Server, and Crystal Reports.
VB6 (ADO/DAO), Crystal Reports, SQL Server 6.5/7.0, Excel 97, and BarOne.
1999 Feb- 1999 MayWindows Developer (Finance)Countrywide Loans (USA)
Development of a USA-wide mortgage-banking system with a Visual Basic front-end, Visual C++ MTS hosted middle-tier, SQL Server back-end, and utilising XML for data transfer.
VB6, COM, ADO, XML, SQL Server, and Visual C++ 5.0.
1997 Sep–1999 JanWindows Developer (Transport)British Airways (Newcastle)
Analysis, design, and development of a fuel-tankering planning system and a flight-crew management system.
VB5 (COM/RDO/ADO/DAO), Oracle 7.x (SQL, PL/SQL and Pro*C), and DSDM.
1