Matthew Tan

• Implemented various pipelines for the proprietary analytical Genie data warehouse and platform for the Americas Region under very tight timelines.
• Created custom reusable jobs in for ingesting content and documents from API, RDBMS, and raw data file sources.
• Used strong analytical and problem-solving skills to develop effective solutions for Employee CoInvest initiative allowing employees to participate in the success of company investments.
• Worked closely with the data modeling team, DBA team, and testing team.
• Collaborated with business intelligence staff at customer facilities to produce customized ETL solutions for specific goals.
• Later on, migrated Talend ETL Jobs into Azure Databricks (pyspark) as mandated by the company's strategic direction.

• Worked as part of the Enterprise Data Warehouse Team primarily building the incremental load framework on top of the existing processes.

• Re-wrote multiple jobs to take advantage of snowflake’s processing capability and utilizing Talend Cloud version components (tPreJob, tPostJob, tLogCatcher, runIf, tSendMail, joblet, tRunJob) for orchestrating dependencies between various components and allow for re-startability using metadata in control tables.

• Performed data analysis; collaborated with business and reporting users to gather and understand the requirements and wrote SQL statements to accommodate complex client data requirements.

• Developed feeds using generic dynamic schemas, tDbInput, tDBOutput, tMap, tJoin, tParallelize, tFlowToIterate to absorb new data from MS SQL Server DB, Oracle DB, Salesforce sources into the EDW. Optimized these processes by increasing fetch, batch size, and introducing parallel streams when applicable to improve processing times.

• Performed unit tests and supported DIT, SIT, UAT phases.

• Coordinated PROD implementations, Talend Management
Console job promotions, and supported PROD failures.

• Worked as part of the Global CitiKYC (Know Your Customer) Data Migration (ETL) team consolidating data from multiple country source systems
• Supported fully metadata driven ETL Framework that was custom built on top of Talend
• Worked with data analysts and business partners to communicate framework and metadata requirements
• Worked with DB team and release management team to deploy and support the run-time environment in all regions worldwide
• Worked closely with various teams throughout the SDLC process: functional team, SIT/UAT testing teams, development (UI, Interface, Framework, Database) teams
• Developed and reviewed code to re-mediate data issues in PROD environments
• Evolved to become a subject matter expert in the CitiKYC business and functional requirements and acted as lead to the ETL and Data investigation teams

• Assisted RRD's Business Communications Services Information Technology team in completing a time-sensitive project for a high-profile client
• Parsed, transformed, and merged complex XML data files into HP Dialogue Extream absorb-able formats using Java
• Loaded and processed data to and from MySQL Databases
• Optimized and automated processes using Talend ETL Tool
• Modified and supported existing data processing applications written in VB.NET.

• Gathered technical specifications from Business Partners and worked with various teams (Database Developers, DBAs, and Web Developers) within IT to deliver solutions
• Designed and implemented comprehensive fully automated Talend ETL solutions to integrate third party applications (Slate CRM, PowerFAIDS, StarRez, Onbase, IDWorks) with Fordham University's ERP System
• Built and maintained Banner Self-Service Banner (SSB) Pages, Internet Native Banner (INB) Forms, and Banner Jobs
• Analyzed and integrated latest Banner release upgrades and patches
• Implemented automated application monitoring with notifications
• Designed and implemented Parking database and application solution.

• Implemented the conversion of physical photos from the ID system into oracle blob format stored in tables, and implemented the modification of Self-Service pages to allow faculty members to see students photos in their roster online
• Wrote programs to migrate photos and identification information from Fordham's legacy ID system to Blackboard's Transact system
• Migrated various data transfers, scripts, and processes into Talend Data Integration tool
• All of these are now automated, saving the University time and resources
• Applied and maintained Fordham modifications to major Banner upgrades and patches delivered by Ellucian
• This includes Oracle PL/SQL packages, procedures, functions, and triggers, Unix Korn Shell scripts, Pro
• C Banner Jobs.

• Performed University wide data migration from the University's Legacy Mainframe system into Ellucian's Banner ERP software running on Oracle RDBMS
• Managed hundreds of validation and translation tables through utilization of DB Links and advanced PL/SQL programming to sync data in between DEV, QA, and PROD environments Customized Banner Jobs written in Pro
• C and Banner Self-Service pages written in PL/SQL
• Worked with Business Partners throughout the University to investigate and resolve issues as well as initiate and complete Fordham IT's initiatives.

• Worked with new and existing partners for a variety of tasks such as new career portal setup, marketing initiatives and data transfers
• Worked individually and as a member of a team on all phases of new development initiatives including: planning, developing, implementing and testing
• Monitored site and job searching issues for over 15,000 career sites and resolving them as soon as possible
• Worked on various projects as needed for consulting based clients.