Lawrence Kelly

Experience

• 

  Xwave

  Jan 2000 - Dec 2010

  Systems Analyst

  Lawrence worked for a number of clients and projects within the Health Care, Government, Telecommunications and Retail industries.Some of Lawrence's activities for these various clients included:- Manage xwave BI resources on the project team;- Project management;- Report development and enhancements;- Cube development and enhancements;- Data gap analysis;- Data validation;- Training technical and business users;- Security and administration of IBM Cognos environments; and- Software development. Minder weergeven

• 

  State of Maine - Office MaineCare Services

  Apr 2006 - Dec 2007

  Xwave BI Consultant / BI Team Lead

  Lawrence was a xwave contractor at the Office MaineCare Services (Maine Department of Health and Human Services). Lawrence was the Business Intelligence Team Lead for the xwave Business Intelligence resources.Some of Lawrence's responsibilities included;- Manage the xwave BI resources on the the Maine Medicaid Decision Support System (MMDSS) team; - Develop reports for senior DHHS management and Finance division;- Lead the Cube Development Team in the development of 3 Claims cubes;- Data modeling involving 3 databases, 12 packages and 400 query subjects; - Train 50 State employees and contractors in Cognos Connection navigation;- Train 7 State employees in Query Studio and adhoc reporting;- Train 4 State employees in analyzing cubes within Analysis Studio; - Security and administration of the Cognos 8 environment; - Provide technical and business support for 100+ users;- Guide the State through the HP-UX installation and configuration of Cognos 8; - Lead the analysis to identify the report, data and certification gaps within the MMDSS; - Work with the client to develop cube and reporting requirements; - Assist Project Lead in coordinating with the State and their vendor a clear understanding of the current situation issues, risks and progress related to the DSS;- Validate data between the Maine Claims Management System (MeCMS) source system and the Decision Support System; - Support project management with project planning, human resources, cost management, software inventory and meeting facilitation; and - Assist in the development of an action plan to address open issues, tasks and risks; Minder weergeven

• 

  State of Maine- Office Of Information Technology

  Jun 2008 - Sept 2008

  Xwave BI Consultant / Business Intelligence Project Manager

  Lawrence was a xwave contractor at the Maine Center for Disease Control and Prevention (MECDC). Lawrence was the Business Intelligence Project Manager for the development and implementation of Phase I of the Cognos Dashboard Reporting Initiative.Some of Lawrence's responsibilities included:- Manage the xwave Business Intelligence resources on the project team; - Assist in the development of 5 reports for the Division Director;- Coach State employees through the building of the MECDC Dashboard model;- Coordinate User Acceptance Testing (UAT) change requests and resolution;- Completing necessary Project Management activities and documentation as required; and,- Provide technical support and knowledge transfer for the Cognos 8 environment. Minder weergeven

• 

  Bell Canada

  Jan 2011 - Jan 2018

  Systems Analyst

  Lawrence worked for a number of clients and projects within the Retail and Government verticals.Some of Lawrence's activities for these various clients included:- Architect and deliver significant changes for a Government department dashboard;- Architect and implement Expense, Inventory and Sales dashboards for a Retail client;- Prototype and present dashboard designs to senior management and business representatives;- Analyze and understand data challenges within existing Data Warehouses;- Identify data integrity issues and data gaps;- Conduct detailed performance analysis on all database objects and Data Warehouse builds;- Work with Database Administrators to optimize SQL procedures and views;- Primary Production Support for the client Data Warehouse;- Report development and enhancement; and- Training technical and business users. Minder weergeven

• 

  Lake Echo Analytics

  Nov 2018 - Nov 2019

  Principal Consultant

  I worked as an independent Business Intelligence and Analytics Consultant, helping organizations overcome data challenges, improve reporting, and make better business decisions. With over 20 years of experience, I provided tailored solutions for clients seeking to gain better insights into their data.Key Projects & Solutions:• User Acceptance Testing & Training – Led UAT facilitation and provided on-site IBM Cognos Analytics 11 training & support for client teams.• Report Migration & Development – Recreated legacy reports in IBM Cognos, ensuring accuracy and improved performance.• Best Practices & Strategy – Advised on IBM Cognos Analytics implementation, providing best practices for architecture and governance.• Business Requirements & Design – Translated business needs into solution options, creating high-level design models for BI systems.• Data Transformation & Warehousing – Built a SQL Server data warehouse, transforming data from Oracle and SQL Server data marts.• Coaching & Mentorship – Guided technical teams on SQL and Cognos functionality, improving their ability to develop robust reporting solutions.I worked closely with business leaders, analysts, and IT teams to ensure data solutions met the business needs.If you're looking for expertise in BI, data strategy, or analytics solutions, let’s connect. Minder weergeven

• 

  MOBIA Technology Innovations

  Nov 2018 - Jan 2019

  Senior Consultant (contract)

  Working on behalf of Mobia for their client based in the Health Services industry. In the role of an ETL Specialist the primary objectives are completing ETL deliverables and delivering multiple data warehouses to support the client's data analytics capabilities.

• 

  MOBIA Technology Innovations

  Jan 2019 - Nov 2019

  Senior Consultant (contract)

  Working on behalf of Mobia for their client based in the Education vertical. As a Business Analyst, the primary objectives are facilitating the UAT and training staff in Cognos Analytics.

• 

  CGI

  Nov 2019 - now

  Senior Consultant

  Providing business solutions to public sector clients in Analytic Architect and Senior Business Analyst roles.Some of the activities for my clients include;• Manage and monitor 28 business user stories and 48 technical user stories within Atlassian Jira;• Document user story mappings, scope, process flow, business requirements, non-functional requirements, decision logs and other documentation within Confluence;• Senior Business Analyst on a new API development project (AWS) for a Canadian Banking client;• QA Team Lead on a Microsoft Azure platform project;• Scrum Master for the daily scrums in the absence of the Technical Project Manager;• Lead Sprint Planning, Retrospective and Showcase meetings in the absence of the Technical Project Manager;• Assist in the creation of a Business Requirements and Roadmap Considerations deliverable;• Author the Quality Assurance Plan deliverable;• Outline the strategies and risks associated with changing the ETL process for an existing data warehouse;• Facilitate workshops for modules within a Case Management application;• Create or modify Configuration and Developer specifications that document how the Case Management application will meet the business requirements;• Supervise and mentor a Reporting Analyst;• Complete Functional Testing and System Integration Testing on new functionality; and• Provide on-site IBM Cognos Analytics 11.1 support and training for client staff.Industries: Health Care, Education, Social Services, Canadian Banking, Information Technology, Public & Private SectorsTechnology: Atlassian JIRA, Confluence, Figma, ALM, Perfecto Mobile, AWS, Power BI, Oracle, SQL, PL/SQL, Azure DevOps (ADO), Azure, MS SQL, MS Purview, IBM Cognos Analytics, PowerSchool Minder weergeven

• 

  Dartmouth Toastmasters

  Jul 2020 - now

  As the club President I was responsible for overall operation of the club. In addition to the role of club President, I also the acting VP Membership (VPM) and VP Public Relations as both roles were vacant for the duration of the Toastmasters year.• I led the club towards achieving its goals and objectives, including increasing membership and enhancing the club's reputation in the community• Managing club operations and activities, ensuring that the club is running efficiently and effectively• Coordinating and executing 2 successful open house events• Utilizing Artificial Intelligence (AI) to create innovative and entertaining social media posts • Manage the Dartmouth Toastmasters web site and social media presence (Facebook and LinkedIn)• Provide guidance and support to club members in developing their public speaking and communication skills• Initial point of contact for prospective guests reaching out through our club website, Facebook or LinkedIn• Manage the club's membership growth, ensuring that new members are welcomed and integrated into the club communityBy taking on multiple roles and utilizing my leadership, PR, and communication skills, I am successfully leading the club to achieve its goals and grow its membership. Incorporating AI into social media posts and to the club website, helping make the club stand out in comparison to other Toastmaster club's social media. Minder weergeven As the Dartmouth Toastmasters VP Public Relations, I • Led the development and implementation of the club's PR strategy to raise awareness, increase membership, and enhance the club's reputation in the community• Managed Dartmouth Toastmasters social media presence (Facebook and LinkedIn)• Provided guidance and support to club members in developing their public speaking and communication skillsBy utilizing my PR and communication skills, I successfully increased the club's visibility and enhanced its reputation in the community. This experience has honed my abilities in media and public relations, event planning, and stakeholder management. Minder weergeven

  • Acting Vice President Public Relations (VPPR)

    Jul 2023 - now

  • President

    Jul 2022 - Jun 2023

  • Vice President Public Relations (VPPR)

    Jul 2020 - Jun 2022
• 

  Toastmasters International

  Jul 2023 - now

  As the Public Relations Manager for District 45 Toastmasters, I am responsible for promoting our district's activities and achievements. My role includes:• Developing and implementing PR strategies to enhance our district's visibility.• Managing and creating content for our social media channels and website.• Collaborating with club officers to support their promotional efforts.• Coordinating press releases and media outreach.• Assisting with the district budget preparations.• Providing PR training and resources to our clubs. Minder weergeven During my year as Area 1 Director, I had the opportunity to support and guide 5 Toastmasters clubs across our district. My role involved conducting club visits to assess and provide feedback on their meeting quality, coaching club officers on leadership best practices, and organizing Area contests. I enjoyed working closely with club leaders to help them navigate challenges and celebrate their achievements.This role allowed me to enhance my skills in project management, leadership development, and public speaking. It was rewarding to see clubs grow stronger and members reach new milestones in their communication and leadership journeys. Minder weergeven

  • Public Relations Manager (District 45)

    Jul 2024 - now

  • Area Director (District 45 Area 1)

    Jul 2023 - Jun 2024