My goal is to provide relevant content to SQL Programmers and help promote standards in the area of data management.
Registration is completely free and members receive the following benefits.
– Free Articles
– Job Postings

View Lawrence Patrick's profile on LinkedIn


  • Home Town: Miami, Florida
  • Favorite Teams: Dolphins, HEAT
  • Loves: Burgers, Movies, Working Remotely
  • Favorite Food: Sushi, BBQ
  • Schools: University of Miami, Stanford University & Oracle University

[tabgroup][tab title=”About Me” id=”1″]

1. How did you arrive at running this SQL Marksman? What path brought you here?
I spend a lot of time online trying to figure things out and I thought I could also provide the same service. I try to write an article as I develop or fix an issue at work.
How did I get here, I stopped by Barnes and Noble and found a book- Problogger – this prompted me to start blogging and try to make a business out of my content and following. I currently have over 500 unique hits a week, not much but I hope that will grow. I am always surprised to see the amount of countries that read my articles.

2. What are you known for professionally? What do you have a knack for?
I am very good at SQL – I can program directly in notepad with few errors – my colleagues are always impressed with this. I was an SQL programmer full time for a while and I got very good at it. I have a knack for AI Mathematics – I can dive into this stuff.

3. What’s the one problem you are best at solving for your clients? What do your ideal clients say about you?
Data issues – Finding missing money or working through a data problem. My clients say about me – “if it’s too hard, just give it to Lawrence”

4. Who have you worked with in the past? And what have you done for them?
I have been around –

I worked for the US Navy as an Operation Specialist – BUDS class 229 – IFF systems & other cool stuff
I worked for University of Miami – worked on their security systems and custom analytics for HR
I worked for Ultimate Software – Helped them performance tune a process (payroll) that was taking over 24 hours to complete – got it down to 2 minutes –Client thought it was broken the first time it ran so fast – CIO thanked me personally for this.
I worked for Kellstrom Aerospace – Performance tuning and Sales Data warehouse (ETL, Data Model, SQL) – also helped them migrate of that old AS400.
I worked for Grassroots – Full time SQL programmer and ETL developer – Cisco Redbadge holder and inactive Top Secret Military Clearance
I worked for Prefered Care Partners – EDI specialist, developed HL7 transfer of claims records for MEDCO.
I work for The Trizetto Group – Managing release operations for Blue Cross Blue Shield clients – Also work on predictive analysis of Medical data.

5. What are you most passionate about professionally? What most excites you about your work & the contribution you can make?
Predictive Analysis of Data – I love working with Machine Learning problems and the advancement of AI.
6. What are you passionate about personally? What do you really enjoy? What can’t you stop talking about?
Being a dad, my daughter is a gymnast and we spend a lot of time on the road, so proud of her! 3rd place all around gymnast State of Florida 2012
7. Where can we find you when you’re not working? What’s your favorite way to spend a weekend or a Sunday afternoon?
At the UM school of business, they have quiet work spaces and I can focus there. I also spend time at the movies or with family throwing the football around.
8. How long have you been doing what you do?
Funny, I did not know much about computers until I got out of the military but since then I have taken a plunge and have loved it. I have been doing this for over 10 years.
9. Where did you grow up and why aren’t you there now?
I am where I grew up, in Miami FL – Now I live on the beach, we like the water

10. Any nonprofits you love, & why?
Bochika – one of my best friends runs it and they specialize in reducing/fighting human trafficking.
11. What would be impossible for you to give up?
Study of Math & Physics

12. Why would someone not want to work with you?
I take the lead and immediately want to learn more about the issue than is required to solve the problem.
13. How do you want to be remembered?
A person that always helped those in need and one that fights for what is right.


  • [/tab][tab title=”Education” id=”2″]
  • Stanford University2012 Machine Learning, AI -, Online Student in Mathematics and Computer Science
    TBA – 2013 Graduate AI/Artificial Intelligence Program
    Programming Octave & R
    Activities and Societies: Yield patterns or predictions using both supervised & unsupervised algorithms with data sets as input- using regression models
  • Trizetto University
    FACETS Data Model Training, Healthcare Informatics Data Model Training
    2011 – 2011
    Corporate sponsored training on Trizetto Data Model Mining. Trizetto is a leading healthcare management sotware suite. It is the most widely used softare to manage healthcare in the US.
    This education is associated with:Oracle University | Orlando, FL
    Certification, Oracle 10g
    2008 – 2008 Oracle 10g on Linux
  • University of Miami | Coral Gables, FL
    Bachelor of General Studies, Computer Science
    2003 – 2006[/tab] [tab title=”Projects” id=”3″]

    • dwBuilder – Reporting SaaS – dwbuilder.cloudapp.net (under development)

      •  March 2009 to Present
      • Koverus Technology Group
      Team Members: Lawrence Patrick, Lawrence Patrick, Ian Adams

      Data Warehousing & BI

      Koverus Tech a leader in Reporting SaaS. dwBuilder™ delivers BI securely from the cloud. The system includes built in features like statistical analysis, use of modern algorithms and the platform has a strong foundation in statistical methods.

      dwMedical™ – our Medical Information Data Warehouse comes pre-packaged with reports on utilization, pharmacy…

      dwbuilder.com | ETL Development Articles
      dbafarm.com | Database Administrator Articles
      sqlmarksman.com | SQL Programming Articles

    [tab title=”Top Skils” id=”4″]

    Top Skills:

    • 1. Artificial Intelligence, Machine Learning (SVM, GD, Recommender Systems, Facial Recognition)
    • 2. Matlab,Octave,R
    • 3. SQL\TSQL. SSIS
    • 4. Data Modeling
    • 5. DW/Business Intelligence
    • 6. Application Development, C# or other
    • 7. Cloud Development | Azure & Azure SSRS


    [tab title=”Recommendations” id=”5″]

    LinkedIn | 20 people have recommended Lawrence
    “Lawrence is a gifted Sr. DBA/Developer. He is well versed in a wide array of technologies and concepts. He
    has provided incredible insight and support in many areas including, software, SQL and BI Development and
    Design, Database Administration, and Security. He is quick to lend a helping hand and enjoys teaching others
    his craft. He is a very valuable asset to our organization.”
    Javier Gonzalez, Senior Systems Architect, Prestige Cruise Holdings, worked directly with Lawrence at
    Prestige Cruise Holdings
    “Lawrence is a wealth of knowledge and experience. He is highly motivated and dependable.”
    — Steven Salgado, Lead SQL/ BI Developer, Preferred Care Partners, worked with Lawrence at Preferred
    Care Partners
    “Lawrence and I worked on a performance issue with TriZetto’s NetworX Modeler product installation at
    Preferred Care Partners. Lawrence was very knowledgeable and helped us get to the root cause of our issue
    (blocking issues) and specifically point out where we needed to focus our efforts. He is a very skilled DBA
    and identified many areas for us to investigate. It was a pleasure working with him and he is a valuable
    member of the team.”
    Keith Cochran, Manager, Software Development, The Trizetto Group, Inc., was with another company
    when working with Lawrence at Preferred Care Partners
    “Lawrence is what I consider a “techie ninja”, given he has some very valuable tricks under his belt, from
    deep db engine and data manipulation perspectives as well as overall technical capabilities and understanding
    that allows him to perform in various development and infrastructure functions. One of the smartest dudes
    I’ve ever met, always loved to engage in any activity that involved getting Lawrence on board. Certainly
    would recommend and want to work with him again. Roberto”
    Roberto Andrade, Product Development Manager, Grass Roots America, worked directly with Lawrence
    at Grass Roots America
    “Dear Lawrence, I’ve written this recommendation of your work to share with other LinkedIn users. Details of
    the Recommendation: “As a software developer, it is always good to have people that understand you and
    your technical needs, and I must say that Lawrence is of this kind, he understand your needs and helps
    accomplish your goal. I enjoy working with him. Regards Marlus”

    — Marlus Silva, Software Developer, Grass Roots America, worked with Lawrence at Grass Roots
    “Lawrence is a great problem solver and thrives on a challenge. He is a great contributor and will offer ideas
    and solutions. If you want a serious SQL player then I would thoroughly commend Lawrence.”
    Steve Parkinson, CIO, Grass Roots America, managed Lawrence indirectly at Grass Roots
    “Simply put, Lawrence is very knowledgeable, hardworking, creative, and is willing to go the extra mile.
    With Lawrence you’ll have know shortage of ideas. He get’s along with everybody and is a real team player.
    It would be my pleasure to work with him again.”
    Darren Peckett, PMP, CSPO, Director Project Management Office – PMO, Grass Roots
    America, managed Lawrence indirectly at Grass Roots
    “Lawrence is an personable, enthusiastic and energetic DBA with excellent technical skills. He’s an asset to
    the company and I enjoy working with him.”
    Jose Leyba, IT Development Manager, Kellstrom Industries, managed Lawrence at Kellstrom Aerospace
    & Defense
    “Lawrence provides all the IT work to my company, he is definately creative and has a gift to know exactly
    what i want for my company. very loyal and trustworthy, definately a pleasure doing busines with.”
    Fernando Tapia, was Lawrence’s client
    “Lawerence, is great to work with, he is a first class DBA”
    Leon Motta, Systems Engineer, EMC Proven Professional, MCSE, Ultimate Software Group Inc, worked
    directly with Lawrence at Ultimate Software
    “Lawrence is a stellar technical talent. Founded in solid technology, Lawrence is capable of assisting in day to
    day and strategic thinking for heavily complex technical challenges for the modern business. Lawrence is
    passionate about making the best in all situations by successfully combining his technical expertise &
    Charles Nicholson, Senior Technical Architect & Engineer, Ultimate Software, worked with Lawrence at
    Ultimate Software
    “Lawrence is a hard worker who is constantly looking for ways to improve the database systems. He has a
    high level of knowledge around Microsoft SQL Server and brings a valuable point of view to the
    conversation. He is certainly somebody you want to have in your team.”
    Rafael Santos, Director, QA, Ultimate Software, managed Lawrence indirectly at Ultimate Software
    “If you need help improving your SQL based application performances, Lawrence is the right person to talk
    to. He is an expert at SQL performance tuning and his understanding of storage media and SANs in general
    gives him that little extra that makes all the difference between a “sluggish” application and a super-fast one!
    Besides consulting with him on performance related problem, I often found myself seeking his advice to
    develop my C# based application as he is quite of a developer himself. Most of all, I really enjoyed his
    positive attitude and his ability to make time to help his colleagues.”
    Olivier Rossi, System Engineer / Automation Engineer, Ultimate Software, worked with Lawrence at
    Ultimate Software
    “During the period of time that I had the privilege to work with Lawrence he proved himself extremely
    competent as a database administrator and a professional all around.”
    Kerwin Bradwell, Security Administrator, Ultimate Software, worked with Lawrence at Ultimate
    “Lawrence is a talented DBA — he enjoys a good challenge….”
    Brian Goldberg, BSP Development Technical Team Lead, Ultimate Software, worked with Lawrence at
    Ultimate Software
    “Lawrence is a detail-oriented, thorough, and professional colleague. In my time working with Lawrence he
    demonstrated self-motivation, impeccable knowledge and the ability to think ‘outside the box’.”
    Christopher Rhoden, Network Engineer, Ultimate Software, worked with Lawrence at Ultimate Software
    “Lawrence joined Ultimate Software as the senior DBA in a high velocity production environment which
    manages records for over a half million employees across dozens of SQL Servers and hundreds of databases
    using our UltiPro Workforce Management solution. The application and environment are complex. Lawrence
    quickly demonstrated that he was able to troubleshoot and resolve issues of all types, contributing to the up
    time and performance of our solution for our customers.”
    Roy Gerber, VP & CTO, Ultimate Software, managed Lawrence indirectly at Ultimate Software
    “Lawrence and I worked on couple of projects to enhancement the performance on the SQL 2000 Cluster
    Server and standardize SQL settings to the farm. He is very knowledgeable on SQL Servers and Database
    performance settings.”
    Peter Kong, Team Lead Application Service, Ultimate Software, managed Lawrence indirectly at
    Ultimate Software
    “Lawrence is always eager to try new things and willing to get the job done.”
    David Piniella, Network Specialist, University of Miami, worked directly with Lawrence at University of
    “Lawrence and I have gained in depth knowledge of the Facets Data Model.”
    Steven Salgado, Lead SQL/ BI Developer, Preferred Care Partners, studied with Lawrence at Trizetto


Leave a Reply