David Pratley Email & Phone Number

London, United Kingdom

Managing, training and supporting four members of staffSupporting a customer base of over 60 organisations using Jira dealing with over 500 incidents a monthSupporting and maintaining all of Servelec Corelogic products including Mosaic, Frameworki Corius, and Admin tool and the underlying hardware / softwareSupporting and configuring Weblogic, Oracle Application Server, Oracle DB, SQL Server, MySQL on Linux, Solaris and WindowsImplementing processes and best practices to ensure a consistent approach can be takenProviding first, second and third line support to internal staff and external customersSignificantly reducing backlog of issues and improving customer satisfactionImproving QA and call handling where calls needs to be passed to other internal teams to provide code changes.Writing and approving Knowledge Base articles to improve knowledge internally and externallyPrioritising issues in conjunction with development teams based on potential short and long term impact.Monitoring and reporting on Customer SLA’s and service desk performance using MySQL, Oracle, SQL Server and ExcelProvide reports and statistics to the Project board Ensuring sufficient cover and support is available for supported hours along with meeting customers response SLA’sWorking with DBA’s / Developers / Maintenance / Product owners to identify and resolve issuesMeeting with customers providing statistics / details around service impacting callsWorking with sales / DBA / implementation teams on new customer installs, setup and SLA’s

London, United Kingdom

Installing and supporting multiple SQL Server / Oracle databases for public and private organisations / charities including backups / restores / patching troubleshooting / upgrading / tuningOracle Application Server and Weblogic administration and installationLinux / Solaris / Windows setup, installation & troubleshootingOut of hours and on call support carrying out upgrades and installationsMonitoring / tuning and troubleshooting database, application, network and server issuesProject Managing installation / upgrades to support customer requirements Frameworki / Mosaic install and upgrades Business objects support and maintenance

London

Utilising SQL Server for monitoring schedules / issue solving and providing reports / providing information for support teams and management information teamsCo-ordinating the re-structure of Adult social services teams on Framework-i including team & finance set-up and support throughout the transitionFramework-i support and development including the introduction of mobile working and new versions of Framework-iTraining on framework-i for a variety of users of the system on workflows & mobile working equipment and softwareSupporting users from Health and social care on Framework-i and other systems including Microsoft office suiteDeveloping E-learning training and guides for Framework-i processes, procedures and workflows Testing and planning implementation of new framework-i versions and software Involved in change control process, project management and implementing changes to framework-i and other related systemsSupporting and developing financial aspects of Framework-i including personal budgets and providing SQL to enable reportingOut of hours framework-i support and development to meet the needs of the businessJava coding for framework-i including trouble shooting on financial forms and resolving java structural issues Supporting Framework-i Reports pack and Business Objects Infoview Framework-i data analysis for planning and implementing changes identifying potential areas for improvement or potential conflict between different service areasOn Site support to improve performance and identifying areas of improvement

London

Writing reports via free-hand sql or business objects, sending out reports in excel format (with pivot tables) on a regular basisWorking with a variety of staff including Compliance Officers and Group managers to ensure that improvements are maintained and identifying areas of excellence or concernBuilt a bespoke VBA excel 'database' to store teacher information for the borough, loading in records and providing support to the team entering the information.Provided support to the Framework-i support and dev team - including SQL support, ongoing analysis and problem solvingReviewing processes and implementing changes, working with the Framework-i trainers to provide support and guidanceSupporting reports team in report writing, analysis of data and advising on the upgrade to a new Business Objects universeAssisting in Finance implementation - identifying issues and providing solutionsEnsuring placements and Child Trust Returns are completed and up to dateProviding training and support in excel & Business Objects reportsDeveloped a series of reports to provide information to service managersSupporting Ofsted and adoption inspections through provision of reports and loading data directly into Framework-iIdentifying open / closed cases and providing be-spoke sql to close down over 10,000 cases

London, United Kingdom

Supporting reporting through Business Objects/Oracle SQL on the Social Care system for Corelogic’s Framework-i for children’s social servicesData Cleansing of incorrect data causing system issue's on Framework-iConfiguration of Framework-i – Including form building, work-flow & administration.Importing data based on new functionality (case closure, chronology) via excel and SQL toolsDesigning and altering business processes and forms based on local and national requirementsTraining and support for local training and performance departmentsProviding support documentation and training for staff around mobile workingGathering and submitting End of year Children Services returns for : 903, CPR3 and CiN CensusWriting reports through free-hand sql or through business objectsEnsuring data quality by comparing clients in systems and loading in missing data (e.g. Unique Pupil Numbers)Loading data via other methods including spreadsheets and SQLLiaising with the business to ensure all records are up to date and advise on areas to prioritiseDealing with ad-hoc performance requests from service managers and Freedom of Information requestsEntering all looked after children placements onto Framework-i, ensuring affective audit trails were introduced and that placement details are loaded in a timely mannerSubmitting and gathering data for monthly Child Trust Returns

London, United Kingdom

Reporting through Business Objects/Oracle SQL on the Social Care system for Corelogic’s Framework-i for children’s social servicesWriting SQL based reports/queries for Performance Indicators and Data qualityAmending the Business Objects universe provided by Corelogic to enhance and ease data collection for Children’s servicesAdvised Corelogic of improvements to the business objects universeProviding support to Managers/social workers and ICT on social care process and procedure Advise and provide guidance on the use of applications including excel, Business objects suite, framework-i & OracleUser acceptance testing of the adult social services migration, and providing SQL or support to facilitate various updates to the systemProvided support, statistics and reports to the Joint Area Review inspectorsBuilt an interactive excel based weekly report to highlight ten data quality issues over four different categories of children at the touch of a buttonAnalyse data and provide support/SQL to improve quality and accuracy of informationAuditing data entry, quality and consistencyMonitoring effectiveness of implementation of new procedures/configurations.

London, United Kingdom

Supporting the Social Care system for Waltham Forest – Corelogic’s Framework-I system providing general and technical support for over 500 users.Writing SQL statements to gather data and then load to improve data integrity in the system and to provide monthly performance indicator figuresProviding day to day support using Oracle Enterprise Manager/SQL PlusProvide the team with Test plans as well testing new versions of the tool while liaising with Corelogic to improve the systemReporting through Business Objects/SQLMigrating data from one environment to anotherConfiguring and testing new hardware/software Providing general network support (Novell/Microsoft products and hardware issues)Running and troubleshooting daily back-ups through Veritas.

London, United Kingdom

Reception duties - helping the public with enquiries, dealing with complaints, room bookingsCreating an automated excel spreadsheet to extract information from another spreadsheet received monthly with different requirements and outputs required.General network support: Mapping network drives, fixing printers, Copiers (toners, staplers, paper jams).

London, United Kingdom

Worked within a team of five, supporting over 100 users requiring access to the Kalido Data WarehouseLoaded, reported, amended and error checked global buying dataEdited structure of the data warehouse in development through to live systemsAmended and monitored schedules Accessed and analysed data through Excel, Oracle, Business Objects, SQL Plus and ToadCreated and maintained user accounts in Business Objects and KalidoCreating, maintained, refreshed and edited reportsDeveloped Microsoft Excel (visual basic based) applications, tested Access based applications.Wrote and applied SLA’s between teamsCreated instructions for users of software and support for any problems that arose regarding software and hardware issues.Trained new team members for all roles within the team

London, United Kingdom

Provided clerical and technical support for students and staff

London, United Kingdom

Collating and analysing data from various banks for Nat West’s Year 2000 projectProvided support for Millennium Bug issuesVarious tasks including filing, printer maintenance & technical supportWorked in a team environment and undertook a number of roles for various people which required interpersonal skills, communication skills both verbal and written

London, United Kingdom

Administrated, created, analysed and amended a Microsoft Access databaseCreated instructions for custom built applications and provided telephone support