James Harrod Email and Phone Number
James Harrod work email
- Valid
- Valid
- Valid
James Harrod personal email
I've automated a file processing application using C#, VB6 and ini files. I use Power Automate for Windows Task management and I enjoy automating programs and processing. I use Power BI for building simple interactive visualizations. I can use SSIS to create simple ETL processes.I have 15+ years experience analysing data in Excel from a variety of data sources including SQL and PostGreSQL. I’ve had 3+ years managing/optimising SQL server environments, using both SQL tools and a C# tool I developed.I have been in a few support positions where I managed different helpdesk environments, managed queries from logging to resolution and supported bespoke products.I enjoy developing applications in SQL, Excel and C#. I also like analysing data and automating data analysis processes.Specialties: VBA, T-SQL, Excel, Power Query, SQL Server, C# WinForms, Power Pivot, Power BI Desktop, Automation
-
Software DeveloperCgi Jan 2023 - PresentBristol, England, United Kingdom -
System DeveloperLatcham Dec 2014 - Nov 2022Bristol, United KingdomManage millions of records pertaining to sensitive personal customer data.Semi-automate report generation using Power Query, PowerPivot and VBA, with data pulled from SQL and PostgreSQL servers.Create and update SQL stored procedures, views and functions and write queries using CTEs, cursors and dynamic SQL.Manage and maintain 2 SQL servers, as well as disk space on a Windows server, using a C# console I developed.Developed and maintain a C# processing suite which automates file processing for multiple clients.Developed and maintain multiple standalone C# applications which analyse PDF, CSV and TXT files. This includes an SSIS package consisting of script objects written in C# and File System Tasks.Maintain code and versioning using TortoiseSVN -
Test & Support TechnicianMaximise It Apr 2013 - Nov 2014I developed VBA modules in Excel, Access, PowerPoint to assist with the support and testing of applications which the company develop and/or support.Created a data analysis tool in Excel. It connected to a SQL Back-End to pull data through and then generated charts using the data.Managed SQL back-end databases and wrote queries, views, functions, stored procedures and CTEs to manipulate data.Basic performance tuning using Execution Plans.Used SSIS for import/export/data manipulation and exposure to the ETL process.
-
Senior Data EngineerEhs 4D Sep 2011 - Apr 2013I wrote complex SQL statements to extract data for clients (including easyJet, Compare The Market and Barclays).Managed data loads and ensure daily checks are performed.Worked with different clients with varying requirements, ensuring strict deadlines are achieved.Identified where processes can be improved and/or automated to ensure smooth running of systems.Managed data uploads/downloads with ExactTarget and create/manage listsAs a senior, an important part of my role was to ensure work is done correctly before going to client services for sending to the client.I was involved with the segmentation of data for multiple clients for improving/maintaining customer retention. -
Data AnalystMerkle | Dbg 2007 - 2011Analysed incoming data from clients using SQL Server, T-SQL, Access, Excel, VBA and Visual Basic.Investigated ad-hoc queries from clients using T-SQL and Excel.Found ways of improving processes/procedures and automated where possible. I vastly improved the matching of DNM records by implementing a fuzzy-match routine.Managed/created indexes, tables and stored procedures, while maintaining and trouble-shooting SSIS packages.
-
Support SpecialistVizual Business Tools Mar 2006 - Feb 2007WorleBacked up/restored of SQL databases as well as user creation via SQL scripts.Used SQL DTS to import/export data.Created a VB6 application which automated the update of XML based configuration files with full change history and usage log.Trouble-shooter for front-end user problems in SQL Server using SQL Profiler.Ran update scripts against SQL tables.Analysed VB.NET error messages and examining .vb files to identify where problem originated.Worked with GoToAssist, SecuRemote and VPN Client. Setting up connections in SecuRemote and VPN Client.Set up/configuring virtual directories and creating websites in IIS 5.1
-
Software DeveloperWebhost Automation Sep 2005 - Jan 2006Performed updates, fixes and fully tested the product and its updates prior to release.Updates/fixes were made in the front-end ASP pages and as well as the VB6 back-end.Examined VB6 code to ensure correctness and that procedures were linked.Maintained project files in Visual SourceSafe, checking in and out when required.Created and maintained code that supported a DotNetNuke portal which operated alongside HELM 3.Liaised locally and remotely with support staff to implement development plans.Used Gemini and VMWare for my own project management and development testing.Used Microsoft Log Parser to assist with generating simple and complex SQL Queries from IIS log files -
Techincal Support ConsultantKoch Media Apr 2004 - Sep 2005BasingstokeProvided 1st / 2nd / 3rd Line helpdesk support for users of KOCH Media bespoke products.Maintained both the company’s’ online ASP and HTML based helpdesk website and internal helpdesk stats website.Created ASP pages that communicated with the SQL database to extract and show data.Created a VB application which assisted the use of the company’s’ High in the Sky product.Trained new helpdesk employees how to use the helpdesk system.Maintained customer data on SQL Server 2000 -
Accounts TraineeCoppid Beech Hotel Oct 2003 - Apr 2004BracknellEnsured all money from previous day was verified against the paperwork.Revenue Control: Ensured that business revenue from previous day was balanced
-
Kitchen PorterHorse & Groom Harvester Jan 1998 - Sep 2003BracknellEnsured food was prepared prior to service, assisting other members of staff with their jobs.Dealt with customer problems and provided support when required.Ensured that procedures were followed and assisted other employees where help was required
-
Office AdministratorGe Medical Systems May 2003 - Jul 2003Slough, United KingdomUsed Business Objects to create reports generated from customer accounts, and created PivotTables in Excel to examine the output from the reports.Assisted other members of the team as well as teaching the new employees how to use the system.Created a user manual for the system -
Office AdministratorLsi Logic Jun 2000 - Jul 2000BracknellUpdated customer databases.Interacted with other companies (By Phone, Fax & Email) to place orders.Backed up company data (NT System).Worked on company IT helpdesk
James Harrod Skills
James Harrod Education Details
-
Bracknell And Wokingham CollegeEnglish -
Bracknell And Wokingham CollegeBtec National Diploma In Computer Studies
-
Bracknell And Wokingham CollegeGnvq Intermediate In It
-
Brakenhale ComprehensiveEnglish Literature
-
Brakenhale ComprehensiveMaths Gcse
-
Brakenhale ComprehensiveGerman Gcse
-
Brakenhale ComprehensiveEnglish Gcse
Frequently Asked Questions about James Harrod
What company does James Harrod work for?
James Harrod works for Cgi
What is James Harrod's role at the current company?
James Harrod's current role is 10+ years Data Analysis experience using Excel, VBA and T-SQL. 2+ years experience using Power BI and SSIS.
What is James Harrod's email address?
James Harrod's email address is ja****@****o.co.uk
What schools did James Harrod attend?
James Harrod attended Bracknell And Wokingham College, Bracknell And Wokingham College, Bracknell And Wokingham College, Brakenhale Comprehensive, Brakenhale Comprehensive, Brakenhale Comprehensive, Brakenhale Comprehensive.
What skills is James Harrod known for?
James Harrod has skills like Microsoft Sql Server, Databases, Sql, Iis, Xml, T Sql, Analytics, Access, Team Management, Microsoft Excel, Html, Transact Sql.
Who are James Harrod's colleagues?
James Harrod's colleagues are Heather Jen Bauza, Acs, Khalid Elhmaini, Pierre-Julien Nogues, Nicola Graham, Nicholas Glaser, Benjamin Carter, Shane Green.
Not the James Harrod you were looking for?
-
James Harrod
Practitioner Account Manager At Yorktest Laboratories - Supporting Practitioners On Delivering Their Wellbeing JourneyEly2lorisian.com, yorktest.com -
-
James Harrod
London2bbc.co.uk, visa.com -
James Harrod
Kingston Upon Hull, England Metropolitan Area1wrenkitchens.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial