$$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Expert
{{ $t($store.state.user.experience_search_name) }}
0
jobs
BI Developer
Timothy Ian Malvern
,
Wirral, United Kingdom
Experience
Other titles
Skills
I'm offering
BI Developer and SAS programmer with 25 years experience
Markets
United Kingdom
Industries
Language
English
Fluently
Available
My experience
1995 - 2020
unknown
Debt Manager Continuous Improvement MI
Barclaycard.
APS Team (5 Years)
Team Focus: To maintain and develop the feeds for the online web and SQL Server based application provided by Aspect also known as APM.
My Role:
• Ongoing management and support to keep the application online and up to date, this included making sure the server patching was in place at the correct times. Also being available post patching to ensure the application was still online and running as it should.
• Developing any new data feeds required from various sources such as Teradata, SAS Extracts, Other SQL Server instances and flat files. Implementing any new measures or amending existing measures in the OLAP cube as required by the relevant business areas.
• Optimising existing data feeds to maximise efficiency. Reviewing existing SSIS packages, table design and index efficiency.
Key achievements:
• Migrating existing SSIS packages from APM 7 to APM 18 (SQL 2008R2 to SQL 2019)
• Migrating database from SQL 2000 to SQL 2008R2 and then to SQL 2016
Using: SSMS, SSIS, SSRS, SSAS, Teradata, SAS and Unix
MI Development (4 Years)
Team Focus: To develop MI solutions, act as a conduit between the technology teams and local MI teams, become the leaders in MI applications and develop and use best practice.
My Role:
• Key contact point for projects to draw out MI requirements, so that the necessary reporting is produced and distributed.
• Working with local MI teams and Tech teams so that the required data is obtained and the reporting is made available for end users to self-serve.
• Quickly become familiar with new software and data sources to help other colleagues and develop best working methods and practices for SQL Server and Tableau.
Key achievements:
• After a successful migration of a new product I developed and maintained a migration MI pack.
• I developed a tactical process within strict project management guidelines to deliver formal data extracts that were provided to the ClickFox external supplier. This data was used to drive improvements within the IVR.
• Developed Collections Portfolio Core Metrics in both SAS and SQL Server giving access to the data to the local MI teams and non-technical users alike. I worked closely with technical and local MI teams to define the consistent measures. The data gathering included sourcing data from SAS datasets, Teradata, SQL Server and some excel files.
Using: SAS, Teradata, SSMS, SSIS, SSRS, Tableau and Unix
Debt Manager Continuous Improvement MI - DMCI MI Analyst (2 Years)
Team Focus: To Support the DMCI, Collections Strategy and Agency Management Teams.
My Role:
• Making changes to live production code in a strict change control environment.
• Developing new reporting to monitor new and existing strategies.
• Reference point for other users of Collections data.
• Creating and storing test and control cells for new tests and strategies.
Key achievements:
• Developing a change framework for new and production SAS code and scripts.
• Giving a structured approach to change and greater comfort and control to the changes being made.
• Driving two automation projects forward with good system and process knowledge.
Using: SAS, Teradata and Unix
Collections Strategy - Strategy Analyst (4 Years)
Team Focus: To drive changes to strategies and monitor the success of strategy tests.
My Role: Taking a lead in driving projects forward and delivering cost savings or performance uplift. Data analysis to monitor and prove worth of new strategies and tests, creating and storing test and control cells. Enable strategies to be implemented by providing support and guidance to implementation teams. Proving current strategies and policies are working, find any issues then implement any changes needed. Find all relevant data available within the Data Warehouse for any tests. Mentor members of the team with their technical knowledge, including SAS and SQL.
Key achievements: Discovered and rectified a system problem whereby the incorrect interest rates were being applied to customer accounts. Developed selection process to send records to two Door knock agencies.
Collections Policy & Strategy (2 Years)
The team monitored the current policies and I provided support. I provided policy monitoring for Collections areas using SAS and various data sources. Extract and collate data to enable key decisions to be made by senior management team. Provided data analysis support for the Strategy team to monitor and prove worth of new strategies, creating test and control cells. Proving existing strategies and policies are in place and are working. Developed apps to tag test cells, automate some account actioning.
Key achievements: Developed existing report into a Sarbanes Oxley control. Development of a Secure web server to take Future card Payments.
Value Centre Collections - Credit Risk Analyst (3 Years)
To test, challenge and improve current policies and practices within Collections. Ensure all data required for monitoring and proving tests was available. Develop scalable MI reports for varying levels of management. A reference point for the team for SAS, SQL queries and trouble shooting. Provide initial training for SAS and SQL within the team. Main sources were SAS data, Teradata and DB2 on MVS.
Risk Optimisation and IBCM - Business Analyst (1 Year)
A test and learn culture was introduced late 2000. This focused mainly on testing theories to establish their validity and learning from outcomes, successful or not. The team focus was to challenge and optimise of Risk processes. I helped to identify test and control groups, the type of test dictated the sizes of test and control groups used. I captured data from several different sources using SAS with Mainframe and Unix, to produce defensible analysis proving or disproving the validity of the theories and tests.
Development Area - Business Analyst (1 Year)
The development team's main aim was to develop, manage and monitor new systems for the Collections Risk Area. I assisted in implementing an upgrade to the predictive dialler, I developed an application that worked with the dialler, the application was developed further and was used by circa 500+ People. I developed MI and high-level reporting for senior the management team.
MIS Area - Business Analyst (3 Years)
The team produced paper reports and used ad-hoc queries using Mainframe SAS, recording statistics in MS Access Databases. Shortly after joining the team there was a transitional period enabling the team to explore and rethink its overall focus. Collections Tactical MIS Project, the aim was to use SAS to produce daily MIS in the form of an EIS and integrate SAS into the business for end users to see online statistics. Produced large volumes of high-quality data and applications.
SAS Version: 9.13 The SAS applets: Base, Connect, Macro, AF & SCL, EIS, SQL, ODS
Training courses attended:
The SAS Institute: SAS Advanced, Customised Application Development, SAS EG V2
Amadeus Software Training: SAS Fundamentals 1 & 2, SAS EIS
Team Focus: To maintain and develop the feeds for the online web and SQL Server based application provided by Aspect also known as APM.
My Role:
• Ongoing management and support to keep the application online and up to date, this included making sure the server patching was in place at the correct times. Also being available post patching to ensure the application was still online and running as it should.
• Developing any new data feeds required from various sources such as Teradata, SAS Extracts, Other SQL Server instances and flat files. Implementing any new measures or amending existing measures in the OLAP cube as required by the relevant business areas.
• Optimising existing data feeds to maximise efficiency. Reviewing existing SSIS packages, table design and index efficiency.
Key achievements:
• Migrating existing SSIS packages from APM 7 to APM 18 (SQL 2008R2 to SQL 2019)
• Migrating database from SQL 2000 to SQL 2008R2 and then to SQL 2016
Using: SSMS, SSIS, SSRS, SSAS, Teradata, SAS and Unix
MI Development (4 Years)
Team Focus: To develop MI solutions, act as a conduit between the technology teams and local MI teams, become the leaders in MI applications and develop and use best practice.
My Role:
• Key contact point for projects to draw out MI requirements, so that the necessary reporting is produced and distributed.
• Working with local MI teams and Tech teams so that the required data is obtained and the reporting is made available for end users to self-serve.
• Quickly become familiar with new software and data sources to help other colleagues and develop best working methods and practices for SQL Server and Tableau.
Key achievements:
• After a successful migration of a new product I developed and maintained a migration MI pack.
• I developed a tactical process within strict project management guidelines to deliver formal data extracts that were provided to the ClickFox external supplier. This data was used to drive improvements within the IVR.
• Developed Collections Portfolio Core Metrics in both SAS and SQL Server giving access to the data to the local MI teams and non-technical users alike. I worked closely with technical and local MI teams to define the consistent measures. The data gathering included sourcing data from SAS datasets, Teradata, SQL Server and some excel files.
Using: SAS, Teradata, SSMS, SSIS, SSRS, Tableau and Unix
Debt Manager Continuous Improvement MI - DMCI MI Analyst (2 Years)
Team Focus: To Support the DMCI, Collections Strategy and Agency Management Teams.
My Role:
• Making changes to live production code in a strict change control environment.
• Developing new reporting to monitor new and existing strategies.
• Reference point for other users of Collections data.
• Creating and storing test and control cells for new tests and strategies.
Key achievements:
• Developing a change framework for new and production SAS code and scripts.
• Giving a structured approach to change and greater comfort and control to the changes being made.
• Driving two automation projects forward with good system and process knowledge.
Using: SAS, Teradata and Unix
Collections Strategy - Strategy Analyst (4 Years)
Team Focus: To drive changes to strategies and monitor the success of strategy tests.
My Role: Taking a lead in driving projects forward and delivering cost savings or performance uplift. Data analysis to monitor and prove worth of new strategies and tests, creating and storing test and control cells. Enable strategies to be implemented by providing support and guidance to implementation teams. Proving current strategies and policies are working, find any issues then implement any changes needed. Find all relevant data available within the Data Warehouse for any tests. Mentor members of the team with their technical knowledge, including SAS and SQL.
Key achievements: Discovered and rectified a system problem whereby the incorrect interest rates were being applied to customer accounts. Developed selection process to send records to two Door knock agencies.
Collections Policy & Strategy (2 Years)
The team monitored the current policies and I provided support. I provided policy monitoring for Collections areas using SAS and various data sources. Extract and collate data to enable key decisions to be made by senior management team. Provided data analysis support for the Strategy team to monitor and prove worth of new strategies, creating test and control cells. Proving existing strategies and policies are in place and are working. Developed apps to tag test cells, automate some account actioning.
Key achievements: Developed existing report into a Sarbanes Oxley control. Development of a Secure web server to take Future card Payments.
Value Centre Collections - Credit Risk Analyst (3 Years)
To test, challenge and improve current policies and practices within Collections. Ensure all data required for monitoring and proving tests was available. Develop scalable MI reports for varying levels of management. A reference point for the team for SAS, SQL queries and trouble shooting. Provide initial training for SAS and SQL within the team. Main sources were SAS data, Teradata and DB2 on MVS.
Risk Optimisation and IBCM - Business Analyst (1 Year)
A test and learn culture was introduced late 2000. This focused mainly on testing theories to establish their validity and learning from outcomes, successful or not. The team focus was to challenge and optimise of Risk processes. I helped to identify test and control groups, the type of test dictated the sizes of test and control groups used. I captured data from several different sources using SAS with Mainframe and Unix, to produce defensible analysis proving or disproving the validity of the theories and tests.
Development Area - Business Analyst (1 Year)
The development team's main aim was to develop, manage and monitor new systems for the Collections Risk Area. I assisted in implementing an upgrade to the predictive dialler, I developed an application that worked with the dialler, the application was developed further and was used by circa 500+ People. I developed MI and high-level reporting for senior the management team.
MIS Area - Business Analyst (3 Years)
The team produced paper reports and used ad-hoc queries using Mainframe SAS, recording statistics in MS Access Databases. Shortly after joining the team there was a transitional period enabling the team to explore and rethink its overall focus. Collections Tactical MIS Project, the aim was to use SAS to produce daily MIS in the form of an EIS and integrate SAS into the business for end users to see online statistics. Produced large volumes of high-quality data and applications.
SAS Version: 9.13 The SAS applets: Base, Connect, Macro, AF & SCL, EIS, SQL, ODS
Training courses attended:
The SAS Institute: SAS Advanced, Customised Application Development, SAS EG V2
Amadeus Software Training: SAS Fundamentals 1 & 2, SAS EIS
Development, Access, SSRS, It, Implementation, Support, Apps, Teradata, SSAS, Analyst, Monitoring, Testing, Mainframe, Software, Online, Web, Server, Production, OLAP, Framework, Processes, UP, Manager, Customer, Data Warehouse, Excel, Sql, Data Analysis, Project Management, SQL Server, Training, Unix, Continuous improvement, Database, Automation, Mentor, Design, Optimization, Tableau, SoMe, Management, DB2, SAS, Sourcing, Technology, Test, Statistics, Ssis
1994 - 1995
freelance
Freelance Consultant
unknown.
Advising on requisite hardware/software for company requirements and training staff to use it. Writing bespoke programmes in Visual Basic to assist the businesses to work more efficiently.
Writing, Training, It, Hardware, Software, Basic
1993 - 1994
job
Systems Analyst Programmer
IBS.
User support role for other users including minor hardware maintenance. Deciding the hardware and software needs of company. Document design, implementation and control. Estimate requirements to set up a small network. Used Visual Basic to develop a stock control system.
Design, Network, Implementation, Support, Hardware, Analyst, Software, UP, Basic
My education
1989
-
1993
Wirral Metropolitan College
N/a, N/a
N/a, N/a
1983
-
1989
Henry Meoles School
N/a, N/a
N/a, N/a
Timothy's reviews
Timothy has not received any reviews on Worksome.
Contact Timothy Ian Malvern
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Timothy directly in Worksome.
are ready to help you
and get specific bids from skilled talent in Denmark