Mark Johnson Email & Phone Number

London, Gb

London, United Kingdom

Senior Salesforce Business Data Analyst.Migration from Salesforce Classic platform to Salesforce Media Cloud.

United Kingdom

1. Analysis and comparison of the CRM platforms of Salesforce and Amdocs CRM on a wide variety of parameters including:1.1. Technical Architecture – Applications, Platform & Integration (APIs and TMF standartisation), Data, Authorisation and Access.1.2. Capabilities Map - Channels, Marketing, Sales & E-Commerce, Service, Communities, IoT & AI, Analytics, Apps Ecosystem, Support, Platform, Integration.1.3. Operating Model - Key Partners, Key Activities, Key Resources, Value Propositions, Customer Relationships, Channels, Customer Segments, Cost Structure. 1.4. Revenue Streams – from Sales, Support and the Professional Services.1.5. Release Management – Deployment architecture, CI/CD pipeline and process, test automation.1.6. Pricing Models – base price and add-ons, Value Chains.1.7. Company Sales - Statistics, Contracts, Compliance, Legal.2. Running workshops to gather initial requirements for the analysis.3. SWOT analysis.4. Creating Powerpoint slides with the results of the comparison.5. Delivering presentations to the senior management and the end client.

United Kingdom

· Transformation project for migrating the telecoms O2 and Virgin Media onto one common cloud-based Salesforce CRM platform for sales and customer care. · Joining the project in the first phase when there was no much structure, alignment, scope and proper management.· Organising and running workshops with business leads, subject matter experts and the Product Owners from O2, Virgin Media and NTT Data to achieve alignment between the companies, create To-Be processes, extract high-level and detailed requirements. Wining over stakeholders from O2 and Virgin Media to engage and contribute to the new solution.· Creating As-Is and To-Be business processes and process maps using Visio. Identifying gaps and potential risks, dependencies and obstacles.· Requirements gathering, analysis, validation and documentation in the form of an AGILE/SCRUM Epics, Features and User Stories in JIRA. Ensuring enough details are captured that the User Stories are easily understood by the development team. Prioritising requirements to the project scope in 3 phases.· Gathering requirements for the following teams: Customer Care, Sales, Billing, Revenue Assurance, Collections, Demand Management, Order Desk, Complaints. · Gathering requirements on integrating the new Salesforce platform with the existing OSS and BSS telecom systems. API specifications. · Making sure that the proposed new solution adheres to the business strategy and policy.· Managing a team of junior business analysts. Delegating work and providing guidance.· Running a daily Stand Up and tracking the progress of requirement capture and document completion. Providing comprehensive reports and pivot tables to the management team to track the completion according to the project plan and scope. Managing the RAID log.· Resilience in a high-pressure environment. Root cause and SWAT analysis. Managing relationships with stakeholders from the telecoms O2 and Virgin Media.

United Kingdom

· Migrating old legacy systems to a new Azure cloud-based solution. · Requirements elicitation, analysis and documentation for data migrations into a data lake.· Analysis and documentation of the old and new data structures Gap analysis and mapping between the two data structures. Communicating with any affected business stakeholders regarding BAU reporting impact.·· Regular show and tells, to delivery program, to explain design, any gaps and report on progress of the project.

United Kingdom

· Data migration from a legacy booking system to the market leading system Salon IQ.· Analysis on the old and new data structures. Gap analysis. Data mapping. · Investigating and analysing business problems, and providing cost-effective solutions.· Creating processes for: end-to-end client’s journey, HR, products ordering and supply.· Creating a prototype of the new web project and liaising with the development company for its implementation.

United Kingdom

· Working in parallel on several multi-functional projects related to the migration to a new order management system and a financial platform for online signing and managing lease agreements with new customers. · Creating As-Is and To-Be business processes for the migration to the new order management system. · Identifying gaps and proposing solutions. Risk and gap analysis.· Implementing test cases for SIT and UAT and uploading them in HP ALM. Execution of test cases.· Managing the test process: raising defects and tracking them through to a resolution.

United Kingdom

· BUPA is a multi-billion UK insurance company. · Worked for the IPAK (Enterprise Architecture) team and later for the IT Change Management team.· Using the Enterprise Architecture EAS software (www.enterprise-architecture.com) to create a model including the areas of Business, Information, Technology and Applications. Mapping Business Capabilities to the above 4 areas. · Facilitating workshops with internal BUPA teams and external providers. Capturing requirements, producing requirements specifications and solution design. Negotiating, influencing and obtaining sign offs.· Analysis on the two main underwriting processes at BUPA – Full Medical Underwriting, and Moratorium Underwriting. Data analytics on the underwriting data, GDPR, data integrations.· Creating 60 As-Is and To-Be (BAU) business processes. Requirements gathering, analysis and validation for the creation of End-to-End processes, gap analysis, identifying opportunities for improvement The processes included Client Administration, Policy Underwriting, Claim Processing, Reinsurance, Accounts, Reports.· Created 4 Levels of business processes. Creating Policies, Procedures and Work Instructions. · Analysis on applications related to the insurance/financial operations (individual health insurance, family floater health insurance, comprehensive health insurance and critical illness insurance).· New service design. Using ITSM and CMDB.· Analysis on application upgrades and application decommissioning, impact assessment, risk and gap analysis, producing documentation and processes.· Data analytics – data access, data flows, data ingestions, data visualization, data mapping, data migrations. Data cleansing and improving data quality.· Managing a team of junior business analysts. Estimating the business analysis tasks, allocation of tasks, mentoring and tracking progress.· Stakeholders management at different level. Delivering presentations to senior managers.

United Kingdom

· Feedback Ferret Ltd is a word leading software company specialised in collecting and analysing feedback from customers. Their clients are BMW, General Motors, McLaren, Nissan, Volvo, ASDA, Morrisons, to name but a few.· Transformation Project for responding to a Request for Proposal from Volkswagen Group of America. Analysis of requirements, creating a software prototype, As-Is and To-Be processes. As a result of my work, Feedback Ferret Ltd won a multi-million contract with Volkswagen Group of America.· Full project lifecycle experience – extracting requirements, analysing and documenting in a requirements traceability matrix, business impact analysis, creating functional specifications – use cases and solution design. Creating test plan and scrips.· Creating As-Is and To-Be business and system processes using BPMN. Gap analysis. · Product Owner role: Setting up a standard for the company how to use the AGILE/SCRUM development methodology, creating templates for the functional and non-functional user stories, business processes, functional specifications/use cases, test schedule and test strategy, etc. Discovery sessions, creating user roles, user stories and acceptance criteria and managing them in JIRA, facilitating workshops with the developers to clarify the user stories and estimation of the development efforts, prioritising the user stories to match the delivery stages according the contract with Volkswagen Group of America, organising review and retrospective meetings, presentations to the senior stakeholders and managing expectations.· Data Analytics – analyzing data received from different interfaces, data ingestion, ETL, data mapping and data integrations.· Leading a team of junior BAs.· Liaising with the Business and Development teams and different levels of management stakeholders to capture, negotiate and sign off requirements.

United Kingdom

· Development of a new E-Signature web platform allowing BMW retailers and customers to sign financial agreements online. · Working with the Project Manager to define the project scope, preparing statements of work (SOW), business justification. Defining change management plans and procedures.· Liaising with the Business team to capture requirements. Analysis, validation, documenting and requirements management. Requirements prioritization, negotiations with the business team. · Creating and remodeling Business Processes – E-Sign on Premise, Ink Sign, E-Sign at Home, etc. Impact assessment of the upgrade and the effect on existing IT system, data flows and processes. Gap and Risk analysis. · Test Manager role: creating Test Strategy and Test Schedule. The Test Schedule includes Test Environments Preparation, Pre-Delivery Testing, Pre-SIT Smoke Test, SIT Entry Gateway, SIT (QA), SIT Exit Gateway/UAT Entry Gateway, UAT (Business Test Cycle 1, Check Point 1, Business Test Cycle 2, Business Test Cycle 3), UAT Exit Gateway/FAT Entry Gateway, FAT, FAT Exit Gateway, PAT (Prepare to Go Live)· Using formal testing methodologies and creating SIT and UAT Test Cases and uploading them into HP ALM. Web based automation testing with HP ALM using IE.· Managing the delivery of the test process within the set budget.· Managing the test process, raising defects and tracking them through to a resolution.· Preparing specifications for the Load and Penetration testing. Functional and non-functional automated testing.· Facilitating meeting with the business team and signing off the completed testing phases – SIT, UAT, FAT and PAT.· Traceability of requirements - managing and tracking requirements through the elicitation phase, functional documentation and test cases.

United Kingdom

· On-boarding the client BMW onto the British Car Auctions’ web platform.· Requirements elicitation, analysis and validation.· Creating As-Is and To-Be Business Processes for rental and company’s cars returns, mapping requirements to processes. Gap analysis. End-to-end customer journeys.· Creating solution design.· Design and development of a new mobile iPad app used by the car surveyors.· Agile/Scrum development. Creating User Stories and Acceptance Criteria. Prioritising and managing the Product Backlog.· Managing junior BAs – Estimation of BA activities, delegating tasks, supervising the creation of system requirements (user stories) and business processes.· Facilitating and running workshops. Stakeholders management at different levels.

United Kingdom

· Analysing and prioritising business requirements on online direct marketing businesses.· Defining Internet marketing business models including Internet marketing funnel with 2 upsells, membership website and a call centre follow up.· Creating processes for Marketing to Lead – advertising using different channels – Social Media (Facebook – news feeds, link ads, messenger, retargeting), Google paid search and GDN, Email marketing, Display media. Tracking the engagement of the visitors on the different channels. · Defining strategies for the conversion of a Lead to Customer (Lead to Order) – creating autoresponder email campaigns, promotions, discounts, upsells, down sells and cross sells.· Creating websites for Internet Direct Marketing using WordPress and InstaBulder. Adding automated Autoresponders messages and a list building functionality using 1ShoppingCart.com. · Using Facebook Audience Insights and AudienceSpy to precisely analyse the data about the potential leads and prospects. Setting up, managing and optimising advanced advertising campaigns in Facebook, achieving $0.001 per video view and $0.02 per website click (CPC Link).· Setting up variety of tracking models with CPV Lab, ClickMagick and also using Facebook pixels.· Generating detailed reports, analysing data and optimising the campaigns to increase the ROI on media buys above 300%.

United Kingdom

· Multi-billion O2/UK Government project for installing Smart Metering communication hubs on more than 60,000,000 premises in the UK. Supply Chain and Machine-to-Machine (M2M) project. · Business analysis, design and development of a Web Portal and an Order Management System (OMS) based on Salesforce for the Energy suppliers to manage online their forecasts, orders, deliveries and returns of smart metering hubs.· Extracting high level external requirements from the contract with the Government. Facilitating workshops with the Government representatives, clarifying requirements and elicitation of new ones.· Creating internal requirements, analysis, requirements mapping and management using HP ALM. · Creating 4 levels of Supply Chain Business Processes using Visio and later transferring them to ARIS. Using Lean IT principles to eliminate waste in the processes of transportation, warehouse/inventory and faulty hubs delivery/rejections.· AGILE/SCRUM – Product Owner role. Creating User Roles, Epics, User Stories & Acceptance Criteria, Prioritisation, Business Rules, Business Processes references, Estimation (planning poker), Product Backlog and Product Burndown chart, Sprint Planning, Sprint Backlog and Sprint Burndown chart, facilitating the Daily Scrum and the Sprint Review and Retrospective meetings. Using JIRA to manage and track the progress of developing the User Stories and their mapping to external/internal requirements and test cases.· Defining product vision and strategy, managing the product lifecycle, gatering and prioritising requirements, working with cross-functional teams, monitoring and analysing team’s performance.· Organising and leading presentations for the UK government. Presenting the OMS development stages using interactive Powerpoint and live demonstrations on SalesForce web portal.· Working closely with the Business, Development and Test teams. Stakeholders management at different levels.

United Kingdom

· Senior business analyst on the design and implementation of new responsive (adaptive) websites for Nokia and the local markets in 73 countries.· Digital media consultant for Nokia on Google’s DoubleClick DFA for tracking the engagements of the visitors with the Nokia’s websites. Analysis on the existing customer engagement and ad tracking functionality and creating a new tracking to achieve higher customer engagement, increase the number of online sales and ROI on the media buys.· Organising and facilitating workshops with internal Nokia teams and third parties, conducting interviews, requirements gathering, analysis and validation, requirements management. Producing business requirements specifications and agreeing sign off. Assisting the developers during the implementation. Creation of a test strategy, plans and scripts. UAT.· Creating a Business Process for engaging Digital Suppliers - a media agency, creative agency, localisation agency, global and local Nokia markets and Google DoubleClick Studio for producing, approving and publishing rich media assets. · Managing a team of junior business analyst. Prioritising tasks. · Stakeholder management at different levels including Nokia teams, third party suppliers and offsite development teams. Selecting 3rd party vendors.

United Kingdom

· Dentsy Aegis Media is a multi-billion digital media company group.· Lead Business Analyst for the Cross-Channel Reporting system of a new digital platform for collecting, analysing and reporting on advertisement performance data from different channels.· Analysis, design and implementation of new external website/portals to allow the B2B clients to access the reporting system. Design of Intranet website for administering the application. · Managing a team of BAs working on different streams. Balancing priorities. Making sure that the BAs support the offshore development teams.· Full project life cycle experience – defining scope, assisting with the producing delivery plans, overseeing all stages of a new project, requirements elicitation, analysis and validation; creating BRS, SRS, use cases, detailed technical specifications; data analytics, data modelling, producing test scripts and plans for Unit, Integration, System testing and UAT.· Business processes re-modelling. Assisting the developers during the implementation.· Delivering presentations of the new functionality to the business teams.· Stakeholder management at different levels. Selecting 3rd party vendors.

London Area, United Kingdom

· Reed Exhibitions Ltd is the world leading events (exhibitions) organiser. Their CMS web platform publishes digital content to more than 500 websites in 41 countries. The scope of the project is to on-board the newly acquired Business Units (BUs) onto the CMS web platform and design and implement the relevant new websites. · Business/technical analysis for implementing additional features to the CMS web platform according to the requirements of the BUs.· Owning and managing the projects for Russia, Austria and Italy. · Gap analysis between existing systems and processes of the BUs and the CMS platform.· Working with the BUs to gather requirements and design the new websites. Defining the feel and look of the new websites. · Business processes re-modelling and improvement. · AGILE/SCRUM development. Defining User Roles, creating User Stories and managing them in the tool Rally. Planning Poker, creating and managing Product Backlog, Sprint Backlog, Product and Sprint Burndown Charts. Facilitating the Sprint Review and Retrospective meetings.· Stakeholder management at different levels – liaising with internal and BUs stakeholders, stakeholders identification, analysis of their needs, authority, etc., creating stakeholders matrix, stakeholder engagement, managing communications.

United Kingdom

· Verizon is a group of companies specialising in Telecommunication, network and IT services.· Analysis and design of a new web platform allowing customers to purchase IT services online. Agile/Scrum development.· Facilitating workshops, requirements gathering, analysis, validation and traceability.· Defining the look and feel of the new web frontend.· Creating individual User Stories from complex requirements. Writing acceptance criteria.· Developing new solutions and operating models. Creation of functional specifications.· Gap Analysis. Creation of new business processes and re-engineering existing ones. · Liaising with marketing, development and test teams globally. Stakeholders management. · Creating test strategy, plan and scripts. Requirements implementation verification.· Managing end-to-end delivery of the changes during the SCRUM Sprints.

United Kingdom

· Business analysis for creating a new web platform allowing Vodafone to sell online M2M (Smart Devices) mobile network services to B2B clients. Design and development of 3 new websites – 1) for network management; 2) for enabling the Vodafone’s operational companies; 3) web e-commerce platform from which the Vodafone operational companies sell M2M related products.· Analysis, design and specification of the look and functionality of the new websites.· Full SDLC project experience in AGILE environment. Stakeholders management. · Requirements gathering via interviews, surveys, facilitating workshops, etc.· Creation of functional specifications, Use Cases and diagrams. Data modelling.· Business processes re-modelling using UML and based on BPMN and eTOM model. · Liaising with marketing, business, design, development and test Vodafone companies globally.· Supporting the design, business and test teams. Test management of the testing phases.· Test strategy, test plan, test scripts. UAT. Compliance verification of the requirements. · Delivering presentations and training.

United Kingdom

· Analysis and development of a Content Management System (CMS) and a membership website for Successful Minds Ltd. Integration with shopping cart, payment gateway and merchant bank. Use Cases and Business processes modelling using UML. Agile methodologies. Hands on full software development project life cycle experience. Creating technological roadmap.· Analysis and development of a CMS for D.A.G Services Ltd. Business processes modelling. Creating functional and technical specifications, test plans and scripts. · Creating new functionality for the existing website of ASL Ltd. Organising paid and free online advertising campaigns. Tracking the results and optimising the campaigns.

London Area, United Kingdom

· OSS and BSS Business analysis for a new system for BT. · Liaising with stakeholders from BT, Amdocs and third parties in India. Stakeholders management.· Gathering requirements via interviews, surveys and facilitating workshops.· Analysing the requirements and creating Use Cases and Business Processes re-modelling. · Agile software development. Delivering presentations of the new system to the clients from BT.

London Area, United Kingdom

· StatPro Ltd is a leading company developing Financial and Asset Management software.· Web hosted analytics platform for investment portfolios: Risk Measurement, Performance Analysis, Attribution Analysis, Research, Performance Measurement, GIPS Composites, Governance & Compliance, Analytics reporting and Financial index data services for small and medium asset management. · Requirements gathering from different levels of stakeholders. AGILE development.· Functional analysis. Creating Use Cases, test plans and test scripts.· Business Process modelling using UML. Stakeholders management at different levels.· Business analysis on new products for Front Office and Middle Office Portfolio Analytics.· Managing multiple projects.

Austria

· Project for Austria Telecom.· Liaising directly with the Business departments to capture requirements. · Business analysis on the Telecom’s OSS architecture and fault management.· Telco BSS related business analysis – new products, orders, bills, payments, CRM. · Business processes re-modelling. Agile methodologies. Use Cases. UML. · Revenue Assurance - data interrogation to find anomalies in transactions. Design and implementation of controls.

Poland

· Gathering requirements for implementing a new Clarify CRM system. · Telco OSS and BSS analysis, feasibility of the requirements and estimations. · Business model and System Architecture of the Clarify CRM system. · Business processes modelling. Creating Use Cases. Agile software development.· Integration of the CRM software with the billing system Geneva.

United Kingdom

· Gathering requirements for future enhancement of a Clarify CRM system.· Analysing system performance issues and implementing solutions.· Creating Functional and Technical Design Documentation.· Software development of Change Requests for enhancing the CRM systems. Technical Support.

London Area, United Kingdom

· Gathering requirements from BT stakeholders for a new Clarify CRM system. · Telco BSS related business analysis. Process mapping and re-engineering. · Creating Functional and Technical Design Documentation.· Data analysis and data migration.

London Area, United Kingdom

· Liaising with BT stakeholders at different levels to gather requirements. · System architecture of a new Clarify CRM application.· Creating high profile Use Cases and Technical Design specifications.· Business Analysis and integration of Clarify CRM with billing and network monitoring systems. · Creating Business Model of the new application and integrating business processes

London Area, United Kingdom

· Liaising with business managers and the development team of a Clarify CRM call centre. · Gathering business requirements and creating functional and technical design specifications.· Business processes re-modelling.· Used Rational Rose for Use Case creation.

London Area, United Kingdom

· Liaising with different levels of stakeholders to engage them and gather requirements.· Analysing the client’s requirements and creating Use Case documents.· Creating Technical Design for the Internet Banking Clarify CRM application.· Test case creation. Central point of contact between the business and the development.· Overseeing the delivery of tasks to ensure they meet the required quality standards.