Carissa Agatha

Experience

• 

  Orang Tua Group

  May 2017 - Jul 2017

  Web & Desktop Apps. Developer

  • Successfully developed a desktop application for Orang Tua Group Event in Jakarta Fair 2017 for Point of Sales Application using C# .NET and Microsoft SQL Server as a database platform• Optimized some internal website such as Tango, Blaster, Mintz• Maintained commercial animation for internal users with Adobe Flash

• 

  PT. Optus Solution

  Nov 2017 - Jan 2020

  Optus Solution is IBM Premiere Business Partner that established to provide the best Analytics and Information Management (AIM) solutions for organizations and companies in running their businesses.• Implemented a data catalog between business and technical section with IBM Information Governance Catalog (IGC)• Performed metadata scoring with IBM Information Analyzer (IA)• Analyzed business process and data flow between existing platforms such as SQL Server, AS/400• Provided a documentation to client needs such as FSD, TSD, TMP, and VIT• Parsed a data flow from SQL Server's PL/SQL into IBM IGC's Extension Mapping Document• Maintained project timeline based on scope of work documentation.• Performed a trained to business users to understand the concept of data governance• Led weekly progress meeting with business and technical team Show less

  • Technical Lead

    Aug 2018 - Jan 2020

  • Technical Consultant

    Nov 2017 - Aug 2018
• 

  AIA Singapore

  Jan 2020 - now

  • Collaborate with cross-functional teams to understand data requirements and deliver solutions that meet business needs• Mentor and coach junior team members, providing guidance on best practices and technical skills development• Implement data governance policies and ensure compliance with regulatory requirements• Communicate effectively with other team and provide updates on project status and progress• Provide an API function using PostgreSQL to another tech team• Continuously assess and improve data engineering practices to enhance efficiency, quality, and reliability• Establish and maintain documentation for data side to cover the DB objects, process, and procedures Show less • Performed a migration of an enterprise data warehouse from PostgreSQL to Azure Databricks• Developed some notebooks in Azure Databricks based on technical requirement• Combined Python and Spark SQL language to achieve the effective script• Created an automation script to run a data mart using Shell Script in Linux environment• Developed a dynamic pipeline in Microsoft Azure Data Factory to populate data from one another platform Developed some API Function in PostgreSQL to collaborate with Micro-service team• Collaborated with business users to achieve the expected result• Developed PL/SQL Stored Procedure and Function in PostgreSQL based on user requirement• Settled any issues in UAT and Production environment for selected projects• Maintained a timeline of technical tasks using Microsoft Planner• Performed a session for new comers to explain an end-to-end flow of data architecture area Show less

  • Assistant Manager, Data Architecture

    Nov 2023 - now

  • Lead Specialist, Data Architecture

    May 2023 - Feb 2024

  • Senior Database Engineer

    Mar 2021 - Jun 2023

  • Database Engineer

    Jan 2020 - Mar 2021