Daniel Perez Email and Phone Number

- Migrated all prediction scripts to Vertex AI on Google Cloud Platform (GCP), refactoring them to extract data from BigQuery tables instead of local databases.- Set up a VPN tunnel between GCP and our local network to enable Change Data Capture (CDC) with Datastream, ensuring raw data is regularly ingested and updated in BigQuery.- Implemented Git and GitHub for version control, ensuring all scripts are backed up and collaboratively maintained.- Enhanced prediction scripts to handle multi-week forecasts by cycling through datasets, optimizing a complex codebase of over 10,000 lines.- Maintained a Looker Studio dashboard showcasing metrics for routes, clients, and warehouses, ensuring data visibility for key managers.- Automated weekly prediction workflows using crontab and Python to run scripts and send email reports directly from Vertex AI.- Automated model monitoring, generating and emailing performance visuals weekly to executives and directors using crontab and Python.- Built a web app in AppSheet for the sales team to register commercial impulses (e.g., desired increases in volume or percentage for specific products/warehouses). Developed a custom allocation algorithm (500+ lines of code) to integrate these impulses into the prediction pipeline, dynamically adjusting the forecasts by adding the impulses to the original predictions.

- Analyze, interpret, and standardize data related to the vehicle accessories market and product information according to company needs.- Use tools like SQL queries and macros to monitor data input quality and integrity in Excel, Access and SQL databases.-Ensure that the process complies with quality, integrity, and coherence requirements as per company objectives.- Analyze discrepancies reported by Electronic Catalog system users and implement modifications to existing content or add new content to resolve reported discrepancies.

– Built an Excel Report of the “Satisfaction” KPI (Comcast satisfaction surveys) and presented to the BI department supervisor, the recruitment manager, and the operations manager. This assessment got me the BI position over more than 15 candidates. – Maintain an Excel report that tracked attrition and provided insights and analysis for the entire campaign. As a result, the attrition rate decreased from 14% to 10% - Built and maintain Power BI dashboard which analyzed the correlation between the agent red flags in the call with the satisfaction survey of the customer. More than 25 satisfaction Top performers identified with a high Transfer rate and Credit amount per call (2 mayor red flags) NPS KPI (survey satisfaction) increased from 17% to 21% the first month the dashboard was released. - Built and maintain Power BI dashboard which shows us the TOP 10 and BOTTOM 10 agents in each KPI (slicer filter) each agent can be analyzed with a deep dive in call behaviors, coach follow up, number of training sessions, absences, discipline interactions, red flags indicators, the dashboard was very helpful for supervisor to understand what was the difference between a Top performer and an outlier, and work on those points. Recognized by Comcast for the insights that the dashboard provided.

- An average of 2 subordinates promoted per month to a better position due to their performance metrics with me as their leader-Xfinity Mobile Team Sales KPI improvement from 2% to 6%-Created an Excel report that tracked attrition and provided insights and analysis for the entire campaign. As a result, the attrition rate decreased from 14% to 10%.