Even though my main functions were to be a Business Analyst, I had to do three developments in Python. Which consisted of connecting to the database in SQL Server, creating a csv file which later had to be loaded into another database so that it could be viewed by the end user.
In addition to my duties as a business analyst and due to the workload of the developers, I had to make modifications, either to the stores procedures used by the application or to adapt the code, in C#, to resolve a reported incident.
• I optimized the SQL code used in the survival survey query with the objective of reducing the execution time and I achieved that instead of the process lasting one day, the duration was five minutes. Likewise, it supported the application for the pensions area, which was occupied by the business to manage all pensioners registered with BBVA Bancomer.