About Camila
Spanish
Native or bilingual
English
Conversational
Experience
- Zafira InmobiliariaBusiness Intelligence AnalystREAL ESTATEDecember 2025 - Today (8 months)Lima, Peru•I manage the commercial CRM as a Super User, ensuring the quality, consistency, and availability of information used for commercial management and tracking.•I develop and track commercial indicators (KPIs) for sales, stock, prices, and revenue, identifying opportunities for improvement in project performance.•I execute ETL processes in SQL and Python to integrate information from multiple sources into Power BI, ensuring data quality and traceability.•I perform cleaning, transformation, and modeling of large volumes of raw data using PostgreSQL (pgAdmin) and Power BI.•I develop executive dashboards for the Commercial, Marketing, and Finance areas, facilitating data-driven decision-making.Achievements:•I designed and implemented an automated solution in Python (web scraping) that integrates 3 external sources and consolidates data from approximately 50 real estate projects for competitive analysis.•I implemented automated commercial dashboards connected to the CRM, replacing manual reports and enabling daily monitoring of key indicators used in commercial committees.
- Scania del PerúBusiness Intelligence InternTRANSPORTATIONApril 2024 - November 2025 (1 year and 7 months)Lima, Peru•I managed the commercial CRM (Microsoft Dynamics) as a Super User, ensuring the quality, consistency, and availability of information for commercial management.•I defined, monitored, and analyzed commercial and financial indicators (KPIs) for continuous business tracking.•I developed executive dashboards in Power BI for monitoring commercial and operational performance.•I analyzed trends, deviations, and improvement opportunities using information from the CRM and corporate databases.•I designed and optimized ETL processes in SQL to clean and structure large volumes of raw data from corporate databases, ensuring reliable information for decision-making.Achievements:•I automated the tracking of commercial indicators through CRM-connected dashboards, reducing report update time by 50%.•I led the proposal and implementation of an automated solution (RPA) for pricing analysis, which increased process efficiency by more than 70%.
- IdegoBusiness Intelligence InternCONSULTING AND AUDITSJanuary 2023 - March 2024 (1 year and 2 months)Lima, Peru•I developed automated reports and interactive dashboards in Power BI, providing key visibility on performance and operational indicators.•I analyzed and managed internal and external databases, identifying patterns and opportunities to optimize information processes.•I collaborated with internal teams to improve efficiency in the information flow and the quality of data used in decision-making.Achievements:•I designed and implemented an automated dashboard, adopted as a permanent consultation tool in the head office, improving the availability and clarity of information.
Recommendations
Be the first to recommend Camila
Help this freelancer shine by sharing your experience working together.
These freelancer profiles also match your criteria
Agatha Frydrych
Backend Java Software Engineer
4.7
(3)
2
Baptiste Duhen
Fullstack developer
4.6
(4)
5
Amed Hamou
Senior Lead Developer
4
(2)
7
Audrey Champion
Web developer
4.3
(3)
4
Education
- Bachelor's DegreeUniversidad Nacional Federico Villarreal2024Bachiller
- SpecializationUniversidad ESANEspecialización