LRNTechnology

LRN Corporation is a global leader in solutions focused on building strong ethical cultures within organizations through training and technology.

  • New York City, NY
  • 700+ employees
  • Ethics & Legal Compliance Education

JIRA MIGRATION

THE CHALLENGE

  • SFS team faced access restrictions to the TR Jira instance due to security compliance.
  • The unavailability of a complete project dump was attributed to limitations.
  • Delays occurred in data retrieval and sharing as a consequence.
  • The TR team encountered challenges in devising a solution for obtaining a comprehensive dump, inclusive of attachments.

THE SOLUTION

  • SFS team utilized Python and REST API to develop a program for fetching project data from TR Jira.
  • The program included the retrieval of all task types and attachments associated with the project data.
  • Another program was created to clean the data, requiring minimal manual intervention.
  • The refined data was then migrated to LRN Jira using a dedicated program.
  • The migration process proved to be seamless and quicker than the initially estimated timeframe.

THE OUTCOME

  • Jira data migrated successfully from on-premise to new version of Jira then to cloud successfully

SERVICES PROVIDED

  • Transfer the data of the “Compliance Learning” project from the Thomson Reuters (TR) Jira instance to the LRN on premise Jira instance.

TR DATA MIGRATION TO SALESFORCE

THE CHALLENGE

  • No Access to Source SF instance.
  • Data received in CSV files.

THE SOLUTION

  • Data Mapping based on CSV files.
  • Created Custom-Fields to Cross-reference its source products and Customer Nos.
  • Migration of SalesCloud data based on CSV files.
  • Migration of Salesforce CPQ related objects Data from CSV files.

THE OUTCOME

  • The migration of the LRN Salesforce instance has been seamlessly and effectively completed, incorporating TR customer data, as well as Subscription and Asset Data, including Renewals and Contracts.
  • The LRN SF instance is now prepared for end users, featuring comprehensive TR Customer Data.

SERVICES PROVIDED

  • Migrate acquired “Compliance Learning” data form Thomson Reuters (TR) SF into LRN SF objects including CPQ objects.

TR OPENAIR TO MAVINLINK: IN A NARROW TIMEFRAME, TRANSFERRING ESSENTIAL DATA FROM ONE PROFESSIONAL SERVICES AUTOMATION (PSA) TOOL TO ANOTHER.

THE CHALLENGE

  • LRN acquired a company that utilized OpenAIR for managing projects in the content management space.
  • As LRN primarily used Mavenlink, there was a need to swiftly migrate the projects from OpenAir to Mavenlink.
  • Ensuring data accuracy was crucial, especially considering the tight deadline for completing the migration.

THE SOLUTION

  • Overcoming issues related to Data Models, API by connecting with support & development teams of corresponding PSA products Developed a migration tool using Python for data export from OpenAIR, stage the data in MySQL and finally import in Mavenlink To precisely track the migration of individual objects, the exported data (which was of substantial volume) was staged in an RDBMS.

THE OUTCOME

  • The data migration in the production system was successfully accomplished in an exceptionally brief period of one hour, and there were no inconsistencies detected in the data.

SERVICES PROVIDED

  • Migrate project management data from one OpenAir to Mavenlink.

SALESFORCE SUPPORT: SIMPLIFIED SALES AUTOMATIONS, VALIDATIONS, FIXING CASES AND REPORTING PROCESSES

THE CHALLENGE

  • Lead Assignment based on the territory country, employee size.
  • Matched Accounts for the Leads.
  • Validate Contact who left company and remove contact from Account Contact Relation.
  • ACV and TCV Revenue rollup on opportunity and Account.
  • Reports and Dashboards.
  • Forms, files upload and email notifications to the teams on the Mavenlink projects completion based on the products.

THE SOLUTION

  • Simplified Territory Management by Configuring Territory Model and assigned the leads based on the territory.
  • Simplified Developed automation to validate the accounts which matches with the website name and assign Lead owner.
  • Developed automation to validate the contacts who has left the company and removed account contact relationship object.
  • Developed Rollup summaries and formula fields to rollup the ACV and TCV revenue fields accurately.
  • Developed Reports and Dashboards.
  • Created custom object and developed multiple forms using screen flows to store the Mavenlink project records and files which were created using the forms on Mavenlink projects and notified respective teams upon the form submission.

THE OUTCOME

  • These automations not only streamlined the sales process but also contributed to a more comprehensive and effective approach to lead, account, contact and opportunity management in Salesforce.

SERVICES PROVIDED

  • Territory Management Optimization.
  • Account Validation Automation.
  • Contact Management Automation.
  • Revenue Calculation Enhancement.
  • Reports and Dashboards Development.

GAINSIGHT: CONFIGURED 360 PAGES AND LAYOUTS, CONFIGURED CUSTOMER GOALS, TASKS CREATION, REPORTS AND DASHBOARDS, INTEGRATION WITH SALESFORCE

THE CHALLENGE

  • 360 Layouts.
  • Salesforce and Gainsight Sync issues.
  • Reports and Dashboards.
  • CTA’s and Timeline.
  • Follow up CSAT for Projects.
  • NPS and CSAT Scores.

THE SOLUTION

  • Configured 360 Layouts for the users and managers.
  • Fixed Salesforce and Gainsight Sync issues by creating the rules in Gainsight
  • Developed reports and dashboards as per the business needs.
  • Developed Call To Actions on the Gainsight and established sync to Salesforce.
  • Developed JO Model and Email templates to send the follow up CSAT surveys and capturing their responses.
  • Developed rules to grade and colour the scores for the CSAT AND NPS Scores.

THE OUTCOME

  • The outcomes of the implemented services are noteworthy. Configuring 360 Layouts has enhanced user and manager visibility, while resolving synchronization issues between Salesforce and Gainsight through rule creation ensures smooth data flow.
  • Developed reports and dashboards cater to specific business needs, providing actionable insights.
  • The integration of Call To Actions on Gainsight streamlines workflow, and automated CSAT survey follow-ups, along with rule-based grading of scores, contribute to efficient customer feedback management.

SERVICES PROVIDED

  • Configured 360 Layouts
  • Salesforce and Gainsight Sync Issue Resolution
  • Custom Reports and Dashboards
  • Call To Actions Implementation
  • CSAT Survey Automation
  • CSAT and NPS Score Rules and Visualization