ValentinoV
BI Consultant
  • Hoegaarden Meldert,
  • Vlaanderen,
  • Belgium
Member Since: 2008/08/11
Industry: Consulting
Top Skills:
Tech Certifications:
View All
CERTIFIED EXPERT
  • Topic Advisor

1998: C++ - SQL Server 6.5
2000-2007: C++, VB6, C#, java - SQL Server 7.0-2005
2008-...: SQL Server 2005-2016
2014-2017: MVP Data Platform

More bio
Activity
Points this month470
Total points3,015,574
Questions: 6
Solutions: 1247
Articles: 17
Videos:
Tutorials:
Posts:
Group Discussions: 20
Professional Background
BI Consultant
Ordina
April 2008 – Present
BI Consultant/Architect using mainly Microsoft technology: SQL Server incl. SSIS, SSRS, SSAS.
Experienced in migration and data integration projects as well as in database/DWH design.
Worked for several customers, most known are Nike and Medtronic.
Senior Application Developer
Western Union
July 2000 – April 2008
During my 8 years at WU I worked on several applications, such as:
o Voyager (VB6, SQL Server 2000-2005 incl. MSDE, SQL Server Express Edition, SQL-DMO, SMO, .NET 2002 - C#, XSLT)
o Agent Services (Java - JPOX, log4j, JMX, Ant, StatCVS - Eclipse 3.x, SQL Server 2000)
o Agent Services Monitor (Java - JSP - Eclipse 3.x, T-SQL, SQL Server 2000)
o Spider prototype (.NET 2002 - C#, ASP.NET - SQL Server 2000)

More Tech:
SQL Server 7.0
VC++ 6.0
More
Education
No Education Background shown
More
Full Biography

You can follow me on Twitter if you'd like to receive a notification whenever I publish a new article: http://twitter.com/#!/ValentinoV42

Or connect on LinkedIn if you feel like it (please mention your EE profile name): http://www.linkedin.com/in/vranken

For a more detailed profile, see the About page on my blog: http://blog.hoegaerden.be/about/

My articles at Experts Exchange
==========================
{CP = Community Pick, EEA = EE Approved, EC = Editor's Choice}
https://www.experts-exchange.com/A_10755.html - Displaying Checkboxes In An SSRS Report (CP/EEA/EC)
https://www.experts-exchange.com/A_9411.html - Implementing Data Bars In A Grouped Table (EEA)
https://www.experts-exchange.com/A_9233.html - Put Some Images On Those SSRS Reports
https://www.experts-exchange.com/A_9158.html - Loading Complex XML Using SSIS (EEA)
https://www.experts-exchange.com/A_9150.html - Loading XML Using SSIS (EEA)
https://www.experts-exchange.com/A_3433.html - Looking Up Data On Different Sources (CP/EEA)
https://www.experts-exchange.com/A_3248.html - Importing Excel Data Using Integration Services (EEA)
https://www.experts-exchange.com/A_3025.html - Retrieving Data From Excel Using OPENROWSET()
https://www.experts-exchange.com/A_2439.html - Free Up Disk Space On Your C: Drive (CP/EEA)
https://www.experts-exchange.com/A_2320.html - Your First OLAP Report (CP/EEA)
https://www.experts-exchange.com/A_2279.html - Adding an Else to your Switch (CP/EEA)
https://www.experts-exchange.com/A_2002.html - Reporting On Data From Stored Procedures (part 2) (EEA)
https://www.experts-exchange.com/A_1931.html - Reporting On Data From Stored Procedures (part 1) (CP/EEA/EC)
https://www.experts-exchange.com/A_1884.html - Pie Chart Techniques (CP/EEA)
https://www.experts-exchange.com/A_1790.html - SQL Server Reporting Services and MDX: Detecting Missing Fields (EEA/EC)
https://www.experts-exchange.com/A_1690.html - The Power Of The Placeholder
https://www.experts-exchange.com/A_1644.html - Chart Optimization Tips (CP/EEA)

EE Milestones
===========
2014/09/10 - Member Rank == Ace
2014/04/01 - MVP!
2014/02/06 - Master Certificate 11 (Programming for ASP.NET)
2013/12/10 - Master Certificate 10 (Databases Miscellaneous)
2013/12/10 - Master Certificate 9 (.NET)
2013/09/03 - Topic Advisor role assigned
2013/04/18 - Genius Certificate 1 (MS SQL Reporting)
2013/04/12 - Sage Certificate 3 (MS SQL Server)
2013/04/12 - Master Certificate 8 (SQL Query Syntax)
2013/03/18 - Guru Certificate 5 (SQL Reporting)
2012/11/15 - Master Certificate 7 (Microsoft Development)
2012/09/22 - Sage Certificate 2 (SQL Server 2008)
2012/07/07 - Wizard Certificate 4 (SQL Server 2005)
2012/04/03 - Wizard Certificate 3 (MS SQL Server)
2012/03/13 - Sage Certificate 1 (MS SQL Reporting)
2012/03/09 - Member Rank == Genius
2012/02/28 - Wizard Certificate 2 (SQL Server 2008)
2012/02/15 - #1 in MS SQL Reporting
2012/02/03 - MVE Award
2012/01/17 - Master Certificate 6 (SSIS)
2011/06/02 - Wizard Certificate 1 (MS SQL Reporting)
2011/05/21 - Guru Certificate 4 (SQL Server 2005)
2011/04/26 - Guru Certificate 3 (SQL Server 2008)
2011/03/11 - Member Rank == Sage
2011/02/07 - Guru Certificate 2 (MS SQL Server)
2010/09/03 - Guru Certificate 1 (MS SQL Reporting)
(2010/08/22 - Master Certificate 6 (MS SQL Reporting - articles) (obsolete))
2010/06/26 - Master Certificate 5 (SQL Server 2008)
2010/05/28 - Member Rank == Wizard
2010/02/11 - First "Community Picks" Article
2009/12/24 - First "Editor's Choice" Article
2009/11/29 - Master Certificate 4 (SQL Reporting)
2009/11/19 - Master Certificate 3 (MS SQL Reporting)
2009/10/18 - First "EE Approved" Article
2009/09/26 - First EE Article
2009/09/15 - Member Rank == Guru
2009/05/09 - Master Certificate 2 (SQL Server 2005)
2009/01/13 - Master Certificate 1 (MS SQL Server)
2008/08/12 - First question answered
2008/08/11 - Joined EE

Memorable Askers Feedback
========================
Q_28490858 - CityofDelrayBeach - "You're a genius Valentino!  Success! I appreciate your help sooo much! We learn new things every day because of people like you!"
Q_28405515 - jvoconnell - "Thank you for the help! Very much appreciated."
Q_28392579 - cindyfiller - "This was by far one of the best answers I've ever received. It was above and beyond - provided me with the scripts needed to accomplish this!!!"
Q_28358743 - Tony303 - "I know Valentino is the undisputed king of SSRS, and his answer was the best"
Q_28349660 - sammySeltzer - "thank you very much for all of your assistance on this, including that nice article of yours."
Q_28333894 - Tony303 - "Bloody legend, mate."
Q_28294643 - sbornstein2 - "perfect awesome help thanks so much"
Q_28309862 - sqldba2013 - "Its working perfect, You're the awesome."
Q_28308098 - brian_appliedcpu - "With great pleasure these points are awarded to you"
Q_27815418 - gberkeley - "Dear ValentinoV, As soon as I saw you had replied, I KNEW I was in good hands. :)  Many, many thanks for the assistance. Not only do you provide the right answer so there's a solution, you take the extra minute to teach me something new so I can do it myself in the future.  You're a rock star, and I thank you!!!"
Q_27777853 - dbbishop - "FANTASTIC! Thanks a million."
Q_27709663 - trawley - "Thanks for all the additional information. This has been really useful. I can edit the mdx query! So cool. Also the info on sorting is really useful. Thank you so much."
Q_27586219 - pepps11976 - "This is Brilliant you are a real credit to this site, Thankyou!"
Q_27581659 - gberkeley - "Thanks as always for the fast response and your expertise. Don't know what I'd do without the help I get from you on Experts Exchange!!!"
Q_27574053 - shah36 - "Thank you very much for such a great help. I was stuck on this from past five days. But now with your help it is working like a charm."
Q_27107976 - Narusegawa - "Thanks ever so much. That's awesome! You have been most helpful, and now I finally have it checking multiple resources and it still only takes a second. Thanks again!"
Q_27095900 - gberkeley - "You ROCK!!! Thanks so very much!!!"
Q_27048909 - simplyfemales - "Valentino.  Thank you for the follow up. ... Your help was greatly appreciated."
Q_26868716 - gberkeley - "Terrific answer - you helped me figure out the missing piece of the puzzle! Thanks!"
Q_26692666 - JJWAI - "Thank you very much. I randomly get it this morning, but you tell me the true reason and solution. Great!"
Q_26453085 - enrique_aeo - "You are the best my friend. Thanks"
Q_26250069 - DowntownIT - "ValentinoV, that worked like a champ! Thank you for taking the time to help."
Q_24953737 - jlaxmi - "Thanks for this detailed description, the solution which u explained is really making sense.."
Q_24918542 - ltorres321 - "Thank you for your time and efforts!!"
Q_24914588 - faiga16 - "My explanation was not probably clear enough, but you were awesome! "
Q_24899900 - n_srikanth4 - "YOU ARE EXCELLENT AND I APPRECIATE YOUR HELP" - "I apprecaite your immediate reply and you are awesome" - "VERY GOOD"
Q_24691508 - Angela4eva - "I cannot tell you how thankful Iam ..you are just unbelievable, Its working exactly as I wanted. I will give you pints for both the questions and they were essentially same."

Microsoft Certification
==================
xxxx/xx/xx - MCSA SQL Server 2012 (passed 461 and 463, still 462 to go)
2013/03/29 - MCITP Business Intelligence 2008
2010/09/30 - MCITP Database Developer 2008
2010/07/09 - MCTS SQL Server 2008 Database Development
2008/07/25 - MCTS SQL Server 2008 Business Intelligence Development & Maintenance
2008/07/25 - MCTS SQL Server 2008 Implementation & Maintenance

Notes to self:
https://www.experts-exchange.com/M_6086749.html
https://www.experts-exchange.com/questions/28239207/SQL-Performance-using-DISTINCT-multiple-AND's-and-BETWEEN.html?anchorAnswerId=39491544#a39491544

More
Languages
English
Full Professional Proficiency
Dutch
Native or Bilingual Proficiency
French
Full Professional Proficiency
German
Limited Working Proficiency

Level Progress

Current: Level 38
ValentinoV needs 26,426 points to level up.
LVL 39
  • Overall
    38
  • SSRS
    30
  • Microsoft SQL Server
    22
  • Microsoft SQL Server 2008
    22
  • Microsoft SQL Server 2005
    14
  • SSIS
    11
  • DB Reporting Tools
    10
  • Microsoft Development
    8
  • SQL
    7
  • SSAS
    6
  • .NET Programming
    6
  • Databases
    5
  • ASP.NET
    5
  • XML
    5
  • Microsoft Excel
    4
  • Microsoft SharePoint
    4
  • Visual Basic.NET
    4
  • C#
    4
  • Windows XP
    4
  • Microsoft Applications
    3
  • Web Languages and Standards
    3
  • Oracle Database
    3
  • Microsoft Dynamics
    2
  • Microsoft Server OS
    2
  • Programming
    2
  • Windows Server 2008
    2
  • MySQL Server
    2
  • Microsoft Server Apps
    2
  • Crystal Reports
    1
  • Windows Server 2003
    1
  • Microsoft Legacy OS
    1
  • Web Applications
    1
  • Visual Basic Classic
    1
  • ASP
    1
  • Python
    1
  • Microsoft IIS Web Server
    1
  • Windows 2000
    1
  • Windows Server 2012
    1
  • Microsoft Access
    1
  • Windows OS
    1
  • Apple OS
    1
  • DB Dev Tools
    1
  • Fonts Typography
    1
  • Google Chrome OS
    1
  • HTML
    1
  • PHP
    1
  • VB Script
    1
  • VPN
    1
  • Web Services
    1
  • Scripting Languages
    1
  • Programming Languages-Other
    1
  • Microsoft Visual Studio
    1
  • Storage
    1
  • Application Servers
    1
  • DB2
    1
  • Facebook
    1
  • Internet Marketing
    1
  • JavaScript
    1
  • Server Software
    1
  • Social Networking
    1
  • Windows 7
    1
  • iOS
    1