|
|
|
PERSONAL
|
Email / |
peisiong@hotmail.com / +44 (0) 7800
538 410 / 14a |
|
Written References: |
http://www.peisiong.com/ref_home.asp |
|
Right to work in |
Married spouse visa expires 1-Feb-09. Eligible for indefinite leave to remain thereafter. |
SKILLS
Database/Query/CRM Tools
q Base SAS 8 and 9, SAS Macros, SAS
q Informatica PowerCenter 6 and some working knowledge of
q Oracle 8i Database administration, PL/SQL, SQL Loader
q Oracle Financial Analyzer, Business Objects, Oracle Developer/Report Rel 6
q Some working knowledge of Epiphany Campaign Management
Business Analysis/Accounting
q Analyzing business processes through interviews and questionnaires, identifying gaps, mapping business requirements to technical requirements and documenting findings.
q Preparing business case and demonstrating cost/benefit analysis through financial modelling.
q Managing project costs and resources.
q Preparing test plans, conducting UATs and documenting results.
q Preparing user documentation conducting end user training and workshop.
q Management and financial accounting and reporting.
Implementation Methods /Project Management/Office Productivity
q Data Warehouse Life Cycle (Ralph Kimball), Oracle Applications Implementation Methods (AIMs)
q Microsoft Project, Microsoft Office and Visio
Financial Applications
q Implementator/End-User: Oracle (R10.6SC to R11i) GL, AP, AR, Fixed Assets, Cash Management, Purchasing, Application Desktop Integrator
Web Design/Operating Systems
q Windows XP/2000/98/NT, some working knowledge of OpenVMS and Unix
q ASP.NET 2.0, HTML, CSS, DHTML, JavaScript, VBScript, Photoshop6, Dreamweaver4
PROFESSIONAL MEMBERSHIPS
Oracle 8i Certified Database Administrator - Nov 2001
Institute Of Certified Public Accountants of Singapore
Award
Retail Week Awards 2005 for Business Excellence (Carphone Warehouse’s “ONE”) - Mar 2005
q Judges said that they “were impressed with the way The Carphone Warehouse uses the (Customer Dashboard “ONE”) system to improve customer service. This is a fundamental part of the strategy of being customer focused, and goes a long way towards how [one] systemize relationships with the customers.” See http://www.peisiong.com/retail_week_award.pdf
WORK EXPERIENCE
Sabbatical (Singapore /United Kingdom
(1 Aug 2006 to date)
q
While spending time in
q
Currently overseeing home
renovation in
dunnhumby (United Kingdom
Senior Data Manager (26 Sep 2005 till 31 Jul 2006)
q
Part of the business analysis
team and the main SAS developer for two quarterly Tesco Club card voucher
allocation for the
q Responsible for business analysis and development of mailing and reporting solutions (in SAS and Oracle) for Tesco’s Baby and Toddler club.
q Acted as SAS/Oracle consultant for the team.
Carphone Warehouse Group (United Kingdom
Senior CRM Developer/Implementation Consultant (7 Jan 2002 – 15 Jul 2005)
q Concurrent project management, business analysis, data design and ETL for fixed line churn prevention data mining project (first data mining project in the company) in 12 weeks.
q Supported users in fixed line churn prevention data mining and value analysis in Enterprise Miner 5.1.
q SAS9 and Enterprise Miner 5.1 Server/client administration.
q Data profiling and ETL development for POS/Finance/extranet applications and EDI.
q Developed and maintained PL/SQL routines for customer value computation and online real-time offer recommendations on Customer Dashboard “ONE”. Also assisted in developing and maintaining Single Customer View for Customer Dashboard “ONE”. (See “Award” section on page 1).
q Supported Epiphany marketing campaigns and SMS automation routines.
q
Conducted business analysis for
data warehouse and involved in data conformity across
q
Managed data warehouse (Oracle
8i) and Business Objects rollout through out
q Proposed and implemented Applications Implementation methodology and Data Migration methodology.
q Provided ad hoc applications consultancy, software evaluation, training and workshops.
GLOBAL CLICKIN FZ-LLC (Based in Dubai Internet
City
GULF INFOTECH LLC (Based in Abu Dhabi
Finance Manager / e-Solutions Specialist (15 Jan 2000 – 31 Jul 2001)
q Conducted feasibility study of new joint venture (Global Clickin) and set up internal procedures, controls and approval authorities. Responsible for full accounting functions and management reporting.
q Managed a team of four web/graphics developers and acted as a customer liaison.
q Conducted business process analysis, testing, documentation and
implementation.
q Involved in data profiling and developed migration strategy for data
load.
Oracle Systems S.E.A. (S) Private Limited (Oracle
Corporation’s South East Asian Office ,
Singapore
Consultant (
q Specialized in project management, operations analysis, implementation, training and data migration.
q Involved in the implementations of various Oracle applications in the following companies:
|
|
Rel |
Data Migration |
GL |
AP |
AR |
Assets |
|
Cash Mgt |
Web Exp |
OFA |
ADI |
|
Grocery Logistics of |
11 |
ü |
ü |
ü |
|
|
|
|
|
|
|
|
|
10.7 |
ü |
ü |
ü |
|
ü |
ü |
|
|
|
ü |
|
Asia Matsushita of |
6.2 |
ü |
|
|
|
|
|
|
|
ü |
|
|
Land Transport Authority of
|
10.7 |
|
|
ü |
|
|
ü |
ü |
|
|
ü |
|
Defence Technology Group |
11i |
ü |
ü |
ü |
|
|
ü |
|
ü |
|
|
|
ColorCon Asia Pacific Pte
Ltd |
11 |
|
ü |
ü |
ü |
|
|
|
|
|
|
|
BonFood/BonStar
(Starbucks/BurgerKing) |
10.7 |
|
ü |
ü |
|
|
|
|
|
|
|
PSA Corporation Limited (The corporatized entity of the
former Port of Singapore Authority
Accountant
(Projects-Corporatization) -
q Implemented Oracle Assets and Oracle GL (R10.7NCA), including asset and GL data migration.
q Co-author of Oracle Financial Applications manual and internal trainer for various Oracle modules.
q Engaged in all corporatization matters relating to fixed assets.
Financial Controller / Accountant (International Business, Engineering & Fixed Assets)
q Managed a team of two accountants and four accounts assistants.
q Maintained fixed assets ledger using Oracle Assets and AP (R10.6SC).
q Developed a financial statement consolidation automation spreadsheet statutory reporting.
q Provided management reporting and budgeting using Oracle Financial Analyser and Oracle Financials.
q Managed the financial controlling and reporting functions for eight subsidiaries and assisted Deputy Finance Manager in financial controlling and reporting of three subsidiaries.
q Conducted overseas investment feasibility studies and post-mortem
analysis.
q Prepared and reported on CAPEX, fixed assets and depreciation using Oracle Assets, GL and OFA.
Johnson & Johnson Private Limited (Singapore
Accounting Intern (
q Assisted in internal audit review of sales, inventory and bank and cash.
q Performed payable functions using Oracle AP and physical inventory count.
24th Battalion Singapore
Personal Assistant (Chief Trainer) - National Service (1991 June till 1993 June)
q Carried out logistic functions in conducting training courses for national servicemen.
EDUCATION & TRAINING
Currently pursuing Post-Graduate Certificate in Business Intelligence with SAS® Certification
q Produce multiple linear regression models for pension administrative costs using Base SAS and STAT.
q Create credit rating scorecard using a variety of data mining techniques SAS Enterprise Miner 4.1.
q Pending completion of a statistics assignment using SAS 9 due at end of September.
SAS Institute, Marlow (
|
ú SAS System Essentials, Nov 2003 |
ú
SAS |
|
ú SAS Programming, Dec 2003 |
ú SAS Warehouse administrator, Nov 2004 |
|
ú Querying and Reporting using SAS Enterprise Guide Software, Nov 2003 |
ú Applying Statistical Concepts using SAS software, Jan 2004 |
|
ú SAS Marco Language, May 2004 |
|
Informatica
PowerCenter 6 – Basics, Feb 2004
Unix Operating System / Screen Forms with PL/SQL (Oracle Developer Rel 6)
Nanyang Technological University (
Degree of Bachelor of Accountancy Second Class Honours
Cambridge General Certificate of Education "Advanced" Level – 3 Distinctions in 6 credits
Cambridge General Certificate of Education "Ordinary" Level – 6 Distinctions in 8 credits