David Swann's Email Addresses & Phone Numbers

📖 Summary

I am a Senior Oracle PL/SQL Analyst Developer with 18 years experience of high profile projects at clients in the financial services and technology sectors. I have been responsible for end-to-end development, communicating with people at all levels, and have a proven track record of designing and creating databases, robust and maintainable high performance ETL solutions and re-usable PL/SQL packages, SQL scripts and UNIX shell scripts. I have promoted the use of common modules and utilities within teams to reduce development time and increase consistency, and have applied my extensive analysis skills and knowledge of the Oracle technology stack to identify and resolve complex technical problems and establish flexible data models and application architectures to meet business requirements. KEY SKILLS & ACHIEVEMENTS • Designed, developed and tuned Oracle PL/SQL solutions and corporate databases since 1998, initially for a global IT consultancy, then for asset management companies and as a contractor. • Also developed UNIX shell scripts, Perl scripts and user interfaces for bespoke and packaged applications using Oracle APEX, Visual Basic and other interface design tools. • Performed financial accountant and auditor roles before moving into IT to develop and support data warehouses, ETL solutions and financial accounting, HR, investment analysis and equity / fixed income trading applications. • Successfully completed the full software development lifecycle on projects lasting up to 2 years or more. Experienced in all stages, from requirements gathering and technical analysis to design, build, testing, deployment, tuning and support. • Consistently rated in the top 5% of employees at annual appraisal during the 9 years as a permanent member of staff at CSC and Schroders before becoming a contractor. • Constantly seeking to learn new technical skills and business knowledge, both on the job and through formal study. IMC qualified. Participated in the CFA programme.Senior Oracle PL/SQL Analyst Developer (Contract) @ Part of the implementation team for a new financial accounting system using Oracle E-Business Suite R12. Focussed on ETL interfaces to the Payables and Receivables modules. Worked with internal developers and third party infrastructure / software providers. • Configured Oracle Change Data Capture (CDC) to mine the source database redo logs for relevant data changes and developed Oracle PL/SQL packages to extract, transform and load these changes into the target database. • Derived and implemented source-target data mappings and developed further generic PL/SQL utility packages to standardise error handling, email generation and CDC configuration. • Developed UNIX shell scripts, bulk data transfers using SQL*Plus and SQL*Loader, SQL*Plus summary/detail reports and performed full-table analysis to identify differences between source/target systems. • Tuned and enhanced queries, data structures and PL/SQL packages in a central Oracle database that utilised the ANYDATA datatype to provide a generic hub and spoke mechanism to store and forward the change data used to synchronise multiple applications. • Utilised Oracle Analytic Functions and extensions to the SQL GROUP BY clause to improve query performance by making fewer passes through the source data. Utilised PL/SQL bulk SQL and bulk binding to reduce PL/SQL to SQL context switches and applied set operators to PL/SQL collections to improve performance where complex procedural logic was required. From August 2010 to April 2015 (4 years 9 months) Oracle PL/SQL Business Analyst (Contract) @ GAM is one of the world’s leading independent, pure-play asset managers. The company provides active investment solutions and products for institutions, financial intermediaries and private investors, under the brands GAM and Julius Baer Funds. • A hybrid Oracle PL/SQL developer and business analyst role in the Fund of Hedge Funds division. Projects ranged from smaller, autonomous pieces of work to large team initiatives covering activities across the full software development lifecycle. • Designed and developed PL/SQL solutions to support pricing and risk analysis, data migration and field level change history based on the Oracle Designer journal model. • Created a PL/SQL API to extract data from a bitmap indexed star schema for an investment analysis dashboard that utilised GROUP BY ROLLUP to return hierarchical data as a single data set to a C# front end that gave end users near instant startup and drill down response times. • Business analyst on a two year project to create an Oracle / C# system to record research, analysis and due diligence used to identify and monitor potential and actual investments. Analysed business processes, agreed improvements and authored detailed business requirements documents. • Performed weekly drawdown analysis for invested funds and attended investment strategy meetings with hedge fund managers to gain a better understanding of their business processes. From December 2007 to March 2009 (1 year 4 months) Oracle PL/SQL Analyst Developer (Permanent) @ Developed Oracle PL/SQL packages for a multi-terabyte Eagle PACE data warehouse to extract, transform and load (ETL) securities, rating, index, pricing and fund data. • Liaised with business analysts and process owners to complete the full software development lifecycle from analysis and design, to development, testing, deployment and support. • Authored detailed technical documentation and developed interfaces between the data warehouse and bespoke derivatives trading application to support swaps trading. • Responsible for developing the position and trade interfaces between the data warehouse and a new equity / fixed income fund accounting system during a two year project to consolidate and decommission multiple legacy systems. • Self-funded Chartered Financial Analyst (CFA) Level I course. From October 2006 to November 2007 (1 year 2 months) Senior Trading Analyst Developer (Permanent) @ Completed analysis, development and support for trading and settlement applications. Worked closely with equity and fixed income fund managers, traders and technical teams globally to resolve trading, data and infrastructure issues and to enhance systems. • Recognised as a Charles River Investment Management Solution (IMS) specialist. Included blotter, workflow, stored query, security, configuration and support. • Developed detailed understanding of Straight Through Processing (STP) of buy-side orders from placement and fill via FIX to confirmation, settlement and fund accounting feeds. • Undertook end-to-end project development. Developed Sybase Transact-SQL and Perl scripts to extract, transform and load (ETL) security, trade and position data. • Monitored batch job schedules and dependencies on external systems using IBM Tivoli Workload Scheduler (Maestro) on UNIX. • Utilised analytical, problem solving and SQL skills to prevent breaches of a £500m client mandate that could have resulted in the loss of the account. • Liaised with JP Morgan to install and configure their Onsite algorithmic trading system. • Self-funded Investment Management Certificate (IMC) course. From November 2003 to September 2006 (2 years 11 months) Lead Technical Consultant (Permanent) @ Computer Sciences Corporation (CSC) is a global leader of next-generation IT services and solutions. The Company's mission is to enable superior returns on their clients’ technology investments through best-in-class industry solutions, domain expertise and global scale. • Key team member in the CSC PeopleSoft ERP Practice, specialising in financial accounting and HR systems for clients Aon, Bhs, BNFL and Schroders. • Performed Lead Technical Consultant role for Oracle and PeopleSoft technologies. • Also a MS SQL Server Consultant to Schroders. Installed and configured PeopleSoft financial accounting and HR systems. Ensured a seamless knowledge handover from in-house teams to CSC to gain confidence of Schroders management. • Liaised with key decision makers up to board level, IT professionals and business analysts to produce specifications and deliver technical solutions, both remotely and at client sites. • Installed and configured UNIX / Windows database, application, web and batch servers. Further developed databases, web pages, reports and ETL interfaces between systems. • Member of pre-sales bid teams that presented to prospective new clients. From December 1999 to October 2003 (3 years 11 months) Oracle PL/SQL & Visual Basic Developer (Permanent) @ Part of the Year 2000 (Y2K) programme for client British Aerospace (now BAE Systems) to replace flat file / mainframe technology with Oracle databases and client-server applications. • Created Oracle schemas and developed PL/SQL packages to implement business logic and to cleanse, extract, transform and load (ETL) decades of mainframe legacy data. • Developed user interfaces using Visual Basic object-based code. From August 1998 to November 1999 (1 year 4 months) Systems Analysis Instructor @ Initially a fee-paying student on the course, then employed as the sole full-time instructor part way through my studies when both of the original instructors left. Taught systems analysis and design including data modelling and database design. From January 1998 to July 1998 (7 months) Co-Founder & Technical Director @ Analysed client requirements and designed and developed bespoke database applications. • Created an Estate Agent management system. Short-listed in tender bid to provide the system to The Woolwich. Negotiated at local, regional and IT Director level to provide the system to Black Horse and other agencies. From January 1995 to December 1997 (3 years) Analyst Developer @ From July 1993 to December 1994 (1 year 6 months) Graduate Trainee Chartered Accountant @ From August 1991 to December 1992 (1 year 5 months) BEng (Hons), Mechanical Engineering @ Loughborough University From 1987 to 1991 David Swann is skilled in: Oracle, PL/SQL, SQL, Databases, Database Design, Software Development, Performance Tuning, SQL Tuning, Data Warehousing, ETL, Unix, Unix Shell Scripting, Systems Analysis, Data Analysis, Data Modeling