Data/Unica Migration Analyst ~Championed part of UNICA system upgrade from v9 to v12 and data migration from Teradata and/or SAS to big data Hive which involving SQL, SAS, Python, Spark exposure ~Mentored junior-level colleagues throughout the migration project, fostering a positive working environment. ~Repointed views and datasets from Teradata to Hive database. ~Optimized view logic via SQL and partitioned data to minimize data extraction time, reducing it from 8 hours to about 1 hour with implementing big data best practices. ~Built Airflow jobs for data injection into hive database. ~Migrated SAS data to big data (parquet) files in s3. ~ Involved in data engineering on transferring frequently generated Unica datasets as ETL into operationally tech managed dataset via colibra govenance. UNICA Campaign Analyst ~Designed, developed and implemented data-driven marketing campaigns. ~Automated and integrated end-to-end campaign into customer journey to maximize customer experience via UNICA and new to UNICA Journey module. ~Coordinated with business stakeholders to gather campaign requirements and criteria for products such as Credit Card, Auto-invest (NAV), and CASA, FD ~Ensured effective delivery and tracking of personalized messages across entire campaign execution. ~Implemented manual and automated customer journeys on own channels like email, SMS, and Push Note Notification. ~Managed the volume and complexity of campaign execution to various customer segments across different channels, ensuring compliance with contact policy and general exclusion.

United Overseas Bank Limited (UOB) | Nov 2017 - Apr 2021

Senior Officer, Balance Sheet Risk Management

Liquidity Risk Analyst ~Collaborated with the risk team to enhance reporting methodologies. ~Generated reports such as daily MAS649 and intraday liquidity that outline risk-related market and financial forecast findings. ~Coordinated the production and distribution of daily, weekly, and monthly liquidity reports to business units, senior management, and regulators. ~ Liquidity metrics monitoring such as loan-to-deposit ratios and Top20. ~ Helped reconcile liquidity data discrepancies, daily variances analysis ~ Identified potential improvements in the bank's liquidity risk data collection process Business and System Analyst ~Automated MAS 649 Notice, LCR, NSFR reporting for head office, subsidiaries and branches via batch file command and window task scheduler ~Enhanced code and mapping to align with group policy change ~Batch jobs and data integration from different banking system ~Developed scalable solutions to enhance liquidity reporting process which mainly on LCR, NSFR and NCO ~ERM downstream system impact analysis ~Coordinated with subsidiaries users for UAT testing to ensure report accuracy ~Gathered business requirement for new treasury products profiling. ~Minimized human manual adjustment ~Involved in group subsidiaries GMP project implementation and roll out

NCS - Integrated Technology Solutions | Jan 2016 - Jun 2017

Application Support Engineer

SAS System and Operation Support Engineer ~System migration from SAS 9.2 to 9.4 which involved ETL batch jobs, Job scheduling, User access and dataset migration. Detailed UAT during pre system roll out. ~Developed SAS Infomap, SAS BI Dashboard and SAS Web Report Studio. ~Maintained user access provisioning with volume of 2k users via SAS Management Console to ensure appropriate security matrix are assigned. Traced and analyzed user login statistics for business enhancement. ~Developed new batch jobs and performed impact analysis via SAS Data Integration Studio ~Optimized batch run time by assessing run time statistics and enhanced job dependencies ~Monitored system health and metadata status via linux command ~Triggered batch jobs log files extraction via shell scripts ~Gathered requirement into Change Request/Service Request due to change in business requirement or new business model ~Prepared test cases for users to perform UAT ~Verified and validated data from source systems to SAS and Oracle data warehouse. ~Compiled statistical reports for stakeholders ~Ad hoc data extraction from users via SAS Studio or SAS Enterprise Guide

My Education

Take a look at my formal education

Bachelor’s Degree, Mathematics and StatisticsNanyang Technological University | 2015

About Me

Tzyy Jiann hasn't filled in a bio text

Create Your Data Portfolio for Free