Delivery of application development projects within Egg Banking Plc’s Corporate Data Warehouse (CDW), and the design, storage and manipulation of highly confidential customer, accounts and product data.- Data cleansing and deletion during decommissioning processes.- Sole developer for Data User Group (DUG) and Small Change Programme (SCP) work streams, often requiring the simultaneous development of up to five separate projects.- Creation of data extracts for both the wider Citi… Show more Delivery of application development projects within Egg Banking Plc’s Corporate Data Warehouse (CDW), and the design, storage and manipulation of highly confidential customer, accounts and product data.- Data cleansing and deletion during decommissioning processes.- Sole developer for Data User Group (DUG) and Small Change Programme (SCP) work streams, often requiring the simultaneous development of up to five separate projects.- Creation of data extracts for both the wider Citi business and external organisations using Oracle predefined packages, ODS load (an in-house SQLLDR-based method of ETL) APEX and UNIX shell.- Alteration and/or performance tuning of existing database objects.- Replication of data from external sources (both non-Oracle and Oracle) into CDW using external tables, materialised views, triggers and Autosys-scheduled data feeds.- Project analysis, creation of detailed specification documents and basic data dictionaries. Show less

- Involved in full SDLC including review and analysis of requirements, project estimates, writing test plans, scripting test cases and executing manual and automated scripts.- Performed automation coverage analysis and regression baselines.- Gatekeeping process (SCM) responsibility, coordinating development releases and security patches into critical system test environments.- Created detailed defect reports and took ownership of defects through to a satisfactory auditable… Show more - Involved in full SDLC including review and analysis of requirements, project estimates, writing test plans, scripting test cases and executing manual and automated scripts.- Performed automation coverage analysis and regression baselines.- Gatekeeping process (SCM) responsibility, coordinating development releases and security patches into critical system test environments.- Created detailed defect reports and took ownership of defects through to a satisfactory auditable conclusion.- Involved in detailed error-checking of technical specification/design documentation. Show less