CV, SQL Data Analyst Seeking Work In The UK

Unavailable

Serial No: 42320

Job Seeker Location

×

Close

Skills keywords: c#.net, data analyst, financial data analyst, sql server

Short Bio:

HK based Data Analyst/Developer with international experience.

MSc in Advanced Information Systems.

Current location:  Hong Kong - View on map

Nationality: Chinese

Preferred Sector of Employment:  accounting and finance, IT and Technology, Banking Insurance and Financial Services

Spoken languages: Cantonese, english, mandarin, Tagalog

Location I am interested in working: Anywhere

Work Experience

September 2014 to current
Ernst & Young
Global Financial Reporting Analyst/DBA (Hong Kong)

Creating new financial reports based on specific requirements provided by our clients

Assisting in developments to automate financial reports generation using VBA Access, Excel

Executing and maintaining of the existing reporting tools in excel and updating the macros when needed

Providing reporting, analysis, and technical advice to our clients across APAC

Maintaining the existing financial datafeed SQL Server and end user tools (Access, Excel, SSIS)

Liaising with the Regional Finance Leads, Service Line Leads, Controllers to handle any ad-hoc reporting

Assigning work and monitoring the performance of the team members

Providing instruction and coaching to the team members (Tableau, Spotfire, MS Access, Excel, SSIS, SSMS)

January 2013 to June 2014
PricewaterhouseCoopers International Limited
Data Analyst & Programmer (New York, United States)

Technical execution of the Data Quality Master File (Master Data Management) monthly operations which provided reports across global PwC systems and territories

Developed applications/tools using VBA in order to accelerate various validation checks as part of daily/monthly operations (e.g. Data loads validation, Data Quality checks)

Used Toad for Data Analyst, MSSQL to generate reports and analysis to find any data quality issues with the system and also to understand any impacts before any new developments/fixes are applied

Review data loaded into multiple environments for accuracy

Performed data quality analysis and generation of reports for territories

Territory flat file UAT from development to production environments as part of new system migration

Used Informatica Data Director and trained staffs in using the system

February 2012 to October 2012
Global Technology Integrator
Analyst Programmer (Hong Kong)

Designed and developed a web and mobile based solutions for the Hong Kong government

Participated in project implementation team for application development and write user documentation

Performed programming/testing of software modules and prototypes (C#, ASP.Net, MS SQL Server, Oracle, ESRI)

Communicated with development team members to make sure that programming tasks are done on time

Interacted with Project Managers and the team to update the current status of each deliverables

April 2010 to September 2011
Phones 4u
Administrator / Deputy Manager (London, United Kingdom)

Commercial acumen in assessing the impact of new customer acquisition on profit and sales objectives

Deep familiarity with different propositions and tariffs that may suit diverse customer needs

Continuous update on products and services knowledge via internal and partner training – e.g., Virgin Media, Sky, Research in Motion (Blackberry), Nokia, Samsung, HTC, Windows Mobile

Assess customer needs accurately/comprehensively to achieve sales and to promote longer-term customer loyalty

Ensure engagement with potential customers whilst demonstrating phones and features that suit their needs

Work well as a team and promote a collaborative environment

Contributed to the highest gross profit sales record in the past five years

Promoted to the Senior Sales Consultant role after exceeding expectations on sales targets, and was awarded the Outstanding Performance certificate

Top 30 Sales Consultant in the UK based on achieved Gross Profit

April 11, 2005 to May 2005
ELS Travel and Tours
Systems Programmer and Designer, Accounting Department (Philippines)

Developed a system using VB 6 and Microsoft Access Database that was to be used in a real-business environment

To ensure efficiency in retrieval and booking processes by developing a system that records customers’ personal information in a database

To enable staff to personalize recommendations to customers based on information from the database (e.g. tracking of customer’s booking history)

To support the customer service personnel with effective tools, where the system alerts the staff of certain significant customer events, such as the imminent expiration of a passport

Education

MSc Advanced Information Systems
From: Birkbeck College, University of London
Period: October 2007 to October 2009

Thesis: MobiSafe (Mobile Safety) Storage System on Windows Mobile (2009)

Mobile contacts backup and restoration system using GPRS and Wi-Fi technology as the transport protocol for storing mobile phone contacts data into a personal online storage space

Courses taken:

Word Wide Web Technologies Developing Internet Applications

Mobile and Ubiquitous Computing Data Warehousing and Data Mining

Advances in Data Management Advanced Applications

Semantic Web Knowledge Representation and Reasoning

Coursework:

 C#.NET web crawler application (WWWT)

 C#.NET link analysis and page rank computing application (WWWT)

BSISM
Bachelor of Science in Information Science and Management (Specialized as Information Systems)
From: College of Computer Studies, Central Philippine University
Period: June 2002 to March 2006, including summers

Thesis: Mobile Point-Of-Service (POS) on PDA (2006)

Keeps track the orders from the customer using PDA technology

Facilitate efficient and accurate billing to customers even with a minimal training to employee

Provide faster and accurate inventory control for the café and restaurant

Achievements and Co-Curricular Activities

Developed a web-based and mobile client solution for the Hong Kong government (2012)

MobiSafe (Mobile Safety) Storage System on Windows Mobile (2009)

Xiamen City, China: Community-based website (2006-2009)

Mobile Point-of-Service (mPOS) Thesis: Best Thesis, Best Program Design, Best Presentation (2006)

Central Philippine University Student Research Symposium 2nd Best Paper (2006)

President, Society of Information Science and Management of 300 members (2005)

Financial Officer, Society of Information Science and Management (2004)

Society of Information Science and Management, Outstanding Academic Campus Organization (2004)

Assistant Team Leader, Society of Information Science and Management(2003)

With Honors, Chinese Batch 2002

1st and 2nd Places Chinese Essay writing contest (2001 and 2002)

2nd Place, Intra-school Chess (2002)

Computer Skills

Microsoft Visual Studio (C#, ASP, .Net, .Net Compact Framework) Oracle, Toad for Data Analyst, MS Access (VBA)

Microsoft SQL Server Windows Apache MySQL PHP (WAMP) Server

MS Office (FrontPage, Word, Excel, PowerPoint, Access, Publisher, Visio) Joomla CMS (Administration, Content Edition, Maintenance), WordPress MU

PL/SQL, MS SQL HTML, CSS, AJAX

ESRI ArcGIS (Desktop and Mobile) Eclipse (JAVA)

Language

English — Native (spoken and written)

Mandarin (Chinese) — Fluent (spoken) and Intermediate (written)

Tagalog (Philippines) — Fluent (spoken) and Intermediate (written)

Cantonese – Basic (spoken and written)