Open To Work
TERENCE D’CRUZE
Data Engineer
Ajax,ON
Summary
Result driven Data Engineer with expertise in ELT job development, AWS services, and data validation. Specializes in Python, SQL, and Mainframe technologies, along with data modeling and dashboard creation in Tableau. Leverages strong analytical and problem solving skills to enhance database technologies and systems, contributing to both independent and collaborative projects.
Overview
2
2
Languages
1
1
Certification
6
6
years of professional experience
Work History
Data Engineer
Sun Life Financial
03.2023 - Current
- Actively engaged in the development and deployment of ELT (Extract, Load, Transform) jobs, facilitating seamless data processing and integration.
- Proficiently utilizing Mainframe daily, adeptly creating CHARM and Zeke jobs to streamline operational workflows.
- Spearheading the creation of Glue jobs, while meticulously verifying data in Production to ensure a successful and smooth launch.
- Owned end-to-end development and delivery of key business benefit, designing and implementing features for optimal functionality.
- Leveraged various AWS services to ensure successful job execution, data processing, and comprehensive data validation.
- Developed automated validation logic to minimize manual effort and enhance process efficiency.
- Monitored project activities and supported the onboarding and training of new team members, ensuring smooth knowledge transfer and project execution.
Data Analyst
Sun Life Financial
06.2022 - 03.2023
- Led development of two insurance underwriting projects, driving progress and ensuring alignment with strategic goals.
- Demonstrated expertise in Mainframe technology, adeptly managing CHARM/Zeke jobs, creating BDMs, and utilizing Hive Hue to validate production data.
- Sustained leadership as the primary developer in two insurance underwriting projects, ensuring their ongoing success and progress.
- Analyzed complex datasets to identify trends and support strategic decision-making.
- Developed interactive dashboards using Tableau for real-time data visualization and reporting.
- Implemented data quality checks, ensuring integrity and reliability of data used in analyses.
Application Developer/Associate Data Analyst
Sun Life Financial
02.2021 - 05.2022
- Spearheaded two crucial projects in insurance underwriting as the lead developer.
- Conducted comprehensive business analysis to enhance communication and strengthen relationships with business group.
- Successfully developed Minimum Viable Product (MVP) solutions and Tableau dashboards for production implementation.
- Developed Minimum Viable Product (MVP) solutions and Tableau dashboards, facilitating production implementation.
- Prepared meticulous project documentation.
- Mentored and trained multiple co-op students, supporting their professional growth and aiding in the organization's talent development initiatives.
- Recognized as RiskStar Nominee in July 2021 for outstanding contributions.
- Received DBTS Stars Nomination for Q3 2021, highlighting significant achievements.
- Collaborated with cross-functional teams to define project requirements and deliver solutions.
Data and Analytics, Analyst Intern
Sun Life Financial
05.2020 - 08.2020
- Analyzed data sets to identify trends and support decision making processes.
- Developed reports utilizing advanced statistical tools for strategic insights.
- Acquired proficiency in various analytical tools through self guided learning initiatives, contributing significantly toward overall job performance.
Education
Bachelor of Applied Science - Computer Engineering (with Management and Entrepreneurship Option)
University of Ottawa
Ottawa, ON06.2021
Skills
- ETL Development
- Data Warehousing
- Tableau; Understanding Tableau Concepts, Connecting to and Preparing Data, Exploring and Analyzing Data, and Sharing Insights
- Jira, PyCharm, Jenkins, Hue, Trino, Mainframe, Snowflake
- AWS Services; Glue, SageMaker, Athena, Step Functions, S3
- Python, SQL and VHDL language skills, and proficiency in Microsoft Office Suite
- Business Analysis Skills
Languages
English
Native or Bilingual
Bengali
Native or Bilingual
Certification
Tableau Desktop Specialist (completed Dec 31st, 2020)
Timeline
Data Engineer
Sun Life Financial
03.2023 - Current
Data Analyst
Sun Life Financial
06.2022 - 03.2023
Application Developer/Associate Data Analyst
Sun Life Financial
02.2021 - 05.2022
Data and Analytics, Analyst Intern
Sun Life Financial
05.2020 - 08.2020
Bachelor of Applied Science - Computer Engineering (with Management and Entrepreneurship Option)
University of Ottawa