Sien Tan Email & Phone Number

Glasgow, Gb

Glasgow, Scotland, United Kingdom

ETL Developer

Cannon Street

ETL Developer· Development work using MEDM, SSIS, SQL for Data managrment and asset managment.· Experience with Batch Job scheduling with Tidal and dependecy.· Release by using Heatview and source control using bitbucket.· Using Jira to keep track development and support works.

Edinburgh, City Of Edinburgh, United Kingdom

2019• UI Workflow development for simplify Exisitng User Experience• UI Workflow development for Flexible Trade Capture reference data & client trade pre-validation.• Tableau reporting2018 Achievements• Builded new UI - Stand-alone FTC (Flexible Trade Capture) pre-validation on static reference data.• As PIR (Production Incidents Reduction) champion and bring down the incidents escalation by target at less 50%.• Improve system stabability.• Role for PIR included review existing issue and functionality , Technical Design and design test plan.2017 Achievements• As PR champion and bring down the problem backlog number from 120++ to less than 5 items.• As technical design and review lead on PR champion.• Provide support across the end-to-end delivery and run lifecycle, utilising their skills and expertise to carry out software development, testing and operational support activities with the ability to move between these according to demand.• End to end accountability for a product or service, identifying and developing the most appropriate Technology solutions to meet customer needs as part of the Customer Journey• Liaise with other engineers, architects, and business stakeholders to understand and drive the product or service’s direction.• Create technical test plans and records, including unit and integration tests, within automated test environments to ensure code quality.• Provide support to DevOps teams working at all stages of a product or service release/change with a strong customer focus and end to end journeys, ensuring they have an excellent domain knowledge.• Working with Ops, Dev and Test Engineers to ensure operational issues (performance, operator intervention, alerting, design defect related issues, etc.) are identified and addressed at all stages of a product or service release / change.• Provide support in identification and resolution of all incidents associated with the IT service, as directed by leadership of the DevOps team.

Edinburgh, United Kingdom

Oversee, improve and extend the existing trade processing systems that process trades covering variety of products and instruments delivered both from client systems and affirmation/confirmation systems.Encompass technical analysis, development as well as development support (including Production). Provide comprehensive global, regional and domestic fund services including fund administration, global custody, corporate trust and loan agency and sub-custody settlement and services to international asset management industry.

Kuala Lumpur, Malaysia

Project involved:Release (Nov 2016)Markit 10.5 and Database Upgrade, environment setup and rattle test.Release (Sep 2016)Markit Trade Auto Asset Create - Build a web service call .Net DLL adopt Markit Porter trigger web request. Clocking on trade status. Auto Markit Trade Reprocess.Release (Jun 2016)FMA (FIFO Methodology Application) Enhancement - Analysis existing FMA process and provided permenant solution for those critical incidents raised since couple years ago.Release (Dec 2015)• Solvency II - Reliance Mutual. Analysis and review FRD, estimate and breakdown project into subtask. Development included loading Bloomberg source, Asset Match and Publishing process.Release (Sep 2015)• IMS Demise Project, Handling the Unit Trust Trade that require perform the Vespasian Process and routed to FXHome. Analyst the core processing on cancellation process and create the Soft Delete for Accounting System. Creating Dynamic report in Adhoc and Daily basis for all under manage by AMG.Release (Jun 2015)• New SWIFT message confirmation with trade capture by Cadis Event Watcher, staging validation XML format (using in house build DLL). Mastering processing with SWIFT message and asset match. ACK’s creation for Client.Daily role involved:Markit EDM/Cadis BAU support for Fund Trade Processing.· Thorough work on the resolution and analysis of production incidents· Resource for complex and detailed root cause analysis including the solution.· Development work on Project which go though the Technical Design, Technical Review, Code Change, Code Review, Unit Test and Creating support Documentation on Markit EDM/Cadis Component.· 3 Month Short Team Assignment working at London involved in project development work including analysis and design aspects and performance analysis.

1. In-charge In-house application CCRISB2B and CTOS ASP.NET C# as platform and SQL 2008 as Database.I. Provide weekly update report to Management.II. Resource planning. III. User requirement gathering for project and production issue.IV. Requirement study and come out scope of works.V. Keep tracking on Project and Production status for all banks.VI. Provide knowledge transfer among the team members.VII. Coordinate for SIT & UAT activities for production fixes and enhancement request / Project.VIII. Create Test script for SIT and UATIX. Prepare document for application changes.2. BAU support modules involved:I. Front-End Application for user enters application and submits to Bank Negara. (ASP.NET C#)II. Web service for Front-End Application (ASP.NET C#)III. Batch Import (VB.NET)IV. B2B Gateway Application (VB.NET)3. Project involved:I. Support HDM (Hong Leong Bank Data Migration) for transform old database to new database server with SSIS.II. Support Citibank (IPA) Pre Approval application to improve Bank sale.

1. In-charge middle way mainframe application (Iexchange) support for different location. 2. Support 6 Application Channel via Iexchange from Bangi which are Auto Dailer, Mobile Banking, BDS, Clicks, Biz Channel and iBroker – SMS Getway3. Support 5 Application Channel via Iexchange from MSB which are Cardlink, RPS, eComm, IVR and Call Centre.4. Provide application support in troubleshooting and escalation to vendor, where necessaryI. First Level Investigation via log fileII. Restore production data for diagnosis to determine the probable causeIII. Escalate to respective technical or business unit for actionIV. To perform follow up with require parties for closure5. Coordinate for SIT & UAT activities for production fixes and enhancement request / Project.6. Work with internal IT Lead (From front end channel and backend system) and vendor.7. Ensure system/ application documentation is kept up to date.8. Perform testing and support in SIT and UAT with system migration procedure to QA for implementation.9. Project involved:I. Credit Card V2 Upgrade – Mainframe and flow upgradeII. Debit Card ProjectIII. IVR enhancement – Enhance existing IVR Call flow – New customer IVR registration IV. EGDA – E-Gold Deposit AccountV. Branch Delivery System phase 2 enhancementVI. 1 platform (1P) – User requirement

1. CIMB Bank support with MSCRM Application and SQL Server.a. Using javescript to improve the MSCRM performance2. Using Sourceface Application control the Source Code.3. Documentation for New Version Release and Deployment.4. Using .Net C# Build Online Sport Booking Application and Database Designa. Using MVC concept to develop whole application5. Help Deloitte Consultant Company do the ASP Application convert to ASP.NET 3.5, MS SQL 2010 and adding 3 module for E-Claim System.

Kuala Lumpur, Malaysia

1. Support all the In- House Application like SMS (Stock Management System)2. Daily Sales Booking Web Application with VB.Net 3. Tallyman system Interface (Credit Management).4. Troubleshooting and phone support for ALL Branches regarding Daily Operation and Networking Support.5. Convert all the Manual Reporting to Auto with Excel VBA.6. Build the web reporting application for 2 country (Malaysia and Singapore) with ASP.NET C#7. Self implement internal data warehousing.8. Handle Credit Analysis for Malaysia and Singapore 9. Use MS SQL 2000 tools e.g dts, scheduler for enhancement on the existing reporting extraction. 10. Credit Sales Analysis – Weekly Sales and Month Sales reports and Credit Sales performance.Involve Tallyman system which is Credit Sales system.