Highly motivated, driven by passion, Excel VBA developer.
Over the last 3.5 years I have completed more then 150 projects, almost all of them being Excel projects. From my experience with Excel I have found that importing/exporting files, creating reports, performing data manipulation based on specific rules, userforms and "Click Away" VBA macros are the most sought by clients. Of course, the list does not end here and I am looking forward for anything that involves Excel and automation.
In Excel, I can provide the following services:
- Automation with VBA: my strongest skill and my long time interest. I am looking to automate everything!
- User forms, with data validation, tiered dropdowns, dynamic controls, etc.
- Excel Add-Ins
- Importing data from DOC, RTF, HTML, CSV, TXT and XLS files
- Processing data in Excel: reports, dashboards, charts, calculations, string manipulations
- Exporting to DOC, CSV, XLS and TXT
- Word to Excel or Excel to Word automation
- Design complex Excel formulas, such as VLOOKUPs, nested IFs and array functions
- Internet Explorer automation, useful for web scraping projects with data being parsed directly in Excel
Other services I provide are:
- Web scraping
- PDF to Excel conversion. I value accuracy more then speed, therefore I do PDF conversion partly manually. The available softwares will fail in one way or another when converting to Excel.
- Small VB.NET applications
Universitatea Dunarea de Jos
2002 - 2005
Analyst programmer (computers section)
1998 - 2002
BGS Divizia de securitate
security systems technician
2008 - 2011
Installing/troubleshooting burglary, fire detection and CCTV surveillance system