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
- 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
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.
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
Team Members: Lawrence Patrick, Lawrence Patrick, Ian Adams
- March 2009 to Present
- Koverus Technology Group
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…
- 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
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
“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
“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
“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
“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
“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
— Peter Kong, Team Lead Application Service, Ultimate Software, managed Lawrence indirectly at
“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