Michael Stevenson Email & Phone Number

London, Gb

London, United Kingdom

Asurion (London) Mar 2016 – present Database Developer (contract)(Oracle12c, SQL, PL/SQL, SQL, Linux, SQL Server 2016, T-SQL, SQLDeveloper, SSMS, Jira, GIT, SVN)1 - Creation of a new version of the company's core insurance softwareAsurion, (although relatively unknown in the UK), is a very large American insurance company with a yearly turnover of over $6.5 billion.I worked within a small team to deliver the new version of their insurance product, called Horizon. Specifically, I worked to expose the data access layer (Oracle 12c), in order for the SOAP services (Tibco) to access insurance information and pass to the front end (Pega).Working in the usual Agile/Scrum and eJira/Jenkins framework, the job consisted of:* Turning the BA requirements into SQL / PL/SQL modules.* Ensuring the overnight file load process was developed successfully and then ran smoothly (typically loading 300k recs per night).* Optimising many areas of the system which required urgent performance tuning.* Considerable complex BI report writing.* Interviewing / mentoring more junior database developers.* Working constantly with offshore teams in India2 - Extraction of data from legacy SQL Server systemI also created regular extracts from the legacy SQL Server system (to flat files) and loaded these into the new Oracle version of the database (using SQLLoader).

Asia, Russia, Europe

After many years of working in computing, I was given the opportunity to travel extensively in Asia, Russia and Europe.

London, United Kingdom

Oracle 11g, PLSQL, SQL, Unix.ETL Data MigrationRecruited to carry out a large ETL data migration of pension data from one secure database to another. I was selected because of my previous experience in this area.Working in an Agile/Scrum framework, the task consisted of:.• Interviewing DBAs and DB owners to collect business requirements.• Analysing the data structures in the 2 databases.• Proposing the ETL solution to stakeholders• Carrying out Data Modelling for the new bridging architecture (meta data structures).• Writing the actual migration code (PL/SQL stored procedures).• Creating and performing water-tight unit tests and later system tests.• Considerable logging and error trapping was used for this risk-averse environment.Because of the large number of records involved, I used features such as Flashback Database and Direct Path Inserts / No Logging.

London, United Kingdom

Oracle11g, PL/SQL, SQL Server, T-SQL, SSIS, SSRS, Business Objects, Unix, Java, XML, Golden Source, Assassin4 distinct tasks:1 - Data Warehouse developmentCreated a new Loans Data Mart for the existing Data Warehouse, bringing in new functional areas of the core Production database for Lloyds’ MI users.2 - ETL Data MigrationWrote all the software (Stored Procedures, T-SQL, SSIS) required for the migration of data from one large Oracle database (Summit settlement system) to a SQL Server system (Assassin SSI). 3 - Risk ReportingCreated many SQL Server reports using Stored Procedures T-SQL / SSRS, for the Lloyds’ Risk team. 4 - ‘Golden Source’ ReportingCreated MI / Risk (e.g. SOX/MiFID etc) reports from data in the core ‘Golden Source’ database.

London, United Kingdom

Oracle10g, PLSQL, Unix, XMLCreation of an overnight load process for equity derivative and Fixed Income pricingWorking in a small Front Office team, I helped develop (PL/SQL) an ETL data integration batch process which loaded overnight pricing and benchmark feeds (JPM, Rimes and Bloomberg) into a new database, ready for Fund Managers to trade in the morning. Other Tasks:• Resolving BAU intraday issues for Fund Managers. e.g. a file not being processed, or data discrepancies (incorrect sedol / BBID / CUSIP / unexpected NAV, etc). It basically consisted of a lot of studying and understanding existing code.• Performing interviews for prospective new employees.• Mentoring less experienced members of the team.• Serving as an Oracle SME for other employees.

Hatfield

Forms‭ ‬10g,‭ ‬Oracle10g,‭ ‬PLSQL,‭ ‬UnixCreation of a financial reporting tool for a Commissions System• Created the front end interface (Developer 10g Forms).• PLSQL packages were written to extract & manipulate data before writing to csv files.

Reading, United Kingdom

Developer 10g (Forms10g web enabled, Reports 10g), Oracle9i, PLSQL, Unix, XML, Javascript, JSP)Re-development of part of Prudential’s Pension Management System (quotations, annual investment statements, etc)

London, United Kingdom

Oracle9i, PLSQL, UnixWorking in a large team, I helped to merge 100 legacy databases into 1 large Oracle database.The nature of the work (safety of airline components and maintenance) meant that data integrity in my migration code was of the highest importance.

Oracle developer (contract)