Colin Pickup Email & Phone Number

Home Based

London, United Kingdom

providing services to public and private clients.

London, United Kingdom

London, United Kingdom

owner of ILCRG Ltd started in March 2012 - Consultant to European Space Agency on behalf of Terma B.V- July 2010 started London IT Consultancy Ltd to work on website integration for ILC.Currently building websites for recruitment industry to capture candidate registration details and display current jobs - this involves the building of a CMS and all data held in Goldmine databasedotVacancy is a bespoke website for the recruitment industry - have worked on integration and testing of dotVacancy webservice with Goldmine (sql stored procedure written to copy data Goldmine database after a candidate; updating of existing Goldmine data is allowed for in SP. Have written applications to extract text from .doc,.docx,,pdf ,.txt files - text added to database and becomes searchable via a Full Text Search. Regular expressions have been used to extract email address from CVs, only CVs with readable email addresses added to database. Highlighting keywords in text is provided following a full-text search of CV. Initial work done on existing applications: Fixed errors in ASP.NET (C#) websites and fixed errors in SQL coding (typically triggers that clash). Integrating and installation of Goldmine with new website and carried out extensive testing. Installing Goldmine SQL Server 2008 and Crystal Reports into new server. May 2010: Looking for new job, agreed to join ILC in June and working on private projects

London

London, United Kingdom

Providing consultancy to European Space Agency on behalf of Terma B.V.

Sage CRM consultant at Uniq Systems - helpdesk, consultancy, customisation of CRM including coding in asp, training and project management

I have developed a stored procedure to insert data from a dotVacancy webservice and load the data into a Goldmine database. additional work involves building full ASP.NET for fast searching of candidate CVs. London IT Consultancy Ltd was founded 2010 for providing IT consultancy. Current projects include building an ASP.NET website for an EU government agency, the data captured from the website (also built by this consultancy) is stored in Goldmine. Have written several C# applications that addon to Goldmine and extend its functionality.

Sage CRM developer and consultant including providing training in use of CRM to clients

Role involved observing business processes and recommended / developed ways of improving processes using IT. I have developed a number of C# web applications which are being used in the office. I have written a number of SQL scripts that have been used to cleanse data and update existing database. Advised on CRM implementation. Used SalesLogix extensively. During this period I created several C# applications notably for exchanging XML data with a remote server and uploaded spreadsheets to SQL Server then analysing the data by looking for matches with data already stored in the database. I also did a lot of importing / exporting of data to /from SQL Server. I also created .NET web applications in C# to compare 2 database tables, this involved writing several stored procedures that were called from within the application, the results were output to an Excel spreadsheet and GridView.

Involved extensively in SQL Server programming for data analysis and data uploading (including writing scripts for the following: cursors, triggers and stored procedures). I also work closely with clients in order to help them obtain the best possible performance from their CRM system (Sage CRM or Goldmine

advising on SEO matters some web development and SQL Server database management.

COR provide a suite of software solutions to the banking and asset management communities.Responsibilities:Supporting COR java based software and COR clients, this involved a high level of technical faultfinding, programming and customer service.Python scripting used to develop analytical tools for clients in investment banks. An extensive suite of analytical programs were developed for a major client in the City and for US banks based in Canary Wharf. This often involved using an API to extract financial data from a Versant database. Jython coding to supplement or replace Python .Developed utilities in Java for COR's software solutions.Used Excel extensively for analysis of financial dataVersant database administration, including installs, upgrades, data loading/migration, general housekeeping and troubleshooting.Responsible for technical authoring of user guides, help files and training manuals in addition to maintaining a fully documented history of support and testing issues such as Help documents and Eclipse User Guide.Used VB6 and VBA to support data analysis.SQL Server for data storage and retrieval including TSQL scripting.

Working on a self employed basis, providing consultancy to public organisations and SME's.ProjectsDeveloped a client contact form (ASP and VB Script) that auto-populated an MS Access database (SME).Built an e-commerce website using ASP and VBScript (SME).Delivered user training on a variety of software packages, Shooters Hill 16+ College.Database population and basic administration.

Aleff provide multimedia information and training materials in the fields of life science and of information and communications technology.Responsibilities:Developing multimedia based learning and training materials (Dreamweaver and HTML).Developing e-Learning websites (Visual Basic 6, ASP, JavaScript, HTML, XML, MS Access and ODBC connections); Responsible for project and client management (UK and USA based).Managed the quality and integrity of information and scientific data from client and other sources.Internal advisor on educational and scientific matters.

Taught UK national curriculum for Physics and Computer Studies (including Visual Basic as part of the programming module).Developed Visual Basic applications to aid in administrative duties.Developed eLearning applications, mainly Q&A utilities (developed using JavaScript and Visual Basic)

taught physics from Key Stage 3 to A level

taught physics from Key stage 3 to key stage 4

worked on Asyst programming, Amorphous silicon research particularly time of flight measurements and absorption spectroscopy

developed automated frequency domain measuring system (based of a Frequency Response Analyser), to examine the low frequency a.c. response of amorphous silicon - measured the frequency shift of spectral features to determine the activation energy of the process - this fundamentally investigated the dielectric relaxation processes within the amorphous silicon.

worked on optical absorption of materials

Phd, Physics

Research into the dielectric relaxation of semi-insulating GaAs to detect deep levels in substrate

Diploma, Business Programming

Phd Solid State, Physics

Bsc, Physics

Bsc; A' Levels, Physics; Physics, Pure And Applied Mathematics, General Studies

8 O' Levels including English Language and Mathematics.