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)