Lawrence Franklin

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