Cliente: Cementos Pacasmayo S.A. (cadena de suministro)- Analysis of external and internal sources of Cementos Pacasmayo this in order to understand the business and related entities for the CDS project- Proposed conceptual, logical and physical modeling for SAP information sources, all this unders the UDV modeling playbook for big data.- Supported with the landing of understanding to define the way to calculate the stock of raw materials inventories.- Developed logic for calculating stocks in inventories in BigQuery- Developed stored procedures and functions in BigQuery to secure the loads incremental and optimal updates, ensuring efficiency in the data processing and cost reduction in production.- Developed and automated execution pipelines for loading informacion using Bigquery, Google Composer (Airflow)

- Developed projects to extract and load information from Wallet from MongoDB and MySQL to GCP using Google Cloud Functions and Apache Airflow- Proposed data architecture that support the load of information from the bronze layer to gold- Created stored procedures to read and load information to BigQuery from GCP Buckets- Developed panels in Power BI for various wallet products, Payments without Issue and Transactions with Wallet.- Identified sources and origins of information for the DataMart project of Refund request for the company Sky Airline.- Developed a listener to read refund events within the Wallet application to finally store them in GCP buckets.

- Developed python code which executes reading of pdfs and extracts information of various tables, achieving an effectiveness of 99% and 14MM soles in savings through a better classification of the client.- Raised logics of valorization of telephones and emails in order to be able to provide value to the activities of my team.- Developed scrapy projects for more than 8 web pages which extracted important information for personal risk teams.- Designed ETL’s processes in Azure Data Factory to have vital information for the deployment of campaigns through contact data.

- Integrated sources of information from various applications related to the prices of products at the national level in order to identify their sales, which allowed the calibration of the models.- Automated information loading processes through ctl files and SSIS pipelines, which allowed me to reduce the operation time by 90%.- Supported the implementation of sales and product quotes datamart nationwide.- Created a rate change request information upload project using appscript for the web form, ctl files forthe information upload and oracle as storage.- Created PySpark procedures for the deployment of campaigns and information segmentation of thefinancial system.

- Identified opportunities for process improvement through the management of forms, VBA, SSIS and SQL Server.- Model and develop relational data modeling for BCP Mailbox Service, Expenses and Budget and Customer Satisfaction projects.- Developed tools for extracting information, deploying surveys and sending daily audit reports, with which we managed to reduce mailbox service times from 3 to 1 day.- Developed dashboards for budget management, mailbox service monitoring and customer satisfactionusing QlikSense tool for GDH management.