I understand that you are looking for a Python developer to create a script that will migrate data from Excel sheets into tables into an Oracle database using cx_oracle. Will need to create one table per excel sheet. And ensure validation of column names and table creation convention. Further detail requirements attached. Sample data with 3 sheets attached. I am an experienced Python developer with extensive knowledge in web scraping, web automation, and coding useful scripts.
My specialties include:
- Excel & automation (all formulas, power pivot, power queries, dynamic charts, dashboards, macros, VBA);
- Power BI, Tableau, Data visualization and Business analysis;
- Document conversion specialist (PDF, DOC, XLS);
- Cost control (BOQ);
- Purchase planning automation.
If you are looking to supplement your team with out-of-the-box thinking that not only generates ideas but has the skills and resources necessary to execute within budget and on time please reach out to me so we can discuss further how we can help bring this project to fruition! Thank you for your consideration.