Andrew Pallant

Software & Web Developer

Who Is Andrew Pallant (@LdnDeveloper)

Andrew Pallant is a Software, Web and Database Developer living in London Ontario Canada. With over 15 years of experience; Andrew uses Python, PHP, ASP.NET, ASP and Java for web-based business solutions. C#, Java, VB, VB.NET and C are just some of the programming languages that Andrew uses in his to build web and desktop solutions. Andrew makes use of many databases including, but limited to: MySQL, MS SQL, DB2. Andrew's keen sense for business needs analysis, usability and accessibility has enabled his work to be used by all company sizes.

Andrew is accepting jobs and contracts located in the London Ontario Canada area.

Current Employment

Andrew Pallant is currently employed as Manager of Technology by Thinq Technologies (DirectDial.com) in London Ontario Canada. Andrew's duties include being Technical Lead, SEO and Social Media Manager, Lead Developer and much more. Andrew Pallant works with technologies including, but not limited to ASP, C#, Python, SQL and various windows platforms. Andrew's main goals is to aide the company moving forward with initiatives that support its distributors and customers.

Andrew Pallant was previous employed by:
  1. Link+ Customs Brokers
  2. Buckland Customs Brokers
  3. ICINITI

QR Code For Resume Download Resume to Device

Latest Blog Entries

Current Blog

SQL Function – Find a Value in a String of Values


In a table I have a field that you can use comma delimited value (example 1,2,3,22). When I tried to filtering use a “LIKE” statement on the value 2, I was being returned 2 and 22. ARG!

So what do you do? You create a simple function the returns a 1 or 0. 1 being successfully found and a 0 meaning failed to find. Seems simple enough? Well it was and the function can be easily tweaked to match the solution you need! Here is the function as I used it:


[read more]

What People Are Saying

Andrew Pallant is passionate about Toastmasters and in his role as VP of Membership he was instrumental in creating new material to increase membership, while also being the club expert and mentor for helping members improve their communication skills using electronic aids. Andrew is a valuable asset to London Western and I am happy to endorse his work. I am delighted that he is now the club president and I look forward to working with him in this role to an even greater extent as Area 71 Governor this year. I am confident that with Andrew as the leader, London Western will continue to grow and help members achieve excellence. Thank you Andrew!

Sue Storie - Past Division S Education Ambassador, Toastmasters International

July 26, 2012
Andrew is unlike any other I've ever worked with in his field. He is highly skilled and experienced in his profession and will never shy away from going the extra mile to ensure a quality product or solution. On top of that, his knowledge of social media is a definite asset and his insight on how Marketing and Design individuals work/think makes a world of difference. Second to none. Andrew is easy to work with, get along with and communicate with. A true professional who isn't above enjoying a good laugh. A true asset to any team he joins - my blood-pressure is sure to go up if ever I find myself not working on the same team as Andrew.

True story. :)

Jas Romain - Creative Direction & Lead/Senior Designer, Thinq Technologies

June 4, 2012
I have learned more in 2 months working with Andrew than I have learned in 2 years with other IT professionals.

In an industry where Social media is still new to many, Andrew is a true expert.

Professional, team player, leads by example, always willing to lend a hand. A true asset to any company or organization.

Kevin G. Douglas - Marketing Manager, Thinq Technologies

April 20, 2012
Andrew's technical wizardary shines through in all that he does as webmaster of London Western's website. With the planned additions that Andrew has made, the website is now a more valuable communications and leadership asset.

Mark Phipps - President, London Western (4189), Toastmasters International

August 2, 2011
Andrew is a very resourceful individual in his field. On occasions where I was stuck or needed guidance relating to our computer programs, settings, and software/website development. Andrew was very quick and responsive to provide a solution. He is also a very dedicated family man & a good guy to have on the BBQ. I highly recommend Andrew and his work.

Rob Ashmore - International Freight Manager, Link+ Corporation

April 18, 2012
In addition to being an excellent programmer, Andrew is a very astute businessman. His vast knowledge of the most up-to-date computer happenings, combined with his entrepreneurial spirit make him an asset to our company. We often collaborate on projects; his ability to create solutions that address the needs of both our clients and our business give me peace of mind that the job will be done right. I recommend his services without hesitation.

Sebastian Gerber - CCS, Account Executive, Link+ Corporation

July 9, 2010
It is pleasure to work with Andrew and he is a good leader also. He has both technical and management skill. He would be a person of great standing for any team or company

Paul Chen - Senior Developer, Buckland Customs Brokers

July 9, 2010
Andrew always maintained a healthy relationship with clients, had good attention to detail in his programming projects and a desire to improve our core products with current technologies and techniques. His ambition and contributions gave synergy to our team.

Darren Jerrard - Senior Software Developer, Iciniti Corporation

June 7, 2012
My experience working with Andrew has shown me that he is knowledgable and proffessional. I recall that the management leaned on him when they needed a tough problem solved.

Jeff Dease - Senior Software Developer, Iciniti Corporation

December 28, 2010
Andrew was a hard working and caring employee with excellent development skills. He managed many successful projects for Iciniti and had a good working relationship with our customers.

Bill Parkinson - President, Iciniti Corporation

May 31, 2010





@LdnDeveloper





Google | humanstxt.org | Andrew Pallant's Blog Site