FELICIA GERALDINE KENCANA
Engineer / Analyst - Database Developer
Sidoarjo
Summary
Results-driven Data Engineer/Analyst with 3+ years of experience in designing scalable data architectures, optimizing ETL processes, and leveraging cloud and big data technologies. Skilled in developing automated solutions that enhance data consistency and operational efficiency. Adept at collaborating with cross-functional teams to translate business requirements into actionable insights.
Overview
3
3
years of professional experience
5
5
years of post-secondary education
3
3
Languages
Work History
Database Developer (Engineer/Analyst)
AIA Singapore Pte Ltd
12.2022 - Current
- Migrated a legacy on-premise data warehouse to a cloud-based solution (Azure), improving performance, scalability, and accessibility while minimizing business disruption.
- Designed and optimized ETL/ELT pipelines using Azure Data Factory & Attunity, reducing data processing time and cutting manual workload by 40%.
- Developed and fine-tuned SQL stored procedures and functions, improving query execution time by 25% and enhancing data retrieval efficiency.
- Built and maintained Datamarts in Azure Databricks, enabling faster and more accurate company-wide monthly reporting.
- Implemented data modeling best practices to optimize database design and support analytics use cases.
- Automated data ingestion, transformation, and validation processes, improving pipeline reliability and reducing failures.
- Collaborated with cross-functional teams for seamless integration of data sources into the company''s data ecosystem.
Intern (Data Engineering & Analysis)
AIA Singapore Pte Ltd
11.2021 - 11.2022
- Assisted in data transformation and integration for business intelligence reports
- Managed data administration tasks, including database backup, batch jobs, and table management
Education
Bachelor of Engineering - Electronic Commerce
Southwest University
Chongqing, China 04.2018 - 01.2022
Chinese Language Program -
Shaoguan University
Shaoguan, China 01.2017 - 01.2018
Skills
- SQL
- Python
- Java
- Bash
- Data modeling
- ETL development
- Apache Spark
- Data migration
- Data warehousing
- ETL processes
Websites
Timeline
Database Developer (Engineer/Analyst)
AIA Singapore Pte Ltd
12.2022 - Current
Intern (Data Engineering & Analysis)
AIA Singapore Pte Ltd
11.2021 - 11.2022
Bachelor of Engineering - Electronic Commerce
Southwest University
04.2018 - 01.2022
Chinese Language Program -
Shaoguan University
01.2017 - 01.2018
Similar Profiles
Leon SooLeon Soo
Financial Advisor at AIA Singapore Pte LtdFinancial Advisor at AIA Singapore Pte Ltd
CHANG BING CHUENCHANG BING CHUEN
Senior Financial Service Consultant at AIA Singapore Pte LtdSenior Financial Service Consultant at AIA Singapore Pte Ltd
XU BAO YUE EMILYXU BAO YUE EMILY
FINANCIAL SERVICES MANAGER at AIA SINGAPORE PTE LTDFINANCIAL SERVICES MANAGER at AIA SINGAPORE PTE LTD