Melody Yang

•Analysis, design, coding, delivering, testing and support web based mortgage system with .NET framework and MS Access based internal financial, banking systems with VBA. •Troubleshooting and improving existing applications with .NET 2.0 •Leading application support team in technical area. Immediately lift the team's problem management capabilities. •Accuratly estimate tasks for self and team members in deployment activities, ie. IT solution delivery process.

•Research, recommend and deliver technological solutions to support HR initiatives •HR information systems management and data warehousing •Data extraction, migration, conversion, mapping and analysing, reporting from PeopleSoft, MS Access •Report HR metrics •Provide real time information to customers to facilitate effective decision-making

•Process payments including reconciliation of cheques, EFTs •Data integrity and consistency •Liaise with Medicare and health insurance companies to gain the details of the query payments •serve customers for credit card payments and accounts inquiry •In accounting periods, generate PL statements, trail balances and balance sheet reports

•Creating high performance T-SQL and PL/SQL databases and in-depth tuning both •Conducting scoping studies, analysis, and database design •Investigating and resolving issues in production DB environments