Arthur Lovato, Ms Email & Phone Number

New York, Ny, Us

- Led the development, deployment, and maintenance of software applications on an AWS EC2 server using Docker and Git to generate actionable, data-driven insights across Hydropoint’s WaterCompass, Baseline, and WeatherTRAK products.- Increased customer retention rates by 10% and eliminated 20 hours of manual work per month by spearheading the design, development, and implementation of a real-time renewals dashboard to inform client strategy and empower sales staff.- Reduced manual work and processing time by 50 hours per month by creating an automation script to seamlessly receive water bill files from third-party entities using Python while ensuring data integrity and efficiency via validation checks.

- Reduced customer water usage analysis time by 50% to save 200+ hours of manual work per year, improve data accessibility and quality, and decrease manual errors by developing a data analytics tool to automatically evaluate customer water costs and predict savings using Python, Django, Postgres and Sklearn library.- Developed efficient data pipelines for data extraction, transformation, and loading (ETL) into a PostgreSQL database to organize disparate sources of data into easily accessible databases using Python.

- Analyzed big data from large databases containing information on 2MM+ home improvement retail store customers to generate actionable, data-driven insights and reports on customer demographics, behavior, and key customer KPIs for stakeholders within the marketing and product teams.- Performed ETL, conducted A/B testing and data modeling using SQL, Python, and Excel, and created visualizations using SQL queries and Python while providing recommendations and influencing business decision-making to enhance marketing program effectiveness across regions and customer demographics.- Communicated results on trimestral presentations and promoted an internal tool that increased sales, customer retention, and enhanced customer experience for sales teams from across 350+ stores.

- Performed data analysis to generate insights on customer churn, behavior, and marketing using SQL and Python.- Eliminated 30 minutes of manual work each day and ensured the on-time delivery of crucial business insights by driving the automation of daily reports containing key CRM metrics such as answer and conversion rates using VBA and Python.

Master Of Science - Ms, Artificial Intelligence For Business Transformation

Bachelor Of Engineering - Be, Mechanical Engineering