Jan 2013 – Jan 2014 · 1 yr · London, United Kingdom

• I was the QlikView and SQL Server BI/MI Lead Developer for global Market, Credit and Contingent Risk
• QlikView architecture, design, development and support to create various Risk KPI and Metrics dashboards.
• ETL design and development using SQL Server 2008r2, MS BI Stack SSIS and T-SQL
• C# design and development. For example, console application to remotely execute QV tasks using EDX methods and classes.
• Development of ASPX C# web pages for reference data maintenance.
• Design and development of multiple AutoSys schedules
• User support during UAT and general out of office UAT and Production support.
• Agile software development using Scrum.

Oct 2012 – Dec 2012 · 2 mos · Nuneaton

• Working on the Mobile BI team specifically on the Vodafone Account.
• Establishing QlikView templates and best practices.
• Design and development of QlikView dashboards, scorecards, KPI and other reports using all the charts and
• GUI features available in QlikView.
• Extraction of data from SQL Server 2008r2 databases using SSIS and T-SQL. Extracted data stored in QVDs.
• Deployment and administration of production QlikView reports and environment using QlikView
• Management Console and QlikView AccessPoint.
• Develpoment using Set Analysis, QlikView functions and QlikView scripting.
• Connecting to OBDC and OLEDB data sources.
• Analyse business needs for Dashboards and other QlikView solutions.
• End-to-end design and implementation of QlikView solutions.

Feb 2012 – Oct 2012 · 8 mos · Leicester, United Kingdom

• Developed and maintained 50+ SQL Server 2008/2008r2 SSIS ETL Packages.
• Developed and maintained 50+ SQL Server 2008/2008r2 SSRS Reports. Data extraction using T-SQL, stored procedures and MDX. KPI analysis using Dashboards.
• Developed 100s of T-SQL stored procedures, functions, views, DML scripts and data migration scripts.
• Prototyping reports in Qlikview Personal Edition v11. KPI analysis using Dashboards.
• 10% of time working closely with Business Users and other stakeholders.
• Developed Dynamic SQL to execute via stored procedures and executed open query MDX via stored procedures using linked servers.
• Assisted in the design of the data warehouse.
• Developed an overnight backfill data update process using SSIS and stored procedures to update a 1.2 billion row Fact table.
• Assisted in the development and maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing and synchronising Production and DR cubes.
• Production of test plans & systems documentation to Company & Project standards.
• Development phases using Agile and Test Driven Development techniques.
• ETL from Oracle/Informix legacy systems to SQL Server.
• Migration of Oracle/Informix DB, Tables, SPs etc to SQL Server.
• Migration of BOXI reports to SSRS.
• Creation of SQL Agent jobs for batch processing / production job scheduling.
• SQL Profiler for Query Optimisation.
• Visual Studio 2008/2010 C# development
• o Create APSX web pages to interrogate and manipulate database tables.
• o Create interfaces to IBM MQ data to retrieve messages from queues.
• o Create Windows Services
• Support of Live Production systems during office hours.
• Some Managed Data Services, PowerPivot and Report Builder 3.0 experience
• Some SQL Server 2012 experience.
• Source control - Visual Source Safe and Team Foundation Server.
• Business areas – Business Intelligence, Retail, Sales, Manpower.

Apr 2010 – Feb 2012 · 1 yr 10 mos · London, United Kingdom

• I was the Equities, Securities Lending, Business Intelligence SQL Server BI/MI Lead Developer for EMEA, Prime Services
• Developed and maintained 100s of SQL Server 2005/2008/ SSIS ETL Packages.
• Developed and maintained 50+ SQL Server 2005/2008 SSRS Reports. Data extraction using T-SQL, stored procedures and MDX. KPI analysis using Dashboards.
• Developed 100s of T-SQL stored procedures, functions, views, DML scripts and data migration scripts.
• Assisted in the development and maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing and synchronising Production and DR cubes.
• Assisted in the Analysis, Design & Implementation of Kimball compliant Data Warehouse
• Prototyping reports in Qlikview Personal Edition v10. KPI analysis using Dashboards.
• 25% of time working closely with Business Users and other stakeholders.
• Coordination of offshore development and testing teams in India and America.
• Control-M job design, development, testing and support. Developed and maintained 2 Control-M schedules which consisted of 250+ jobs with cross server in and out conditions.
• 24 hour fix on fail live service 3rd line production support.
• Migration of Microsoft Access system to SQL server.
• Production of test plans and other systems documentation to Company and Project standards.
• Development phases using Agile and Test Driven Development techniques.
• Visual Studio 2005/2008 C# development
• o Create APSX web pages to interrogate and manipulate database tables.
• o Create a build process which produces on DB script based on a build manifest.
• Responsible for the team version control using Rational ClearCase and Subversion SVN (Tortoise). Creation of branches, labels, tags and config specs.
• Business areas – Business Intelligence, Prime Services, Securities Lending, Rehypo, Counterparty Risk, Transfer Pricing, Product Control.

Mar 2005 – Mar 2010 · 5 yrs · London, United Kingdom

• Conversion of SQL Server 2000 DTS to SQL Server 2005 SSIS
• Analysis, Design & Implementation of Kimball compliant Data Warehouse
• Developed & maintained 100s of SQL Server 2005/2008/ SSIS ETL Packages
• Developed & maintained 50+ SQL Server 2005/2008 SSRS Reports. Data extraction using T-SQL, stored procedures & MDX. KPI analysis using Dashboards
• Developed 100s of T-SQL stored procedures, functions, views, DML scripts & data migration scripts
• Development & maintenance of SSAS OLAP Cubes. Maintenance, deployment, reprocessing & synchronising Production & DR cubes
• Creation & maintenance of 100s of business user reports using QlikView Professional & Enterprise
• Installation of QlikView Publisher on VM & App servers
• Creation & maintenance of batch job schedules using QlikView Publisher
• Supported the Architects in the design of the BI solution so that it conforms to standard Data Warehousing principles i.e. Kimball Methodology
• Coordination of offshore development & testing teams in India & America
• 30% of time working closely with Business Users & Senior Management on a daily basis to gather requirements & to produce prototype reports. Worked with Business Users to convert their SQL into Adhoc reports
• Developed migration scripts & DTS/SSIS packages from Oracle & Sybase to SQL Server
• Visual Studio 2005 C# development of APSX web pages to interrogate & manipulate database tables
• Create a build process, which produces on DB script based on a build manifest
• Production of test plans & other systems documentation to Company & Project standards
• Assisted & lead System Testing, User Acceptance Testing (UAT) & Operational Acceptance Testing (OAT) support across continents & time zones
• 24-hour fix on fail live service 3rd line production support
• Responsible for the team version control using Rational ClearCase. Creation of branches, labels & config specs
• Business areas – Trade & Product Control, Exposure & P&L Reporting, Counterparty Risk

Jan 2004 – Jan 2005 · 1 yr · Derby, United Kingdom

• Developed PL/SQL / SQL Objects & Scripts: SQL*LOADER, External Table, Meta Data, Packages, Procedures, Cursors, Autonomous Transactions, Functions, Sequences, Triggers, Database Links, Views, Materialized Views & Logs, DB Links, DBMS Jobs & scheduling, Data Correction SQL scripts, DDL & Tablespace creation scripts.
• Used Oracle 9i, PL/SQL, SQL, SQL*PLUS, , SQL*LOADER, TOAD 7.5.2.0, PVCS, Oracle Enterprise Manager, Tera Term & FTP
• Used messaging technology & packages for Oracle Advanced Queues & XML.
• Provided technical skills in order to prove the Egg business departments with a consolidated view of all its customer data in a single repository.
• Have gained financial sector business knowledge. This includes life insurances (PPI e.g. Accident, Sickness & Life), general personal insurances (motor, home, travel), pensions (AXA life), mortgages (Prudential), credit cards (Boots, MasterCard), personal loans, savings, investments & the BASEL II implementation.
• Coding, Unit / System testing & delivery of the following functionality - Egg Money Manager (EMM), Trigger & Spend data marts, OMIGA data feed, UKI Motor Web & Phone Quotes Backfill, MasterCard CMF, MasterCard SQL*LOADER control files, CIC SQL*LOADER control files, BACS, DCM, AXA Home / Travel / Motor Quotations & Policies, Contact Address data cleansing & formatting.
• Basic Unix shell scripting – calling SQL*LOADER another Oracle scripts.
• Data Migration from legacy systems to new Management Information system using PL/SQL & SQL*LOADER.
• Have used BusinessObjects 5i & 5.1 to produce client specified universes & reports. Technical scope as per BP (see above).
• I have also produced supplementary Analysis documentation which has been incorporated into the master specification by the team’s Business Analysts e.g. BACS & Trigger Mart
• Produced the PL/SQL coding standards & other project related quality & process documentation
• Coached & mentored new members of staff

Sep 2001 – Jun 2004 · 2 yrs 9 mos · Telford, United Kingdom

• Designed, developed, tested & delivered Cool:Gen & Advantage:Gen (V5 to V6.5) GUI & Batch functionality.
• Built PL/SQL (using TOAD) & Unix batch functions using Oracle parallel processing and Unix Shell scripting.
• o Writing code with effective and appropriate SQL hints
• o Writing code using both the rule-based and cost-based optimizer
• o Writing code using the many built-in functions
• Performed the role of Project DBA (using TOAD and DBA Studio) for 2 years on a NT and UNIX platform.
• o Maintaining the Oracle Database on a Unix Server Environment including File and Disk Management
• o Performing Backup and Recovery tasks
• o Installing Oracle on Unix and Windows NT
• o Creating a Parallel Oracle Database
• o Configuring Net8 Clients
• Used SQL*LOADER extensively to load data from flat files.
• Built, tested & delivered Oracle Based batch functions in an NT and Unix Tuxedo environment using the Maestro scheduling tool.
• Mentored and coached Graduates and other permanent members of Staff.
• Performed the role of Technical lead, which has included the use of ‘best practices’.
• Led teams of up to 12 people to deliver business critical Oracle based software.
• Produced analysis and design documentation for development teams.
• Been involved the Oracle 9i validation project
• Been on 24 hour fix on fail call for all the functions produced by the project
• Integrated calls from Advantage:Gen code to Oracle based PL/SQL and C code.
• PL/SQL / SQL Objects developed: SQL*LOADER scripts, External Table scripts, Packages, Procedures, Functions, Sequences, Triggers, Database Links, Views, Data Correction SQL scripts, DDL scripts and Tablespace creation scripts
• Unix Scripting objects developed: File handling, text manipulation, job scheduling, SQL*LOADER Unix scripts, oracle script management (passing parameters to oracle scripts).

Jan 1997 – Jan 2001 · 4 yrs · Woking, Surrey

• Developed and maintained many GUI Client Server and Batch applications which have utilized many new features of Cool:Gen and used third party software such as Sheridan’s calendar and tab OCX controls.
• Ported the Cool:Gen code to various UNIX environments such as HP, Compaq, Sun and Sequent.
• Installed Composer and Cool:Gen software on Windows NT, HP UNIX, Sun, Sequent and Compaq environments.
• Built many PL/SQL and Unix batch functions using Oracle parallel processing and Unix Shell scripting.
• Lead a team of six to develop, install and support the production version of InterconnecT – this has involved a great deal of technical coaching and mentoring especially with the Graduate Trainees.
• Been responsible for the data model management for various releases of the InterconnecT product.
• Involved in the writing of GUI, Quality Assurance and Installation standards for Interconnect product.
• Been involved in the worldwide systems installation, support and maintenance division.
• Development of GUI client server applications using Java 2 with Swing, JDBC, RMI and CORBA.
• Performed the role of Oracle 8i DBA for 9 months. This has involved
• o performing daily start up and shutdown tasks
• o creating instances, databases and users
• o monitoring data file sizes and efficiency
• o managing users and there resources
• o performing exports, imports and backups
• PL/SQL / SQL Objects developed: SQL*LOADER scripts, External Table scripts, Packages, Procedures, Functions, Sequences, Triggers, Database Links, Views, Data Correction SQL scripts, DDL scripts and Tablespace creation scripts

Apr 1996 – Present · 30 yrs 1 mo · United Kingdom

• QlikView, Qlik Sense Enterprise, Qlik Sense SaaS, Power BI, Kibana, Elastic Stack, Azure Data Factory
• Migration of Qlik applications to Power BI.
• SQL Server, Data Warehousing, Business Intelligence, ETL, Data Architecture.

Apr 1996 – Sep 1997 · 1 yr 5 mos · Dudley, United Kingdom

• Been responsible for the design, construction, delivery and maintenance of three major design areas - Work Instructions, Work Instructions Printing (On-line & Batch) and Usage Enquiry. This has involved supervising a team of up to three IEF / COMPOSER developers.
• Developed numerous (35) IEF C3 GUI Client / IEF CICS Server and (3) Batch procedures (including check pointing / restart processing / streaming) using IEF V5.2 and Composer 3 including development of several IEF interfaces to existing systems. Also used CICS printing products such as Advanced Function Printing and Prevail.
• Given technical assistance and advice to members of the project.
• Performed QA Reviews on several GUI and Batch procedures developed by other Contractors on the project.
• Been involved in the migration of code from PC to IBM mainframe environment using ENDEVOR and the IBM IEF Implementation Toolkit and performed system testing using database tools such as QMF, RELATIONAL TOOLS & SPUFI and client/server tools such as the IEF Client Manager.
• Created an integrated PC and mainframe database, which was utilized by the other members of the project.

Jun 1991 – Apr 1996 · 4 yrs 10 mos · Solihull

• Developed numerous GUI Client Server procedures, several batch procedures, common action blocks to read & create serial files, & specified C external action blocks.
• Been involved in the development of Invoicing & Accounting systems using IEF V5.2. PC construction & unit testing on OS/2 DB2/2 environment - target environment was UNIX Oracle for Server applications & Windows for the GUI Client executables.
• System tested on-line & batch procedures on UNIX using SQL*PLUS to create & manipulate test data & to verify test results.
• Been heavily involved in the cross generation of on-line & batch procedures from the OS/2 DB2/2 OSPM environment to the UNIX Oracle Windows client server environment. This has involved the use of the Windows Software Development Kit (SDK), the IEF Implementation Toolkit, TI utilities such as AEF & IEFC1, general utilities such as the File Transfer Protocol (FTP) & an understanding of UNIX principles such as daemons, sockets & funnels.
• Performed several model management tasks such as change control, version management, impact analysis, migrations & adoptions. I have also assisted the writing of the Model Check In / Check Out procedures for both seamless transfer & manual file transfer of the IEF.TRAN files. I have also frequently used the IEF query facility Central Encyclopaedia (CE) Access.
• Programming on ICL George 3 / 2900 / 3900 using VME COBOL - Batch & TP.
• Systems Analysis of Gas Billing system using SSADM V4 techniques. Programming on ICL 3900 using VME COBOL - Batch & TP. Systems Test Preparation using Maestro Development Workbench. System Test scripting. Systems Test Execution. Systems Delivery, Implementation & Support. Project & Team planning using PMW & ARTEMIS. Team Leading - up to 6 people (which have included permanent members of staff, Contractors & temporary contract staff) on several projects which have lasted from 3 to 9 months in duration.