Alan Whiting

Background

About Alan Whiting

I have 35 years experience as a Data Analyst/Designer up to Senior/Lead across banking, public sector and telecom organisations. I am an NZ citizen. I looking at contract roles in NZ/Australia, further afield. I have four years experience in Customer Remediation. I am comfortable leading, interfacing directly with business areas to capture business requirements and translating them to technical requirements. I have used Agile and SDLC approaches.'Soft' Skills • Collaboration/communication • Leading, mentoring/coaching. • Recognising the value people bring to a project and supporting them to enhance their contribution • Taking responsibility and responsibility and ensuring follow through Technical Skills • SAS and SQL, Dashboarding • Design/coding/ETL • Data Structure: Analysis of complex data structures, mapping, matching distinct sources • Data Migration: Matching, cleansing/scrubbing and reconciliation of distinct but • related sources • Documentation External (e.g. Confluence), data/process flow diagrams. metadata • Documentation Internal to code. Thorough detail on intention of each step • Testing: UAT liaison, regression testing, reconciliation • Scheduling: Ctrl M, SAS DI Studio (last one a little dated:) • Dashboard design/development SAS: Enterprise Guide (EG), Macros, Visual Analytics and Stored Processes on Windows/Unix/Mainframe • SQL: Teradata/Oracle/SQL-Server/DB2/SAS • MS SQL-Server: Stored Procedures • Code control tools (Bitbucket/Git, SVN Tortoise) • MS Suite: Word, Excel including Pivot tables, formulae and VBA (somewhat dated), MS-Access (somewhat dated) Industries • Banking: Personal, measuring Customer Numbers, Funds Under Management, Identifying Fraud, Documenting/ Producuctionisation of Credit Cards • Insurance • Government/Public Sector: Dashboard Reporting: Immigration, Internal Health and Safety, Staff Compliance • Telecom: Reporting