Francisco Zambrano Email and Phone Number

Development of an automated reporting tool to keep an overview and detailed understanding of financial data, expenses, forecasts... The tool produces a dashboard which is easy to use and provides insight to the less technical person.

- Using Python I developed the process in charge of data gathering and manipulation tailor made to the specific needs of the reporting purposes of the department.- Designed and built a new recurring report in Power BI. This way improving previous report by providing different levels of data granularity to non-technical stakeholders depending on their interests.- Conducted independent research in order to gain more team knowledge and detailed figures on topics the team needed more light.

- Ensured flow of data form sources toward users was up to the banks' standards using tools such as Mainframes and Informatica Power Center.- Responsible of providing ready to use data tables meeting all requesters requirements by writing SQL scripts that perform the adequate queries.- Participated in the migration process from IBM services to Microsoft Azure cloud services.

- Provide innovative ways of improving regular business processes.- Data collection (webscrape) and data manipulation in order to build a database and keep it up to date.- Automation of repetitive email tasks on Outlook and Gmail and personalized email writing tasks.

Process financial transactions, Responsible for the full vendor invoice registration process of several administrations, Responsible of expense registration process including accounting review and reimbursement of expenses, Responsible for allocation of customer payments, General ledger journal entries in SAP.