Mark Johnstone was the owner and operator of Johnstone Enterprises, a Database Consulting business specialising in iMIS (CRM or AMS)I worked closely with customers to help them maximize the information held within their databases. I worked on many projects including:iMIS Consulting Database Upgrades and ImplementationData AnalysisData SegmentationCrystal Reports Microsoft Reporting Services (SSRS and SSIS)Website Integration Process… Show more Mark Johnstone was the owner and operator of Johnstone Enterprises, a Database Consulting business specialising in iMIS (CRM or AMS)I worked closely with customers to help them maximize the information held within their databases. I worked on many projects including:iMIS Consulting Database Upgrades and ImplementationData AnalysisData SegmentationCrystal Reports Microsoft Reporting Services (SSRS and SSIS)Website Integration Process AutomationI worked not only in Melbourne, but around Australia and even in the US and UK. Show less

Led the mapping of customer journeys for Associations utilizing uXpressia, resulting in a comprehensive understanding of user interactions and touchpoints.Translated business requirements into actionable functional requirements by utilizing EPICS, User Stories, and Acceptance Criteria, ensuring alignment with stakeholder expectations.Consulted with stakeholders to deeply understand their business requirements and effectively communicated proposed changes to the Salesforce… Show more Led the mapping of customer journeys for Associations utilizing uXpressia, resulting in a comprehensive understanding of user interactions and touchpoints.Translated business requirements into actionable functional requirements by utilizing EPICS, User Stories, and Acceptance Criteria, ensuring alignment with stakeholder expectations.Consulted with stakeholders to deeply understand their business requirements and effectively communicated proposed changes to the Salesforce environment.Configured and customized Salesforce settings, applications, objects, and workflows to meet specific business needs, enhancing overall user experience.Developed custom objects, fields, workflows, and process builder flows to customize Salesforce functionality according to business requirements, improving efficiency and productivity.Implemented robust data quality measures to maintain data integrity within Salesforce, ensuring accuracy and reliability of information.Created and maintained comprehensive documentation for Salesforce configurations, customizations, and processes, facilitating knowledge transfer and future reference.Collaborated closely with cross-functional teams, including developers, administrators, and business analysts, to ensure seamless implementation and integration of Salesforce solutions.Conducted thorough testing of Salesforce configurations and customizations to validate adherence to specified requirements, minimizing errors and enhancing system reliability.Managed and contributed to Salesforce projects, ensuring timely delivery and adherence to project timelines, resulting in increased efficiency and client satisfaction.Communicated project progress and issues to stakeholders through daily stand-ups and sprint retrospectives, fostering transparency and alignment with project goals.Maintained strong client relationships through effective communication and understanding of evolving needs, resulting in continued collaboration and trust. Show less

I joined the AMCA to help the association move from state based offices to a single National office. This resulted in the consolidation of 7 State based bodies into 1 National Body, including consolidation of CRM Systems, Database, Membership Structure, File structure and reporting for internal staff, management and board,I work with multiple departments including communication and marketing team, membership, training and finance.During this time we had to implement Office365,… Show more I joined the AMCA to help the association move from state based offices to a single National office. This resulted in the consolidation of 7 State based bodies into 1 National Body, including consolidation of CRM Systems, Database, Membership Structure, File structure and reporting for internal staff, management and board,I work with multiple departments including communication and marketing team, membership, training and finance.During this time we had to implement Office365, Microsoft Teams, Team Calling and Sharepoint. This was as a result of the Pandemic and having staff who were working from home (WFH).Where possible we seeked to use the industry standard applications and then used API to integrate back into our CRM system, to ensure single source of data.More recently we implemented metrix and dashboards internally for staff, board and management team. To see membership revenue, members by state and type and detailed analytics. Show less

Fire Protection Association Australia is as Systems coordinator, which involved managing and implementing all IT systems and data across the entire organization, including integrating external systems with our CRM and LMS systems. Responsible for managing and implementing an accreditation program for the NSW government, to ensure that fire safety assessors were accredited and trained in fire safety. This program has recently accredited over 1000 assessors and assessed over 20,000… Show more Fire Protection Association Australia is as Systems coordinator, which involved managing and implementing all IT systems and data across the entire organization, including integrating external systems with our CRM and LMS systems. Responsible for managing and implementing an accreditation program for the NSW government, to ensure that fire safety assessors were accredited and trained in fire safety. This program has recently accredited over 1000 assessors and assessed over 20,000 exams. All information collected was integrated between the LMS and CRM System, via API calls (where possible) and automated tasks.Instigating the implementation of the digital transformation of the organization, including Office 365, Teams, and Sharepoint.Building of new online shop to allow members and non-members to purchase products online 24/7. Show less