David Pearce

• With over thirty years of SAS programming experience and training in economics and statistics, I offer intelligent and practical solutions to data analysis challenges. 
• Until recently, I managed a team developing and deploying SAS solutions for fraud detection and supported financial crime analysts in a large bank, on both Windows and Unix platforms
• Previously, I was a SAS and metadata administrator in a very complex insurance data warehousing environment with up to 900 SAS users. 
• Provided advice and solved code and platform problems.
• Experienced managing and analysing large volumes of data using SAS and other tools on mainframe, Unix and on PC. 
• Worked for the SAS Institute in their Technical Support team. 
• Previously I had been working with computer capacity planning and performance measurement, problem detection and analysis, forecasting, and profit centre charge back. 
• I have also worked in a human resource management environment doing productivity measurement, work measurement studies, staffing models, and MIS.

Key Skills/Experience Summary

• SAS Base 
• SQL
• SAS v9 Administration
• SAS SMC, DI-Studio
• SAS/Graph, SAS/Stat, SAS/Connect
• Statistical analysis
• SAS PERL Regular Expressions
• SPDS
• Unix
• Agile methodology
• MXG, computer performance measurement
• JCL, ISPF panels, and CLIST
• Work measurement analysis, especially ‘activity sampling’ 
• Team leadership
• Project leadership
• Microsoft Excel and Word

Tools: SAS Foundation, SAS SMC, SAS DI Studio, LSF, Unix scripting.

Achievements:

Developed methods and processes to ensure quality, sustainability and reliability in the data analysis and fraud alerting processes. Built a culture of customer-focused service in the team. Balanced the needs of stability and control and the need for agility. My team performed IT services outside the usual box of IT processes allowing rapid development, deployment and tailored solutions for fraud analytics.

Key Highlights:

• Designed a secure method for immediate deployment of new fraud detection rules to the Unix production environment, resolving an impasse between business and IT. This method was used 149 times, saving days in the IT change process and enabling rapid response to fraud threats.
• Developed a method for quick detection and SMS notification of any problem arising on the multiple Windows platforms.
• Developed measurements showing resource consumption of each Unix process. This provided far greater insight into the causes of CPU and platform performance issues. 
• Worked with IT to migrate to SAS 9.4 on Unix and then a complete re-platforming to Linux.

Bachelor of Arts (Economics) Macquarie University 1978

Professional Qualifications & Training• SAS DI Studio Fast-track

• SAS Platform Administrator
• Advanced Excel
• Excel VBA (Pollack)
• SAS Base
• SAS Programming I & II
• SAS Macro
• Computer Performance Evaluation
• Advanced SAS Programming Techniques
• IT Service Vision – Warehouse Administration
• IT Service Vision – Interactive Reporting
• Project Leadership (Patton)
• Structured Analysis (Thomsett)
• Problem Solving and Decision Making (Kepner-Tregoe)
• Project Management (IPAA)