Paresh Patel

Experience

• 

  Morgan Grenfell & Co. Ltd

  Jun 1992 - May 1995

  Analyst/Developer

  Analysis, design, implementation and support/maintenance of both Ingres-based database applications and in-house & 3rd-party PC based applications for different business areas across the bank

• 

  Deutsche Morgan Grenfell

  Jun 1995 - May 1999

  Senior Analyst/Developer

  Development and support/maintenance of 2-tier (Powerbuilder/Oracle) client-server Regulatory Reporting application. Responsible for implementation of Powerbuilder and Oracle Pl/SQL components, SQL*Loader scripts & UNIX shell scripts to load/process data.Development and support/maintenance of the Global SAP R/3 and Deutsche Morgan Grenfell SAP R/3 implementations. Responsible for design and implementation of ABAP/4 software components, configuration of the special purpose ledger, support of overnight/weekend batch process etc. Show less

• 

  Deutsche Bank

  Jun 1999 - Jun 2012

  Senior Developer/IT Team Lead

  Senior Developer/ITPM managing delivery of 2-tier (.NET/Oracle) client-server web applications for various business areas across the bank. Main responsibilities included:- Managing projects across the full software lifecycle- Designing logical data models and implementing/maintaining physical data models in database- Implementing PL/SQL packages, procedures, functions - Creating table partitions & PL/SQL trigger-based generic audit-log facility- Building PL/SQL based generic ETL autoload framework (including SQL*Loader script generation)- Creating role-based user-security- Performance tuning database components- Leading vendor team and sharing components/best practices across projects- Project planning, effort/cost estimations, status reporting, client relationship management etc.Senior Developer/IT Team Lead managing development & support of 3-tier (Java/J2EE/Oracle) client-server Regulatory Reporting application. Main responsibilities included:- Implementing SQL*Loader scripts, PL/SQL modules & Java/EJB components for ETL processes- Performance tuning database components- Creating PL/SQL triggers for audit logging- Building UNIX shell scripts and Control-M jobs to automatically load feeds- Managing releases so that changes were tested, signed-off & productionised in a controlled manner- Leading vendor team, project planning, effort/cost estimations, status reporting, client relationship management etc.IT Team Lead managing delivery of 2-tier (MS Access/SQL*Server) client-server Regulatory Reporting application. Responsible for requirements analysis/functional design, database design & build, implementation of client & database software components, project planning, UAT Support, status reporting, client relationship management etc.IT Team Lead managing production support/maintenance of all UK Regulatory Reporting & Tax applications. Responsible for project planning, effort/cost estimations, leading team, status reporting, client management etc. Show less

• 

  N/A

  Jul 2012 - Feb 2016

  Career Break

  Took a career break in order to look after my children and enable my wife to go full-time at her workplace. During this time kept up-to-date with Oracle PL/SQL by studying for, and successfully completing, Oracle Certifications

• 

  BBC (for SintecMedia Ltd)

  Mar 2016 - now

  Oracle PL/SQL Developer

  Senior Oracle PL/SQL Developer responsible for development and support of bespoke Data-Warehouse Reporting Application, which processed data from the OnAir Broadcast Management System:- Responsible for the Oracle database components, Oracle Logical DataGuard (LDG) and Shell Scripts utilised for the ETL of OnAir data into the application.- Performance tuning database components and shell scripts- Responsible for the requirements analysis, design, development and testing of changes and bug-fixes, including preparing detailed test cases. Also provided support to offshore team during system testing phase- Performance tuning application’s Ofcom Reporting subsystem (which generated reports for the UK Communications Regulator, Ofcom)- Providing support to Support Team during QA and UAT phases, and helping to resolve any issues raised. In addition providing 3rd level support on Production issues- Performing impact analysis of each new Oracle patch and OnAir service-pack/ hot-fix/ data-fix, on the application- Responsible for the administration of the Development/ System Test environments and the Oracle LDG (using logical standby) including setting up the DataGuard Broker and monitoring the SQL Apply process Show less