Freelancer profile translated to English.
Back to original languageAbout Mégane
Having been the sole development support for over 5 years for several units of the company I worked for, I am more than familiar with the problem of time loss at all levels – from executors to project managers – when easily automatable tasks are performed manually.
Firmly convinced that the primary purpose of IT is to save time for as many people as possible, I am dedicated to automating every process that can be automated to free up time for decision-making rather than for obtaining actionable data, by working as I always have: as closely as possible to the users, so that the coded tools truly meet their needs. Self-taught out of passion since high school, I have acquired each of my current skills by taking on the challenges I have faced over the years, and I am now looking for new challenges. My motto: continuous improvement!
Specialties:
• VBA/Excel
• Python/QGIS (+ geopandas)
• Web scraping: Python, VBA, Java
• Google Sheets + Apps Script
I am used to working on all types of projects, from the most significant ones lasting several weeks or even months (complete overhaul of a fiber optic study process, by identifying and then automating all steps that did not require human verification) to the shortest ones lasting a few days or even hours (document concatenations, data transformations from multiple sources into client-format deliverables, mass file renaming, etc.).
I am also a consulting engineer, capable of identifying all possible improvements and optimizations within a project: setting up a project management tool with automated extraction and presentation of relevant indicators, easy data retrieval from websites, etc.!
(Nb: I offer a reduced rate for VSEs! 😉)
French
Native or bilingual
English
Native or bilingual
German
Basic
Spanish
Basic
Russian
Basic
Remote only
Primarily works remotely
Experience
- Mégane ZAWADA (EI)Developer and IT Support EngineerSOFTWARE PUBLISHINGAugust 2023 - Today (2 years and 10 months)Clamart, France- IT Consulting:• Three watchwords: analysis, improvement, and optimization!• Generic advice for a user based on their relationship with IT: how to choose the best computer (value for money) based on its intended use, which software to use, highlighting unknown features, etc.• More specialized advice for certain software: Word, Excel, QGIS, etc.• Complete setup of new computers• Especially for professionals: analysis of IT processes (project management, deliverable generation procedures, etc.) then highlighting all possible improvement points for increased efficiency and therefore time savings.- VBA / Python Developer (mainly):• Coding, testing, and maintenance of tools to automate repetitive or difficult-to-perform tasks manually• Based on a philosophy of developing multiple small functionalities that meet specific needs rather than large complex software• Either as part of already well-defined requests, or following a process analysis that has highlighted areas for improvement of this type.- Windows System Troubleshooting:• Resolution of all kinds of bugs causing problems for the user (excluding hardware issues)• Restoration of the computer's operating system: improvement of the work environment, removal of unnecessary or malicious software, etc.• Remotely as much as possible (beneficial for everyone: it avoids travel costs!)
- ENSIOSupport EngineerCIVIL ENGINEERINGMarch 2019 - July 2023 (4 years and 4 months)Clamart, FranceIT PART:• Automation (in VBA, Python, or less commonly JS and batch) of multiple processes on different projects + maintenance as needs evolve.• Development of several tools (in VBA or Java) to retrieve information not exportable from online databases to simplify the verification of FTTH studies, improve their quality, and simplify file management.• Development of dozens of tools to: provide summaries of data too complex to obtain manually, automate standardized data processing, generate a project tracking file from input data from 12 to 20 different sources, summarize or modify data as needed in dozens of files using a standardized network architecture across an entire project, etc.• Providing IT advice and troubleshooting various bugs to optimize users' work environment + management and tracking of IT equipment (inventory, setup of new workstations, etc.).• Development of a Java application interfaced with a small internal database to dispatch the processing of problems in FTTH network deployment to the competent individuals and to unblock files.FTTH PROJECT MANAGEMENT SUPPORT PART:• Cross-referencing information from 5 different databases, analysis, data validation (for approx. 60,000 files) and processing of inconsistencies during a migration to a new internal database.• Analysis of complex files remaining to be processed as a major project nears completion, identification of blocking elements, processing of some files, management and maintenance of overall project progress tracking.• Project management support role: identification of malfunctions, proposal of process improvement areas, etc.
- SADE TélécomFTTH Study EngineerFebruary 2018 - February 2019 (1 year)Clamart, FranceFTTH STUDIES PART (carrying out back-zone studies for PA = EZAPA, residential area, for the Orange client):• Detailed analysis of a city and optimization of existing network usage.• Validation of building addresses + the number of housing units they contain.• Network modeling and updating of client databases (GeoFibre, IPON, REFSITES, OPTIMUM) + internal database.• Creation of deliverables (PA sheet, schematic, route, etc.). IT PART (overhaul of the internal FTTH study process):• Automation of information retrieval available online but not directly exportable, previously searched manually for each study. To do this, coding of tools in VBA to transfer data from the source code of relevant pages to the destination tables of a pre-existing Excel template.• Optimization of the overall process through the switch to more suitable software, simplifications or even deletions of certain less essential or unnecessary steps, and the development of tools/files to automate tasks that do not require manual verification/user control (details below).• Implementation of a single file gathering all the data for a study, from which small VBA tools generated all or part of the final deliverables: filling in Excel file templates, generating comment blocks for PDFs, formatting for destination and/or automatic data transfer to global internal files, etc.• Use of VBA AutoCAD to automatically generate groups of objects from a template, already pre-filled with the data for each PB.• Development of small parallel tools to simplify the remaining tasks: data transformation from one format to another, splitting global data to obtain one file per PB, concatenation of files of similar format, etc.
Reviews
Recommendations
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Engineering degree, Agronomy and Environmental ManagementAGRO Toulouse-National Higher Agronomic School of Toulouse-ENSAT2016Diplôme d'ingénieur, Agronomie et management de l'environnement
- Biology, Chemistry, Physics and Earth SciencesCPGE BCPST Georges de la Tour, Metz2013Biologie, Chimie, Physique et Sciences de la Terre