Lance Purtill Email & Phone Number

Hailsham, GB

London, United Kingdom

• Data Custodian:Where applications are being decommissioned and the business deems the application to contain golden source data this data is stored in Informatica vaults. The data Custodian is involved at several.
• Responding to legal, regulatory (investigations) and internal user queries on vaulted data
• Understanding how the data, its sources and the application are constructed
• Authorised Viewers of the data - some datasets will contain sensitive or confidential information
• Working with the business to help define the data to be retrieved. Work with the requestor to understand the request, provide options and definitions of different fields available for retrieval and express the request.

London, United Kingdom

Working with investigators in the correspondent banking Financial Intelligence Unit (FIU). - Risk Rank Bank ReviewRan a Proof of Concept (PoC) exercise for SWIFT Compliance Analytics software which provides a holistic view of all wire transactions. The key objective of the PoC was to use the tool to prioritise the in-flight UK correspondent banking vostro.

London, United Kingdom

The Start-up Loans Company, chaired by James Caan, is a Government-backed initiative tasked to help individuals start successful businesses across the country by providing low cost finance to those excluded from mainstream markets.Reporting to the Senior Management Team, documented the AsIs picture of current MI reporting processes. Presented important.

Peterborough, United Kingdom

• Projects: Stategic MI ReportingBusiness facing role requiring a director level interface. Organised and built the automated gathering of company wide data to design, create and implement strategic Management.
• Top customer by revenue reporting
• Business application usage charting
• Stock utilisation
• Average price reporting
• Damage billing summary

Woking

Researched information sources needed for the migration. Organised access to worldwide data sources with business, infrastructure and technical teams. Created ETL (Extract, Transform and Load) processes to hold and maintain project data. Provided an Intranet web based front end to report mailbox status, project metrics and enable the scheduling of mailbox.

• Extracted daily data from a PostgreSQL 3rd party tool to produce daily summary reporting of desktop machine performance to show if they are good candidates for virtualisation. Data stored in a 100GB+ SQL Server DB.Two.
• Hosted Desktop – Virtual desktops for the business, using 3rd party desktop data
• Windows 7 – Desktop Rollout project
• Data Cleansing – The right people, with the right access, to the right data
• Data Centre Capacity Breach Trending Analysis
• Performance Monitor Charting - Server Vitrtualisation project

Skills Used: Business/Systems Analysis, Microsoft Visual Basic 6.0, Microsoft Access 97/2002, Excel, Windows NT/XP, Ingres II, UNIX (Solaris), Embedded SQL, C, Perl, HTML 4, SQL Server 2000Developed and supported systems for Staff Personal Account Dealing, Training and Tracking and Asian Disclosure of Interest.Enhanced and supported GCS (Group Compliance.

• Skills Used: Business/Systems Analysis, Ingres 6.406/II, UNIX (HPUX), Embedded SQL, C
• Reverse engineered Trade Settlement Systems to provide Functional Specifications for these systems to the business and migrated these systems from one HP9000 machine to another.
• Migrated Ingres 6.4/06 systems to Ingres II.
• Wrote procedures for and decommissioned Legacy systems.

• Skills Used: Business/Systems Analysis, Ingres 6.406/II, UNIX (HPUX), Embedded SQL, C
• Trained new starters in Ingres/UNIX/Embedded SQL/C
• Implemented Service Guard package in Ingres environment
• Recreated development environments for Securities Settlement systems which had lost track of version control and wrote Code Librarian procedures to enable a stable environment
• Part of team interfacing SWIFT into existing Securities Settlement Systems
• Debugged and rewrote MIS(Management Information System) software for New York office in direct contact with the New York Head of Securities Operations

Skills Used: Business/Systems Analysis, Microsoft Visual Basic 4.0, Microsoft Access, Ingres 6.405/II, UNIX (Sequent), Embedded SQL, C, Crystal Reports, GQL• Redeveloped and supported property management system; communicating directly with key users to establish and implement their requirements.• Designed and built BACS(Bankers Automated Clearing Services).

Skills Used: Business/Systems Analysis, Ingres 6.404/II, UNIX (HPUX), Embedded SQL, C, COBOLProgrammed in COBOL supporting and enhancing a large television rating driven Airtime Sales System. In 1991 a decision was made to rewrite the Airtime Sales System in Ingres/C/UNIX. I was chosen as one of the team to work on the analysis of the new system and became.