I think there are different questions you should be asking yourself. I can see how from your perspective you would prefer to go to one of the top two full-time MBA programs in New York City to facilitate a career switch. However, the full-time MBA programs are more competitive. So, if you are not competitive for the full-time MBA programs would Columbia's Executive MBA Program or either NYU Stern's Part- or Executive- MBA programs help you make the switch over the full-time MBA programs for less prestigious programs in NYC. So, in doing your due diligence, contact Stern's Career Center for Working Professionals (CCWP) - https://www.stern.nyu.edu/portal-partner ... fessionals - and Columbia's EMBA Career Management - https://www8.gsb.columbia.edu/programs-a ... management - to really kick the tires on the degree to which they will help you in this transition. Ask if the current policy on NYU Stern part-time students allows them to interview for full-time MBA positions.

Two years ago, I had a 29-year old client who wanted to go to a full-time MBA program - she was rejected by Duke's Full Time MBA Program, yet accepted to Wharton's Executive MBA Program. In a perfect world, she would have rather attended Wharton's Full Time MBA Program but she was not competitive for it. I do not know the overall strength of your candidacy, but attending NYU Stern's Part Time MBA Program might be better for you long-term than attending say City University of New York, Baruch College MBA or a comparable local New York City program.

FYI - For a primer on Different MBA Programs refer here - https://www.mbaprepadvantage.com/blog/di ... ram-types/

Good luck,

You have candidly discussed your profile.You have gone great lengths to give yourself every chance that you have. with years of experience and exposure, Adcoms would be very wary of your career goals and your aim at a transition. MBA is an investment not only for you but for the Adcom as well. Their perspectives are important and how you convince them of your goals are of paramount need.Hence you can have a detailed discussion with the B School on why your candidature was rejected.As far as the programs are concerned, you should look at EMBA options of the top ones in the geography you wish to stay on, rather than looking at full time programs of second rung B Schools.Consider this - With your experience, you should be pretty poised to take advantage of connections and networking even in an EMBA program to land you a role of your choice.
All the Best