Lawrence Franklin

Lawrence Franklin

Cashier

Followers of Lawrence Franklin444 followers
location of Lawrence FranklinRenton, Washington, United States

Connect with Lawrence Franklin to Send Message

Connect

Connect with Lawrence Franklin to Send Message

Connect
  • Timeline

  • About me

    Data Integration Administrator III at the Allen Institute, an independent nonprofit bioscience research institute aimed at unlocking the mysteries of biosciences and advance our knowledge to improve human health.

  • Education

    • Whittier College

      2000 - 2005
      Bachelor of Arts Physics

      Activities and Societies: Lancer Society, Men's Lacrosse, Black Student Union,

  • Experience

    • Fry's Electronics

      Jan 2005 - Jan 2006
      Cashier
    • Reliance Network

      Jun 2006 - Sept 2011
      Database Administrator

      Developed databases using Microsoft SQL Server working with Stored Procedures, Functions, Triggers, Views and Automated Jobs to update and maintain database integrity. Improved development process by leveraging new tools available in updated versions of SQL Server. Developed production SQL scripts for engineers to use in web applications.

    • Thomson Reuters

      Sept 2011 - Oct 2021

      -Provided effective consulting services to internal business partners and external clients that generated solutions to a wide variety of work-related problems.-Primarily focused on Business Intelligence solutions for Data Analysis, helped to develop new processes to extract data, perform necessary transformations and load into analytics platform services (such as Tableau, PowerBI, Azure).-Generated customized reports through ad-hoc SQL queries and reporting platforms (SSRS, Excel, PowerBI).-Supported internal business units to assist with pre-sales requirements gathering, market analysis, B2B integrations and on-boarding new clients with ETL processes (SQL-to-SQL, Oracle-to-SQL, Excel-to-SQL).-Served as T-SQL guru (10+ years experience) for professional services team by developing new processes & procedures to increase efficiency while providing technical training in MS SQL Server to the team of consultants.-Leveraged the agile development process to gather key requirements from customers to design, develop, and implement data visualizations that provide actionable data analysis.-Traveled to remote clients to provide in-person consulting sessions when needed to create the most effective suite of BI Solutions. Show less -Administered database systems to ensure that the data is 99.999% available for the Software-as-a-Service application that provides an online Matter Management system to corporate law Departments, law firms and lawyers. -Continually upgraded existing hardware and deployed new hardware to support rapid expansion of customer base. -Setup near bit-level replication processes to sync disaster recovery site with production center databases in the event of a necessary failover.-Deployed encryption-at-rest to ensure increased security for customer data.-Setup automated processes to provide company-wide monthly reports based of customer data for analysis of clients to internal departments.-Developed ad-hoc SQL queries to generate reports on-demand to encourage cross-departmental collaboration.-Assisted in various data integration projects such as developing an Oracle database environment for ETL processes into MS SQL Server database environments. Show less

      • Senior Technology Consultant

        May 2016 - Oct 2021
      • Database Administrator

        Sept 2011 - May 2016
    • Concentrix

      Oct 2021 - Jul 2024
      Senior BI Consultant

      Concentrix Catalyst is the experience design and engineering team of Concentrix, PK was acquired by Concentrix.As a Senior Consultant, Lawrence has worked with several Fortune 100 companies to achieve their goals with technology and optimize existing processes to help them be more efficient while exploring new solutions and opportunities.-Designing and developing premium technical solutions for clients in a highly iterative business centric delivery model.-Managing and meeting delivery milestones-Providing expert technical advice and guidance to project team members, client stakeholders, and our staff.-Contributing positively to our team culture and the practice Show less

    • Allen Institute

      Jul 2024 - now
      Data Integration Administrator III
  • Licenses & Certifications

    • Oracle Cloud Infrastructure 2024 Application Integration Professional

      Oracle
      Nov 2024