Tat Seng Wong

Tat Seng Wong

Summary

I am a certified IBM Cognos TM1 Developer, who is able to to provide TM1 consultations to clients, I have worked on various big projects around South Africa such as Sasol Limited, Sasol Polymers, Anglo Gold Ashanti, Southern Sun, SBV, and some projects outside South Africa, such as Kenya Airways. I am mostly involved in the technical side of the projects, which takes a very big part on building systems for the companies.

Work History

Work History
Apr 2008 - Present

Developer

Cortell
Provide professional and technical advice to business which require a highly advanced budgeting system with the use of IBM Cognos TM1.
Jan 2006 - Feb 2007

Developer

CCD Couriers
Develop solutions for the company, enhances the business performance as well as database administration, also require performing business analysis, system design, implementation, and training. Most of the clients for the company are major banks in South Africa, particularly Card Division, Fraud Division; we also require speaking to the bank’s representative, to discuss further development, reporting and procedure enhancement.

Education

Education

School name:

Skills

Skills

SDLC

The Systems Development Life Cycle (SDLC), or Software Development Life Cycle in systems engineering and software engineering, is the process of creating or altering systems, and the models and methodologies that people use to develop these systems. The concept generally refers to computer or information systems.

Microsoft Visio

Microsoft Visio (pronounced VIH-zee-oh), marketed as Microsoft Office Visio, is a diagramming program for Microsoft Windows that uses vector graphics to create diagrams.

C#.Net

C# (pronounced "see sharp") is a multi-paradigm programming language encompassing imperative, functional, generic, object-oriented (class-based), and component-oriented programming disciplines. It was developed by Microsoft  within the .NET initiative and later approved as a standard by Ecma (ECMA-334) and ISO (ISO/IEC 23270). C# is one of the programming languages designed for the Common Language Infrastructure.

VB.Net

Visual Basic .NET (VB.NET) is an object-oriented computer programming language that can be viewed as an evolution of Microsoft's  Visual Basic (VB) which is generally implemented on the Microsoft .NET Framework.

SQL Server

Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL  and ANSI SQL.

VBA

Visual Basic for Applications (VBA) is an implementation of Microsoft's  event-driven programming language Visual Basic 6, and associated integrated development environment (IDE), which is built into most Microsoft Office applications. VBA enables developers to build user defined functions, automate processes, and access Win32 and other low level functionality through DLLs

Microsoft Access

Microsoft Office Access, previously known as Microsoft Access, is a pseudo-relational database management system from Microsoft  that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications.

Microsoft Excel

Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet  application written and distributed by Microsoft  for Microsoft Windows and Mac OS X. It features calculation, graphing tools, pivot tables and a macro programming language called VBA (Visual Basic for Applications). It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993. Excel forms part of Microsoft Office.

TSQL

Transact-SQL (T-SQL) is Microsoft's and Sybase's proprietary extension to SQL. Transact-SQL is central to using SQL Server. All applications that communicate with an instance of SQL Server do so by sending Transact-SQL statements to the server, regardless of the user interface of the application.

TM1 Server

TM1 is an in-memory MOLAP  system used to implement collaborative planning, budgeting and forecasting solutions, as well as analytical and reporting applications. Data in TM1 is stored and represented as multidimensional cubes, with data being stored at the leaf  level. Computations are performed on demand in real-time.

TM1 Turbo Integrator

TM1 TurboIntegrator lets you manipulate TM1 data and metadata when you define a process. This is accomplished through the use of functions in the Prolog, Metadata, Data, and Epilog sub-tabs within the Advanced tab of the TurboIntegrator window. These sub-tabs include generated statements based on settings and options you select when defining a TurboIntegrator process.

TM1 Rules

Rules in TM1  provide a means of calculating results in a cube  that is more powerful and flexible than simple consolidation of a dimension. Rules can work across dimensions, refer to data in other cubes, and access metadata. Like consolidations, Rules are calculated on demand. Unlike consolidations, the sparse consolidation engine is not able to determine in advance which results will be empty without additional information. For this purpose Feeders are used to identify which intersections need to have rules evaluated, and which can be skipped. Effective use of Feeders is essential to making Rules efficient and avoiding combinatorial explosion.