PBT Group specialise in providing business intelligence as a consulting service to various institutions nationwide. These include insurance, credit risk and other financial sectors.
- SAS Development in Base SAS, Dataflux functions, DI Studio and SAS Macro language
- Supporting the current architecture.
- Creating sign-off documents and project plans.
- The work I have been involved include:
üData scrubbing of addresses, telephone numbers and e-mail. Includes using Dataflux with locales.
üIAB Scheduler support
üLSF Support (last used Nov. 2003)
üSQL and Universe support from SAS.
üExtract, Stage and Load of data into SAS EDW
üSupport of SQL tables from SAS
üFinancial development and design
üOLAP Cubes (some very basic MDX coding)
üWeb Report Studio
- Specific Project work includes:
üDesign and implementation of transaction utility to, trap bad transactions, report them (using SAS email and HTML over excel programming) and feed the bad transaction back into Universe
üImplementation of payment profile mart for performing and non-performing customers
üRedesign and implementation of ETL process using SAS pass-thru programming to transfer extract work over to SQL server.
üDesign and implementation of Best Contact campaign marts utilising Deeds and Dataflux match codes to match addresses to property owned by the customer or spouse thereof. Designed to capture letter RTS for Campaigns (Done in DI Studio) and update relevant marts and tables with statuses captured from various sources
üDesign and implementation of ETL process to import SQL log table for telephone system invalidation. (Also ETL Studio)
üExtract, stage and load of financials from Universe into SAS EDW
üImplementation of complex financial pecking system to calculate pecking of payments and induplim across columns per transaction. Columns being capital, interest, legal fees and bank charges. NCA Compliance.
üRedesign and implementation of financial statements for home loan customers.
üDesign and implementation of financial report for CCA requirements.
üDocumentation of entire EDW environment from administrative, financial, facts and mart point of view. Using flowcharts and entity relationship diagrams.
üDesign and implement Interest rate engine based on an account’s active status, pension and payment method as well as Repo and apply the rate retrospectively.
üDesign and implementation of Collection Commission utility to generate commission based on 10% of payments pecked off various pecking columns based on the current collector.
üDesigned OLAP Cube to show the business what accounts have been campaigned on, when they have been campaigned, if fee has been raised for a campaign and if the letter has been RTS’ed.
üDesign and implementation of dynamic extract, stage and load of transactions into EDW using control tables in DI Studio
üCreating Reports in Web Report Studio.