Cecile Hidalgo
Kawit, Province Of Cavite,CAV
Summary
Detail-oriented Analyst with experience in financial data management, sector classification, and database integration across multiple industries including Basic Materials, Consumer Durables, REITs, Financials, and other sectors. Skilled in creating and validating sector-specific financial codes, fiscal date adjustments, reconciliation of financial datasets, and ensuring data accuracy before uploading into MongoDB. Experienced in handling large datasets using Excel, APIs, and financial data platforms to support investment research and reporting processes.
Overview
11
11
years of professional experience
Work History
Senior Research Analyst
FactSet Philippines
Taguig, Metro Manila, Philippines
01.2016 - Current
- Provide research and concordance support for various datasets and collection processes owned by other groups.
- Manage the institutional/fund/contact coverage already in the database following the procedures already established for each country.
- Responsible for keeping track of research analysts and investment personnel at buy-side and sell-side firms.
- Collects and maintains institutional and contact data for buy-side and sell-side firms.
- Manage the institutional/fund/contact coverage already in the database following the procedures already established for each country.
- Analyzed complex datasets to identify trends and inform strategic decision-making.
- Developed comprehensive reports synthesizing research findings for stakeholder presentations.
Data Analyst
Virtual Assistance Online
Remote
01.2015 - 01.2016
- Created and maintained sector-specific financial codes for multiple industries including Basic Materials, Consumer Durables, Real Estate Investment Trusts (REITs), Financials, Industrials, and other sectors.
- Conducted fiscal date adjustments to align company reporting periods across datasets for accurate comparison and standardization.
- Performed reconciliation of financial data between source platforms and internal databases to ensure data consistency and completeness.
- Identified missing, null, and inconsistent financial values and performed root-cause analysis for correction and validation.
* Managed mapping of financial statement line items including Income Statement, Balance Sheet, and Cash Flow Statement for REIT and Non-REIT sectors. - Uploaded validated sector datasets into MongoDB while maintaining data integrity and proper classification structure.
- Supported investment teams by providing clean and accurate financial datasets for research models and reporting.
- Assisted in API-based extraction of price, volume, and financial metrics for faster workflow automation.
- Analyzed large datasets to identify trends and insights for decision-making.
Education
Bachelor of Science - Marketing Management
Sta.Isabel College
Manila01-2013
Skills
- Financial Data Analysis
- Sector-Specific Code Creation
- Excel Advanced Functions (LET, VLOOKUP)
- Data Reconciliation & Validation
- FactSet Excel Plug-ins
- Remote Desktop / Virtual Machine Environment
Timeline
Senior Research Analyst
FactSet Philippines
01.2016 - Current
Data Analyst
Virtual Assistance Online
01.2015 - 01.2016
Bachelor of Science - Marketing Management
Sta.Isabel College