Shaun Crowley

Oracle Technical Manager

PERSONAL SUMMARY

●Over 12 years of programming experience as an Oracle PL/SQL, Forms and Reports Developer in Analysis, Design and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS). In the last three years I have lead a team of 5 developers as the Business As Usual (BAU) Team Leader using agile / kanban approach to development, this role was 50% Technical and 50% Management.

●Supplier Management, create supplier work packages and manage procurement. Manages delivery scope and resolve deviation in managed service.

●Change Management, this involves managing the complex interdependencies between business, people, process and technology dimensions of change. Chaired and been part of a Change Advisory Board (CAB).

●Planning & Delivering, using project management skill I have managed large-scale / complex projects encompassing the coordination of cross functional teams (including external teams).

●Facilitation, manage groups to achieve desired outcomes, using tools and techniques to maximise the group's decision-making potential

●Major Incident Manager for all Severity 1 & 2 issues.

●Team Management, I have Created Monthly KPI Reports and Personal Development Plans and conducted Performance Reviews, 1 to 1’s and Setting SMART Objectives.

●Stakeholder Management, point of contact for sponsors and senior stakeholders and monitors and manages solution delivery.

●Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.

●Experience with Data flow diagrams, Data dictionary, Database normalization theory techniques, Entity relation modeling and design techniques.

●Expertise in Client-Server application development using Oracle 12g/11g/10g/9i/8i, PL/SQL, Oracle Forms and Reports, SQL*PLUS, TOAD and SQL Developer.

●Experience in SQL performance tuning using Cost-Based Optimization (CBO).

●Experience in logical and physical Data Modeling using normalization Techniques.

●Created Tables, Views, Constraints, Indexes, Materialized views.

●Worked extensively on Ref Cursor, External Tables and Collections.

●File based loading to move data between databases using Java.

●Expertise in Dynamic SQL and PL/SQL, Collections and Exception handling.

●Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.

●Good knowledge of key Oracle performance related features such as Query Optimizer, Execution Plans and Indexes.

●Experience with Performance Tuning for Oracle RDBMS using Explain Plan and HINTS.

●Created Shell Scripts for invoking SQL scripts and scheduled them using crontab.

●Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

ACHIEVEMENTS

In the last 12 months I have been involved with numerous projects. On these projects I have been had various roles from Project Manager / Technical Architect / Business Analyst / Developer. The most successful projects are:

●Oracle Upgrade 11i to 12c, Databases and APP servers. This project ran for 4 months working through many oracle service requests (SR) ending with a cut over weekend. This was highly successful resulting in 0 downtime after upgrade.

●Automatic payment solution for PCI compliance using New Voice Media, handling thousands of payments a day. This resulted in solutions creating API (internal/web) interfaces between oracle and 3rd party system via PHP web front end.

●Implement changes highlighted by Internal / External (Deloitte) audits.

●Implemented formal release, change and incident management processes in line with ITIL standards. This resulted in stabilising the production environment and reducing the amount of major incidents.

●Part of Restart / War room / Turn around meetings to move on going data migration project from failing to delivering (Team of 30). Project moved to a scrum/rapid development principles with in one week the holes in the program identified and all high impact issue solved and first deliveries completed. This is currently ongoing.

PROFESSIONAL QUALIFICATIONS

Prince 2 Foundation On going

ILM Level 3 Award in Leadership & Management November 16

Global Knowledge - Foundation ITIL V3 October 10

TRAINING COURSES

GMC Inspire Automation March 15

GMC Inspire Designer January 15

Oracle University – Oracle 10g PL/SQL Advanced November 09

Oracle University – Oracle 10g Forms July 06

Interquad - Oracle 9i PL/SQL Fundamentals December 05

Oracle University - Introduction to Oracle: SQL September 04

EDUCATION

University of Surrey 2002-2003

Masters of Science in Information Studies (MSc)

Final year project title “Designing and Building a Call Logging System”

University of Surrey 1996-2001

Bachelor of Science in Computing and Information Technology (BSc)

Final year project title “Web Based Navigation”

NESCOT College, Epsom

BTEC National Diploma in Computer Science

Passed with Merit and Distinction, with programming languages PASCAL and Visual Basic.

EMPLOYMENT HISTORY

Perkins, Peterborough May 18 to June 18 Contract

Technical Business Analyst

Six weeks contract to deliver failing integration project, successfully completed.

Capita (TFL Contract), Coventry January 18 to May 18

Applications Support Lead

Leading a team of 8 application support analysts, working on the TFL contract using the Amdocs Application. I have intruded Agile into the teams processes and complete Daily standups / Sprint Meetings. Completing a Data Syncing Project between collection db and billing db.

LGSS Cambridge County Council, Cambridge January 17 to Nov 17 Contract

Oracle Technical Manager (3 Contract Extensions)

Leading a team of 8 oracle ebusiness suite technical and functional experts with the aid of fujitsu consulting (Managed Service). Point of escalation of all ebusiness issues and point of contact for all major incidents. Change Management duties plus being part of CAB. Ebusiness supported modules, Financials (AR,AP,GL) and HRMS. Last extention I become part of the Data Migration team from SAP/Oracle to agresso projects, leading the AR Exports/Load Team.

Totemic Ltd, Grantham February 14 to December 16

Lead Oracle Application Developer / Scrum Master (Title: Business as Usual Team Lead)

50% Technical / 50% Management, Reporting to the CIO. Supporting various in-house packages designed to support the Debt Management process (full life cycle) from initial call to customised debt plan to debt resolution with over 1000 debt advisors per month.

Team leader of 5 developers. On large/medium scale developments I architected / design / project manage the team solutions. In the last 2 years I have trained and mentored 3 graduates from non-oracle backgrounds to become oracle developers within their first year.

Totemic Ltd, Grantham December 12 to February 14

Oracle Application Developer

Supporting in-house package (Vulcan). A system designed to support the Debt Management. Interrogation/Data Analyst (via SQL) of oracle databases run on UNIX\Linux that run the Vulcan package. Analysing/Programming of Business Solution to the Vulcan Application manly in SQL and PL/SQL. Tools used include SQL Developer, SQL*Plus, Oracle Forms, XML, Oracle Reports, Oracle Enterprise Manager.

KBR, Leatherhead January 11 to December 12

Senior IT Applications Analyst/Developer

Supporting in-house package (IPMS Integrated Project Management System). A system designed to support all aspects to Oil Rig, Procurement – Logistics – Warehousing. Interrogation/Data Analyst (via SQL) of oracle databases running on UNIX\Linux and windows that run the IPMS package. Analysing/Programming of Business Solution to the IPMS Application manly in SQL and PL/SQL. Tools used include Toad, SQL*Plus, Oracle Forms, APEX, Database deployment/setup, Oracle Enterprise Manager. Running project teams of 3 - 4 developers to develop large projects. Recent Large projects: Logistic Enhancement, focused to improving Route Segments. Enhancement for Engineering TAG interfaces to a single global solution.

KBR, Leatherhead January 10 to December 10

Senior Business Process Analyst

A years secondment. Analysing and Designing systems/reports from functional support/end user’s requirement for an in-house package (IPMS Integrated Project Management System) this is systems is designed for the procure-to-pay process. (Systems include Materials Management (interfacing with CAD), Procurement (interfacing with SAP), Document Management (Interfacing with Documentum), Site Control, Shipment Tracking (Interfacing with 3rd Party Couriers)). Planning/Documenting DB moved between countries/offices, DR plans, HA plans, new application roll-outs including Dev/Test/Stage/Prod.

KBR, Leatherhead August 04 to January 10

IT Applications Analyst/Developer

Supporting in-house package (IPMS Integrated Project Management System). Interrogation/Data Analyst (via SQL) of oracle databases that run the IPMS package. Analysing/Programming of Business Solution to the IPMS Application manly in SQL and PL/SQL. Tools used include Toad, SQL*Plus, Oracle Forms, APEX, Database deployment/setup, Oracle Enterprise Manager.

Halliburton (KBR), Leatherhead August 03 to August 04 (Contract to Permanent)

Customer Support

First line break/fix support. Remote support of desktops running Windows XP. Part of web development team to document internal processes. All types of call centre work conducted from password resets to Microsoft suite advice. Investigation of potential business impact issues from server to security issues including out of hours support. Writing, identifying, modifying of internal/external processes.

Thales IS, Crawley September 01 to September 02 (Contract to Permanent)

Support Technician

For 9 months I work as the IT coordinator liaising both internally and externally to ensure SLA compliance. Monthly, Weekly and Ad-hoc reporting with GSS. Creation of SLA flowcharts for use with external companies to establish project management procedure. Creation of local business model. Remote & On-site fixes of Desktop/Server applications and operating systems (NT / 2000). Administration of User accounts (Passwords / Mapping / Setup / Privileges). Software Fixes & Installation (MS Office Suite / Anti-Virus / Ghosting / etc). Hardware Fixes & Installation (HP Printers / Compaq & HP Desktops / Toshiba Laptops).

BTS Ltd, Wallington February 00 to September 00 (Permanent)

Technical Customer Service Placement

A busy Customer Service Helpdesk with a Call logging company. Responsibilities of logging and solving technical problems on UNIX and Windows NT 4.0 servers via a remote connection.

UFB Humberclyde, Basingstoke June 99 to January 00 (Permanent)

IT Placement

A busy IT Helpdesk within a Finance House my duties including 1st and 2nd line support for Desktop and Server of a network of 300 PC’s. 3rd line support for NT applications and scripts. Also telecoms, laptops, remote access, cabling and patching, exchange 5.5 admin.

PERSONAL DETAILS

11 Bowman’s Way

Sedgebrook

Lincolnshire

NG32 2HF

077********

ac6orp@r.postjobfree.com

DOB: 12/10/1977

Nationality: British

Contact this candidate