Answer business questions using SQL queries in data warehouse. Maintain accurate and complete inventory of data, data systems, and storage. Maintain communication with non-technical users to determine specific business requirements for reporting and BI solutions. Perform audits and validation of databases to guarantee their integrity. Search for patterns and analysis of information that allow their grouping correctly.
Major achievementOne of the achievements obtained is the implementation of the process of automatic downloading of information from provider APIs to store it in AWS redhsift, at the same time structuring views in order to make them available and functional for the data analyst.
Collect information from different sources corresponding to incoming calls abandoned, service levels, conversation averages and other metrics of the inbound, outbound service lines, IVRs. Prepare and present reports that show the different metrics of the indicators to the different areas of the company and to the clients Make improvements and implementation of reports and procedures of the area seeking the optimization of resources.
Major achievementOne of the achievements obtained was the automation of the billing process for the services provided by the call center to a corporate client, using the VBA programming language, which led to a reduction in time in the preparation of pre-invoices and less time in the presentation to the client