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.
Apr 2008 - Present
Provide professional and technical advice to business which require a highly advanced budgeting system with the use of IBM Cognos TM1.
Jun 2007 - Feb 2008
Jan 2006 - Feb 2007
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.
Feb 2002 - Dec 2005
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 (pronounced VIH-zee-oh), marketed as Microsoft Office Visio, is a diagramming program for Microsoft Windows that uses vector graphics to create diagrams.
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.
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.
Microsoft SQL Server is a relational model database server produced by Microsoft. Its primary query languages are T-SQL and ANSI SQL.
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 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 (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.
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 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.
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.