Логотип Freelancer Як це працює Пошук роботи
Увійти Реєстрація
Опублікувати проект
ВІДКРИЙТЕ ДЛЯ СЕБЕ
C# Programming
Data Processing
Excel
SQL
Visual Basic for Apps
Фото на обкладинці профілю
Тепер ви підписані на
Помилка підписки на користувача.
Цей користувач не дозволяє слідувати за ним.
Ви вже слідуєте за цим користувачем.
Ваш членський план дозволяє мати не більше 0 підписок. Покращити рівень членства можна тут.
Успішно відписалися від
Помилка під час скасування підписки на користувача.
Ви успішно рекомендували
Помилка рекомендування користувача.
Щось пішло не так. Будь ласка, оновіть сторінку та повторіть спробу.
Електронну адресу успішно верифіковано.
Аватарка користувача
$40 USD / год.
Прапор UNITED KINGDOM
london, united kingdom
$40 USD / год.
Зараз тут 9:17 дп
На сайті з квітня 5, 2012
0 Рекомендацій(-ії)

Michael C.

@mrchambers

 5,0 (6 відгуки(-ів))
4,0
4,0
100%
100%
$40 USD / год.
Прапор UNITED KINGDOM
london, united kingdom
$40 USD / год.
100%
Завершених робіт
100%
В межах бюджету
100%
Вчасно
17%
Рейтинг повторного найняття

Application Consultant

My core skills are * VBA macro coding (Mac & Windows) in Excel, Word & Access incl. web integration * Access Databases (tables, queries, forms & reports) and SQL queries more generally * C#.Net coding of Windows Desktop Applications and Excel-DNA add-ins * Web scraping data including from JSON or XML via restful API s / POST requests * Pdf conversion to Word , Excel or Powerpoint using professional software I have retired from full time employment in the roles of Project Management and Business Consultancy. * Experience of full project life cycle for software development - from specification through development, testing (including documentary evidence), deployment, commissioning and ongoing support. * Native English speaker with ability to produce high quality written documents * Flexible availability to meet client deadlines Although I have only a minimal job history on this portal, I have been working on upwork (originally known as odesk or elance) since 2012 and have a 100% job satisfaction score there after 250+ jobs and over USD 40k earnt.
Freelancer Data Processing Executives United Kingdom
Переглянути всіх Data Processing Executives в United Kingdom

Зв'яжіться з Michael C. щодо вашої роботи

Авторизуйтесь, щоб обговорити деталі в чаті.

Портфоліо

5916121
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
5916117
The objective was to create a user friendly front end with underlying VBA code that automated the actions required to search through a list of SEO keywords from SEMrush, and move them to category specific worksheets. All code was to be both PC and Mac compatible.
Excel Sorting SEO Keywords
5916114
The requirement was to merge a list of pdf files selectable via an Excel form into a single pdf file. The approach adopted was to write an Excel addin in C#.Net making use of the Excel-DNA framework, and the PDFSharp library for pdf operations. The pdf merge functionality was made available to Excel as a user defined function =MergePdfFiles(file_list) and via a COM interface. The PDFSharp library was built from the latest source code, and a C#.Net library was written to contain the merge fucntionility which calls the PDFSharp library. Both libraries were packaged into an Excel-DNA xll file which included a ribbon button to trigger an About popup with the library version details.
Excel-DNA C#.Net Add-in to Merge Pdf Files
5916112
The requirement was to be able to extract the .Net dll library files, and the .dna source code from an Excel-DNA xll Excel addin file that had previously been packed with the Excel-DNA Pack command line utility. An online search revealed a concept project which was coded to extract a specific xll file. After triangulating this code with the source code of both the Pack utility and the Excel-DNA runtime, I was able to develop a generic UnPack command line utility (in C#.Net) to extract dll library files, the dna source file, and any included image files (for icons etc). A final step was to automatically adjust the contents of the unpacked .dna file to recreate the source needed to repack the xll add-in file.
.Net Utility to Unpack Excel-DNA xll files
5916110
The requirement was to configure a data entry form for an Access database utilising sub-forms relating to specific tables to allow an integrated data entry environment. VBA code was provided to allow record selection in one sub-form to be reflected in the other sub-forms
Access Database Forms and Sub-forms
2328579
The requirement was to parse several 600 page MS Word documents which contained contact details which had been scraped off the web by another developer into sensibly delimited Excel columns. The solution was to write an Excel VBA macro, which opened the Word Document, sucked off the data line by line, and intelligently parsed the data into Excel columns or into an exceptions report if too badly formatted to be interpreted.
Word to Excel Automatic Copy of Contact Details
5916121
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
The requirement was to download available investments from an investment website's API. Login to the website necessitated a POST configured with basic authentication derived from username/password, and the extraction of session token from a response header for subsequent api calls. All API calls returned JSON encoded data. The third party library VBA-WEB was used to for both the API integration and parsing the returned JSON data.
Excel integration with web API
5916117
The objective was to create a user friendly front end with underlying VBA code that automated the actions required to search through a list of SEO keywords from SEMrush, and move them to category specific worksheets. All code was to be both PC and Mac compatible.
Excel Sorting SEO Keywords
5916114
The requirement was to merge a list of pdf files selectable via an Excel form into a single pdf file. The approach adopted was to write an Excel addin in C#.Net making use of the Excel-DNA framework, and the PDFSharp library for pdf operations. The pdf merge functionality was made available to Excel as a user defined function =MergePdfFiles(file_list) and via a COM interface. The PDFSharp library was built from the latest source code, and a C#.Net library was written to contain the merge fucntionility which calls the PDFSharp library. Both libraries were packaged into an Excel-DNA xll file which included a ribbon button to trigger an About popup with the library version details.
Excel-DNA C#.Net Add-in to Merge Pdf Files
5916112
The requirement was to be able to extract the .Net dll library files, and the .dna source code from an Excel-DNA xll Excel addin file that had previously been packed with the Excel-DNA Pack command line utility. An online search revealed a concept project which was coded to extract a specific xll file. After triangulating this code with the source code of both the Pack utility and the Excel-DNA runtime, I was able to develop a generic UnPack command line utility (in C#.Net) to extract dll library files, the dna source file, and any included image files (for icons etc). A final step was to automatically adjust the contents of the unpacked .dna file to recreate the source needed to repack the xll add-in file.
.Net Utility to Unpack Excel-DNA xll files
5916110
The requirement was to configure a data entry form for an Access database utilising sub-forms relating to specific tables to allow an integrated data entry environment. VBA code was provided to allow record selection in one sub-form to be reflected in the other sub-forms
Access Database Forms and Sub-forms
2328579
The requirement was to parse several 600 page MS Word documents which contained contact details which had been scraped off the web by another developer into sensibly delimited Excel columns. The solution was to write an Excel VBA macro, which opened the Word Document, sucked off the data line by line, and intelligently parsed the data into Excel columns or into an exceptions report if too badly formatted to be interpreted.
Word to Excel Automatic Copy of Contact Details

Відгуки

Зміни збережені
Показано з 1 по 5 із 6 відгуків
 Фільтрувати відгуки за:
5,0
€170,00 EUR
Convert XML file to Excel (.xlsx)
Michael did a very high quality job and was very collaborative in fixing issue not foreseen in the initial bid request. Highly recomended freelancer!!
XML
Data Processing
Excel
C# Programming
B
Прапор Stefano R.
@BugFreeIt
•
4 years ago
5,0
$145,00 AUD
Project for Michael C. -- 3
Excellent work as usual. Thanks Michael.
Data Processing
Excel
SQL
Visual Basic for Apps
JSON
B
Прапор Justin M.
@Belgotex
•
4 years ago
5,0
$465,00 AUD
Excel Macro Expert Required
Michael was easy to work with and knows his stuff. He took our very average brief and produced what we had hoped for. Will definitely work with Michael again if his expertise are required. Thanks mate.
Visual Basic
Data Processing
Excel
Visual Basic for Apps
Excel Macros
B
Прапор Justin M.
@Belgotex
•
4 years ago
5,0
$30,00 USD
Efficient storage of analog trend data in SQL databases
Very good freelancer. Answered all my questions in a clear and professional manner.
Engineering
SQL
MySQL
G
Closed User
@gerardshaw
•
8 years ago
5,0
$225,00 USD
Upload products from a CSV file to shopify via JSON
Fast and efficient. Went above and beyond. Delivered an easy to use, and efficient product.
JavaScript
Python
Shell Script
Shopify
JSON
Аватарка користувача
Прапор Bergur E.
@enghamar
•
8 years ago

Досвід роботи

Principal Consultant

System Integrator
груд. 2002 - квіт. 2015 (12 years, 4 months)
Principal Consultant and Project Manager specialising in IT solutions for manufacturing industries. Specialties Project Management, PRINCE2, Consultancy, BPMN, Team Leading, MES, MIS, MOM, DCS, S88, S95, Batch, Chemicals, Pharmaceutical, EBR, OEE, DTM, Historians, OPC, Data Acquisition, Industrial Ethernet

Senior Automation Engineer

Multinational Chemical Manufcaturers
серп. 1988 - лист. 2002 (14 years, 3 months)
Control & automation software enginnering

Освіта

MEng Chemical Engineering

Imperial College London, United Kingdom 1984 - 1988
(4 years)

Кваліфікація

Chartered Engineer (CEng)

Institution of Chemical Engineers (IChemE)
1992
UK Professional Engineer Certification

Зв'яжіться з Michael C. щодо вашої роботи

Авторизуйтесь, щоб обговорити деталі в чаті.

Верифікації

Бажаний фрілансер
Особу верифіковано
Спосіб оплати верифікований
Номер телефону верифікований
Електронна пошта верифікована
З'єднано з Facebook

Сертифікати

us_eng_1.png US English 1 95%
vworker.png Foundation vWorker Member

Топ-навички

Data Processing 4
Excel 4
Visual Basic for Apps 3
SQL 2
C# Programming 2

Пошук схожих фрілансерів

Data Processing Executives in United Kingdom
Data Processing Executives
Excel Experts
Visual Basic for Apps Developers

Переглянути схожі презентації

Data Processing
Excel
Visual Basic for Apps
SQL
Попередній користувач Наступний користувач
Запрошення успішно надіслане!
Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Логотип Freelancer Ukraine / Українська Допомога та підтримка Фрілансер Категорії Проекти Конкурси Фрілансери Enterprise Членство Програма "Бажаний Фрілансер" Керування проектами Місцеві роботиPhoto Anywhere Вітрина API для розробників Верифікація Desktop App Про нас Про нас Як це працює Безпека Інвестиції Мапа сайту Історії Новини Команда Нагороди Прес-релізи Вакансії Умови Політика конфіденційності Умови користування Політика захисту авторських прав Правила поведінки Комісії і тарифи ПартнериEscrow.comLoadshiftWarrior Forum ЗастосункиЛоготип Apple App StoreЛоготип Google Play
Не вдалося скопіювати в буфер обміну. Будь ласка, налаштуйте дозволи та повторіть спробу.
Скопійовано в буфер обміну.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.