Highlights:

Skills:Microsoft Excel, PowerBI, Autocad

Freelancer VBA-Excel Developer 1/1/2016 - current
Upwork.com platform, Cairo, Cairo Egypt
Industry: Computer Software
For two years I have been delivering projects based on Microsoft Excel locally and Online. Mostly, they were data analysis, data scrapping, task automating, data cleansing, dashboards and visualization projects that were used in sectors like engineering, pharmaceuticals, online marketing, Medical, and finance.
- Save hours of work for my clients by automating repetitive and complicated tasks and create graphical and written reports. - Scrape Tables and Databases from websites, e.g. Linkedin, Amazon - Create Dashboards and data analysis, e.g.clients, the energy institute at city college of New York. - Worked with various clients that had different knowledge / backgrounds, e.g. Marketing, Engineering. - Over two years on Upwork and locally, I have been providing Excel and VBA projects for engineering and digital marketing industries using my 3 years’ experience in the Electrical Engineering field. - Analyze work data using Excel, Powerpivot and PowerBI desktop. - Keyword position tracking for listing SEO on Amazon. - Convert thousands of products in an internal database to Amazon listing format. - Manage sponsored keywords from search term reports files and update Sponsored Products Bulk File for PPC campaigns on Amazon. - SCADA program on Excel instead of buying software that cost thousands for machines monitoring. - Dynamic multilingual Excel forms to be used for surveys. - Improve work performance and save hours of the team time using VBA macros. - Merge hundreds of CSV files using Power Query. - Nice looking interactive dashboards that help to take fast decisions. - Generate pdf reports and quotes with charts using VBA scripts. - Automate MS Powerpoint to create videos and advertising facebook banners. - Scraping data tables daily from Yahoo finance using VBA and present summarized in pivot tables.--
Automation and Electrical Engineer 1/8/2013 - 1/7/2015
Jedco International Pharmaceuticals, Cairo, Cairo Egypt
Industry: Pharmaceuticals
Worked as an Electrical engineer for 2 years. Paying attention to maintenance spare parts inventory and manage PLC devices.
The first responsibility was, Electrical maintenance of Hard Gelatin Capsule Machines (HGC). - Adding a periodic maintenance for (HGC machines, PCB, Dc motors, Lab Instruments), which reduced the electrical down time by 70%. - Because of the limited budget, we developed new techniques and to reduce the maintenance cost by 30%. - Editing SLC and HMI programs of HGC machines for better performance, add the ability of multi-users. - Designed SCADA system for HGC machines via MS Excel, monitoring and visualizing 500+ tags.--

El Shorouk Academy 9/2006 - 7/2011
Cairo, Cairo, Egypt
Degree: Bachelor's Degree
Major:Electrical Engineering
Study electrical engineering, electrical machines and control department.

Ahmed Kamal - VBA developer