CELINE KIM

• Utilised AWS Cloud Platforms to build and optimise data pipelines, ensuring a streamlined process for data storage and integration.

• Developed and maintained the Snowflake Cloud Data Warehouse, ensuring data high standards of data quality and consistency.

• Designed and customised Tableau visualisations to meet specific business needs, fostering a data-driven decision-making culture among stakeholders.

• Engineered and deployed API solutions, seamlessly integrating internal and external data sources to enhance the overall efficiency of data interaction and flow across diverse systems.

• Leveraged Python programming and API solutions to build advanced Machine Learning models for predicting call data, resulting in a 35% improvement in forecasting accuracy for call data.

• Responsible for continually enhanced user-friendly and interactive reports and visualisation dashboard using tools such as Tableau, Power BI, and MS Excel, resulting in a notable 28% reduction in man-hours per year.

• Developed and managed a comprehensive Microsoft SQL Server environment, overseeing SSRS for reporting, SSIS for integration, and SSAS for analysis.

• Crafted complex and optimised SQL queries to extract large volumes of data from multiple databases, aligning with dynamic business requirements.

• Contributed to the architecture and maintenance of data warehouses, ensuring a structured and organised repository for analytical insights.

• Set up and managed key operational activities and processes related to local phase IV and non-interventional studies, Investigator Initiated Trials, etc.

• Managed medical affairs initiatives such as key system upgrades, process enhancements, database development, knowledge sharing, and training initiatives.

• Assisted in developing new HR initiatives, projects, and procedures.
• Maintained clear, accurate salary records for improved department budgeting.
• Updated records with employee status, personal information and agreement term changes.