Kevin Mendoza

Foundation and development of a consultancy focused on providing personalized data analysis and business intelligence solutions for businesses, SMEs, and organizations.

Key responsibilities and achievements:

• Design and implementation of custom control panels and interactive dashboards using Looker Studio and Power BI to optimize decision-making.

• Modeling, cleaning, and normalization of databases using SQL (PostgreSQL / SQL Server / BigQuery) and Python (Pandas and NumPy).

• Automation of ETL processes for data integration from various scattered sources.

• Personalized consulting for clients, identifying business needs and transforming technical requirements into clear, efficient, and actionable analytical reports.

Evolutionary Data Architecture: I designed a relational structure in PostgreSQL that migrated from a static model to a 1:N model, allowing for a complete history of donor states to be maintained, not just their current situation.

Integrity and Traceability: I implemented Triggers and audit tables to record critical changes in accounting data, ensuring that every movement is traceable, an essential practice for financial systems.

Raw Data Processing: I developed scripts in Python (Pandas) for cleaning and transforming data from heterogeneous sources, resolving format inconsistencies before loading into the centralized database.

Strategic KPI Visualization: I created dashboards in Looker Studio that unify the view of income (donors) and expenses (suppliers), enabling real-time cash flow analysis.