Caio Scarmocim

• Created dashboards to monitor and track real estate market indicators.
• Developed ETL processes to prepare data for dashboards.
• Maintained and created new data pipelines in our database
• Used statistical methods to analyze data and generate useful market insights.
• Synthesized complex analytics-derived insights into easy-to-understand, actionable recommendations for business users.
• Extracted and interpreted data patterns to translate findings into market insights .
• Collaborated with stakeholders to identify business needs and data sources.
• Collaborated with business-unit leaders to identify and prioritize problems.

• Support multiple Facility Management and Project Management teams with analytical solutions
• Translate business requirements from different teams into technical specifications and Tableau visualizations
• Gathering requirements during monthly engagement calls with clients
• Designing, building and deploying BI solutions (SQL,Tableau)
• Maintaining and enhancing existing dashboards
• Troubleshooting Data Source and Dashboards
• Collaborating with teams to integrate data model with multiple systems (data warehouse, flat files)
• Developing and executing database queries as well as conducting analyses (SQL, DBeaver)
• Developing and updating technical documentation

Key Achievements

• Led a PJM dashboard project and delivered it as per agreed deadline, meeting the client's requirements
• Developed a dashboard to support clients in identifying the rate of missing data from fields used in their reports
• Brought multiple improvements and shared best practices for dashboard, improving dashboard performance and exceeding clients' expectations

• Data management and input using SaaS systems (Sequentra, Tririga)
• Performing in-depth analysis to provide accurate results for Variance reports
• Validating and sending monthly Tableau report from BA to the client
• Abstracting real estate leases from multiple clients
• Answering client's queries and tickets
• Monitoring data quality

Key Achievements

• Developed a macro to clean data from the variance report which contributed to a greater data accuracy and significant reduction of time for its preparation
• In cooperation with other team, conducted a comprehensible FTE Capacity Study using data extracted from Salesforce
• Improved the client's data accuracy by engaging in projects using Excel to compare and identify missing data from previous system

• Coordinated maintenance teams on site to deliver all tasks on time and delivered monthly reports
• Evaluated final results to determine quality levels and isolate root causes of any identified faults.