Paul Trott

• SC Clearance requirement.
• Monitoring auditing completion through geographical MI system (MS Excel).
• Presenting enumerations through QlikView.
• Measuring both assessed and non-appraised zones (safe, danger, vulnerable), and displaying through QlikView Maps.
• Presenting Stakeholder management meetings with Q&A sessions and weekly update reports (EXCEL / PowerPoint / QlikView / MS Teams).
• Sharing government reports/analysis (MS SharePoint)

Monitoring auditing completion through geographical MI system (MS Excel).
Presenting enumerations through QlikView.
Measuring both assessed and non-appraised zones (safe, danger, vulnerable), and displaying through QlikView Maps.
Presenting Stakeholder management meetings with Q&A sessions and weekly update reports (EXCEL / PowerPoint / QlikView / MS Teams).
Sharing government reports/analysis (MS SharePoint).

Data scrutiny and Data Validation (Office 365 / MS Excel / MS TEAMS / MS SharePoint).
Data inspection and investigation from divergent systems and manually amalgamating onto on a single platform (MS Excel).
Data Migration.
Examine spreadsheet data against departments MI Licensing system, while revising worksheets accordingly and using predefined measures to determine International Trade rating (Oracle / MS TEAMS / MS SharePoint / MS Excel).
Working within an Agile environment, while leading and providing patronage (inside an international-trade-level) stakeholder tariff legislations support (MS Teams / CRM).
Developing an unimpaired functioning platform for staff usage and Data Visualisations (Oracle / MS Excel / Power BI).
Liaising and presenting with stakeholders and establish conclusions, indicating prospects & impending project impacts (MS Teams / CRM / RAID Log / MS Excel / RACI Matrix).
Functioning within policy and digital teams to produce final reference documents (Excel / Word / MS Teams).

Recommend project control solutions for planning, scheduling, allocating resources and tracking projects with Gantt Charts, project timelines & cross-functional flowcharts (MS Project / VISIO).
Create and working within Kanban Boards while working to project boards, arrange project assurance teams and quality review meetings (Office 365 / MS Excel / MS TEAMS).
Building project files, liaise with Stakeholders while compiling benefactor narratives and distributes reports (MS Teams / SharePoint / Outlook).
Produce asset reports together with budget narratives, and assure trends and forecasts are clearly demonstrated while ensuring potential impacts on end users (Stakeholders) are considered. (MS Excel / Power BI / MI).
Working within political procedures & outlining the entirety of the project scope (MS Project).
Monitoring the team’s work against milestones and ensuring individual needs are considered when setting tasks (MS Project / MS Excel).
Measure risks (RAG), identifying areas of improvement and monitoring stakeholder engagements. (MS Project / RAID Log / MS Excel / RACI Matrix).
Provide guidance on project management and data software, procedures, processes, tools and techniques (MS Project).

Waterfall, Agile and Prince Environments (P30).
Managing diplomatic deliverables, defining project scope and objectives, while measuring risks (RAG) and identifying areas of improvement. (MS Project / RAID Log).
Monitor progress and make adjustments as needed, linking dependencies & allocating resources. (MS Project / MS TEAMS).
Change management: Providing guidance on individual project proposals, project change and project phase transformation. (MS Visio / MS Excel / MS Project / MS PowerPoint).
Provide project updates on a consistent basis to various stakeholders about strategy, adjustments, and progress. (MS Visio / MS Project).
Operation management planning and using technology, where possible, to increase efficiency, while considering all impact changes that could affect a diverse range of end users. (MS Visio / MS Excel / MS Project / MOSS).
Reporting: Project Status, Risk, Time Tracking (baselines, milestones), Variance Report, RACI Chart, WBS, RAM (Responsibility Assignment Matrix) (MS Project / MS Word).
Indicating performance which meet customer requirements and presenting value for money. (Power BI / MS Excel).

Undertaking analysis, design & testing while implementing services within various IT/Sub systems.
Performing daily system checks (Live, Trip & Testing) through reports (Excel / MI / Power BI).
Remotely testing various virtual workstations from one host server to another (VMware vSphere).
System “imaging” - capturing, storing, and retrieving military classifications and backup procedures on Portable Maintenance Access Terminals ready to be used on Airbus A400m Atlas aircrafts (PMAT / Acronis).
Stakeholder management with Royal Air Force military personnel and Airbus employees.
Performing system data analysis progress reports (MS Excel / Power BI).

Working within an Agile environment, while leading and providing patronage (inside an international-trade-level) stakeholder tariff legislations support (Teams / CRM).
Functioning within policy and digital teams to produce final reference documents (Excel / Word / Teams / SharePoint).
Following government international trade tariffs and exercising QA level of preparations via MI (Oracle).
Liaising with the wider diplomatic association and establishing a workflow tariff system for future implementations (MS Visio / MS Project / MS Dynamics 365 CRM).
Multitasking effectively with a high degree of data accuracy, while working independently with minimal supervision (Excel / MS Project).
Modifying & creating internal tracker system while maintaining accuracy (Excel / SharePoint / Oracle MI).

Working within an Agile environment for a Marketing division.
Collectively delivering various forms of marketing analysis (MS Excel / Power BI).
Deliver project targets, Gap Analysis and evaluate KPI's alongside product delivery and revenues.
Dashboard, platform developing & business case modelling from multiple data streams. (Google Analytics / MS Excel / Power BI).
Stakeholder management & providing reports against campaign goals, demographics, sales, with data integration for the wider team and clients (MS Excel / QlikView / Power BI).
Measuring footfall, staff performances, product sales and store behaviours through sales analysis.
Reporting analysis and project development onto end client (MS PowerPoint / MS Teams / CRM).
Delivering against strategic direction and developing new approaches, incentives and recognition while working to short lead times (MS Excel & Google Analytics).

Implementation of major procurement projects and provide visible project plans reserved from Client Contracts, Statement of Work, Bill of Materials, Financial Reports and Predetermined Working Hours along with Standard Operation Procedures (Raid Log / MS Excel / MS Project).
Presenting daily & weekly progress reports to management, Stakeholders and team members, stating group progresses and areas of concern (MS Excel / Power BI / CRM).
Developing budgets and schedules to meet contractual/project requirements for an assigned portion of a program while managing slipping baselines and monitoring milestones reports (MS Excel/MS Project).
Analysing SLA’s and KPI’s while reporting issues and seeking project quality assurance solutions (MS Excel / Power BI).
Developing project proposals, technology evaluations and other project activities requiring subject matter expertise and managing the lifecycle process flow of all projects (MS Project).
Setting Baselines, managing Time Dependencies (FS, SS, SF & FF) & WBS (MS Project).
Generating Timelines, auto scheduling tasks, linking & unlinking tasks (successors, predecessors) within Gantt Charts, Levelling Gantt, etc…
Building new project plan templates and manage procurement processes, insourcing and outsourcing agreements, while ensuring projects are delivered within agreed scopes, time, cost and quality limits. (MS Project).

Liaising Stakeholders and Project Managers in order to understand their Data Analytical needs.
Designing workflows and identifying critical trends and KPIs (MS Excel / MOSS).
Create and maintain interactive visualisations through data interpretation, status updates and analysis from multiple data sources (MS Excel / Power BI).
Identify trends, areas of improvements, and opportunities (MS Excel / Power BI).
Using data to create models and depict trends in the customer data areas of opportunities for growth through analysis of complex data sets (MS VISIO, MS & Excel Power BI).
Sales/Revenue and progress reports (MS Power BI, Cornerstone On Demand, MS Excel).

Project Managing and analysing decommissioned, and newly appointed apprenticeships (MS Excel / MS Project / SAS Visual Analytics / MS PowerPoint).
Producing course content & mediating with Stakeholder (Trailblazers) & coordinating new course content, core module preparations (MI / CRM / MS Excel / MOSS).
Providing [through analysis] and Investigating SLA’s and KPI’s while reporting issues and seeking solutions (MS EXCEL / Power BI).
Deliver Service Area Project Management Reports, Strategies, Budgets & Procedures (MS EXCEL).

Handling PRINCE 2 - P30 styles to grasp the lifecycle of a project from pre-project activities through to closure and post project review (MS Project).
SAR (Subject Access Requests) and meeting Data Retention agendas (MS Excel / MS Project).
Project planning: estimating effort, scheduling resources & identifying dependencies (MS Project).
Designing comprehensive Data Visualisation(s) project processes (MS Visio) while meeting & generating milestone analyst reports (SAS Visual Analytics / MS Excel / MS PowerPoint / MOSS).

Working within an Agile and Prince2 environment and leading a project following GDPR processes and GDPR compliances within SanTech Human Resources Department.
Developing a staff-friendly platform to measure GDPR compliance (UAT & QA).
Illustrating and Analysing completed workloads to managers – (MS Excel / SAS Visual Analytics / MS PowerPoint / & BI Tools).
Scripting VB Macros (Excel) to appraise, destroyed recordkeeping dates, clear cells, and archiving (looping) cases (MS Excel).
Support Quarterly Financial Reports for the SanTech Service Line (MS EXCEL / BI Power Tools).
Tracking KPI’s, and Purging staff files that comply within the 7 year GDPR guidelines.
Stakeholder management – Baselines, project appraisal (MS Project, MS PowerPoint / CRM).
Utilising formulas to calculating dates and time frames to meet GDPR purging observances - GDPR record purging dates (MS Excel [V-lookup, ISBLANK, IFERROR]).
Maintaining employee and stakeholder relations through (MS Excel / MS MOSS).

Remediation Operations department – PPI Claims within a Prince 2 (P30) working environment.
Maintaining a proficient work list of completed and outstanding stakeholder cases – (MS Excel).
Verifying customers through a widespread, chronological catalogue of mortgages and Recordkeeping cases (MS Access).
Coordinate project(s), meetings, and output’s processes (MS Project).
Evaluating completed & outstanding workloads – (MS Excel / MS PowerPoint).
Maintaining RAID log (Risk, Assumption, Issues, & Dependencies).
Reporting SLA’s and displaying areas of improvements (Power BI).

Working within an Agile setting for the Marketing department.
Managing numerous lifecycle processes, Baselines, Time Dependencies (FS, SS, SF & FF) for 24-month development product-to-market launch (MS Project, MS Dynamics 365 CRM).
Project KPI’s, Budgets & account information via SharePoint.
Indicating trends, budgets and forecasting with Management & Stakeholders (MS Project / SharePoint / Power BI / MS Excel / SAS Visual Analytics / MS PowerPoint).
Generating Timelines, auto scheduling tasks, linking & unlinking tasks with Gantt Charts.
Producing Quarterly Financial and Progress Reports / Dashboards (MS Excel / Power BI).

Analysing and reporting a vast amount of the organisation’s employee information through a variation of methodical practices: v-lookups, pivot tables / graphs (MS Excel / SAS Visual Analytics / MS PowerPoint).
Providing [through analysis] SLA’s and KPI’s (MS EXCEL / Power BI).
Coordinate project(s), meetings, and output’s processes (MS Project).
Data visualisation and project process flow design (MS Visio).

Working within PRINCE2 (P30), Agile and Waterfall environment(s).
Maintaining and recreating a central database and forum – linking Access tables to view in Excel (MS Access & Excel XLS).
Reconciling government balance sheets, generating Quarterly Financial and Progress Reports while setting trends and forecasts – (MS Excel XLS, SAS Visual Analytics, Power BI).
Maintaining stakeholder relations and analysing revenue (MS Project / MS EXCEL).
Micro managing projects for the Overseas Registration Unit (MS Project).
Assessing SLA’s and KPI’s baselines and investigating discrepancies (MS EXCEL XLS / Power BI).
Operation management patterns - data mapping and process flow design (MS Visio).
Globally distributing, and receiving large-scale government documents via (SharePoint).