Oracle Developer

Preeti Thakur

*** ********* ****, ******, *********, HA2 6JT

Mobile: 079**-***-***

Email: acd2b5@r.postjobfree.com

Nationality: British ? Security Clearance Level: Fully Cleared (DV)

PROFESSIONAL PROFILE

A highly experienced and successful Consultant & Development Team

Member/Leader/Support Analyst with 18 years of experience in the

Information Technology industry. A PRINCE2 and ITIL certified senior

ORACLE developer and applications support analyst with a successful track

record of leading ORACLE development and support teams and extensive

experience of the full development life cycle using different software

development methodologies including Waterfall Model, V Model and Agile

Software Development. An excellent team leader and team player with

exceptional planning, delegating, managing, troubleshooting and problem

solving skills; enjoys working independently or as part of a team and

possesses excellent communication and client presentation skills.

TECHNICAL EXPERIENCE

. An expert user of ORACLE, Developer 10g, ORACLE 11g, UNIX, LINUX,

Oracle Internet Directory (OID) / LDAP, Oracle RAC, ORACLE Text, SQL,

PL/SQL, Performance Tuning, Forms10g and Reports10g, Toad, SQL

Developer, PL/SQL Developer, PVCS, VSS,SVN and other source control

systems.

. Extensive Oracle based project experience using Oracle XML, Oracle AQ

(Advanced Queuing), Oracle Data Hub, Oracle Label Security (OLS) and

Oracle Application Server (OAS)

. Extensive experience in data modelling, Logical and Physical data

design for implementing applications and warehousing databases.

Database design to be used alongside Hibernate ORM.

. Experienced in integrating Oracle databases with .Net, C# and JAVA

applications.

EDUCATION & PROFESSIONAL QUALIFICATIONS

2014 : ITIL Certification.

2009 : PRINCE2 Certification in (Foundation & Practitioner).

2004 : Cold Fusion Certificate Course from Tech-Connect.

2001 : Concepts of Object Oriented Programming with the example of

JAVA, from Brunei University.

1995 : B.A. in Maths & Economics.

1995 : Post Graduate Diploma in Computer Applications.

1995 : Certificate course in ORACLE.

CAREER HISTORY

SENIOR Oracle Developer/Analyst (DV Cleared) April

2012 - March 2014

Foreign Office (FCO)

. Involved in full software development lifecycle from designing to testing

to implementation. Also involved in support activities for bug fixes and

enhancements to existing functionality.

. Interacting with end users to understand their requirements for

application enhancements.

. Producing technical design specifications based on functional

requirements.

. Writing and Maintaining SQL, PL/SQL and front end code for multiple

applications based on ORACLE 11g Database, hosted on Unix and Linux

operating systems. Using Oracle Internet Directory (OID) / LDAP for

secured single sign on (SSO) access control, with Oracle Application

Server (OAS) as Middle Tier. Writing ORACLE Text code for Domain

Indexing. Writing and maintaining front end code using variety of

technologies ex. ORACLE FORMS, ORACLE REPORTS, C, Visual Basic, C#, .Net,

Java Script and Java.

. Developing interfaces using SQL,PL/SQL and Oracle's built in functions.

. Database and application Performance Tuning using Oracle's latest

features for example Bulk Collection, PL/SQL Tables, Materialized Views.

. Extensively using Oracle's built in PL/SQL packages and types ex. DBMS

and UTL packages.

. Participating in Data Modelling activities for transactional/OLTP and

data mart applications.

. Creating and maintaining database objects using DDL and DML scripts.

. Performing thorough unit testing and producing unit test reports.

. Writing Unix / Linux shell scripts.

. Using Oracle Real Application Clusters (RAC).

. Utilises Oracle features such as Compound Triggers, Virtual Columns,

Analytics, LOBS, Materialised Views, Index Tables, External tables and

advanced PL/SQL functions including ref cursors, PL/SQL tables, records

and dynamic queries.

. Interaction with end users and business analysts for application

enhancements.

. Producing technical design specifications.

. Mentoring junior members of team.

. Providing 2nd and 3rd line application support for 20 applications based

on the ORACLE 11g Database, hosted on Unix and Linux operating systems,

using Oracle Internet Directory (OID) / LDAP for secured single sign

on(SSO) access control, with Oracle Application Server (OAS) as Middle

Tier, using ORACLE Text for Domain Indexing with variety of front end

technologies ex. ORACLE FORMS, ORACLE REPORTS, C, Visual Basic, C#, Java

Script and Java.

SENIOR Oracle Developer

April 2010 - April 2012

BAE Systems Applied Intelligence - Detica

. Instrumental in the full software development lifecycle, from

designing new tables in association with the business analyst to

producing complex PL/SQL packages, procedures, functions and database

triggers. Integrating Oracle databases with .Net C# and JAVA

applications.

. Be part of Agile Software Development methodology extensively.

. Data Modelling, Logical and Physical data design using Enterprise

Architect for transactional and a data mart application development

projects. Database design to be used alongside Hibernate ORM.

. Producing technical design specifications based on functional

specifications.

. Used Oracle 11g and Oracle RAC and the latest Oracle security features

including Oracle Label Security, Oracle Internet Directory(OID) and

Data Encryption.

. Utilised Oracle features such as Analytics, LOBS, Materialised Views,

Index Tables and advanced PL/SQL functions including ref cursors,

PL/SQL tables, PL/SQL records and dynamic queries.

. Lead a team of 6 technical staff consisting of DBAs, Developers and

Database Architects responsible for supporting one of the largest

Detica projects.

. Wrote technical design specifications for developers, unit test plans

and release notes for the release managers, and user manuals for end

users.

. Improved quality assurance procedures for Data Base development

activities.

. Managed the impact of code releases and ensures adequate defect

management procedures are adhered to.

. Conducted regular team building meetings to provide the team with a

vision of the project objectives, resolve conflicts, share knowledge,

motivate and inspire team members.

. Conducted performance reviews for Consultants and Senior Consultants'

grade team members.

. Ensured adequate team resources are available to ensure successful

management of the project.

. Coordinated the activities of the DB Team, Java Team, Integration Team

and external teams.

Senior Oracle Developer

November 2007 - April 2010

Pilat Media Ltd

. Responsible for managing the Scheduling and Presentation modules of

IBMS, which is the software system used for enterprise-wide management

of broadcasting and airtime sales operations.

. Involved in full software development lifecycle from technical

designing to testing to integration. Also involved in support

activities for bug fixes and enhancements to existing functionality.

. Use Waterfall Software Development methodology.

. Headed a team of 5 developers and was responsible for planning,

delegating, monitoring and controlling IBMS development work items.

. Wrote technical design specifications, unit test plans and release

notes.

. Participating in Data Modelling activities for transactional/OLTP

applications.

. Creating and maintaining database objects using DDL and DML scripts.

. Producing complex PL/SQL packages, procedures, functions and database

triggers. Wrote and maintained the front end code using C# on .Net

Platform.

. Utilised Oracle features including Analytics, LOBS, Materialised

Views, Index Tables and advanced PL/SQL functions such as ref cursors,

PL/SQL tables, PL/SQL records and dynamic queries.

. Developing interfaces using SQL,PL/SQL and Oracle's built in

functions.

. Database and application Performance Tuning using Oracle's latest

features for example Bulk Collection, PL/SQL Tables, Materialized

Views.

. Extensively using Oracle's built in PL/SQL packages and types ex.

DBMS_UTL, DBMS_LOB packages.

. Performing thorough unit testing and producing unit test reports..

Oracle Developer

February 2005 - November 2007

BT Radianz

. Worked as a part of the PNAD team and performed analysis and design of

core product code changes.

. Assisted with the full software development lifecycle (using V-model)

from designing new tables in association with the business analyst to

producing complex Forms, Reports, PL/SQL packages, procedures, functions

and database triggers.

. Produced Scripts for data migration and SEED data creation.

. Utilised Oracle features such as Analytics, LOBS, Materialised Views,

Index Tables and advanced PL/SQL functions including ref cursors, PL/SQL

tables, PL/SQL records and dynamic queries.

. Wrote technical design specifications for developers, unit test plans,

release notes for the release managers and user manuals for end users.

SENIOR SOFTWARE ENGINEER

May 1999 - February 2005

OLM Systems Ltd.

. Used different software development methodologies including Waterfall

Model and V-Model,

. Wrote Code/Programs using Designer 2000, SQL, PL/SQL, FORMS 6i and

REPORTS 6i, COLDFUSSION and JAVASCRIPT.

. Designed specifications as defined within the user requirements and

schema changes in association with Business Analysts.

. Designed specifications for Forms6i, Reports6i or server level SQL/PL/SQL

code as per the user requirements.

. Developed and enhanced existing Forms6i screens, Reports6i as defined by

the technical specifications.

. Developed and maintained SQL and PL/SQL packages, PL/SQL triggers and

PL/SQL procedures functions and packages.

. Optimised and carried out performance tuning of SQL statements and PL/SQL

programs as and when required.

. Wrote and designed processes to populate client database based systems.

. Performed code reviews and testing for peers.

PREVIOUS EMPLOYMENT HISTORY

Oracle Developer HCL February 1998 - May 1999

Oracle Developer Eclipse Systems Pvt. Ltd May 1996 - February 1998

Member of Faculty SQL Star International January 1996 - May 1995

Developer DRDO October 1995 - March 1996

TECHNICAL COMPETENCY LEVELS

ORACLE 7/8/8i/9i/10g/11g (PL/SQL, SQL) Expert

ORACLE Performance Tuning (SQL, PL/SQL) Expert

ORACLE Text Confident

SQL * Loader/Data Pump/OLS/ Data Encryption Expert

Enterprise Architect Expert

Designer 2000 / 9i Expert

Forms / Reports 10g Expert

PL/SQL Developer / SQL Developer / Toad Expert

Windows 8/NT Expert

PVCS/VSS/SVN/Perforce/Clear Case Expert

Bugzilla/Team Track/Clear Quest/Jeera Expert

MS-OFFICE Expert

XML Confident

Unix Confident

Microsoft .NET Framework (Version 2.0) Confident

Microsoft Visual C# 2005 Confident

Microsoft Visual Studio 2005 (Version 8.0) Confident

Project Management using PRINCE2 Expert

PERSONAL INTERESTS

. Enjoys literature, debating and listening to music.

Contact this candidate