Willis Towers WatsonSkills: ORACLE 12c, PRO*C, PL/SQL, SQL, UNIX shell scripting, SQL Developer, Putty, WinScp, PVCS , GIT, Bitbucket, Software Mover, Agile, JIRA, Confluence, Jenkins• Willis Towers Watson is a global advisory, broking and solutions company that helps clients turn risk into a path for growth.• Working as part of the Technology & Administration Solutions team (TAS) on project Titania for the Hong Kong market.• Design and development of enhancements to an in-house developed pensions administration system called Benefit Connect HK.• Responsible for requirements and impact analysis, specifying business and IT solutions for projects / enhancement requests.• Producing logical systems design models in conjunction with Senior Systems Analyst / System Architects.• Development of payment interface and fee rebate processing modules using PRO*C, PL/SQL and SQL.• Producing detailed technical designs, coding, unit / system testing and documentation.• Working with stakeholders, product owners and team members split across a virtual scrum team based in Manilla, India, Hong Kong and the UK.

ElexonSkills: ORACLE 12c, ORACLE Forms 11g, PRO*C, PL/SQL, SQL, UNIX shell scripting, XML, SQL Developer, Putty, WinScp, FileZilla, SVN, Agile, JIRA, Confluence, ALM• The Settlement Administration Agent (SAA) is a suite of services that support the Balancing and Settlement Code (BSC) to calculate energy charges by comparing how much electricity generators and suppliers produce / consume against actual volumes.• Working as part of a UK delivery team to enhance the existing application stack for a major industry change in the Energy industry.• Design and development of enhancements to the BSC system to facilitate the settlement of exchanged GB balancing energy products within the Trans European Replacement Reserve Exchange (TERRE).• Development of user maintenance screens for RR Activations / Bid Offers data using Oracle Forms 11g.• Development of settlement calculations using PRO*C, PL/SQL and SQL.• Producing detailed technical designs from functional specifications, coding, unit / system testing, documentation and performing code reviews.• Working with stakeholders and team members split across a virtual scrum team based onsite & offshore.

Skills: ORACLE 11g R2, RAC, PL/SQL, SQL, Java, Performance tuning, ORACLE Forms 10g, PRO*C, SQL Server Management studio, LINUX shell scripting, GIT, Bitbucket, SQL Loader, Datapump, TOAD, JIRA, Confluence, Control-M, ETL, FitNesse, Jenkins, Artifactory, Agile, Scrum• M&G Investments, Prudential Plc’s UK based fund management business, underwent a number of large IT regulatory development projects. Worked integrally on the Solvency II and MiFID II Regulatory Reporting projects.• Responsible for the requirement analysis, design, development and migration of a collateral apportionment application developed in Java to Oracle. This application allows business users to correctly apportion Cash & Stock collateral received or paid to support OTC and FFX trading. Other activities include development of interfaces and feeds to support regulatory reporting requirements.• Producing functional specifications and technical design documents to support architectural and high level designs, coding to user acceptance testing.• Participating in architectural and design workshops and providing input into designs.• Working closely with project stakeholders, product owner and team members split across a virtual scrum team based onsite & offshore. Working within an Agile, Scrum methodology to ensure delivery of high quality work with every sprint iteration. Other activities include sprint planning, estimation sessions, retros to facilitating daily standups.• Development operations, Release Build management, FitNesse test driven development and providing system testing, UAT and 3rd line production support.• Preparing release procedures and handover documentation for support teams.• Peer code review and governance of other developers deliverables.• Developing and automating Oracle jobs using Control-M and Linux shell scripts.

Skills: ORACLE 11g / 10g, RAC, PL/SQL, SQL, ERWIN Data modelling, Performance tuning, Materialized Views, Development DBA activities, ORACLE Forms 10g / Discoverer, SQL Server Management studio, T-SQL, SSIS, LINUX shell scripting, Subversion, SQL Loader, Datapump, RMAN, TOAD, JIRA, Mantis, Powershell scripting, JP1 scheduler, ETL, Datamasking, Agile & Waterfall software development, Scrum• Developing database designs that meet customer requirements and the Banks standard to support a wide range of solutions for various business areas across the EMEA region.• Building relational and dimensional data models that support OLTP / OLAP and BI database solutions• Design and optimisation of database schema design and the development of efficient code and ETL processes. Logical and physical modelling using ERWIN• Developing and automating Oracle jobs using Windows scheduler, DOS & Unix shell scripts, Powershell, CRON and DBMS_JOB• Lead developer in the implementation of a Market Risk data warehouse used for risk reporting• Design and development of software using agile development practices• Development DBA activities include installations, upgrades and applying patches• BAU, root cause analysis and 3rd line production support• Defining and exercising database standards, guidelines and procedures, evaluation of software products• Working with enterprise architecture, application development and support areas to help provide a stable environment that meets current business objectives, but is also adaptable to future change• Key member of a development team that implemented the Open Payments Framework for SEPA and Faster Payments Service at BTMU• Other duties involve assisting team leader with work estimation, resource planning project work and mentoring other team members

Skills: ORACLE 11g, PL/SQL, Subversion, Unix Shell scripting, Agile software development, Release Management, SQL Loader, Datapump, JIRA• The Employee Trade Request and Approval system (ETRA) is a personal account dealing system for Compliance IT. The global Gifts & Entertainment system (GECO) is a component of the Bank's Anti-Corruption Program. These systems required enhancements as part of a multi-country rollout. • Responsible for the design, development and testing of change requests on the ETRA and GECO systems within the Compliance IT department.• Reviewing database architecture, producing technical specifications and optimisation of code.• Conveying requirements to vendors, validating detailed designs, QA development standards• Administration and release management of the development and integration testing environments.• Bug fixing, problem analysis and resolution, 3rd line production support• Oracle development within a Java / Agile software development environment.

Skills: ORACLE v9i / 10g / 11g, PL/SQL, ORACLE Forms 9i/10g, ORACLE Discoverer , ORACLE Application Server, MS SQL Server 2000/2005, T-SQL, MS SSIS, DOS shell scripting, MS Visual Basic 6, MS Source Safe, SQL Loader, TOAD, rFrame v4.24, ERWIN• BTMU is replacing its back office system in overseas branches with a centralised package (WINS). This core banking application generates the Balance Sheet and Profit and Loss Statement for the bank. As part of a European system roll-out there is a need to provide interfaces to systems that support the reporting requirements of the local regulators.• Responsible for the design, development and support of the London Data Store (LDS), Mapping Server (MPS) and other back office / MI reporting systems. MPS maps the WINS database to meet the local regulatory requirements of each branch. Project work also includes changes for Basel II and Bank of England reporting• Working with business analysts and end users to deliver critical functionality on time and error free. Any delay would seriously impact the banks ability to meet its statutory obligations.• Development of interfaces and feeds using PL/SQL and SQL, which supplement the extraction, transformation and loading of the data hub. Other development activities include T-SQL, MS SSIS, Forms 9i/10g, Discoverer, performance tuning, DOS shell scripting and VB scripting.• Producing technical designs from external design documents, documentation, functional/integration testing, release management, production support and BAU activities.• Responsible for the database administration of development and test environments.• Oracle development within a C# / .NET environment.• Knowledge of Financial accounting and Regulatory Reporting.

Skills: ORACLE v9i / 10g, ORACLE Forms 9i, ORACLE Designer 6i, ORACLE Application Server (10g), PL/SQL, LINUX shell scripting, MS Visual Source Safe, TOAD• Responsible for the design, development and support of an intranet based warranty system that provides risk management services to the house-building and construction industry.• Forms 9i and PL/SQL development, performance tuning and shell scripting• Producing detailed technical designs from process models / functional specifications, coding to user acceptance testing.• Coordinating with an off-shore development team to clarify design requirements / knowledge transfers

Skills: ORACLE v9i, ORACLE Developer 6i, ORACLE Designer 6i, Geneva Billing Engine, PL/SQL, PRO*C, XML, LINUX shell scripting, Weblogic Application Server, CM Synergy, TOAD• Responsible for the design, development and support of a web based energy and telephony supply registration system.• Aspects of Oracle development include PL/SQL, PRO*C, Forms 6i, performance tuning and shell scripting• Producing detailed technical designs from functional specifications• Providing technical lead within small development teams• J2EE exposure within an Oracle environment.

Skills: ORACLE v9i, ORACLE Forms 9i, ORACLE Developer 6i,ORACLE 9i Application Server (9iAS), PL/SQL, LINUX shell scripting, PL/SQL Developer• Responsible for the design, implementation and support of an Insurance system (TIA) for internal and external customers• Producing technical specifications• Providing support to teams on site, production support and bug fixing.• Aspects of Oracle development include PL/SQL, Forms 9i, Reports, performance tuning and 9iAS

Skills: ORACLE v8i, ORACLE Developer 6i, ORACLE Application Server v4.0.7,PL/SQL, HP/AIX UNIX / PERL shell scripting, MS Access/Excel, TOAD• Responsible for the development, maintenance and support of a Loan and Asset management system (CapCon) , Global Client Information Exchange system (GCIX) and other back office applications for the Global Banking Division (GBD). GCIX is a terabyte class Data Warehouse.• Enhancements that spanned the development life cycle from requirements capture to user acceptance testing.• Writing, coding from and testing to functional / program specifications.• Developing interfaces for feeds received from multi-platform DB systems.• Implementing Data Warehousing techniques such as Bit map indexes and table partitioning• Global user liaison, production support and bug fixing.

Skills: ORACLE v8i, ORACLE Designer 2000 v6, ORACLE Developer 6i,ORACLE Application Server v4.0.8, PL/SQL, Database Administration, HTML, UNIX shell scripting, MS Access• Responsible for the design, development and deploy of web enabled communications system over the company intranet.• Systems developed using ORACLE Designer 6 and Developer 6i toolkit.• Responsible for the configuration of the ORACLE Application Server.• Support a trading system and other back office applications.• Provide basic administration duties for development database environments.• QA of work produced by junior colleagues

Skills: ORACLE v7 & v8, ORACLE Designer 2000 v1.3 & 6, PL/SQL, SQL*Loader, ORACLE Developer 2000 (Forms 4.5 & 5, Reports 2.5 & 3), UNIX shell scripting, SQL Navigator• Responsible for the design, development and implementation of client server applications, that includes a supply registration system, a business quotation system and a demand forecasting system.• Use of ORACLE Designer 2000 to achieve near 100% server code generation.• Project work has also involved creating data feeds / transfers to other internal systems, porting applications across versions of ORACLE, setting up testing environments, user training and providing production support.• Responsible for development plans and QA of design / code.

(Oct 1997 - Aug 1998) Lloyds Bank Skills: ORACLE v7, ORACLE Designer 2000 v1.3, PRO*C, PL/SQL, ORACLE Developer 2000 (Forms 4.5, Reports 2.5), UNIX shell scripting• Working for the Corporate Banking team preliminary tasks were assisting in system upgrades.• Migration of PRO*C applications across versions of Unix and the ORACLE server.• Y2K maintenance and an ORACLE SQL*FORMS 3.0 to Developer 2000 Forms 4.5 upgrade.• Implemented an Interest Calculation system in ORACLE Developer 2000 that encompassed the full development life cycle.• Project work also consisted of PRO*C development, shell scripting and producing documentation.(Jul 1997 - Oct 1997) Coca-Cola & Schweppes BeveragesSkills: ORACLE v7, ORACLE Designer 2000 v1.3, PL/SQL, SQL*Loader, UNIX shell scripting, Business Objects• Responsible for reporting supply data held in an ORACLE Information Warehouse to the purchasing department.• Implemented Business Objects universes, reporting system and data feeds from Oracle Financials.• Tasks involved requirements capture, producing documentation, coding and acceptance testing.

Skills: ORACLE v7, ORACLE Developer 2000 Forms 4.5, ORACLE SQL*Forms 3.0,PL/SQL, PRO*C, C, SYBASE 4.92 & 10, APT 4 & 5, T-SQL, UNIX shell scripting• Role involved the maintenance, development and support of an equine insurance trading system.• Initial tasks consisted of writing SQL reports, database procedures, C programs, front-end code and shell scripting. The role expanded to undertaking major system enhancement projects.• Optimised reporting system, database and application front end. Entailed identifying I/O bottlenecks, evaluating Database / application design, and re-writing code to generate efficient execution plans.• Development activities involved a Forms 3.0 to Forms 4.5 upgrade, PL/SQL development and PRO*C / Y2K maintenanceTechnical lead in a small development team. Estimated development effort, review of code produced by junior colleagues. Responsible for the administration of SYBASE Databases.