$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
A Specialist Generalist, C++ or VBA, C# Or T-SQL, or even create a programming language for the task
Ian Smith
,
Worcester, United Kingdom
Experience
Other titles
Skills
I'm offering
I am an older programmer who started his working life writing assembler on a 1MHz 8 bit microprocessor with 256 bytes of RAM.
At the other end of the technology scale recently I wrote a C#, WinForms, ASP.Net, Web Forms, WCF system creating and fronting an SQL Server databases with 500 million plus rows, which was used to manage email marketing campaigns of millions of emails per month.
People who needed the power and flexibility had a desktop app, others who only wanted to see “results on an iPad” had a web app and some people who needed to access to the raw data has WCF web REST services (APIs).
In the middle size wise, I wrote a full cycle EDI administration and quotation system for household and motor insurance using MS Access/VBA to provide a front end to an SQL Server database and a C++ quotation engine.
At the other end of the technology scale recently I wrote a C#, WinForms, ASP.Net, Web Forms, WCF system creating and fronting an SQL Server databases with 500 million plus rows, which was used to manage email marketing campaigns of millions of emails per month.
People who needed the power and flexibility had a desktop app, others who only wanted to see “results on an iPad” had a web app and some people who needed to access to the raw data has WCF web REST services (APIs).
In the middle size wise, I wrote a full cycle EDI administration and quotation system for household and motor insurance using MS Access/VBA to provide a front end to an SQL Server database and a C++ quotation engine.
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Available
My experience
1998 - 2020
job
Self Employed
Self Employed.
Wrapped Around Contracts
Contracts, Contracts
2014 - 2018
temp
Contract Position Developing and Supporting mail marketing system
Data Resources.
• Developed Larger SQL Server database, 750GB database, some tables over 500 million rows with email marketing details, emails sent, response, how soon, what device mail client etc. hosted on Azure. Extensive use of T-SQL and Stored Procedures, some use of .Net/CLR User Defined Functions.
• Display front end for sales force in C# ASP.Net and C# Web Forms, some MVC/Entity frame work but they weren't well suited to databases of this size where each query uses significant resources.
• Administration front end for most office bound people in C# Win Forms.
• Various web services to query this database in WCF, C# ASP.Net.
• Various batch processing tasks in C# Console App (desktop).
• Source code control via GIT
• Display front end for sales force in C# ASP.Net and C# Web Forms, some MVC/Entity frame work but they weren't well suited to databases of this size where each query uses significant resources.
• Administration front end for most office bound people in C# Win Forms.
• Various web services to query this database in WCF, C# ASP.Net.
• Various batch processing tasks in C# Console App (desktop).
• Source code control via GIT
Web Services, Processing, App, Server, Web, Office, Net, WCF, Sales, T-SQL, Stored procedures, MVC, SoMe, Marketing, Database, ASP, C, Azure, ASP.NET, SQL Server, Email marketing, Administration, .Net, Git, Sql
1998 - 2017
job
Contractor
Own Brand Products And Minor Contracts.
• I do a lot of work with Clients generated from Elance.com and similar freelance sites, these tend to be smaller projects in pretty much any language, C++, C#, VB.Net, VBA, desktop or web based.
• Applications sold under my own name
• PerBI a "Personal business intelligence" product in Visual C++ with a small amount of Pentium Assembler dumping the .cpp and .h files gives a total of about 96,000 lines. This has always been developed in the current version of Visual Studio including 2008. (http://www.PersonalBusinessIntelligence.co.uk)
• IPL a programming language aimed at people with a casual interest programming on a Windows PC and written in Visual C++, dumping the .cpp and .h files gives a total of about 38,000 lines. (http://www.InitialProgrammingLanguage.co.uk)
• Loyalty Manager a small business Loyalty Card program and Assessor a unified pupil assessment recording program aimed at school teachers. These are smaller projects in Access and VBA.
• Developed a small range of promotional software, that could be personalised like a mouse mat or a pen using Visual C++/MFC.
• Creating a small range (two) of "shrink wrapped" web sites in Classic ASP, for Recruitment Consultants and Loyalty Scheme Management), these are now obsolete.
• Sometimes you just have to stop being serious http://www.buyaghost.co.uk/ which is an also advert for IPL via a download of a pacman type game.
• Applications sold under my own name
• PerBI a "Personal business intelligence" product in Visual C++ with a small amount of Pentium Assembler dumping the .cpp and .h files gives a total of about 96,000 lines. This has always been developed in the current version of Visual Studio including 2008. (http://www.PersonalBusinessIntelligence.co.uk)
• IPL a programming language aimed at people with a casual interest programming on a Windows PC and written in Visual C++, dumping the .cpp and .h files gives a total of about 38,000 lines. (http://www.InitialProgrammingLanguage.co.uk)
• Loyalty Manager a small business Loyalty Card program and Assessor a unified pupil assessment recording program aimed at school teachers. These are smaller projects in Access and VBA.
• Developed a small range of promotional software, that could be personalised like a mouse mat or a pen using Visual C++/MFC.
• Creating a small range (two) of "shrink wrapped" web sites in Classic ASP, for Recruitment Consultants and Loyalty Scheme Management), these are now obsolete.
• Sometimes you just have to stop being serious http://www.buyaghost.co.uk/ which is an also advert for IPL via a download of a pacman type game.
Net, Manager, Cpp, Vb, PC, Web, Http, Software, Mfc, Assembler, Assessment, .Net, Windows, Recruitment, Visual Studio, Management, Vb.net, ASP, C, VBA, Business Intelligence
1999 - 2008
temp
Bolton - Part time
Broker Direct plc.
(£300-£500 p/day)
• During this time I wrote the EDI, Quotation and Policy management side of a full cycle EDI admin system for Household and Private Car insurance
• The admin and Edi system were based on Access/VBA against SQL Server 7/2000 and SQL Server 2005. Very roughly my bits of VBA code total up to 241,000 lines including comments but excluding blank lines.
• The motor and household quotation system was a C++ COM object and an Access tool that generated C++ code for regular updates.
• The database had about 2.5 million policy records, which means that some tables have grown to about 12million rows, all data access is via stored procs and there is a fair amount of T-SQL used for data movement. All tables had non indexed copies which provided audit trails with triggers on update&delete
• We used Word under Automaton to produces Point Of Sale documents and some Excel/VBA to manage test packs.
• Various internal use applications were browser based around VB/ASP.net but running on the internal network not the internet.
• During this time I wrote the EDI, Quotation and Policy management side of a full cycle EDI admin system for Household and Private Car insurance
• The admin and Edi system were based on Access/VBA against SQL Server 7/2000 and SQL Server 2005. Very roughly my bits of VBA code total up to 241,000 lines including comments but excluding blank lines.
• The motor and household quotation system was a C++ COM object and an Access tool that generated C++ code for regular updates.
• The database had about 2.5 million policy records, which means that some tables have grown to about 12million rows, all data access is via stored procs and there is a fair amount of T-SQL used for data movement. All tables had non indexed copies which provided audit trails with triggers on update&delete
• We used Word under Automaton to produces Point Of Sale documents and some Excel/VBA to manage test packs.
• Various internal use applications were browser based around VB/ASP.net but running on the internal network not the internet.
Management, SQL Server 2005, UP, Vb, Audit, Server, Internet, EDI, Insurance, Net, Network, Test, T-SQL, Excel, SoMe, Database, ASP, Word, C, VBA, Audit, ASP.NET, SQL Server, .Net, Sql
1988 - 1993
job
Internal developer/IT Supervisor
unknown.
1988 -1993 (with a break) Misys
• Development of EDI module for their Insurance Broker admin system in BCPL under Tripos
• Internal developer/IT Supervisor using BOS Cobol under BOS and Informix i4gl/Standard Engine under RiscOs (Unix).
• Development of EDI module for their Insurance Broker admin system in BCPL under Tripos
• Internal developer/IT Supervisor using BOS Cobol under BOS and Informix i4gl/Standard Engine under RiscOs (Unix).
Unix, Cobol, It, Developer, Insurance, EDI, Development
1988 - 1988
job
Z-80 assembler
Mitronix.
with emphasis on Brokernet EDI.
EDI, Assembler
1979 - 1981
job
Assembler
Dynamic Logic.
Exposure To
• I have looked at WPF Windows Presentation Foundation so am familiar with it but I haven't built a commercial product using it.
• I have very, very limited Xamarin experience, enough to have done simple build and deployment to a real Android device. The iOS build never took place as I don't have a Mac.
• Blazor/Razor is often promoted as a new idea but the reality is that once you move beyond the trivial, many ASP.Net web forms often build some or most of the content in PageLoad() and the populate an <asp:literal> with it.
End of document
• I have looked at WPF Windows Presentation Foundation so am familiar with it but I haven't built a commercial product using it.
• I have very, very limited Xamarin experience, enough to have done simple build and deployment to a real Android device. The iOS build never took place as I don't have a Mac.
• Blazor/Razor is often promoted as a new idea but the reality is that once you move beyond the trivial, many ASP.Net web forms often build some or most of the content in PageLoad() and the populate an <asp:literal> with it.
End of document
Xamarin, Web, Assembler, Razor, Net, It, Content, Windows, Wpf, .Net, SoMe, Mac, ASP, Deployment, ASP.NET, IOS, Android
Ian's reviews
Ian has not received any reviews on Worksome.
Contact Ian Smith
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Ian directly in Worksome.
38100+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark